92 blog posts in 13 categories
ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. This blog post shows how to run the new ProxySQL 2.x for Galera Cluster on Docker container, which is quite a bit different as compared to ProxySQL 1.x.
Replication and Galera Cluster are both widely used to implement high availability for MySQL/MariaDB, but when should you pick one over the other? What are the limitations of each solution, and what are the trade offs?
In this blog post, we will look at the differences in terms of data consistency, conflict resolution, failover, node provisioning and robustness.
Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.
Can we increase Galera performance if we speed up applying data that is replicated between its nodes? In this blog post, we assess the impact of having multiple wsrep_slave_threads on the overall performance of Galera cluster.
In this blog, we will show you how to monitor Galera Cluster for MySQL or MariaDB using Prometheus. We will have a look at the newly released SCUMM architecture for agent-based monitoring and how ClusterControl deploys Prometheus and exporters to collect database metrics and the graphs available in the different dashboards.
The idea behind ClusterControl operational reporting is to put all of the most relevant data into a single document which can be quickly analyzed in order to get a clear understanding of the status of the databases and its processes. This blog post shows how to leverage the ops report functionality to understand the state of your MySQL, MariaDB, MongoDB and PostgreSQL infrastructure.
This blog post shows how to leverage ClusterControl performance monitoring and advisors functionality to keep your MySQL, MongoDB and/or PostgreSQL databases and clusters healthy.
ClusterControl can be used to deploy open-source database clusters that are configured in complex topologies. The full high availability stack includes both database and proxy layers.
In this blog, we are going to show you how to deploy a production-grade Galera Cluster, complete with load balancers, for a high availability setup.
In this blog post, we will show you how you can monitoring your database clusters using your terminal and the s9s Command Line Interface.
Prometheus is an open-source software for monitoring and alerting, it depends on exporters to ‘scrape’ information from e.g., MySQL running on Docker. In this blog, we’ll see how to deploy the database as well as the monitoring stack with Prometheus and its components. We’ll do this for both MySQL running on standalone Docker containers as well as a Galera Cluster running on Docker Swarm.
