MySQL Database Architecture Expert - Part-time - EU

MySQL Database Architecture Expert Needed - Galera & Async Replication Optimization

Project Overview:
We're operating a geographically redundant database system using a combination of Galera and MySQL Async replication. As our system load increases, we need an experienced database expert to optimize performance and resolve complex edge cases.

Key Responsibilities:

• Analyze and optimize transaction speeds through server configuration and indexing improvements
• Troubleshoot and stabilize asynchronous MySQL replication, particularly during schema changes
• Review and enhance our HAProxy load balancing setup, focusing on high-frequency client requests
• Validate existing database configuration and provide expert recommendations
• Assess and improve our performance monitoring solution
• Provide ongoing consultation for emerging challenges

Technical Environment:

• MySQL with Galera Cluster
• Asynchronous MySQL replication
• HAProxy for load balancing
• Geographically distributed infrastructure

Required Expertise:

• Deep experience with MySQL replication architectures
• Strong background in Galera Cluster implementation
• Proven track record in database performance optimization
• Experience with HAProxy configuration for MySQL
• Knowledge of database monitoring and performance testing

Project Type:
Consulting/troubleshooting with potential for ongoing collaboration. Remote work possible.

Ideal Candidate:
We're looking for an experienced database architect who can both provide strategic guidance and hands-on problem-solving for specific technical challenges. The ability to communicate clearly and collaborate effectively with our existing team is essential.

Current Challenges:

• High-frequency client requests causing system stress
• Replication stability issues during schema changes
• Flow Control activation during peak loads
• Need for formal performance testing and monitoring optimization

If you have experience with similar database architectures and can help us optimize our system, please reach out with your relevant experience and availability for an initial discussion.