What do you mean by storing a subset? Are you only wanting to replication a portion of the tables? If so, you can configure the master to ignore certain databases or you can configure the slave to apply updates for certain databases/tables or prohibit the master from replicating certain databases/tables. Master my.cnf binlog-ignore-db=<database-name> OR In the slave my.cnf file you use the replicate-ignore-table=<table-name> replicate-ignor-db=<database-name> or replicate-wild-ignore-table=<pattern>
to replicate a `subset`. -----Original Message----- From: Callan Tham To: [EMAIL PROTECTED] Sent: 5/25/04 11:54 AM Subject: Storing a subset of data in a slave database Hi everyone, I am trying to set up database replication, and would like to know if I can store just a subset of data in the slave DB. Anyone has any insight? Thanks in advance, Callan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
