0 Replies Latest reply on Apr 12, 2018 11:50 AM by Mubashar Iftikhar

    MySQL5.6 “Role Transition”  Master Slave Replication

    Mubashar Iftikhar

      I have a setup of MySQL 5.6 Master Slave Replication. Recently i promote slave to master and now old slave is acting as a MASTER.
      My question is when i trying to create a database in MASTER then slave can't create database. Can anyone please clear this issue.

      here is status

      Slave_IO_State: Waiting for master to send event

                        Master_Host: 192.168.******

                        Master_User: ali

                        Master_Port: 3306

                      Connect_Retry: 60

                    Master_Log_File: mysql-bin.000004

                Read_Master_Log_Pos: 440

                     Relay_Log_File: mysqld-relay-bin.000002

                      Relay_Log_Pos: 603

              Relay_Master_Log_File: mysql-bin.000004

                   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: 440

                    Relay_Log_Space: 777

                    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

      Master_SSL_Verify_Server_Cert: No

                      Last_IO_Errno: 0

                      Last_IO_Error:

                     Last_SQL_Errno: 0

                     Last_SQL_Error:

        Replicate_Ignore_Server_Ids:

                   Master_Server_Id: 2

                        Master_UUID: 5c77a9b9-3bb5-11e8-a2df-000c294d86bf

                   Master_Info_File: /var/lib/mysql/master.info

                          SQL_Delay: 0

                SQL_Remaining_Delay: NULL

            Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it

                 Master_Retry_Count: 86400

                        Master_Bind:

            Last_IO_Error_Timestamp:

           Last_SQL_Error_Timestamp:

                     Master_SSL_Crl:

                 Master_SSL_Crlpath:

                 Retrieved_Gtid_Set:

                  Executed_Gtid_Set:

                      Auto_Position: 0

      1 row in set (0.00 sec)

       

       

      everything is working fine. but i dont know why slave can't create database when i create database at master side.

      please clear this issue

       

      regards

      mubashar