Thanks for the info as I planned to use mariadb cluster. I presume our only option is mysql with replication as perconadb also uses galera so presume that wont work either.
Regards Ian > On 24 Jun 2014, at 06:42, Damoder Reddy <[email protected]> wrote: > > The problem with MariaDB/galera is it does not support explicit locking of > tables etc.. which are used inside Cloudstack code.. > > https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations/ > > > Thanks & Regards > Damodar/ > > -----Original Message----- > From: Ian Marshall [mailto:[email protected]] > Sent: Tuesday, June 24, 2014 10:25 AM > To: [email protected] > Subject: Re: Management Server HA & DB Replication > > Hi Tejas > > I suggest you try mariadb cluster v5.5. Although My only experience is using > it for active-active db for openstack, it was quite easy to set up and can > work with two installations. You can increase the nodes by using arbitrator > if you wish. See the community website for mariadb and the galera website for > more information. > > Regards > Ian > >> On 24 Jun 2014, at 05:23, Tejas Gadaria <[email protected]> wrote: >> >> Hi, >> >> I want to make MS on high availability, with automatic failover. >> I have MS & DB on same server. & planning to create slave DB on >> separate server. >> >> but if I create separate Slave MS for HA, how can point it to DB so >> command issued from any of MS will trigger to same infrastructure. >> >> Regards, >> Tejas
