03 八 10 MySQL学习
从今天开始，会陆续帖些有关mysql的tips.
在mysql replication中我们知道的M/S架构外，可参考如上的扩展patch.
Notes: 在主从复制时，通过修改slave IO线程拷贝Master的binlog到slave机器上.
Example:
Server A, the master
# at 499 #080424 16:14:38 server id 11306 end_log_pos 618 Query thread_id=6 exec_time=0 error_code=0 SET TIMESTAMP=1209078878/*!*/; insert into t1 values (1,2), (3,4), (5,6), (7,8), (9,10)/*!*/; # at 618 #080424 16:14:56 server id 11306 end_log_pos 712 Query thread_id=6 exec_time=0 error_code=0 SET TIMESTAMP=1209078896/*!*/; insert into t2 select * from t1/*!*/;
Server B, first level slave
# at 98 #080424 16:14:38 server id 11306 end_log_pos 217 Query thread_id=6 exec_time=12 error_code=0 use test/*!*/; SET TIMESTAMP=1209078878/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/; SET @@session.sql_mode=0/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; insert into t1 values (1,2), (3,4), (5,6), (7,8), (9,10)/*!*/; # at 217 #080424 16:14:56 server id 11306 end_log_pos 311 Query thread_id=6 exec_time=0 error_code=0 SET TIMESTAMP=1209078896/*!*/; insert into t2 select * from t1/*!*/;
Server C, second level slave
# at 296 #080424 16:14:38 server id 11306 end_log_pos 415 Query thread_id=6 exec_time=24 error_code=0 SET TIMESTAMP=1209078878/*!*/; insert into t1 values (1,2), (3,4), (5,6), (7,8), (9,10)/*!*/; # at 415 #080424 16:14:56 server id 11306 end_log_pos 509 Query thread_id=6 exec_time=6 error_code=0 SET TIMESTAMP=1209078896/*!*/; insert into t2 select * from t1/*!*/;
People who looked at this item also looked at…
Related items
Tags: mysql, mysql replication
