Hello all,
We're currently busy testing Sequoia v2.10.8 + Appia + libsequoia as a
HA solution.
I've run into the following problem (I've run into some more, but this
is a real show stopper atm):
I have 2 machines with each one backend with 1 mysql database.
I bring everything up as per the instructions in the manual.
When everything is up and running, I start a test script that will do a
lot of create/read/update/delete queries (on one table). The test script
is in Perl (like everything that uses the database here).
While this script is running I start the console on one backend, and
issue a disable backend.
The backend will then start its shutdown cycle, and complain about open
transactions, and that it will wait for 300 seconds for them to finish.
The transactions will not finish in that time, and then the backend crashes.
This leaves it in a state where it will be necessary to restore a new
dump to get back online. (Not something you want to do a lot with a
large database.)
This is about the first test that we can think of to test HA, but it
doesn't really give me confidence in the HA solution Sequoia offers...
Any suggestions on what I do wrong, or what I can do to improve matters?
Jan-willem
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
