Good morning,
I have to perform some scheduled maintenance on one of the analytics MariaDB replicas https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB next week under ticket T343109 https://phabricator.wikimedia.org/T343109.
Specifically, this is the replica we have of the s2 shard https://noc.wikimedia.org/conf/highlight.php?file=dblists/s2.dblist, which is accessible through the s2-analytics-replica.eqiad.wmnet alias. I have to rebuild this shard from a backup as a preventative measure.
I expect this shard to be unavailable for *a few hours* next *Tuesday October 24th*, starting from approximately *09:30 UTC*, whilst the rebuild is taking place. This downtime may affect you if you:
* Use the analytics-mysql https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB#MySQL_wrapper wrapper from stats servers * Use the wmfdata-python https://github.com/wikimedia/wmfdata-python or wikimedia-discovery-wmf https://github.com/wikimedia/wikimedia-discovery-wmf libraries to read from the analytics replicas
Please let me know if this maintenance window will adversely affect your work and I will try to reschedule it.
If you have any questions or comments, please don't hesitate to get in touch.
Kind regards, Ben
A quick reminder that this work will start in approximately 35 minutes' time.
Kind regards, Ben
On 20/10/2023 10:04 am, Ben Tullis wrote:
Good morning,
I have to perform some scheduled maintenance on one of the analytics MariaDB replicas https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB next week under ticket T343109 https://phabricator.wikimedia.org/T343109.
Specifically, this is the replica we have of the s2 shard https://noc.wikimedia.org/conf/highlight.php?file=dblists/s2.dblist, which is accessible through the s2-analytics-replica.eqiad.wmnet alias. I have to rebuild this shard from a backup as a preventative measure.
I expect this shard to be unavailable for *a few hours* next *Tuesday October 24th*, starting from approximately *09:30 UTC*, whilst the rebuild is taking place. This downtime may affect you if you:
- Use the analytics-mysql https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB#MySQL_wrapper wrapper from stats servers
- Use the wmfdata-python https://github.com/wikimedia/wmfdata-python or wikimedia-discovery-wmf https://github.com/wikimedia/wikimedia-discovery-wmf libraries to read from the analytics replicas
Please let me know if this maintenance window will adversely affect your work and I will try to reschedule it.
If you have any questions or comments, please don't hesitate to get in touch.
Kind regards, Ben
-- *Ben Tullis*(he/him) Senior Site Reliability Engineer Wikimedia Foundation https://wikimediafoundation.org/
This work has finished successfully now.
I'm not expecting any changes, but if anything unexpectedly misbehaves for you regarding the analytics mysql replicas, please do feel free to let me know and I will investigate.
Kind regards, Ben
On 24/10/2023 9:54 am, Ben Tullis wrote:
A quick reminder that this work will start in approximately 35 minutes' time.
Kind regards, Ben
On 20/10/2023 10:04 am, Ben Tullis wrote:
Good morning,
I have to perform some scheduled maintenance on one of the analytics MariaDB replicas https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB next week under ticket T343109 https://phabricator.wikimedia.org/T343109.
Specifically, this is the replica we have of the s2 shard https://noc.wikimedia.org/conf/highlight.php?file=dblists/s2.dblist, which is accessible through the s2-analytics-replica.eqiad.wmnet alias. I have to rebuild this shard from a backup as a preventative measure.
I expect this shard to be unavailable for *a few hours* next *Tuesday October 24th*, starting from approximately *09:30 UTC*, whilst the rebuild is taking place. This downtime may affect you if you:
- Use the analytics-mysql https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB#MySQL_wrapper wrapper from stats servers
- Use the wmfdata-python https://github.com/wikimedia/wmfdata-python or wikimedia-discovery-wmf https://github.com/wikimedia/wikimedia-discovery-wmf libraries to read from the analytics replicas
Please let me know if this maintenance window will adversely affect your work and I will try to reschedule it.
If you have any questions or comments, please don't hesitate to get in touch.
Kind regards, Ben
-- *Ben Tullis*(he/him) Senior Site Reliability Engineer Wikimedia Foundation https://wikimediafoundation.org/
-- *Ben Tullis*(he/him) Senior Site Reliability Engineer Wikimedia Foundation https://wikimediafoundation.org/