• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

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?
0
Dan560
Asked:
Dan560
1 Solution
 
johanntagleCommented:
I think you will have to manually restart the slave.  That's why it's good to have a monitoring tool to check the slave status.  We use Nagios check_mysql_health plugin (http://exchange.nagios.org/directory/Plugins/Databases/MySQL/check_mysql_health/details) - it checks a lot of other things (actually, too many things in my opinion).  You can search the same site for other alternatives.
0
 
wolfgang_93Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now