mysql多源复制详解

  • 时间:
  • 浏览:0
  • 来源:uu快3规律_uu快3下载地址_窍门

          SQL_Remaining_Delay: NULL

                 Channel_Name: al_rds

               Relay_Log_File: beifen1-relay-bin-al_rds.0000150

            Executed_Gtid_Set: 09cb91bf-2669-11e7-8b70-00163e0835ff:1-640645,

               Last_SQL_Errno: 0

               Master_SSL_Crl: 

                  Master_Bind: 

        Seconds_Behind_Master: 0

               Until_Log_File: 

1db4cb1b-5e00-11e7-89eb-00163e046b4a:1-8,

3edae34c-6299-11e6-95cd-15038bc0c67be:1-6758,

           Master_SSL_CA_File: 

  Replicate_Wild_Ignore_Table: 

                  Master_User: rep

                Connect_Retry: 150

Master_SSL_Verify_Server_Cert: No

      Last_IO_Error_Timestamp: 

               Master_SSL_Crl: 

                  Master_Port: 31506

Master_SSL_Verify_Server_Cert: No

        Relay_Master_Log_File: mysql-bin.000013

               Relay_Log_File: beifen1-relay-bin-me_mysql.000004

           Retrieved_Gtid_Set: 09cb91bf-2669-11e7-8b70-00163e0835ff:511503-640645

                Last_IO_Errno: 0

                 Skip_Counter: 0

             Slave_IO_Running: Yes

  Replicate_Ignore_Server_Ids: 

           Master_SSL_Allowed: No

                    SQL_Delay: 0

          Exec_Master_Log_Pos: 246854093

                    SQL_Delay: 0

                  Master_UUID: 817498dc-2676-11e7-a673-00163e024674

4cdc2a74-6299-11e6-95ce-008cfaf595bc:1-39258544

               Until_Log_File: 

               Last_SQL_Errno: 0

           Replicate_Do_Table: 

           Master_SSL_Crlpath: 

        Relay_Master_Log_File: mysql-bin.001297

           Master_SSL_CA_Path: 

           Master_SSL_Allowed: No

                Relay_Log_Pos: 51507464

                   Last_Error: 

          Replicate_Ignore_DB: 

                Last_IO_Errno: 0

                Last_IO_Error: 

                 Channel_Name: me_mysql

                  Master_User: rep

                   Last_Error: 

          Read_Master_Log_Pos: 51507291

              Master_Log_File: mysql-bin.001297

4cdc2a74-6299-11e6-95ce-008cfaf595bc:1-39258544

           Master_TLS_Version: 

              Master_SSL_Cert: 

                  Master_Host: 10.2.0.5

                   Last_Errno: 0

          Replicate_Ignore_DB: 

               Slave_IO_State: Waiting for master to send event

                 Skip_Counter: 0

         Replicate_Rewrite_DB: 

           Retrieved_Gtid_Set: 4cdc2a74-6299-11e6-95ce-008cfaf595bc:38888940-39258544

              Replicate_Do_DB: 

               Last_SQL_Error: 

            Executed_Gtid_Set: 09cb91bf-2669-11e7-8b70-00163e0835ff:1-640645,

          SQL_Remaining_Delay: NULL

                  Master_Host: 10.2.0.6

               Last_SQL_Error: 

                Until_Log_Pos: 0

              Until_Condition: None

*************************** 1. row ***************************

       Replicate_Ignore_Table: 

      Replicate_Wild_Do_Table: work1.%,work2.%

        Seconds_Behind_Master: 0

                  Master_Bind: 

                  Master_Port: 31506

                Until_Log_Pos: 0

           Master_SSL_CA_File: 

      Replicate_Wild_Do_Table: work1.%,work2.%

                Relay_Log_Pos: 1551502415

     Last_SQL_Error_Timestamp: 

              Replicate_Do_DB: 

            Slave_SQL_Running: Yes

      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

                Auto_Position: 1

              Relay_Log_Space: 51507767

mysql> show slave status\G

      Last_IO_Error_Timestamp: 

           Master_SSL_Crlpath: 

             Slave_IO_Running: Yes

           Master_TLS_Version: 

             Master_Info_File: mysql.slave_master_info

              Master_SSL_Cert: 

       Replicate_Ignore_Table: 

  Replicate_Wild_Ignore_Table: 

              Until_Condition: None

             Master_Server_Id: 2721321239

                   Last_Errno: 0

1db4cb1b-5e00-11e7-89eb-00163e046b4a:1-8,

2 rows in set (0.00 sec)

3edae34c-6299-11e6-95cd-15038bc0c67be:1-6758,

           Master_Retry_Count: 86150

             Master_Info_File: mysql.slave_master_info

         Replicate_Rewrite_DB: 

  Replicate_Ignore_Server_Ids: 

               Master_SSL_Key: 

              Master_Log_File: mysql-bin.000013

           Master_Retry_Count: 86150

               Slave_IO_State: Waiting for master to send event

                Connect_Retry: 150

      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

          Exec_Master_Log_Pos: 51507291

              Relay_Log_Space: 1551502632

          Read_Master_Log_Pos: 246854093

*************************** 2. row ***************************

            Master_SSL_Cipher: 

           Replicate_Do_Table: 

                Last_IO_Error: 

             Master_Server_Id: 253241

            Slave_SQL_Running: Yes

               Master_SSL_Key: 

                Auto_Position: 1

            Master_SSL_Cipher: 

     Last_SQL_Error_Timestamp: 

           Master_SSL_CA_Path: 

mysql -uroot -p'******' -h10.2.0.7 -P31506

                  Master_UUID: 4cdc2a74-6299-11e6-95ce-008cfaf595bc