From: Dan Nelson
Date: August 28 2008 9:53pm
Subject: Re: recommended high availability setups
List-Archive: http://lists.mysql.com/mysql/214287
Message-Id: <20080828215351.GH26653@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 28), Bryan Irvine said:
> I saw that.  That's what initially got me thinking that I might need
> to look elsewhere for a different HA solution.
> 
> The biggest thing is that the DB is for a hosting company.  This
> company could add databases for their clients upon a request and at
> any point during the day.  The current master-master that I've got set
> up and working in my test environment requires the MySQL server be
> restarted because you have to manually add the databases you want to
> sync to the my.cnf file.

Instead of specifying databases to replicate with the replicate-do-db
option, why not specify the databases you /don't/ want to replicate
with the replicate-ignore-db option?  Then any newly-created databases
will get replicated automatically.

-- 
	Dan Nelson
	dnelson@stripped