Dave Stokes is a MySQL Community Manager for Oracle Corporation and travels extensively to promote MySQL, speaking over thirty times each year for the past several years. He is also the author of MySQL & JSON - A Practical Programming Guide which is a guide for those wishing to take advantage of the JSON data type and the MySQL Document Store. With degrees in computer science and business, you can find him on the road at shows like FOSDEM, SCaLE, Confoo, PHP UK, Scotland PHP, PyCaribbean, or maybe you local meetup (please let him know if you need a speaker!). Dave actually started programming in FORTRAN on punch cards on a Digital Equipment Corporation KL1091 36-bit computer and wants you to know that the dinosaurs roaming the earth at the time did make on-campus parking especially daunting. Has has been playing guitar (badly) for way too long. Dave resides in Texas with the mandatory hound dog and pickup truck.

Accepted Talks:

MySQL Replication Update

MySQL replication has been around for well over a decade and the latest version of MySQL has a lot of advancements. InnoDB cluster provides a fault tolerant, highly available cluster. Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time with read-only replicas to split the load. Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued concurrently. And to make bringing a new cluster member online easier,there is a clone plugin permits cloning data locally or from a remote MySQL server instance. Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata to have the new system operational as quickly as possible. MySQL Router is a Level 4 proxy to handle the flow of your data. Plus there are utilities in the New MySQL Shell, mysqlsh, for the easy administration of a cluster. So if you have not looked at MySQL replication in a while your will be happily surprised with the new features and performance.