[
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)
