Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-09 Thread Yves Trudeau
Hi Andreas, with NDB, you have 3 types of node: SQL which is mysqld, Management running ndb_mgmd and data running ndbmtd. SQL and Management can be on the same physical host (cohosting) but you ideally need 2 for HA, the ndb_mgmd process is very small and low on resources. Data nodes, for H

Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-09 Thread Stallmann, Andreas
Hi Yves, Ø NDB requires a minimum of 4 nodes for HA... I understood that in NDB-Cluster the concept of „nodes” has nothing to do with physical (or virtual) hosts but with running instances / processes. That’s at least, what can be derived from http://www.howtoforge.com/setting-up-a-loadbalanc

Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-08 Thread Yves Trudeau
Hi Andreas, NDB requires a minimum of 4 nodes for HA... 2x SQL/mgmnt nodes + 2x data nodes. The SQL/mgmnt nodes could be your tomcat servers without problem but the data nodes must be other physical servers. Regards, Yves On 12-01-30 04:46 AM, Stallmann, Andreas wrote: Hi! I’m on the

Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-02 Thread Stallmann, Andreas
> If I understand you correct, you'd like to have a multi-master MySQL setup > with circular replication? No, not really. :-) I just want to avoid the overhead of DRBD for replication. We have to get faster than that. :-) As I already wrote. I'm evaluating two different approaches: - MySQL repl

Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-02 Thread Andreas Kurz
tsführer/Managing Directors: Anke Höfer > - > > -Ursprüngliche Nachricht- > Von: Andreas Kurz [mailto:andr...@hastexo.com] > Gesendet: Mittwoch, 1. Februar 2012 23:55 > An: pacemaker@oss.clusterlabs.org > Betreff: Re: [Pacemaker] MySQL-Cluster wi

Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-02 Thread Stallmann, Andreas
Von: Andreas Kurz [mailto:andr...@hastexo.com] Gesendet: Mittwoch, 1. Februar 2012 23:55 An: pacemaker@oss.clusterlabs.org Betreff: Re: [Pacemaker] MySQL-Cluster with Pacemaker Hello, On 01/30/2012 10:46 AM, Stallmann, Andreas wrote: > Hi! > > > > I'm on the lookout for alte

Re: [Pacemaker] MySQL-Cluster with Pacemaker

2012-02-01 Thread 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 a

[Pacemaker] MySQL-Cluster with Pacemaker

2012-01-30 Thread Stallmann, Andreas
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. Currently we run a Tomcat application, which works i