Topic: mysql mirror

[darren]

I am setting up 2 offices that use the same database and i need to set it up so i have a mirrored database is there any easy way to do this.

[guestHH]

Hi,

I don't know if mysql itself has capabilities. Don't think there is an _easy_ way to do this. Set up an VPN and use 1 database..?

Otherwise take a look at this http://www.star-support.com/downloads/mitel/contrib/Linux-HA/
Maybe there are interesting pasrts in there for you.

Regards,
guestHH

[schotty]

If you cant use VPN or a direct Connection then you are not really going to be able to use MYsql and have the database looking the same in both locations.

You are goint to nned time to get the information from one site to the other.

I guess you could make scripts and export the data from one site to the other but this is going to take time..... It would be better if you used vpn.

[Frank]

Hi guys,

Is there any synchronise program go get the directory content auto-update at both side of the network? My users would like to have a schedule cron job to make a directory data to be the same at both side.

Regards,
Frank

[schotty]

once again evaluate VPN. VPN lets you have a secure connection between 2 sites. to sync a directory you could use a stink dirty old cron job......

[guestHH]

or you could rsync together with cron...

Regards,
guestHH

[Ruusvuu]

RequestedDeletion!

Please educate me -

How to setup rsync to be run daily
with auto passwords and all...

Cheers!

Russvuu

[guestHH]

Hi Russvuu,

Take a look here. Maybe it gives you a start....

http://www.ifost.org.au/~peterw/

The difference is that it synchronises 2 way's instead of 1 way ( like syncing e.a. a PDA wiht outlook, what to do with changes on both sides....)

If it's not what you want, we have to start a topic on 'how to use rsync' but I guess the first reply will be 'read the man pages' .........

Regards,
guestHH

[Bart]

On topic : rsync-ing a mysql database?
i wonder if that's a good idea - probably not.
if it would work you'd have to shutdown (both!) your mysql-dbs first.

Better opt for replication. A quick search on Google (mysql replication 3.23) gave me:

http://www.phpbuilder.com/columns/tanoviceanu20000912.php3?print_mode=1

http://www.mysql.com/doc/en/Replication_HOWTO.html
states:  "Use Version 3.23.29 or higher".
I think SME 5.5 should do (based on RH 7.2).Maybe 5.1.2 too.

Good luck! Bart