Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: show slave status (reset)

Resolving Error: master and slave have equal MySQL server UUIDs
+4 Vote Up -0Vote Down

If you’ve run into the following error, then there area couple quick fixes:

Errno: 1593
Fatal error: The slave I/O thread stops because master and slave
have equal MySQL server UUIDs; these UUIDs must be different for
replication to work.

To give some background first, starting in MySQL 5.6, the server generates a true UUID in addition to the –server-id supplied by the user. This is ultimately to help with new replication features.

From a under-the-hood view, when starting, the MySQL server automatically obtains a UUID as follows (per the manual):

  • Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir is the server’s data directory); exit on success.
  • Otherwise, generate a new UUID and save it to this file,
  •   [Read more...]
    Not a cool new feature for Master_Host
    +1 Vote Up -1Vote Down

    I was surprised to find on a customer MySQL server this new syntax for Master_host in SHOW SLAVE STATUS.

    mysql> SHOW SLAVE STATUS\G
    *************************** 1. row ***************************
                   Slave_IO_State: Connecting to master
                      Master_Host: testdb1.xxx.com or 10.XXX.XX.XXX
                      Master_User: repl
                      Master_Port: 3306
                    Connect_Retry: 60
                  Master_Log_File: db1-354215-bin-log.000005
              Read_Master_Log_Pos: 1624
                   Relay_Log_File: db2-354214-relay-log.000001
       

    Is this a fancy new Percona Server feature? No. It’s operator error.

    We read a little further to find.

    mysql> SHOW SLAVE STATUS\G
    ...
                 Slave_IO_Running: Connecting
    
    ...
                    Last_IO_Errno: 2005
                    Last_IO_Error:
      [Read more...]
    Discover MyXplain, another way to learn, search, find and stroll
    +4 Vote Up -1Vote Down

     

     

    I’m very glad to announce you that MyXplain is released today.

    This project is the result of many weeks of work for my friend Max and I and we are obviously very proud to present it.

    Please take a time to browse it and find all the surprises that awaiting you.

    We wanted to make an unique place, a gathering place where you can find all you want to know about the most useful MySQL commands.
    We started with the explain command because we consider it as one of the most important.
    show processlist and show slave status will be the next proposed commands on

      [Read more...]
    MySQL: Using CONNECT to Quickly Verify Replication Health
    +0 Vote Up -0Vote Down

    One very helpful use of the technique Sheeri described in Remote connections without leaving the mysql shell is making sure that replication is working properly.

    According to the MySQL Reference Manual’s section on SHOW SLAVE STATUS Syntax, it shows information corresponding to the slave thread in the slave server. When replication is broken, however, or not working properly due to network issues between master and slave, this information may not be accurate. This has improved over recent releases, but it’s still not perfect.

    The question, then, is: how to be 100% sure (or as close as you can get to 100%) that replication is running fine? The answer, as

      [Read more...]
    When SHOW SLAVE STATUS and the error log Disagree
    +0 Vote Up -0Vote Down

    Or, When MySQL Lies!

    When I do a show slave status\G, sometimes mysqld will lie to me and give me a wrong Exec_Master_Log_Pos. Let me explain with a situation from last night.

    This is the output of show slave status\G from mysql version 5.0.41-community-log:

    mysql> show slave status \G
    *************************** 1. row ***************************
                    Slave_IO_State: Waiting for master to send event
                       Master_Host: XXX.XXX.XXX.XXX
                       Master_User: replic_username
                       Master_Port: 3306
                     Connect_Retry: 60
                   Master_Log_File: mysql-bin.000480
               Read_Master_Log_Pos: 690470773
                    Relay_Log_File: db2-relay-bin.000028
                     Relay_Log_Pos: 683977007
          Relay_Master_Log_File:
      [Read more...]
    Showing entries 1 to 5

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.