Benchmarking databases 101 – part 2
In the previous blog post we have discussed a couple of best practices related to benchmarking. This time we would like to talk about the process itself. What can go wrong, what are the potential...
Need Performance Advice? Turn To ClusterControl!
If you frequently find yourself working with any kind of database, it’s natural that you might need some advice on how to deal with them at least once in a while. At present, you might...
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....
PostgreSQL and TimescaleDB backup restoration using ClusterControl CLI
Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. Backups are the basic way to keep it...
Proactive Galera Monitoring (Developer Studio/Advisors angle)
Monitoring is one of the vital parts for many organizations. In fact, there is a role specifically for monitoring purposes. This proves that with proactive monitoring, a lot of things could be achieved including driving...
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,...
Webinar Replay: Top Five Tips to Drive MariaDB Galera Cluster Performance for Nextcloud
Are you a MariaDB database administrator that is facing problems regarding your Galera Cluster implementations? Perhaps you even tried to make it work in harmony with Nextcloud? If you have answered “yes” to any of...
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...
Proactive PostgreSQL Monitoring (Developer Studio/Advisors angle)
Monitoring is a way to know if your systems are working properly. Even when using a robust technology like PostgreSQL, it is important to have a good monitoring system that allows you to prevent issues...