vw183 Posted October 10, 2014 Report Share Posted October 10, 2014 Hi,I really like e way that BT sync works and how convenient it is to handle it as well as the secure data transfer peer 2 peer. I am working on a desaster relief communications software that is currently based on apache, php, mysql. Looking forward, it would make a lot of sense to use the distributed redundant HW of the 4..10 Laptops instead of a single server. The question I have is: would there be a short term or long term way to use BT sync to databases (type of database is nearly not important because the database would be running on each machine as a local instance). Also, one could consider that data is allways uniquely added to each database with a unique ID so that there would not be changes to existing data or merging of existing data. Any idea how to fo this and what db type to use? Quote Link to comment Share on other sites More sharing options...
GreatMarko Posted October 10, 2014 Report Share Posted October 10, 2014 I'd suggest adding this suggestion to the Feature Request forum, as the ability to sync MySQL and other "open" databases between devices would indeed be very useful. In the meantime, the best way to "sync" MySQL type databases specifically between devices would be to setup MySQL replication or a cluster. If however, as you indicate, you're not bothered about the type of database you sync via Sync itself, it would firstly have to be a database that's stored in a physical file, but also bear in mind that Sync can't sync files whilst they're open/locked/in use by other applications. Therefore, when considering database formats, you'd need to choose one that doesn't lock or keep the physical database file open the entire time, and only locks it whilst actually writing data. Quote Link to comment Share on other sites More sharing options...
richdotward Posted October 11, 2014 Report Share Posted October 11, 2014 I backup mysql data bases every night to a file and share via this.Seehttp://ks3353134.kimsufi.com/nibbleblog/index.php?controller=post&action=view&id_post=20RichSent from my Nexus 4 using Tapatalk Quote Link to comment Share on other sites More sharing options...
GreatMarko Posted October 11, 2014 Report Share Posted October 11, 2014 I backup mysql data bases every night to a file and share via this.Yeah, but that's not quite what the OP is asking - he's looking for "real time" synchronization, rather than "daily backup" Quote Link to comment Share on other sites More sharing options...
richdotward Posted October 11, 2014 Report Share Posted October 11, 2014 Yeah but as its not possible at the moment its better than nothing. Could be nodded to run hourly.RichSent from my Nexus 4 using Tapatalk Quote Link to comment Share on other sites More sharing options...
vw183 Posted January 15, 2015 Author Report Share Posted January 15, 2015 BT Sync team: any news on this topic? Quote Link to comment Share on other sites More sharing options...
RomanZ Posted January 16, 2015 Report Share Posted January 16, 2015 @vw183Unfortunately Sync does not has any improvements on DBs backup. It will still treat DB files as regular ones and live syncing is not going to be effective (and with some DBs most likely is impossible due to fact that DB stays open for exclusive use by DB owner). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.