Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

As my title mention I have a Master and a Slave database.

Master if for operations data and my slave mainly for reporting stuff.

The issue is that I need to create extra tables on reporting that can't be on the master, but the way my replication is set (the simplest one mentioned by the official doc) at the moment, this breaks the replication system.

How could I add tables on the Slave without Master caring about it ? Is it even possible ?

share|improve this question
2  
It is totally possible and should work without a problem on the slave in a simple/common/default configuration, so please explain what you mean by "this breaks the replication system." Do you mean theoretically? Or in your actual system? In what way does it break? – Michael - sqlbot Mar 27 at 11:42

1 Answer

up vote 0 down vote

I think I got a rough idea how you setup replication. I think you have taken mysqldump --all-databases ... something along those lines.

Now if you want extra tables inside one of those database that you exported by mysqldump and those that belong to the master replication will break as you mentioned aswell.

Now to create more tables you need to create a new database with some name and then create tables in there. This will not break the replication.

I do not know if this helps....

Masood

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.