You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Tejas Gadaria <re...@gmail.com> on 2014/06/24 06:23:04 UTC
Management Server HA & DB Replication
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
Re: Management Server HA & DB Replication
Posted by Tejas Gadaria <re...@gmail.com>.
Thanks Suresh!
Regards,
Tejas
On Tue, Jun 24, 2014 at 5:37 PM, Suresh Sadhu <Su...@citrix.com>
wrote:
> IN a cluster management setup:
>
> ON Master MS you will install master db with deploy option
> Cloudstack-setup-databases cloud@10.1.1.2 --deploy-as=root
>
> On slave MS : you will point to master db
> Cloudstack-setup-databases cloud@10.1.1.2
>
> ( here don't mention --deploy-as option on slave if you mention then it
> will overwrite the master db content)
>
> Once you ran the above command on slave you can see
> "db.cloud.host" point to master IP in db.properties file
>
>
> Note: always take a baclkup of your DB before doing cluster management
> setup .Due to any mistake if master db got overwritten and you can safely
> revert back using ur backup copy
>
> Regards
> Sadhu
>
> -----Original Message-----
> From: Tejas Gadaria [mailto:refond.gmrt@gmail.com]
> Sent: 24 June 2014 17:04
> To: dev@cloudstack.apache.org
> Cc: users@cloudstack.apache.org
> Subject: Re: Management Server HA & DB Replication
>
> Hi abhi,
>
> My 1st MS & DB Master running on : 10.1.1.2 2nd MS & DB Slave running on :
> 10.1.1.3
>
> MS will be in cluster so
>
> Both MS will be pointed to : 10.1.1.2
> Is it correct ?
>
> If so,
> Which parameter should I change in db.properties to point MS cluster to db
> master?
>
> Regards,
> Tejas
>
>
> On Tue, Jun 24, 2014 at 3:54 PM, Abhinandan Prateek <
> Abhinandan.Prateek@citrix.com> wrote:
>
> > MS will work in a cluster pointing to same DB. The DB can be
> > configured as master-slave.
> >
> > https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838
> > 207
> >
> > -abhi
> >
> > On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
> >
> >
>
Re: Management Server HA & DB Replication
Posted by Tejas Gadaria <re...@gmail.com>.
Thanks Suresh!
Regards,
Tejas
On Tue, Jun 24, 2014 at 5:37 PM, Suresh Sadhu <Su...@citrix.com>
wrote:
> IN a cluster management setup:
>
> ON Master MS you will install master db with deploy option
> Cloudstack-setup-databases cloud@10.1.1.2 --deploy-as=root
>
> On slave MS : you will point to master db
> Cloudstack-setup-databases cloud@10.1.1.2
>
> ( here don't mention --deploy-as option on slave if you mention then it
> will overwrite the master db content)
>
> Once you ran the above command on slave you can see
> "db.cloud.host" point to master IP in db.properties file
>
>
> Note: always take a baclkup of your DB before doing cluster management
> setup .Due to any mistake if master db got overwritten and you can safely
> revert back using ur backup copy
>
> Regards
> Sadhu
>
> -----Original Message-----
> From: Tejas Gadaria [mailto:refond.gmrt@gmail.com]
> Sent: 24 June 2014 17:04
> To: dev@cloudstack.apache.org
> Cc: users@cloudstack.apache.org
> Subject: Re: Management Server HA & DB Replication
>
> Hi abhi,
>
> My 1st MS & DB Master running on : 10.1.1.2 2nd MS & DB Slave running on :
> 10.1.1.3
>
> MS will be in cluster so
>
> Both MS will be pointed to : 10.1.1.2
> Is it correct ?
>
> If so,
> Which parameter should I change in db.properties to point MS cluster to db
> master?
>
> Regards,
> Tejas
>
>
> On Tue, Jun 24, 2014 at 3:54 PM, Abhinandan Prateek <
> Abhinandan.Prateek@citrix.com> wrote:
>
> > MS will work in a cluster pointing to same DB. The DB can be
> > configured as master-slave.
> >
> > https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838
> > 207
> >
> > -abhi
> >
> > On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
> >
> >
>
RE: Management Server HA & DB Replication
Posted by Suresh Sadhu <Su...@citrix.com>.
IN a cluster management setup:
ON Master MS you will install master db with deploy option
Cloudstack-setup-databases cloud@10.1.1.2 --deploy-as=root
On slave MS : you will point to master db
Cloudstack-setup-databases cloud@10.1.1.2
( here don't mention --deploy-as option on slave if you mention then it will overwrite the master db content)
Once you ran the above command on slave you can see
"db.cloud.host" point to master IP in db.properties file
Note: always take a baclkup of your DB before doing cluster management setup .Due to any mistake if master db got overwritten and you can safely revert back using ur backup copy
Regards
Sadhu
-----Original Message-----
From: Tejas Gadaria [mailto:refond.gmrt@gmail.com]
Sent: 24 June 2014 17:04
To: dev@cloudstack.apache.org
Cc: users@cloudstack.apache.org
Subject: Re: Management Server HA & DB Replication
Hi abhi,
My 1st MS & DB Master running on : 10.1.1.2 2nd MS & DB Slave running on : 10.1.1.3
MS will be in cluster so
Both MS will be pointed to : 10.1.1.2
Is it correct ?
If so,
Which parameter should I change in db.properties to point MS cluster to db master?
Regards,
Tejas
On Tue, Jun 24, 2014 at 3:54 PM, Abhinandan Prateek < Abhinandan.Prateek@citrix.com> wrote:
> MS will work in a cluster pointing to same DB. The DB can be
> configured as master-slave.
>
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838
> 207
>
> -abhi
>
> On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
>
>
RE: Management Server HA & DB Replication
Posted by Suresh Sadhu <Su...@citrix.com>.
IN a cluster management setup:
ON Master MS you will install master db with deploy option
Cloudstack-setup-databases cloud@10.1.1.2 --deploy-as=root
On slave MS : you will point to master db
Cloudstack-setup-databases cloud@10.1.1.2
( here don't mention --deploy-as option on slave if you mention then it will overwrite the master db content)
Once you ran the above command on slave you can see
"db.cloud.host" point to master IP in db.properties file
Note: always take a baclkup of your DB before doing cluster management setup .Due to any mistake if master db got overwritten and you can safely revert back using ur backup copy
Regards
Sadhu
-----Original Message-----
From: Tejas Gadaria [mailto:refond.gmrt@gmail.com]
Sent: 24 June 2014 17:04
To: dev@cloudstack.apache.org
Cc: users@cloudstack.apache.org
Subject: Re: Management Server HA & DB Replication
Hi abhi,
My 1st MS & DB Master running on : 10.1.1.2 2nd MS & DB Slave running on : 10.1.1.3
MS will be in cluster so
Both MS will be pointed to : 10.1.1.2
Is it correct ?
If so,
Which parameter should I change in db.properties to point MS cluster to db master?
Regards,
Tejas
On Tue, Jun 24, 2014 at 3:54 PM, Abhinandan Prateek < Abhinandan.Prateek@citrix.com> wrote:
> MS will work in a cluster pointing to same DB. The DB can be
> configured as master-slave.
>
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838
> 207
>
> -abhi
>
> On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
>
>
Re: Management Server HA & DB Replication
Posted by Tejas Gadaria <re...@gmail.com>.
Hi abhi,
My 1st MS & DB Master running on : 10.1.1.2
2nd MS & DB Slave running on : 10.1.1.3
MS will be in cluster so
Both MS will be pointed to : 10.1.1.2
Is it correct ?
If so,
Which parameter should I change in db.properties to point MS cluster to db
master?
Regards,
Tejas
On Tue, Jun 24, 2014 at 3:54 PM, Abhinandan Prateek <
Abhinandan.Prateek@citrix.com> wrote:
> MS will work in a cluster pointing to same DB. The DB can be configured as
> master-slave.
>
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838207
>
> -abhi
>
> On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
>
>
Re: Management Server HA & DB Replication
Posted by Tejas Gadaria <re...@gmail.com>.
Hi abhi,
My 1st MS & DB Master running on : 10.1.1.2
2nd MS & DB Slave running on : 10.1.1.3
MS will be in cluster so
Both MS will be pointed to : 10.1.1.2
Is it correct ?
If so,
Which parameter should I change in db.properties to point MS cluster to db
master?
Regards,
Tejas
On Tue, Jun 24, 2014 at 3:54 PM, Abhinandan Prateek <
Abhinandan.Prateek@citrix.com> wrote:
> MS will work in a cluster pointing to same DB. The DB can be configured as
> master-slave.
>
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838207
>
> -abhi
>
> On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
>
>
Re: Management Server HA & DB Replication
Posted by Abhinandan Prateek <Ab...@citrix.com>.
MS will work in a cluster pointing to same DB. The DB can be configured as
master-slave.
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838207
-abhi
On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
Re: Management Server HA & DB Replication
Posted by Abhinandan Prateek <Ab...@citrix.com>.
MS will work in a cluster pointing to same DB. The DB can be configured as
master-slave.
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838207
-abhi
On 24/06/14 9:53 am, "Tejas Gadaria" <re...@gmail.com> 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
RE: Management Server HA & DB Replication
Posted by Damoder Reddy <Da...@citrix.com>.
Yes, from 4.3 onwards we enabled DB-HA within cloudstack using mysql replication and connector configurations.
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=34838207
Thanks & Regards
Damodar/
-----Original Message-----
From: Ian Marshall [mailto:ian@itlhosting.co.uk]
Sent: Tuesday, June 24, 2014 11:31 AM
To: users@cloudstack.apache.org
Subject: Re: Management Server HA & DB Replication
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 <Da...@citrix.com> 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:ian@itlhosting.co.uk]
> Sent: Tuesday, June 24, 2014 10:25 AM
> To: users@cloudstack.apache.org
> 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 <re...@gmail.com> 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
Re: Management Server HA & DB Replication
Posted by Ian Marshall <ia...@itlhosting.co.uk>.
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 <Da...@citrix.com> 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:ian@itlhosting.co.uk]
> Sent: Tuesday, June 24, 2014 10:25 AM
> To: users@cloudstack.apache.org
> 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 <re...@gmail.com> 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
RE: Management Server HA & DB Replication
Posted by Damoder Reddy <Da...@citrix.com>.
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:ian@itlhosting.co.uk]
Sent: Tuesday, June 24, 2014 10:25 AM
To: users@cloudstack.apache.org
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 <re...@gmail.com> 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
Re: Management Server HA & DB Replication
Posted by Ian Marshall <ia...@itlhosting.co.uk>.
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 <re...@gmail.com> 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