Categories
MySQL Replication

MySQL Replication Series tip #1: what should be replicated

MySQL Replication Series tip #1: what should be replicated and what should not be replicated? | Technology: Learn and Share

Welcome to Tip #1 in MySQL Replication Series. In this tip we will go over what to do when you only want to replicate certain data to slaves. Most general way to tell what is replicated to which slave is to include following configuration directive in my.cnf file depending on your environment and your goals. We will start with slave server side options since you have more flexibility on slave on what to replicate and what not to.