FAQ

Can you help us migrate from ProxySQL to MaxScale?

Yes. Migrating from an existing proxy like ProxySQL to MariaDB MaxScale is a common consulting project for us. We manage the entire process, from planning and configuration to a seamless cutover, ensuring your application experiences no disruption during the transition. We also handle MaxScale version upgrades.

What is included in your MaxScale implementation service?

Our service covers the entire end-to-end deployment of MaxScale. This includes:

  • Architecting the optimal routing and load-balancing strategy.
  • Installing and configuring the MaxScale listeners, servers, and monitors.
  • Implementing advanced features like query filtering or connection throttling.
  • Conducting rigorous failover testing to ensure the solution is production-ready.
What database environments are best suited for a MaxScale deployment?

MaxScale is most powerful when used with high-availability cluster technologies. It is the recommended proxy for MariaDB Galera Cluster, MariaDB Replication Setups and is also an excellent choice for Percona XtraDB Cluster and standard replication setups. Our consulting service helps architect the right MaxScale configuration for your specific environment. The USP Maxscale over other proxies are its Data Masking, Binlog Router capabilities for binary log backups and setting up replication chains.

How does MaxScale improve my database's performance and availability?

MaxScale improves performance by intelligently routing queries. It can send write operations to the primary server and distribute read queries across multiple replicas (read-write splitting), preventing overload. It improves availability by monitoring the database cluster and automatically rerouting traffic away from a failed server, ensuring zero application downtime.

What is MariaDB MaxScale and why do I need it?

MariaDB MaxScale is an advanced database proxy that sits between your application and your database. You need it to provide a single, stable endpoint for your application while enabling critical features like automatic failover, load balancing, and read-write splitting. It is the key to achieving true high availability for MariaDB and MySQL clusters.

What makes Mydbops experts in supporting InnoDB Cluster specifically?

InnoDB Cluster is a complex system, and our expertise goes beyond general MySQL knowledge. We are specialists in the entire stack, including the nuances of Group Replication, the proper configuration of MySQL Router for transparent failover, and the correct administrative procedures using MySQL Shell. Our proactive approach includes regularly testing failover and monitoring for cluster-specific issues like split-brain, ensuring your high-availability environment is truly resilient.

How does your support service integrate with our existing team?

Our service acts as a seamless extension of your team. We collaborate directly with your developers and administrators via shared Slack channels and calls, acting as the specialized MySQL experts they can rely on for everything from query tuning to architecture advice. This frees your team to focus on application features while we guarantee database reliability.

How do you handle MySQL version upgrades and security patching for the cluster?

We manage all MySQL security patches (minor version upgrade) as well as Major version upgrades and they are our core part of the service. Every upgrade is meticulously planned with your team, tested in a staging environment, and executed during a low-traffic maintenance window using a rolling update strategy to ensure zero downtime for your application.

Does your support include managing MySQL Router and MySQL Shell?

Our service covers the entire MySQL InnoDB Cluster stack. A healthy cluster depends on more than just the database nodes. We manage MySQL Router to ensure proper connection routing and transparent application failover, and we use MySQL Shell for all cluster administration according to Oracle's official best practices as well have our own platform tools that uses MySQL shell for backup, recovery and data stream.

What is your SLA for responding to critical InnoDB Cluster incidents?

Our support is governed by a formal Service Level Agreement (SLA). When your MySQL InnoDB Cluster has a critical issue, an on-call expert is immediately alerted and begins active resolution, day or night. Our guaranteed response time for P1 (critical) incidents is 15 minutes.

We already have an InnoDB Cluster. Can your team take over its support?

Yes, we specialize in transforming unstable clusters into production-ready systems. Our diagnostic audit focuses on fixing the root causes of instability, including:

  • Resolving split-brain conditions and misconfigured quorum.
  • Tuning flow control to prevent write-stalls and performance drops.
  • Optimizing read/write splitting at the MySQL Router level.
How do you ensure our InnoDB Cluster fails over correctly during an outage?

We guarantee high availability through a combination of proactive monitoring and rigorous testing. Our team constantly monitors the health of your MySQL nodes and Group Replication. Crucially, we perform regular, controlled failover tests to ensure that MySQL Router correctly and seamlessly redirects traffic to a healthy replica, validating the entire HA process before a real emergency occurs.

What is included in your MySQL InnoDB Cluster Support service?

Our service provides complete, 24/7 operational ownership of your MySQL InnoDB Cluster. This includes proactive monitoring, incident response, performance tuning, security hardening, and a fully managed backup and disaster recovery strategy. We handle all the day-to-day management so your team can focus on your application.

Who performs MySQL audit and what are their qualifications?

Our audits are performed by a seasoned team of senior MySQL DBAs, not generalists. They are certified experts with years of hands-on experience tuning and securing large-scale, mission-critical MySQL environments for global enterprises.

Do you just provide an assessment report, or do you also help implement the fixes?

The audit provides the strategic roadmap. After delivering the report, most clients engage our MySQL Consulting Services for a follow-up project to expertly implement the critical fixes and architectural enhancements we identified.

What specific security areas do you investigate in the audit?

Our security audit is a comprehensive review of your MySQL security posture, tailored to your compliance needs. We investigate:

  • User roles, privileges, and access control policies.
  • Network exposure and firewall configurations.
  • Encryption settings for data at-rest and in-transit.
  • A Common Vulnerabilities and Exposures (CVE) assessment against your MySQL version.
  • Alignment with industry best practices, including CIS Security Hardening guidelines.
What are the key deliverables of the audit?

You will receive a detailed report with prioritized, actionable recommendations. Key deliverables include:

  • A Performance Bottleneck Report detailing slow queries and inefficient indexes.
  • A Security & Vulnerability Report with a clear remediation plan.
  • An Architecture & High Availability Review with scalability suggestions.
Will the audit process cause downtime or impact our live database?

Our audit process is 100% non-invasive and read-only. We use standard monitoring commands and secure connections that have a negligible impact on your production environment. We will never alter your data or configuration during the audit, guaranteeing zero risk of downtime.

How do I know if our MySQL database needs an audit?

You should consider a performance audit if you're experiencing slow queries or application slowdowns. A security audit is critical, and we will tailor it based on your specific compliance needs, whether you are preparing for a GDPR, HIPAA, or PCI DSS assessment. It is also essential if it has been over a year since your last comprehensive security review.

Does the MySQL audit cover MySQL variants and different environments?

Our audit is tailored for the entire MySQL ecosystem, wherever it runs. This includes:

  • Variants: Oracle MySQL, Percona Server for MySQL, and MariaDB.
  • Cloud Platforms: Amazon RDS, Aurora, Google Cloud SQL, and Azure.
  • Infrastructure: On-premises data centers and hybrid-cloud setups.
  • Operating Systems: All major Linux distributions and Windows Server.
What is a MySQL Performance & Security Audit?

An expert-led, comprehensive review of your entire MySQL environment. We analyze Performance, Security, and Architecture, incorporating industry best practices like the CIS Security Hardening guidelines. Our process includes a Common Vulnerabilities and Exposures (CVE) assessment to deliver a detailed, actionable roadmap for improving speed, hardening security, and ensuring scalability.

How does your team work with our in-house developers and admins?

Our engagement model is flexible. We can integrate with your existing team, providing the specialized MySQL expertise they need to successfully deploy and manage InnoDB Cluster. For clients who prefer a turnkey solution, our team can also manage the entire project from start to finish, adapting our approach to fit your needs.

How do you ensure the security of a new InnoDB Cluster?

Our implementation follows a security-first approach. We enforce best practices for MySQL, such as encrypting Group Replication traffic, isolating the cluster on a private network, and applying a 'least privilege' model for user permissions. This helps you meet the database requirements for compliance standards like PCI DSS and GDPR.

How do you migrate an existing MySQL database to an InnoDB Cluster?

Our process is built on a meticulous assessment approach, as this is the most critical step for success. We first conduct a thorough audit of your existing schema, workload, and infrastructure to design the optimal cluster topology. Only then do we proceed with the migration itself, using live replication to provision the new InnoDB Cluster with near-zero downtime. This assessment-first strategy ensures a smooth, stable, and successful deployment.

Does your consulting service include configuring MySQL Router and Shell?

Our service covers the entire InnoDB Cluster stack. A successful implementation depends on more than just the database nodes. We ensure that MySQL Router is correctly configured for proper connection routing and transparent failover, and we use MySQL Shell to manage the cluster according to best practices.