[jira] [Commented] (CLOUDSTACK-4916) To Enable Master Database High Availabilty.

["Damodar Reddy T (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-4916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13802831#comment-13802831 ] 

Damodar Reddy T commented on CLOUDSTACK-4916:
---------------------------------------------

Looked into Percona XtraDB Cluster setup and tried to do the setup in local.

Found the following limitations/concerns over it.

Limitations (http://www.percona.com/doc/percona-xtradb-cluster/limitation.html , ):
1.	We cannot use queries like Lock/UnLock tables
2.	lock functions will also do not work
3.	SELinux has to be disabled (www.percona.com/doc/percona-xtradb-cluster/howtos/cenots_howto.html#centos-howtoSeLinh prerequisites)

Also it is synchronous writes between all nodes.

We need to explicitly install some dependencies like “socat” etc.. Also the cluster boot strapping process is required some manual process (It is not just straight forward process to call from scripts, http://www.percona.com/doc/percona-xtradb-cluster/manual/bootstrap.html ).

I found another feature provided by Percona which is HAProxy. I will be trying this after this..

Percona Xtra Cluster internally uses Galera to achieve DB HA active/active master. Will also take a look at it and check if we can use that directly (Not sure whether the above limitations of percona are coming from this or not? Need to look into it for confirmation) along with some other tools like MHA.


> To Enable Master Database High Availabilty.
> -------------------------------------------
>
>                 Key: CLOUDSTACK-4916
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4916
>             Project: CloudStack
>          Issue Type: Improvement
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server
>    Affects Versions: Future
>            Reporter: Damodar Reddy T
>            Assignee: Damodar Reddy T
>             Fix For: 4.3.0
>
>
> To automate the Master Database High Availability out of the box with out management server intervention. 



--
This message was sent by Atlassian JIRA
(v6.1#6144)