mysql多源复制详解

  • 时间:
  • 浏览:2

               Last_SQL_Error: 

      Last_IO_Error_Timestamp: 

mysql> show slave status\G

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

          Read_Master_Log_Pos: 246854093

         Replicate_Rewrite_DB: 

                  Master_Port: 310006

                 Channel_Name: al_rds

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

2 rows in set (0.00 sec)

            Slave_SQL_Running: Yes

           Master_SSL_CA_Path: 

           Master_SSL_Allowed: No

              Until_Condition: None

Master_SSL_Verify_Server_Cert: No

          Exec_Master_Log_Pos: 246854093

             Master_Info_File: mysql.slave_master_info

            Slave_SQL_Running: Yes

              Replicate_Do_DB: 

  Replicate_Ignore_Server_Ids: 

             Master_Server_Id: 253241

                  Master_User: rep

      Replicate_Wild_Do_Table: work1.%,work2.%

             Master_Server_Id: 2721321239

       Replicate_Ignore_Table: 

               Slave_IO_State: Waiting for master to send event

                Until_Log_Pos: 0

           Replicate_Do_Table: 

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

            Master_SSL_Cipher: 

                  Master_Host: 10.2.0.6

                Relay_Log_Pos: 15510002415

               Last_SQL_Error: 

              Relay_Log_Space: 510007767

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

            Master_SSL_Cipher: 

             Slave_IO_Running: Yes

               Master_SSL_Crl: 

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

                 Skip_Counter: 0

          SQL_Remaining_Delay: NULL

               Relay_Log_File: beifen1-relay-bin-me_mysql.000004

                   Last_Errno: 0

                 Skip_Counter: 0

          SQL_Remaining_Delay: NULL

           Master_SSL_CA_File: 

                    SQL_Delay: 0

      Last_IO_Error_Timestamp: 

                  Master_Host: 10.2.0.5

                   Last_Error: 

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

                  Master_Port: 310006

               Master_SSL_Key: 

          Replicate_Ignore_DB: 

               Last_SQL_Errno: 0

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

                Connect_Retry: 1000

           Master_SSL_CA_Path: 

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

             Master_Info_File: mysql.slave_master_info

                Auto_Position: 1

          Exec_Master_Log_Pos: 510007291

           Master_SSL_Crlpath: 

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

              Relay_Log_Space: 15510002632

                 Channel_Name: me_mysql

              Master_SSL_Cert: 

        Relay_Master_Log_File: mysql-bin.000013

     Last_SQL_Error_Timestamp: 

              Master_Log_File: mysql-bin.000013

               Until_Log_File: 

                    SQL_Delay: 0

           Master_Retry_Count: 861000

                Auto_Position: 1

                Until_Log_Pos: 0

               Master_SSL_Crl: 

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

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

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

      Replicate_Wild_Do_Table: work1.%,work2.%

                Last_IO_Error: 

                Last_IO_Error: 

               Master_SSL_Key: 

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

           Master_TLS_Version: 

     Last_SQL_Error_Timestamp: 

               Slave_IO_State: Waiting for master to send event

               Last_SQL_Errno: 0

              Master_SSL_Cert: 

                  Master_Bind: 

                   Last_Errno: 0

               Until_Log_File: 

                Last_IO_Errno: 0

          Read_Master_Log_Pos: 510007291

         Replicate_Rewrite_DB: 

                  Master_Bind: 

        Seconds_Behind_Master: 0

              Replicate_Do_DB: 

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

               Relay_Log_File: beifen1-relay-bin-al_rds.00001000

             Slave_IO_Running: Yes

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

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

          Replicate_Ignore_DB: 

  Replicate_Wild_Ignore_Table: 

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

                Connect_Retry: 1000

  Replicate_Ignore_Server_Ids: 

           Master_SSL_Crlpath: 

           Master_TLS_Version: 

                Relay_Log_Pos: 510007464

       Replicate_Ignore_Table: 

                  Master_User: rep

              Master_Log_File: mysql-bin.001297

              Until_Condition: None

           Master_SSL_CA_File: 

  Replicate_Wild_Ignore_Table: 

                   Last_Error: 

           Master_SSL_Allowed: No

           Master_Retry_Count: 861000

           Replicate_Do_Table: 

Master_SSL_Verify_Server_Cert: No

                Last_IO_Errno: 0

        Seconds_Behind_Master: 0

        Relay_Master_Log_File: mysql-bin.001297