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

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