List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:June 2 2008 7:11am
Subject:Re: slaves to specific tables
View as plain text  
Pay attention to the database must be binloged in the my.cnf.

On Thu, Jan 17, 2008 at 10:36 PM, Ben Clewett <ben@stripped> wrote:

> 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
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Thread
slaves to specific tablesPaul Berry17 Jan
  • Re: slaves to specific tablesBen Clewett17 Jan
    • Re: slaves to specific tablesMoon's Father2 Jun