$ mydump——host=123.123.12开云体育电动老虎机3.123——port=3306——user=foo——password=********* -B log——trx-consistency-only——triggers——routines -o /mysqldata/new_db/ -c -L mydump .log #(2)停止从Debezium集群的所有复制。开云体育官方注册网址$ mysql> STOP SLAVE channel 'foo';$ mysql> STOP SLAVE channel 'bar';$ mysql> STOP SLAVE channel 'baz';#从MySQL中获取当前GTID清除的值。$ mysql>显示全局变量像'%gtid_purged%';#(3)将数据库转储加载到Debezium集群中。开云体育官方注册网址开云体育电动老虎机$ myloader -d /mysqldata/new_db/ -s new_db #清除现有的GTID_PURGED值，以便我们可以覆盖它，以包括新的转储文件中的GTID。$ mysql>重置主#设置新的GTID_PURGED值，包括MySQL转储文件中的GTID_PURGED值。 $ mysql> set global GTID_PURGED="f3a44d1a-11e6-44ba-bf12-040bab830af0:1-10752,c627b2bc-b36a-11e6-a886-42010af00790:1-9052,01261abc3-6ade-11e6-9647-42010af0044a:1-375342"; # (5) Start replication for the new DB. $ mysql> CHANGE MASTER TO MASTER_HOST='123.123.123.123', MASTER_USER='REPLICATION_USER', MASTER_PASSWORD='REPLICATION_PASSWORD',MASTER_AUTO_POSITION=1 for CHANNEL 'new_db'; $ mysql> START SLAVE for channel 'new_db'; # Start replication for the DBs that we paused. $ mysql> START SLAVE for channel 'foo'; $ mysql> START SLAVE for channel 'bar'; $ mysql> START SLAVE for channel 'baz'; # Repeat steps 2-5 on the old primary (now secondary).

｛”的名字”：”开云体育官方注册网址debezium-connector-microservice1”，”配置”: {”的名字”：”开云体育官方注册网址debezium-connector-microservice1”，”connector.class”：”io.开云体育官方注册网址debezium.connector.mysql.MySqlConnector”，”tasks.max”：”1”，”开云体育电动老虎机database.hostname”：”dbz-mysql01”，”开云体育电动老虎机database.port”：”3306”，”开云体育电动老虎机database.user”：”用户”，”开云体育电动老虎机database.password”：”* * * * * * *”，”开云体育电动老虎机database.server.id”：”101”，”开云体育电动老虎机database.server.name”：”db.开云体育官方注册网址debezium.microservice1”，”gtid.source.includes”：”c34aeb9e - 89 -广告- 11 - e6 - 877 - b - 42010 - a93af2d”，”开云体育电动老虎机database.whitelist”：”microservice1_db”，”poll.interval.ms”：”2”，”table.whitelist”：”microservice1_db.table1, microservice1_db.table2”，”column.truncate.to.1024.chars”：”microservice1_db.table1.text_col”，”开云体育电动老虎机database.history.kafka.bootstrap.servers”：”kafka01:9093、kafka02:9093 kafka03:9093”，”开云体育电动老虎机database.history.kafka.topic”：”开云体育官方注册网址debezium.history.microservice1”，”开云体育电动老虎机database.ssl.truststore”：”确实的事情/信任库”，”开云体育电动老虎机database.ssl.truststore.password”：”* * * * * * *”，”开云体育电动老虎机database.ssl.mode”：”要求”，”开云体育电动老虎机database.history.producer.security.protocol”：”SSL”，”开云体育电动老虎机database.history.producer.ssl.truststore.location”：”确实的事情/信任库”，”开云体育电动老虎机database.history.producer.ssl.truststore.password”：”* * * * * * *”，”开云体育电动老虎机database.history.consumer.security.protocol”：”SSL”，”开云体育电动老虎机database.history.consumer.ssl.truststore.location”：”确实的事情/信任库”，”开云体育电动老虎机database.history.consumer.ssl.truststore.password”：”* * * * * * *”，}}

｛”之前”: {”id”：1004，”first_name”：”安妮”，”last_name”：”Kretchmar”，”电子邮件”：”annek@noanswer.org”}，”后”: {”id”：1004，”first_name”：”安妮玛丽”，”last_name”：”Kretchmar”，”电子邮件”：”annek@noanswer.org”}，”源”: {”的名字”：”mysql-server-1”，”server_id”：223344，”ts_sec”：1465581，”gtid”：零，”文件”：”mysql-bin.000003”，”pos”：484，”行”：0，”快照”：零}，”人事处”：”u”，”ts_ms”：1465581029523｝