LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 06-16-2009, 04:31 AM   #1
Padawan.AVT
Member
 
Registered: Feb 2006
Distribution: Gentoo, Slackware, Debian, Suse
Posts: 86

Rep: Reputation: 15
MySQL replication


Hi everyone!

I have some issues with my master-master replication for my local MediaWiki site:
I did all the steps as in the tutorial below:
http://www.howtoforge.com/mysql_mast...er_replication

check slave status & check master status are OK

but when I create some test article in one wiki, no changes appear in another. According to log, replication has started.


Any ideas?
 
Old 06-16-2009, 09:43 AM   #2
diilbert
Member
 
Registered: Nov 2003
Location: North of the Border
Distribution: Gentoo & Debian
Posts: 155

Rep: Reputation: 30
What is SHOW SLAVE STATUS showing?
 
Old 06-16-2009, 09:48 AM   #3
Padawan.AVT
Member
 
Registered: Feb 2006
Distribution: Gentoo, Slackware, Debian, Suse
Posts: 86

Original Poster
Rep: Reputation: 15
Code:
mysql>  show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 10.249.134.144
                Master_User: replication
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: edms-wiki2-bin.000003
        Read_Master_Log_Pos: 29436
             Relay_Log_File: edms-wiki-relay-bin.000002
              Relay_Log_Pos: 240
      Relay_Master_Log_File: edms-wiki2-bin.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 29436
            Relay_Log_Space: 240
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified



And on another one:

Code:
mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 10.159.198.144
                Master_User: replication
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: edms-wiki-bin.000007
        Read_Master_Log_Pos: 15706
             Relay_Log_File: edms-wiki2-relay-bin.000006
              Relay_Log_Pos: 15847
      Relay_Master_Log_File: edms-wiki-bin.000007
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 15706
            Relay_Log_Space: 15847
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified
 
Old 06-16-2009, 09:50 AM   #4
Padawan.AVT
Member
 
Registered: Feb 2006
Distribution: Gentoo, Slackware, Debian, Suse
Posts: 86

Original Poster
Rep: Reputation: 15
Code:
mysql> SHOW PROCESSLIST\G;
*************************** 1. row ***************************
     Id: 3
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: SHOW PROCESSLIST
*************************** 2. row ***************************
     Id: 4
   User: replication
   Host: 10.249.134.144:59569
     db: NULL
Command: Binlog Dump
   Time: 2164
  State: Has sent all binlog to slave; waiting for binlog to be updated
   Info: NULL
*************************** 3. row ***************************
     Id: 27
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 1565
  State: Waiting for master to send event
   Info: NULL
*************************** 4. row ***************************
     Id: 28
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 1565
  State: Has read all relay log; waiting for the slave I/O thread to update it
   Info: NULL
4 rows in set (0.00 sec)

ERROR:
No query specified

And on the second:
Code:
mysql> show processlist\G;
*************************** 1. row ***************************
     Id: 53
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 6142
  State: Waiting for master to send event
   Info: NULL
*************************** 2. row ***************************
     Id: 54
   User: system user
   Host:
     db: NULL
Command: Connect
   Time: 241
  State: Has read all relay log; waiting for the slave I/O thread to update it
   Info: NULL
*************************** 3. row ***************************
     Id: 72
   User: replication
   Host: 10.159.198.144:59414
     db: NULL
Command: Binlog Dump
   Time: 1603
  State: Has sent all binlog to slave; waiting for binlog to be updated
   Info: NULL
*************************** 4. row ***************************
     Id: 73
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist
4 rows in set (0.00 sec)
 
Old 06-16-2009, 10:27 PM   #5
fritz001
Member
 
Registered: Aug 2004
Posts: 127

Rep: Reputation: 18
A very good HOWTO about MYSQL MASTER-MASTER replication

http://capttofu.livejournal.com/1752.html
 
  


Reply

Tags
mysql


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 lord-fu Linux - Server 0 04-02-2007 09:38 AM
MySQL Replication ACDII Linux - Server 5 12-18-2006 09:08 AM
mysql replication twistedpair Linux - General 7 06-23-2006 11:10 AM
Mysql replication pk21 Linux - Software 0 08-28-2003 06:00 AM
mysql replication cheng Linux - Software 1 08-22-2002 03:11 PM


All times are GMT -5. The time now is 09:34 PM.

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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration