MySQL Security with ClusterControl
If you are an experienced MySQL DBA, you probably already know how important MySQL security is. For you, security comes without any question - you already secured your database instances from the get-go: as soon...
The Common MySQL error: “Got an error reading communication packet”
MySQL is the second famous database in the world according to the DB Engine website behind Oracle. What makes MySQL famous is probably because it is a very fast, reliable and flexible Database Management System....
What’s new in ProxySQL?
Quite recently ProxySQL has changed the way it names new releases. To avoid confusion we’d like to go over it a bit. In the past, we had two branches: 1.4.x and 2.0.x where new features...
ClusterControl Schema Advisors: Why, When, How?
If you’re a database administrator, your database schema is probably one of the primary things you keep a watchful eye on. However, database schema design consists of many different things, and as a database administrator...
ClusterControl: Intro to the New Query Monitor
ClusterControl 1.9.0 was released on July 16th 2021 with a lot of new features introduced to the system. Those features include Redis Management and Monitoring, a new agent-based Query Monitoring system for MySQL and PostgreSQL,...
Proactive MySQL Monitoring (Developer Studio/Advisors Angle)
Monitoring your MySQL database proactively is imperative nowadays. It plays a crucial and significant part for managing and controlling your database especially for your production-grade clusters. Missing specific information that would be beneficial for improving...
ClusterControl – Advanced Backup Management – mariabackup Part III
So far in the previous two parts of this short blog series we have discussed several options that may impact the time and size of the backup. We have discussed different compression options and a...
Proactive MongoDB Monitoring (Developer Studio/Advisors angle)
ClusterControl has many metrics related to the database, replication, and also operating system. You can also monitor the process that runs inside the database through the opscounter in the Overview. If you enable Agent Based...
ClusterControl – Advanced Backup Management – MongoDB
Disaster recovery does not complete without a proper backup system. When something bad happens, the data could be restored by using the backup preferably with the latest one. We might want to avoid restoring the...
A Comparison Between ClusterControl and MongoDB OPS Manager
There are various ways to provision MongoDB servers, e.g., manual installation by command line, configuration management tools (eg. ansible, saltstack), or specialized MongoDB deployment tools such as ClusterControl and MongoDB Ops Manager. Manual installation will...
ClusterControl – Advanced Backup Management – PostgreSQL
Information is one of the most valuable assets in a company, so you will need a good Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or hardware failure. Backups...
Intro To Key-value Stores
When the internet gained popularity and relational databases could not cope with the tremendous variety of data types in the mid-1990s, non-relational databases or commonly referred to as NoSQL was developed and introduced by Carlo...