This will be helpful for many people who do not want to spend much money for standby servers (i.e. DRBD) but also want to achieve short-time failover.
Another interesting failure scenario is a slave crash. Since updating master.info, relay-log.info and InnoDB log files is not atomic each other, data consistency might be broken when a slave crashes. In other words, replication thread might stop on restart due to “duplicate key error”. Do you recover slaves by restoring a full backup file? This is not fun. MySQL development team and communities have worked a lot for this area. I’ll talk an approach to check consistencies between relay logs and InnoDB log file, and recovering consistency without full data restore.
Non-stop scheduled maintenance is also an interesting topic. Maintenance tasks such as online schema changes, sharding, aggregating shards, migration are not trivial, but third-party tools such as oak-online-alter-table/OSC, Spider, etc have made things much easier. I’ll talk about how to achieve non-stop sharding operations.
Yoshinori Matsunobu is 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.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts
Comments
Good description of what is involved in failover but I was expecting to hear how it was automated. Either It was explained while I wasn’t looking or the speaker forgot to cover that part.