Performance practices for minimizing replication delay

For many applications, significant (seconds to minutes) replication delay is not acceptable. In this session, the speaker will cover practices to avoid or minimize replication delay. The following topics will be covered. - How to check replication delay correctly Using "replication clock table" is a common practice. Seconds_Behind_Master often tells lies. Probably the most annoying case is Seconds_Behind_Master returns 0 and SQL/IO_Running return Yes even though I/O thread is not actually running. The speaker will show some interesting examples. - H/W and my.cnf configurations Using larger memory or using SSD is very effective. When using SSD, reducing write volumes (i.e. disabling doublewrite) is also effective. The speaker will show some examples how these optimizations are effective. - Slave Prefetching Slave prefetching is often very effective to reduce replication delay. The speaker will introduce "Replication Booster (http://yoshinorimatsunobu.blogspot.com/2011/10/making-slave-pre-fetching...)" here. - Multiple SQL threads MySQL 5.6 supports parallel SQL threads. The speaker will show some benchmarks how parallel threads helps. - Case study The speaker will show some examples of replication delay, and will explain how to solve them. (i.e. bad queries, massive random reads, sudden stalls, etc)

Track: 
Replication and High Availability Strategies
Experience level: 
Intermediate

Schedule info

Time slot: 
11 April 11:00 - 11:50
Room: 
Ballroom G

Schedule Info

11 April 11:00 - 11:50 @
Ballroom G

Speakers

Yoshinori Matsunobu's picture
Database Engineer, Facebook

Yoshinori is a database engineer at Facebook. Before joining Facebook,
Yoshinori was a database and infrastructure architect at DeNA, living in Tokyo. Yoshinori's primary responsibility at DeNA is to make our database infrastructure more reliable, faster and more scalable. Before joining DeNA, Yoshinori worked at MySQL/Sun/Oracle as a lead consultant in APAC for four years. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.




Sponsored By