Galera cluster maintenance
min £36 GBP / hour
We're looking for a Galera cluster administrator to perform maintenance in our production environment (three MariaDB nodes on Debian). The right candidate has excellent knowledge of Galera clusters, MariaDB, and server admin for supporting the daemons, and good communication skills.
Services must remain operational 07:45-02:15 GMT and data loss isn't acceptable - we have a range of backup tools to assist. We'll ask you to sign a non-disclosure agreement.
We currently have 93% disk space used and can't delete data because the log file fills the disk and is not being consumed by replicas. We'd like to fix this over the weekend, and identify further issues for the next round of maintenance.
If we complete this job successfully then we'd like to invite you to join our team for a short time to maintain availability of the cluster and migrate to a managed solution shortly.
Please help us choose the right candidate by answering these questions;
1. Give an example cause of a cluster losing quorum?
2. A server has no disk space left. What procedure would you use to fix this?
3. How much DBA experience do you have?
4. Downtime is only acceptable 02:15-07:45 GMT (4.5 hour window). What is your local timezone, and are you comfortable with this?
Thank you for taking the time to read and apply thoroughly, all applications will be read carefully.
Project ID: #28865560
About the project
Awarded to:
Working with MariaDB Galera Clusters for 5 years. Can help you. 1. Restarting the node and unable to sync. 2. Add the space in one of the disks via LVM. When all goes good, disconnect other nodes..and add disk..and b More
7 freelancers are bidding on average £41/hour for this job
greetings my name is Ervin and id like to assist you with this project. in regard of your questions: 1) it can be a network connectivity issue , that the cluster has lost the quorum (this is only a possible case) 2) w More
1. Give an example cause of a cluster losing quorum? power outage, network outage 2. A server has no disk space left. What procedure would you use to fix this? Shutdown one - reinstall with bigger disk size and setup More
