OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: slaves to specific tables

From: Ben Clewett (benclewett.org.uk)
Date: Thu Jan 17 2008 - 08:36:05 CST


I do it all the time, look at:

--replicate-do-table

In: http://dev.mysql.com/doc/refman/5.0/en/replication-options.html

Section of my mysql.conf:

# Replication Options
replicate_do_table = db.member
replicate_do_table = db.company
replicate_do_table = db.site
replicate_do_table = (etc)

Ben

Paul Berry wrote:
> hey guys - is it possible to have a lightweight slave setup? so that you
> only take X amount of tables from the DB
> curious what good solutios are out there
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql