I am new to mysql and I have a query in regards to mysql replication.
Currently, I have a master database that replicates to four slave servers at the moment. I would need to set up a few replication servers(as slave) but these will replicate only a few databases. How would approach this issue?
Should I be using something like this on slave /etc/my.cnf?
Can I set something on slave configuration stating exactly which databases and tables to be replicated?
Should the changes happen only on the slave configuration or on master as well? The reason being this master server currently replicates whole lot of databases to other slaves which will remain as it is.