Synchronous Replication For MySQL

Speaker: Kenny Gryp (Percona)

Abstract

Built-in MySQL Replication is known for its capability to enable to scale reads easily. However, there are some limitations and known issues with this solution because of the asynchronous nature of this replication. This talk will describe another way of doing MySQL replication, by using synchronous replication, available in Percona XtraDB Cluster. The open source solution will be explained and compared to traditional asynchronous MySQL replication, as well as some known use cases will be described. Percona XtraDB Cluster is an, open source, high availability and high scalability solution for MySQL clustering. Features include: Synchronous replication, Multi-master replication support, Parallel replication, Automatic node provisioning.

Biography

Kenny is currently Principal Consultant at Percona. Bitten somewhere in the late 90s by the open-source bug, most of his spare time was spent working with Linux & OpenBSD servers. Eventually, after education, Kenny turned into a Linux system engineer and performed that role at various companies. Before joining Percona, he worked at a large social networking company in Europe as DBA and Puppeteer.