If you are wanting each database to replicate only certain databases then you should look over the replication commands. http://www.mysql.com/doc/en/Replication_Options.html --replicate-do-db=database_name might be able to solve your issue.
-----Original Message----- From: ron To: [EMAIL PROTECTED] Sent: 3/11/04 10:39 AM Subject: Replication - separate binary logs Hello (first post) I'm a noob to this group but I have an issue which I am hoping there is a solution to. I would like to have one instance of mysqld serving many databases, and acting as a master server. Each slave will only replicate one database, and it would be undesirable for them to be able to access separate databases. I thought the built in replication tool was exactly what was required, with separate users for each DB. But I came across a snag. Even though each slave has access to only one database, the replication log they retrieve from the master contains sql statements pertaining to the other databases, from which they can gather information I would rather they not see. So my question is - can one instance of mysqld maintain multiple binary logs, specific to each database, or would I need separate instances of mysqld for each database? TIA Ron Heywood -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
