vw183

Is It Possible To Sync Database Contents With Bt Sync

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

@vw183

Unfortunately 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).

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.