Solved

MySQL Replication

Posted on 2011-09-14
2
366 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Webinar: Deploying MySQL in production 6/22 11am

Join Percona’s Senior Operations Engineer, Daniel Kowalewski as he presents Deploying MySQL in production on Thursday, June 22, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 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