Re: MySQL active/passive cluster not recovering from master power failure

2011-09-30 Thread R.I.Pienaar
- Original Message - > > > - Original Message - > > How did you simulate such error? > > I have tested JDBC master/slave in the past and killed -9 the > > master. > > The lock on the database was released immediately and so the slave > > was able to take over. > > > > Have neve

Re: MySQL active/passive cluster not recovering from master power failure

2011-09-30 Thread R.I.Pienaar
- Original Message - > How did you simulate such error? > I have tested JDBC master/slave in the past and killed -9 the master. > The lock on the database was released immediately and so the slave > was able to take over. > > Have never simulated a kernel panic though. > Do you use a def

Re: MySQL active/passive cluster not recovering from master power failure

2011-09-30 Thread Torsten Mielke
How did you simulate such error? I have tested JDBC master/slave in the past and killed -9 the master. The lock on the database was released immediately and so the slave was able to take over. Have never simulated a kernel panic though. Do you use a default MySQL configuration? Torsten Mielke

MySQL active/passive cluster not recovering from master power failure

2011-09-30 Thread R.I.Pienaar
hello, I have a active/passive setup using a mysql datastore: this works fine, one of the pair is master and one is slave based on the lock contention on the table. When the master fails - like with a power failure or a kernel panic - the lock