Using blackhole storage engine as binlog server in master/slave replcation
Monday 5:45PM
@ Demo Theater in the Exhibit Hall
MySQL / MariaDB
Lightning Talk
Intermediate
Tracks:Business / Case Studies, Operations
In master/slave replication cluster, there are many branch nodes. They are full-blown database servers yet its only purpose is to serve binlogs to its slaves.
Blackhole storage engine does not storage any data in the table, but allows the transactions to be recorded in the binlogs. Therefore it is suitable as binlog servers with reduced capacity requirements.
With the release of Percona server 5.7.20-19 in January 2018, MySQL server becomes a viable solution as it fixes two critical bugs related to blackhole engine.
This talk describes the implementation details.
Speakers
Michael Wang (Salesforce)
MySQL DBA
Biography:
Michael Wang is a MySQL DBA at Salesforce, he has been attending and giving talks at previous Percona Live conferences for past three years.
Connect with Percona
Stay Connected on:
Percona Live Conferences
The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
Contact Us
For general information about the event/expo/conference, including registration, please contact us at:
- info(@) percona.com
- +1-888-401-3401
- +1-919-948-2863