LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-20-2005, 03:34 PM   #1
Ratclaws
Member
 
Registered: Sep 2001
Location: New York
Distribution: Slackware 8
Posts: 100

Rep: Reputation: 16
MySQL Replication not working correctly?


This setup is using one master and two slaves.

master- Mysql 4.0.20 - working
slave1 - Mysql-4.0.20 - ?????
slave2 - Mysql 4.0.17 - working

as far as i know the data seems to be ok. but i am a little bit unsure about some of the output of show slave status..


when i run show slave status on slave2 i see the folloing two things,
Slave_IO_Running: Yes
Slave_SQL_Running: Yes


However, When i run show slave status on slave1 i get
Slave_IO_Running: Yes
Slave_SQL_Running: No

Log file and position seem in sync with the master. Whats going on here?


I also tried doing slave stop; slave start; and that didn't help...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql replication twistedpair Linux - General 7 06-23-2006 10:10 AM
Looking for suggestions on MySQL one-way replication Pcghost Linux - Software 1 01-25-2005 10:22 AM
installpkg not working correctly Addict3dtoX Linux - Software 13 09-22-2004 04:31 PM
Mysql replication pk21 Linux - Software 0 08-28-2003 05:00 AM
mysql replication cheng Linux - Software 1 08-22-2002 02:11 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:25 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration