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@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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Pacemaker mailing list: Pacemaker@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
