https://bugzilla.wikimedia.org/show_bug.cgi?id=68881
Bug ID: 68881
Summary: Provide resource fpr db access in grid
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Blocks: 67556
Web browser: ---
Mobile Platform: ---
Currently long maintences are done at meriadb10. Also future updates and so on.
Having a sql resource would prevent sge scripts to run while database is
down/broken and schedules them later when database is available again.
On toolserver there were many sge different resources defined. On Labs there
will probably be only three db servers, so having one resource for replicated
db, one for tools-db and one for postgre should be enough.
This resource should set to 0 while maintenance is done or replication is
broken. This could be done manually or by a load sensor script.
For this the resource must be a simple indicator and does not need to be
consumable. On toolserver the resource was consumable to limit the number of
queries run at the same time to prevent heavy peak usage. I don't know if this
is needed on labs, too.
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
