***BOGO*** Re: recommended high availability setups

[Dan Nelson <dnelson@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx