MySQL Replication 101

MySQL replication is the backbone of the web economy. Its usage has allowed tiny startup companies to become internet giants without huge investments in hardware and licenses. This tutorial will introduce MySQL replication from the ground up. It will cover the basics of how replication works before explaining how to set replication and extend your cluster of servers. Attendees will learn: * How to instantiate simple master/slave system; * How to start, stop, inspect, and monitor replication nodes; * How to add a new slave; * Common mistakes to avoid; * How to use replication to help taking a backup; * How to set replication filters; * Useful tools for replication

Track: 
Tutorials
Experience level: 
Beginner

Schedule info

Time slot: 
10 April 09:30 - 12:30
Room: 
Ballroom C

Schedule Info

10 April 09:30 - 12:30 @
Ballroom C

Speakers

QA Director, Continuent, Inc

QA Director at Continuent
I am active member of the MySQL community and long timer open source enthusiast. During the past 25 years I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C , French, Spanish, Java. I work in cyberspace, with a virtual team.

Slides




Sponsored By