MySQL georedundant HA klaszter

@AwaisChaudhry

Hello, I will design and implement an active-active, geo-redundant MySQL HA cluster across two sites using MySQL 8 with Galera (Percona XtraDB Cluster 8.0 or MariaDB Galera 10.x), or InnoDB Cluster if you prefer. The stack will run on Rocky Linux 10 (or another stable RPM-based distro you approve), with Pacemaker + Corosync for failover and either HAProxy or ProxySQL for load balancing. Replication will be encrypted with TLS to provide a high-bandwidth, secure channel without a dedicated VPN. I’ll deliver a clear, practical installation plan, tuning steps, maintenance procedures, and troubleshooting guides, plus reproducible playbooks and runbooks. The plan includes rigorous test cases to prove seamless failover and failback after a full site outage with no data loss, plus a straightforward rollback and verification process. I will also provide version recommendations, migration paths, and environment sanity checks so you have a reliable, production-ready cluster. What is your target RPO and RTO for the multi-site cluster?\n\nDo you prefer Percona XtraDB Cluster (PXC) 8.0 or MariaDB Galera 10.x as the base, or another option?\n\nWhat are the inter-site bandwidth and latency constraints, and is TLS replication mandatory?\n\nShould failover/failback be automatic with a single writable node per site, or should we allow multiple read-write nodes per site?\n\nDo you require HAProxy/ProxySQL for load balancing, and is there any monitoring/alerting integration (e.g., Zabbix) you wa

@divumanocha

Hello, I came across your project and found it truly interesting. With over eight years of hands-on experience in this field, I have successfully delivered high-quality solutions to clients worldwide. My dedication to excellence is reflected in the 180+ positive reviews from satisfied clients. I’d love to bring this expertise to your project and ensure outstanding results. However, I do have a few important points I’d like to clarify to align perfectly with your vision. Let’s connect via chat, where I can also share relevant examples of my past work. I'm looking forward to hearing back from you! Best Regards, Divu.

@AZTURK1

Hi there, I’ve thoroughly reviewed your project details for setting up an active-active, geo-redundant MySQL HA cluster across two physical sites. With my 7+ years of experience in Linux server management and database clusters, I’m confident in delivering a robust, zero-downtime solution tailored for CentOS 10 or Rocky Linux 10. - Install and fine-tune MySQL 8 with Galera Cluster for active-active replication. - Configure Pacemaker + Corosync for seamless automatic failover and failback. - Set up encrypted replication ensuring secure high-bandwidth data transfer without needing VLAN/VPN. - Provide comprehensive, clear documentation covering installation, maintenance, and troubleshooting. - Validate cluster resilience through failover tests ensuring no data loss. **Skills:** ✅ MySQL 8 & Galera Cluster deployment ✅ Pacemaker + Corosync HA configuration ✅ Encrypted replication channels on RPM-based systems ✅ Documentation with detailed admin/user guides ✅ Load balancers integration experience (HAProxy, ProxySQL) **Certificates:** ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ cPanel® & WHM Certified CWSA-2 I’m ready to start immediately and can complete the setup and testing within two weeks. Which RPM-based Linux distribution do you prefer for the cluster, or would you like my recommendation based on your workload needs? Best regards,

@Rekhathakur

Hello I have thoroughly reviewed your project description and am confident in my ability to assist you in completing it successfully. I believe it would be highly beneficial to delve deeper into the specifics of the job to determine the most effective way forward. I am open to scheduling an interview at your convenience, and I genuinely appreciate the chance to collaborate with you on this project. Your response is eagerly anticipated, and I'm excited about the prospect of working together. Thank you for considering my proposal. Looking forward to your prompt reply! Best regards Rekha!!!

@umer6316326

Dear , I hope this message finds you well. My name is Umer Hayat, and I am a full-stack PHP developer with over 8 years of experience in developing, customizing, and maintaining PHP-based websites for various clients. I have reviewed your project requirements and would like to ask a few clarifying questions to ensure that I can meet your expectations. I believe a brief chat would be the best way to proceed. Here is an overview of my skill set: Core PHP Laravel (PHP MVC Framework) CodeIgniter (PHP MVC Framework) WordPress (PHP CMS) Shopify (PHP CMS) Custom APIs and scripts Data Backup, Documentation, System Administration, MySQL, Database Administration, System Admin and Linux I look forward to discussing your project in more detail. Please feel free to reach out at your convenience. Thank you. Best regards, Umer Hayat

@nikhilgarg96

As an accomplished developer with in-depth knowledge of the Linux environment, MySQL 8, and pertinent HA components such as Galera and keepalived. My proficiency spans across establishing actively-highly-available MySQL systems on CentOS and Rocky Linux distributions- hence your project's objectives are fully aligned with my skill set. With parallel mastery of backend frameworks like Laravel, CI, CakePHP,Yii; coupled with my ability to comfortably switch to frontend requirements featuring the likes of React.js, Angular.js,and Vue.js; I bring a dual-power that can immensely benefit our project. In addition to delivering state-of-the-art Active-Active MySQL HA cluster, I will personally develop step-by-step directories that emphasize installation, maintenance, and troubleshooting procedures. Lastly, even though the Zabbix cluster falls out of this project's scope, as a passionate individual who thrives on numerous domain challenges, I'm greatly motivated to tackle it! Let's solidify your infrastructure for utmost efficiency and reliability together. With Regards! Nikhil

@Feriver

Hello, I understand you’re looking for a reliable way to implement an active-active, geo-redundant MySQL high-availability cluster across two physical sites with automatic failover and failback and no service downtime. I have direct experience designing and deploying MySQL 8–based HA architectures using Galera Cluster and InnoDB Cluster on RPM-based Linux systems, including Rocky Linux and CentOS-derived distributions, with a strong focus on data consistency, encryption, and operational stability. My approach would be to evaluate the provided architecture and select the most suitable active-active technology, typically MySQL 8 + Galera for true multi-master writes, combined with HAProxy or ProxySQL for traffic management and health checks. I will configure secure, encrypted replication channels, tune MySQL and OS parameters for low-latency cross-site replication, and implement proper quorum and split-brain protection. I will deliver a fully tested cluster that survives a full site outage and recovers cleanly without data loss, along with clear, step-by-step documentation covering installation, maintenance, monitoring hooks, and disaster recovery procedures so your team can confidently operate the platform long-term. Thanks, Asif

@nickdevops

Hello my name is Nikos and Im working on the Linux server administration field for the past 12 years. Over these years I worked for two web hosting companies as a Senior Administrator managing their servers & providing customer support. I have extensive experience with the following control panels: CPanel, Plesk, Directadmin, and many more. I can do what you are asking for. Message me for more details. Regards

@Herculesz

Hi I have extensive experience designing geo-redundant MySQL HA architectures, and I can build a fully active-active cluster across your two physical sites with zero-downtime failover. The main technical challenge is ensuring synchronous consistency and stable quorum behavior under site outage conditions, which I address using MySQL InnoDB Cluster or Galera with proper cluster quorum, flow-control tuning, and encrypted inter-node replication. I can configure Pacemaker/Corosync, keepalived, and a load-balancer layer such as HAProxy or ProxySQL to provide seamless failover and client routing. My background includes deploying MySQL 8 clusters with multi-site replication, secure transport layers, and optimized buffer/transaction settings for high write workloads. I will also provide clear installation, maintenance, and troubleshooting documentation for long-term operability. Test scenarios will validate resilience, data integrity, and full recovery after complete site loss. I can deliver a stable, production-grade HA foundation with clean operational procedures. Thanks, Hercules

@abhisaini0188

As an accomplished web developer, I have garnered a wealth of experience over the past decade. My skills span the range from backend to frontend, ERP to cloud computing, and even AI and machine learning. This expertise is exactly what is required for building a highly available, georedundant MySQL HA cluster on different physical sites - a project that I'm more than qualified for. Specifically, my knowledge in Linux and MySQL combined with an intimate command of powerful server infrastructure tools such as Pacemaker + Corosync, Galera Cluster, and HAProxy makes me a valuable asset to this task. Additionally, I assure you that not only will we install and tune the requisite components expertly but also every step of the setup will be carefully documented for your convenience. Beyond just being technically proficient, my approach is deeply ingrained in ensuring client satisfaction. This includes proactively suggesting improvements and delivering punctually on every project I undertake. Trust me to not only create an active-active MySQL HA cluster that runs smoothly without failover or failback but also demonstrate its resilience through rigorous test cases. With Regards! Abhi

@android2014213

Hi There, I can help you to configure Mysql High Availability (HA) cluster. I am experienced in Database cluster. I am also worked on mongodb, postgresql cluster. Thanks Ashish A.

@phpxpert89

Hello Trust4Sec, I checked your project, and it looks interesting. This is something we already work on, so the requirements are clear from the start. We mainly work on System Admin, Linux, MySQL, Database Administration, Documentation, Data Backup, System Administration We focus on making things simple, reliable, and actually useful in real life not overcomplicated stuff. Let’s connect in chat and see if we’re a good fit for this. Best Regards, Ali nawaz

@mykhaylob4

✋ Hi there. I can build your geo-redundant, active-active MySQL HA cluster across two sites to provide continuous database service with automatic failover and failback. ✔️ I have solid experience designing and deploying MySQL 8 HA clusters using Galera Cluster and InnoDB Cluster, combined with Pacemaker, Corosync, and load balancers like HAProxy or ProxySQL. I’ve handled encrypted replication channels, tuned cluster performance, and validated failover and recovery without data loss in production environments. ✔️ For your setup, I will install and configure the MySQL solution of choice on your preferred CentOS or Rocky Linux nodes, integrate HA components for site redundancy, and secure the replication channel. I will also produce clear, step-by-step documentation covering installation, maintenance, and troubleshooting. ✔️ I will run comprehensive tests simulating full site outages to ensure seamless failover and automatic recovery, demonstrating that no data is lost and the service resumes normal operations efficiently. Recommended software versions and tuning parameters will be provided to optimize performance and stability. Let’s chat to finalize your architecture choices, timeline, and testing strategy. Best regards, Mykhaylo

@Muhammadzeesha59

As an experienced Full Stack Developer with over 6 years in the field, I have acquired a diverse skill set that will prove invaluable for your MySQL Geo-redundant HA cluster project. I am proficient in Database Administration, Linux, MySQL, and System Admin to name a few. Pitch:Drawing on my extensive knowledge of MySQL 8, Galera, keepalived, and load balancers such as HAProxy or ProxySQL, I can construct an active-active, geo-redundant MySQL HA cluster that guarantees uninterrupted service even during site outages. My detailed approach would include leveraging technologies like Pacemaker + Corosync or similar high-quality solutions fit to not only ensure a high bandwidth and encrypted replica channel but create easy-to-follow step-by-step documentation for the installation and maintenance of the cluster

@volodymyrkoval

Hi, I am excited about the opportunity to help you build an active-active, geo-redundant MySQL HA cluster as outlined. With over 10 years of experience in system administration and database management, I have successfully implemented similar solutions using Galera and InnoDB Clusters. My expertise in configuring HA components such as Pacemaker and Corosync will ensure a seamless and resilient database service that meets your uptime requirements. I will also provide comprehensive documentation detailing installation, maintenance, and troubleshooting processes to ensure ease of future handling. I estimate that the project can be completed within a week, depending on the specific configurations needed based on your architectural diagrams. Best regards, Volodymyr

@juanjosec63

Hello, I’m excited about the opportunity to assist with building your **active-active, geo-redundant MySQL HA cluster**. With experience in **MySQL**, **Galera Cluster**, and high-availability solutions, I can set up a robust system that ensures no downtime and provides automatic failover and failback. I’ll recommend the best solution based on your needs, likely **Galera Cluster** or **InnoDB Cluster**, and configure the required **HA components** like **Pacemaker** and **Corosync** for seamless failover. I’ll ensure the replication channel is encrypted with high bandwidth but avoid the complexity of dedicated VLANs or VPNs. The cluster will be tested to handle site outages without data loss. After the setup, I’ll provide detailed documentation for installation, maintenance, and troubleshooting, and will run test cases to confirm everything works as expected. Looking forward to helping you build this highly available and resilient database architecture! Best regards, Juan

@durgesh8527

As a FULL STACK SOTWARE ENGINER with over 12 years of experience, I have gained a deep understanding and technical proficiency in Database Administration, especially in MySQL. I empathize with your need for an active-active, geo-redundant MySQL HA cluster to ensure continuous database services - even during site outages. Not only am I well-versed with Galera Cluster and InnoDB Cluster, but I am also familiar with Pacemaker + Corosync and other HA solutions that would go effectively alongside MySQL for failover and failback mechanisms. My proficiency extends to configuring high-bandwidth replication channels to facilitate secure data transfer. Throughout my career, I have consistently produced comprehensive documentation; step-by-step installations guides, maintenance protocols, detailed troubleshooting procedures - ensuring that your project's know-how remains intact even after project completion. Being versed in MySQL 8, Galera, keepalived, load balancers like HAProxy, ProxySQL or their counterparts further compliments my suitability for this task. Optimizing downtime protection isn't just a project for me; it aligns with my passion for building and scaling technology products. Let's connect to discuss your specific requirements; I look forward to leveraging all my expertise for the seamless execution of this crucial project.

@justinw45

Hello, I have reviewed the MySQL georedundant HA cluster project requirements and attachments. I propose implementing a Galera Cluster solution for active-active geo-redundancy on CentOS 10 or Rocky Linux 10. I will configure Pacemaker + Corosync for HA components and ensure encrypted, high-bandwidth replication without the need for a dedicated VLAN or VPN. My experience with MySQL 8, Galera, keepalived, and load balancers like HAProxy will ensure a robust solution. I will provide detailed documentation and conduct thorough test cases to validate the cluster's resilience. Happy to jump on this. –

@billybryan98

Hello, I hope you are doing well. I’m a Linux sysadmin with solid experience building production-grade, active-active MySQL HA clusters on RPM-based distros (CentOS, Rocky Linux). I design geo-redundant, zero-downtime architectures and provide clear, runnable docs. In similar work I’ve deployed two-site MySQL environments using Galera with Pacemaker/Corosync, plus HAProxy or ProxySQL for load balancing. I ensure encrypted replication channels, high-bandwidth links, and tested failover/failback with no data loss, along with comprehensive installation, maintenance, and troubleshooting guides. I can deliver a robust solution tailored to your two-site needs, with recommended versions and a practical timeline. I will handle the project end-to-end and guarantee a smooth, data-safe transition during failover. Please feel free to contact me so we can discuss more details. I am looking forward to the chance of working together. Best regards, Billy Bryan