views:

77

answers:

2

OK when working with table creation, is it always assumed that creating a table on one database (the master) mean that the DBA should create the table on the slave as well? Also, if using a master/slave configuration, shouldn't data always be getting replicated from the master to the slave to synch?

Right now the problem I am having is my database has a lot of stuff in the master, but the slave is missing parts that only exist in the master. Is something not configured correctly here?

A: 

I prefer to rely on CREATE TABLE statements being replicated to set up the table on the slave, rather than creating the slave's table by hand. That, of course, relies on the DBMS supporting this.

If you have data on the master that isn't on the slave, that's some sort of failure of replication, either in setup or operationally.

chaos
A: 

Depends how the replication is configured. Real time replication should keep the master and slave in sync at all times. "Poors mans" replication is usually configured to sync upon some time interval expiring. This is whats probably happening in your case.

ennuikiller
Well the thing here is that for our company, we have to notify the DBA which tables should be replicated. Doesn't that contradict the entire master/slave methodology?
Steven Wright
@steven Wright, the concept of DB replication can take many forms. Partial replication (slaving only a subset), "superimposed" replication (pooling together many masters), multimaster, etc. can all be useful.
pilcrow
@pilcrow, Maybe it could be using Partial replication then.
Steven Wright