How to manage large databases effectively
One of the biggest concerns when managing a database is the size and complexity of its data. As the size of the database increases, you need to have a plan in place for how to...
Understanding Indexes in MySQL: Part Three
This blog post is the third part of the series of blogs about indexes in MySQL. In the second part of the blog post series about MySQL indexes, we covered indexes and storage engines and touched upon some...
Understanding Indexes in MySQL: Part Two
This blog post is the second part of the series of blogs about indexes in MySQL. In the first part of the blog post series about MySQL indexes, we have covered quite many things, including what...
Understanding Indexes in MySQL: Part One
Indexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them - we will do that in these series of...
Automating Security Audits for MySQL
Taking care of the security of your MySQL instances is a near-daily task of almost every MySQL DBA. Today, we will look into how you should go about automating security audits for MySQL. Why Automate...
Securing MySQL Backups: A Guide
If you’ve ever used MySQL, chances are you probably took backups of your database. If you took backups of your database, chances are you have at least once thought of how you could secure them....
Understanding Lock Granularity in MySQL
If you’ve been working with MySQL for some time, you have probably heard the terms “table-level locking” and “row-level locking”. These terms refer to the lock granularity in MySQL - in this blog we will...
Announcing ClusterControl 1.8.2: Enhanced Security, Resource Utilization and Administration
We are pleased to announce the release of version 1.8.2 of Severalnines ClusterControl - the only management system you’ll ever need to deploy, monitor, and manage your open source databases. ClusterControl version 1.8.2 features new...
How Database Automation Lowers The Total Cost of Ownership of Infrastructure Services
With the pandemic scorching the world for more than a year already, businesses are looking for a reduction in the cost of operating a business. In many cases, IT is one of the most expensive...
A Guide to Database Automation with Severalnines ClusterControl
Nowadays, database automation is a very hot topic. Database automation, simply speaking, refers to leveraging processes and tools to make administrative tasks for database developers and database administrators simpler. Why Database Automation? Database automation refers...
Securing MySQL – Making Use of Data Access Privileges for a Secure Installation
MySQL installation security is something that should be on the mind of every MySQL DBA. While we have discussed how you should take care of your MySQL security as a whole (take a look at...
Architecting for Security: A Guide for MySQL
Security is paramount today across the whole of IT. From time to time we hear about ransomware attacks or data leaks that have their origin in not secured databases or IT infrastructure. You may wonder:...