Master - Slave MySQL Replication - Which dB tables?
 

Hello*

I searched the vB on-line manual and could not find any references to MySQL master-slave replication.

We are replicating our vB database and the MySQL configuration is working fine.

However* normally when you replicate a dB there are some tables that should not be replicated. For example* statistics and site logging tables should not be replicated unless the plan is to have distributed statistics.

We don't have this plan* and simply want to replicate in a master (read-write) and slave (read-only) configuration.

As I said* all is working fine* but we could not find any documentation on which tables NOT to replicate.

Is there a HOWTO document that covers this?

Thanks.