Wikimedia uses over 200 MariaDB instances to store content and metadata for Wikipedia and other free knowledge projects. While standard open source tools for both monitoring and automation are used when possible, there are some tasks that require custom development. There are 2 options for a project to choose here:
Mockups for inspiration:
2. Small-scope command line utilities to perform maintenance and monitoring tasks, such as: [[ https://phabricator.wikimedia.org/diffusion/OSMD/browse/master/wmfmariadbpy/compare.py?blame=off | data checks between servers ]], [[https://phabricator.wikimedia.org/diffusion/OSMD/browse/master/wmfmariadbpy/transfer.py?blame=off | data transfers]], consistency checks between data and metadata, strange MariaDB process monitoring, and more.
Integration of existing libraries and tools should be preferred when possible, rather than custom solutions, as well as focusing on future extensibility and maintainability rather than a large scope.
* **Skills required:** Python (preferred) or PHP, SQL
* **Mentors**: [[https://meta.wikimedia.org/wiki/User:JCrespo (WMF)|Jaime Crespo]] aka #jynus [@jcrespo], [[https://meta.wikimedia.org/wiki/User:MArostegui_(WMF)|Manuel Arostegui]] [@marostegui]
There are a few tasks related to the above project with the details, they are listed below as subtasks. These are examples of task within the scope, others are possible too, but **only 1 or 2 should be chosen to work on (not all)**.