List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 28 2008 9:53pm
Subject:Re: recommended high availability setups
View as plain text  
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
Thread
recommended high availability setupsBryan Irvine28 Aug
  • Re: recommended high availability setupsJimmy Guerrero28 Aug
    • Re: recommended high availability setupsBryan Irvine28 Aug
    • Re: recommended high availability setupsBryan Irvine28 Aug
      • Re: recommended high availability setupsDan Nelson28 Aug
  • RE: recommended high availability setupsMartin Gainty29 Aug