Solved

MySQL Replication

Posted on 2011-09-14
2
361 Views
Last Modified: 2012-06-21
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
Comment
Question by:Dan560
2 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
ID: 36535184
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
 
LVL 8

Expert Comment

by:wolfgang_93
ID: 36554906
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now