MySQL Replication Tricks & Tips

Learn how you can leverage MySQL replication to achieve better scalability and high availability!

Replication is a versatile tool to solving many problems in today's highly dynamic modern web architectures, as well as offering many ways to simplify maintenance.

This presentation provides useful tips and tricks related to the MySQL 5.5 GA and MySQL 5.6 Development Milestone Release, including:

  • Ways to set up multi-source replication
  • Multi-master setup: do's and don't
  • Using logs for auditing
  • Ways to handle filtering
  • Keeping the system online
  • Examining the binary log
  • Using relay slaves
  • Splitting the replication stream
  • Handling fail-over