41 blog posts in 1 category
Bad query performance is probably the most common problem that a database administrator has to deal with. This blog post shows you how to use ClusterControl to monitor queries on your MySQL, MariaDB or Percona Server.
Recently, several attackers were able to break into thousands of MongoDB systems, wipe the databases and leave a ransom note. This could have been prevented if those in charge would have followed some standard security procedures. This blog post describes how to protect yourself from MongoDB ransomware. What is it, why is it a problem and what can you do to protect yourself against it?
Sharding can be a painful exercise. Databases need to be split on multiple servers, data migrated, and applications have to be tweaked to be aware of the shards. However, there are ways to make this less painful. This blog explains how to use ProxySQL to shard a table to another cluster in ClusterControl without changing your application.
Check out our free new whitepaper on database backups, which discusses in detail the two most popular backup utilities available for MySQL and MariaDB, namely mysqldump and Percona XtraBackup.
This blog explains how to enable and set up your email notifications properly in ClusterControl. Apart from receiving notifications when things go wrong, you can also receive digest emails for less critical notifications.
Announcing our new customer, eCommerce platform vidaXL, who use ClusterControl to manage their MongoDB & MySQL database to help them compete with the world's largest e-commerce platforms.
Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.
ClusterControl allows you to write elaborate advisors. This post shows you how to combine multiple metrics and trigger alerts if your MongoDB replication window becomes smaller than 24 hours.
Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.
This blog post will show you how to add custom graphs to ClusterControl to monitor specific MySQL, MariaDB, MongoDB or PostgreSQL metrics.