Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: darren on August 19, 2002, 12:18:46 PM

Title: mysql mirror
Post by: darren on August 19, 2002, 12:18:46 PM

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.

Title: Re: mysql mirror
Post by: guestHH on August 19, 2002, 12:29:46 PM

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

Title: Re: mysql mirror
Post by: schotty on August 19, 2002, 12:59:40 PM

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.

Title: Re: mysql mirror
Post by: Frank on August 19, 2002, 03:34:43 PM

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

Title: Re: mysql mirror
Post by: schotty on August 19, 2002, 04:21:39 PM

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

Title: Re: mysql mirror
Post by: guestHH on August 20, 2002, 01:44:30 AM

or you could rsync together with cron...

Regards,
guestHH

Title: Re: mysql mirror
Post by: Ruusvuu on August 20, 2002, 10:40:01 PM

RequestedDeletion!

Please educate me -

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

Cheers!

Russvuu

Title: Re: mysql mirror
Post by: guestHH on August 20, 2002, 11:36:38 PM

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

Title: Re: mysql mirror
Post by: Bart on August 21, 2002, 04:18:32 AM

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