Easy MySQL Replication Setup and Troubleshooting
Replication and High Availability Strategies
4 April 11:00AM - 11:50AM @ Ballroom G
50 minutes conference
Do you need to set up replication for MySQL? Afraid that it'll take hours or it's just not worth the trouble? Got it going but seeing weird errors? This presentation plainly describes MySQL replication in just enough depth then shows you how to get it running. Typical replication failures and fixes are discussed also. Replication can seem complicated if you haven't set it up before. This presentation aims to describe how to use and fix replication as plainly as possible, focusing on current MySQL versions. Once one knows the basic mechanism of MySQL replication, it's much easier to set up and to troubleshoot. Aimed at MySQL users who are familiar with the database but new to replication, this presentation begins by describing how data flows from master to replication slave. Config settings and relevant commands are covered, then a walk-through of setting up replication is done. After slightly more advanced replication topics are covered, typical failures and their fixes are described. Here's the outline: A. Description of MySQL replication 1. master database 2. binary logs 3. slave database B. Configuration parameters for basic replication setup C. Commands that control replication D. Basic replication setup: Walk-through E. Beyond basic replication 1. limiting replicated tables or schemas 2. multiple-level replication F. Troubleshooting 1. Typical failures 2. Corrective actions G. Questions Prerequisites: Passing familiarity with Linux/Unix shell. Minimal knowledge of MySQL.
Principal, Database Engineering, Salesforce Marketing Cloud
Bob has been squeezing every drop out of MySQL for several years, having previously spent several years roaming in the Garden of Oracle. In late 2007, he found himself suddenly (and without warning) responsible for storing and retrieving all the information amassed at Radian6, the original leading social media monitoring company. Now, as Principal DBA leading a team of five at Salesforce Marketing Cloud (which Radian6 is now part of), the database challenges are bigger than ever.