Link to home
Start Free TrialLog in
Avatar of Dan560
Dan560Flag for United Kingdom of Great Britain and Northern Ireland

asked on

MySQL Replication

Hi,

I am running a help desk package that uses MySQL 4.0.16.

I am going to be creating a Master and Slave setup described in the article:
http://dev.mysql.com/doc/refman/4.1/en/replication.html

The Slave Database will be running off site. My question is if the connection breaks between master and slave, will the slave automatically pick up  the replication after the connection is restored?
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
MySQL version 4.1 is ancient. There were lots of bugs with replication in the earlier
versions of MySQL. You should looking at upgrading to MySQL 5.5 or version 5.1 for
reasonable replication.