Solved

MySQL Replication

Posted on 2011-09-14
2
365 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Using coldfusion <cfexecute> to restore mysql database 7 67
java mysql insert application 14 47
restriction of entering a a page 5 34
Not listening to where 1 23
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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