[Pacemaker] MySQL-Cluster with Pacemaker

[Andreas Kurz]

Hello,

On 01/30/2012 10:46 AM, Stallmann, Andreas wrote:
> Hi!
> 
>  
> 
> I’m on the lookout for alternatives to our current MySQL “cluster”,
> which is an Active/Standby solution with MySQL on DRBD.
> 
> With increasing customer demand for a faster failover, we want an
> Active/Passive or even an Active/Active cluster.

Already had a look at this presentation my colleague Florian held at
Percona Live UK 2011 in London?

http://goo.gl/5mDFR

Regards,
Andreas

-- 
Need help with Pacemaker?
http://www.hastexo.com/now

> 
>  
> 
> Currently we run a Tomcat application, which works in
> Active/Passive-Mode. The applications on the active node communicate
> it’s status via a MySQL database to the passive node. In our current
> setup, both nodes run the tomcat application but only one holds the
> database (due to the setup with DRBD). For faster failovers, we’d rather
> want the database to be active on both nodes. It’s not necessary, that
> it can written on both nodes, but read access would be desirable. The
> thought is, that switching the “master status” of a database might be
> quicker than switching DRBD’s master status, unmounting and mounting the
> file system and stopping and starting the database.
> 
>  
> 
> A MySQL/Pacemaker cluster with replication as described  in
> http://www.mysqlperformanceblog.com/2011/11/29/percona-replication-manager-a-solution-for-mysql-high-availability-with-replication-using-pacemaker/
>  thus looked very promising, but it seems to be not yet mature enough
> for a production environment. Please do correct men if I’m wrong there,
> I’m really interested in your experience with this solution in a real
> world scenario.
> 
>  
> 
> Are there perhaps other howtos describing Pacemaker and MySQL replication?
> 
>  
> 
> The second idea was using the native MySQL NDB clustering with
> Pacemaker.
> http://www.mysqlperformanceblog.com/2010/05/19/pacemaker-please-meet-ndb-cluster-or-using-pacemakerheartbeat-to-start-a-ndb-cluster/
> (from 2010, uses heartbeat and pacemaker) and
> http://www.howtoforge.com/loadbalanced_mysql_cluster_debian (from 2008,
> uses pure heartbeat). Are there any more recent “howtos” on pacemaker
> and MySQL NDB 7.x describe this. Can you provide me with your opinions
> and field reports on these setups?
> 
>  
> 
> Looking forward to your upcoming mails,
> 
>  
> 
> Andreas
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> ----------------------------
> CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef.
> Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136)
> Geschäftsführer/Managing Director: Anke Höfer 
> 
>  ----------------------------
> 
>  
> 
> 
> 
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> 
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 222 bytes
Desc: OpenPGP digital signature
URL: <http://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120201/8831917a/attachment-0002.sig>