Hello and sorry for my unprecised questions,
the fact is that controllers are not stable under load (around 50
request by seconds on 2 controllers). If I slow down the load to 20
request by seconds, it becames reasonnable and activity came back after
15 min, when I disable and enable a backend (logs are register all the
time).
My main problem is now about the log engine. Even with a load of 20
request by seconds, I have some problems :
My scenario
- 2 controllers with each a postgresql database and RAIDb1 management
- load under 20 request by seconds
- after 2 min of activity (around 2000 rows), my databases are consistent
- I disable one backend to do a backup => it takes 5 min to disable, but
everything is ok
- I make my dump
- Enable the backend ... unstable : logs can't often be replayed. If it
failed, I must restore log other node. And even there, I can't restore
anything. My second node stay disabled.
The error for log replay is an sql error, saying that there's already
the data or duplicate id (sequence).
Any ideas ?
Regards,
Arnaud.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
