Replicating several databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
determinedmoth
Forum Commoner
Posts: 33
Joined: Wed Jul 07, 2004 9:13 am

Replicating several databases

Post by determinedmoth »

Hi
I have replication set up between my primary server and it's failover. Currently I have 1 database set up that caters for all sites on that box. Being that that is a security issue, each new site is going to get it's own database.

So, I have database_1, and I have added database_2. How do I go about adding database_2 to the current replication setup? I've not found any information thus far to help me with this and swear I must be missing something obvious.

Thanks.
determinedmoth
Forum Commoner
Posts: 33
Joined: Wed Jul 07, 2004 9:13 am

Post by determinedmoth »

ah ah. Got it.

--replicate-do-db=db_name

The way is to simply add another line in my.cnf as above...

As you were!
Post Reply