uu快3手游_uu快3分析_游戏 - uu快3手游,uu快3分析,游戏是新浪网最重要的频道之一,24小时滚动报道国内、国际及社会新闻。每日编发新闻数以万计。

mysql多源复制详解

  • 时间:
  • 浏览:2

                  Master_User: rep

               Relay_Log_File: beifen1-relay-bin-al_rds.000080

          Exec_Master_Log_Pos: 5807291

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

               Until_Log_File: 

              Replicate_Do_DB: 

                  Master_Host: 10.2.0.6

           Master_SSL_CA_File: 

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

           Replicate_Do_Table: 

          Exec_Master_Log_Pos: 246854093

              Until_Condition: None

        Seconds_Behind_Master: 0

               Last_SQL_Errno: 0

              Master_SSL_Cert: 

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

                   Last_Error: 

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

                Last_IO_Error: 

                Until_Log_Pos: 0

               Until_Log_File: 

              Master_Log_File: mysql-bin.000013

                 Skip_Counter: 0

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

       Replicate_Ignore_Table: 

                   Last_Errno: 0

           Master_TLS_Version: 

                Relay_Log_Pos: 5807464

          Read_Master_Log_Pos: 246854093

           Master_Retry_Count: 8680

        Seconds_Behind_Master: 0

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

                 Channel_Name: me_mysql

                Last_IO_Errno: 0

         Replicate_Rewrite_DB: 

           Master_SSL_CA_Path: 

             Slave_IO_Running: Yes

  Replicate_Ignore_Server_Ids: 

       Replicate_Ignore_Table: 

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

           Master_SSL_Crlpath: 

Master_SSL_Verify_Server_Cert: No

      Last_IO_Error_Timestamp: 

              Until_Condition: None

              Relay_Log_Space: 155802632

               Master_SSL_Key: 

         Replicate_Rewrite_DB: 

                 Skip_Counter: 0

                  Master_Port: 3806

           Master_Retry_Count: 8680

                Relay_Log_Pos: 155802415

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

mysql> show slave status\G

          SQL_Remaining_Delay: NULL

               Slave_IO_State: Waiting for master to send event

               Master_SSL_Key: 

                  Master_Port: 3806

                Connect_Retry: 80

        Relay_Master_Log_File: mysql-bin.000013

      Last_IO_Error_Timestamp: 

           Master_SSL_Allowed: No

           Master_SSL_Crlpath: 

     Last_SQL_Error_Timestamp: 

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

           Master_SSL_Allowed: No

             Master_Info_File: mysql.slave_master_info

             Master_Info_File: mysql.slave_master_info

                    SQL_Delay: 0

               Last_SQL_Error: 

             Master_Server_Id: 2721321239

     Last_SQL_Error_Timestamp: 

  Replicate_Ignore_Server_Ids: 

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

           Master_SSL_CA_File: 

               Master_SSL_Crl: 

  Replicate_Wild_Ignore_Table: 

           Master_TLS_Version: 

                    SQL_Delay: 0

                   Last_Errno: 0

                Auto_Position: 1

          Replicate_Ignore_DB: 

             Master_Server_Id: 253241

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

              Master_Log_File: mysql-bin.001297

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

           Master_SSL_CA_Path: 

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

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

               Slave_IO_State: Waiting for master to send event

               Last_SQL_Errno: 0

          SQL_Remaining_Delay: NULL

Master_SSL_Verify_Server_Cert: No

              Master_SSL_Cert: 

             Slave_IO_Running: Yes

           Replicate_Do_Table: 

2 rows in set (0.00 sec)

               Master_SSL_Crl: 

      Replicate_Wild_Do_Table: work1.%,work2.%

                Last_IO_Errno: 0

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

                  Master_Host: 10.2.0.5

                  Master_Bind: 

        Relay_Master_Log_File: mysql-bin.001297

              Replicate_Do_DB: 

               Last_SQL_Error: 

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

            Slave_SQL_Running: Yes

                Connect_Retry: 80

              Relay_Log_Space: 5807767

                   Last_Error: 

                Auto_Position: 1

            Master_SSL_Cipher: 

  Replicate_Wild_Ignore_Table: 

            Master_SSL_Cipher: 

                  Master_Bind: 

                 Channel_Name: al_rds

                Last_IO_Error: 

                Until_Log_Pos: 0

          Replicate_Ignore_DB: 

      Replicate_Wild_Do_Table: work1.%,work2.%

          Read_Master_Log_Pos: 5807291

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

                  Master_User: rep

               Relay_Log_File: beifen1-relay-bin-me_mysql.000004

            Slave_SQL_Running: Yes