はてなブックマーク

Severalnines Blog From MEM to Automation: Managing MySQL Enterprise with ClusterControl October 14, 2025 Ashraf Sharif When Oracle announced the deprecation of MySQL Enterprise Monitor (MEM), many organizations running MySQL Enterprise... Read more Performance is one of the most important and most complex tasks when managing a database. It can be affected by the configuration, the hardware or even

App logs may be easily tailored to be used as audit trails. System logs not so easily because: They are limited in their format by the system software They act globally on the whole system They don’t have direct knowledge about specific business context They usually require additional software for later offline parsing/processing in order to produce usable audit-friendly audit trails. However on t

Severalnines Blog From MEM to Automation: Managing MySQL Enterprise with ClusterControl October 14, 2025 Ashraf Sharif When Oracle announced the deprecation of MySQL Enterprise Monitor (MEM), many organizations running MySQL Enterprise... Read more Databases, tables, normalization, and a solid backup plan allow us to store and maintain data. Those combined best practices, in turn, afford us intera

In our MySQL replication tutorial we have covered different aspects of replication including master failover by performing a slave promotion using ClusterControl. The slave promotion will turn a slave into the new master, and re-attach the remaining slaves in the topology under the new master. Keep in mind that ClusterControl will not perform an automated slave promotion in the current version. We

Nginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend services, provided these passed some health checks. Using a reverse-proxy is common when you are running a critical application or service that requires high availability. It also distributes the load equally among the bac

Note: This post updated on 28th April 2015 with updated installation steps. Kubernetes is a system for managing containerized applications in a clustered environment. It provides basic mechanisms for deployment, maintenance and scaling of applications on public, private or hybrid setups. It also comes with self-healing features where containers can be auto provisioned, restarted or even replicated

There are two models of load balancing: transport and application layer. HAProxy is a great TCP load balancer, but it’s lack of SQL awareness effectively limits its ability to address certain scaling issues in distributed database environments. In the open source world, there’s been a few SQL-aware load balancers, namely MySQL Proxy, ProxySQL and MaxScale, but they all seemed to be in beta status

In a previous post, we gave you a quick overview of the MaxScale load balancer and walked through installation and configuration. We did some quick benchmarks using sysbench, a system performance benchmark that supports testing CPU, memory, IO, mutex and also MySQL performance. We will be sharing the results in this blog post. Sysbench setup For our tests we used the latest version of sysbench, st

Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL/MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the remaining nodes are able to join and form the cluster. This process is known as cluster bootstrap. Bootstrapping is an initial step to introduce a database node as primary component, before others see i

Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. Although it was fairly straightforward to replicate from a standalone MySQL server to a Galera Cluster, doing it the other way round (Galera → standalone MySQL) was a bit more challenging. At least until the arrival of GTID. There are a few good

Applications typically connect to a database cluster or replicated setup by opening connections on one of the database nodes in order to run transactions. If the database node fails, the client would need to reconnect to another database node before it can continue to serve requests. There are different ways to provide connectivity to one or more MySQL database servers. One way is to use a databas

Database Ops Your Way Sovereign DBaaS Reliably scale your database ops anywhere and take control of your infrastructure and database layer from third-parties. Learn more about the implementation concept