Hi,

We have implemented CloudPlatform and CloudPortal in highly available configurations for customers and have explored/implemented MySQL clustering options such as Galera synchronous clusters. However, such clustering is not supported by Citrix so we have had to revert to MySQL active/passive replication.

So technically it is possible, it just needs Citrix's seal of approval.

Regards,

Tariq Iqbal
Senior Consultant

S: +44(0)20 3603 0540

tariq.iqbal@shapeblue.com | www.shapeblue.com | Twitter:@shapeBlue

ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS

The reason the CCP doesn't support MySQL Clusters, from my understanding, is that CCP requires the InnoDB engine which isn't available in Cluster mode.

What I have done in the past, that has worked quite well, is to setup "Master-Master" replication between two MySQL servers. I've then used Heartbeat/Corosync to move a VIP from the "normal" master to the "backup" master in the case of a failure scenario. Configuring it that way ensure that only one node is doing writes at any given time.

If you have the management application and mysql running on the same nodes, another option would be to do master-master and have each application configured to use localhost for its database. This introduces writes to multiple writers and I'm not sure CCP has been written to do this safely. I've run a similar setup in test environments and haven't seen any issues, but your mileage may vary.

Both of the above configurations are outside of Citrix's reference architecture, so I'm not sure of the level of support you can expect from them. Ideally Citrix would include an HA configuration example in the reference architectures so we can stop having to "fake" it.

--Mike