[SOLVED] Looking for site replication software

unix1adm · 03-25-2010, 08:15 AM

I had a question from a friend that runs 2 redhat systems one on west coast and one on east coast.

He is looking for some software (pay or free, prefer pay with support options) that he can use to keep these 2 systems (each has local disk no SAN disks) in sync with each other.

One will be primary and one backup. But real time with a minimum of data loss should one of them go down.

Basically he process real time transactions on the primary system and needs to keep the backup system in sync over the network.

They are running mysql for the DB.

Is there any good sw or tools to do this?

If this is to much over the net he may consider getting a 3rd system local to the primary machine but that kinda defeats a site outage issue but still covers a local hdw issue should one arise.
Thanx

CJ

sreeharsha.t · 03-25-2010, 08:29 AM

Try rsync. I don't know much about it but a simple google search can help you.

If he wants a very low level replication, then try DRBD. This will achieve a near SAN like replication.

unix1adm · 03-29-2010, 06:01 AM

anyone else have ideas?

chrism01 · 03-29-2010, 08:45 PM

For MySQL try http://dev.mysql.com/doc/refman/5.0/en/replication.html which as it says

Quote:

Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous - slaves need not to connected permanently to receive updates from the master. This means that updates can occur over long-distance connections and even over temporary or intermittent connections such as a dial-up service.

Outside the DB, rsync is (probably) the way to go.