From: Ben Clewett
Date: January 17 2008 2:36pm
Subject: Re: slaves to specific tables
List-Archive: http://lists.mysql.com/mysql/210913
Message-Id: <478F67D5.3070009@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>