Luis Soares

Row-based binary log is mostly used as a logical replication log for MySQL. However, ever since row-based replication was introduced, it has also been widely used as an integration point between a MySQL server and other components in an IT infrastructure. It is often used as a capture-data-changes stream, as a source of data for extract-transform-load operations or even as an event notification trigger (e.g., propagating transaction information to proxy layers).

Commonly deployed setups revolve around collecting/subscribing to data changes and propagating these to downstream consumers through a message bus, like Kafka for instance.

This session will present such use cases, highlighting the additional metadata added to the binary log in the latest releases, explain how to efficiently make the most out of these and how to optimize the implementation of a change capture procedure. We will also showcase a couple of example plugins that tap into the server's binary log stream and export it even before it reaches the binary log files.

MySQL replication is the foundation for both scalability and high availability for many of the world’s busiest services, in particular, those that operate at scale on the Web. In fact, some of the largest and highest profile online applications trust their data to MySQL and regard MySQL Replication as the key technology to ensure that data is always available, even in the event of catastrophic disasters.

MySQL Replication strives to keep on meeting the ever tougher requirements of online services so that it can be deployed together with them in symbiotic harmony. In fact, in recent years we have seen an exponential development in MySQL, in particular in replication.

MySQL 5.6 was a major step forward, with fabulous replication features, but the work continues and MySQL 5.7 is set to be another ground breaking release. The next generation of replication features are scattered over several technical areas, including: better semi-synchronous replication; enhanced multi-threaded slave performance; improved monitoring; online configuration changes; options for fine tuning the replication stream performance; support for more advanced topologies; developer friendly frameworks and much more. This is just the tip of the iceberg. In fact, in the lab we have more exciting news such as the MySQL Group Replication plugin, a plugin that brings group communication techniques and database replication together.

Seize the opportunity to learn about the new MySQL Replication features' internals, the technical details and the roadmap. Come and learn what is already there in MySQL 5.7 and what's still in the making.

MySQL replication is the foundation for both scalability and high availability for many of the world’s busiest services, in particular, those that operate at scale on the Web. In fact, some of the largest and highest profile online applications trust their data to MySQL and regard MySQL Replication as the key technology to ensure that data is always available, even in the event of catastrophic disasters.

MySQL Replication strives to keep on meeting the ever tougher requirements of online services so that it can be deployed together with them in symbiotic harmony. In fact, in recent years we have seen an exponential development in MySQL, in particular in replication.

MySQL 5.6 was a major step forward, with fabulous replication features, but the work continues and MySQL 5.7 is set to be another ground breaking release. The next generation of replication features are scattered over several technical areas, including: better semi-synchronous replication; enhanced multi-threaded slave performance; improved monitoring; online configuration changes; options for fine tuning the replication stream performance; support for more advanced topologies; developer friendly frameworks and much more. This is just the tip of the iceberg. In fact, in the lab we have more exciting news such as the MySQL Group Replication plugin, a plugin that brings group communication techniques and database replication together.

Seize the opportunity to learn about the new MySQL Replication features' internals, the technical details and the roadmap. Come and learn what is already there in MySQL 5.7 and what's still in the making.

MySQL Group Replication is a recent MySQL plugin that brings together group communication techniques and database replication, providing both a high availability and a multi-master update everywhere replication solution.

At its core is a set of group communication primitives that act as the building blocks to create reliable, consistent and dependable messaging between the servers in the group. This allows the set of MySQL servers to coordinate themselves and act as a consistent and replicated state machine - in which transactions commit in the same order on every server. As a consequence, the group itself is fault-tolerant, and so is the service provided by the group - the MySQL database service.

In addition to HA, the plugin provides multi-master update everywhere with row-level conflict detection. This builds on the fact that the servers in the group have to agree on how to progress the replicated state machine and so also check for conflicts.

Come and learn about the technical details of the exciting and popular MySQL Group Replication plugin and discuss how this fits in the overall picture of MySQL HA solutions.

MySQL Group Replication is a recent MySQL plugin that brings together group communication techniques and database replication, providing both a high availability and a multi-master update everywhere replication solution.

At its core is a set of group communication primitives that act as the building blocks to create reliable, consistent and dependable messaging between the servers in the group. This allows the set of MySQL servers to coordinate themselves and act as a consistent and replicated state machine - in which transactions commit in the same order on every server. As a consequence, the group itself is fault-tolerant, and so is the service provided by the group - the MySQL database service.

In addition to HA, the plugin provides multi-master update everywhere with row-level conflict detection. This builds on the fact that the servers in the group have to agree on how to progress the replicated state machine and so also check for conflicts.

Come and learn about the technical details of the exciting and popular MySQL Group Replication plugin and discuss how this fits in the overall picture of MySQL HA solutions.

The new replication features in MySQL 5.7 help users to further reduce downtime, thus increasing data and service availability. Moreover, they consolidate MySQL as a perfect fit for distributed environments such as elastic clouds.

The most recent Development Milestone Release presents a lot of new and exciting enhancements. Worth noting the latest developments on semi-synchronous replication, multi-threaded slave, and replication instrumentation for accessing internal stats through performance schema tables. In addition, the work done to make replication more scalable, perform even better and be more user friendly also deserves some of the spotlight.

Therefore, don't miss this chance to meet with the engineers behind the product, to get to know the next generation of replication features and to influence future development. Lets talk about MySQL Replication!

"MySQL Replication is a proven, simple and popular technology used to fulfil many different requirements. Whether it is used as a simple data store for a web shop, as an online backup tool or even as a mean to extract reports without impacting the master, it is always regarded as a very simple to setup and intuitive solution.

Coupled together with emergent tools and technologies, such as MySQL utilities, MySQL proxy or even the binary log API, it opens a wide range of possibilities for building complex and very useful solutions, yet in a very simple way. For example, aggregating data from multiple data centers, migrating data from/into MySQL servers and other databases, using esoteric slaves as external full-text search engines or even bridging into non-traditional and/or non-relational external components to handle special requirements, these are all possibilities that one can think of. Furthermore, MySQL 5.6 Replication shows up as an enabler for many of these settings.

This session will showcase some advanced architectures combining MySQL 5.6 Replication and other tools."