Jump to content

Live Database replication AND file replication


deanlearner

Recommended Posts

I have live master-master replication running on a mysql database (currently only really used as master-slave, but for the following to work I've configured it as master-master).

 

Users can upload files to the system, the file is stored in a documents directory and an entry is added to the database pointing to this file.

NOW, I want this uploaded file to be replicated in the required place on the other system as well and even if the connection isnt available for a while, it will perform the replication when it can.

 

Can such replication be set up in a live fashion?

 

I've not given it too much thought just yet, but I am thinking of doing an rsync every X minutes and picking up the changes as required.

 

Anyone have any experience with this?

 

Thanks :)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.