I have a mysql database that contains some tables with private information, and some tables with public information.
I would like to replicate only the tables containing public information from one database to another, making sure that NO confidential information ever gets stored on the slave.
I know I can use the
replicate-do-table to specify that only some tables are replicated, but my understanding is that the entire bin log is transferred to the slave.
Is there a way to ensure that only the public information is transferred to the slave?
I am very hesitant to add another copy of the database to an existing server - I just don't think the existing server has the available capacity, in either RAM or CPU.