mysql-learning the choice of -10-20170531-replication types

mysql-learning the choice of -10-20170531-replication types

How does positioning be a big business when encountering a delay from the library?  What will you do if you delay from the library?   First show slave status\g; There is a exec_master_log_position inside the digital card master, will not move, then 1 through Mysqlbinlog has 2 threads io_thread, sql_thread second_behind_master = Io_ Thread.timestamp-sql_thread.timestamp MySQL 10,000 inserts per second is very easy
Second_behind_master = 0

S1, S2, S3 them who synchronization of the most forward, how to judge???  Gtid does not have the above second_behind_master this parameter first to determine whether it is not the io_thread pull over the log execution is complete. Read_master_log_file==relay_master_log_file
Read_master_log_pos = Exec_master_log_pos
Recivie_gtid, Execute_gtid

And look who's on top of that?

Let's see if a file is worse.

S1.read_master_log_file S2. Read_master_log_file

and see if the following position is consistent?

S1.read_master_log_pos = = S2.read_master_pos

Recommended configuration for row format +gtid

Require an ACK response from the io_thread of the library to the main library
Protection of Binlog log transmission

In the financial environment: if half-sync is used, it is set in Settings, Bushin switches from semi-synchronous to asynchronous

PXC is the principle of synchronous replication

"bubbling" a608-Li Weiliang-Chengdu (673529096) 21:45:27
MySQL 5.7 Semi-synchronous enhancement, increase the Rpl_semi_sync_master_wait_slave_count parameter control how many slave write transactions the main library receives successful feedback before returning to the client successfully
"Admin" Wu Bingxi (82565387) 21:46:08
Rpl_semi_sync_master_wait_for_slave_count
default is 1

Mysqlbinlog + Semi-sync
Row+gtid

"Admin" Wu Bingxi (82565387) 22:21:36
Master_log_file= ' mysql-bin.000100 ', master_log_pos=10000000
But there's another one on the main library: mysql-bin.000101
"Admin" Wu Bingxi (82565387) 22:23:02
mysqlbinlog-start-position=10000000 mysql-bin.000100 |mysql-h s1-p xxx-pxxxx-uxxxx
"Active" a475-Chen Tao-Suzhou (20548079) 22:23:17
Executed twice
"Admin" Wu Bingxi (82565387) 22:23:17
Mysqlbinlog mysql-bin.000101 |mysql-h s1-p xxx-pxxxx-uxxxx
Mysqlbinlog mysql-bin.000101 mysql-bin.000102 |mysql-h s1-p xxx-pxxxx-uxxxx

mysql-learning the choice of -10-20170531-replication types