Live Webinar: Tips to Drive MariaDB Galera Cluster Performance for Nextcloud
Join us for this webinar on Tips to Drive MariaDB Galera Cluster Performance for Nextcloud. The webinar features Björn Schiessle, Co-Founder and Pre-sales lead at Nextcloud, and Ashraf Sharif, senior support engineer at Severalnines. They...
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...
New User and LDAP Management in ClusterControl 1.8.2
After upgrading to ClusterControl 1.8.2, you should get the following notification banner: What's up with that? It is a depreciation notice of the current user management system in favor of the new user management system...
Automate Database Schema Object Check
Monitoring your database schema changes in MySQL/MariaDB provides a huge help as it saves time analyzing your database growth, table definition changes, data size, index size, or row size. For MySQL/MariaDB, running a query referencing...
Automate Database Configuration Check
Many system administrators commonly overlook the importance of ongoing database configuration tuning. Configuration options are often being configured or tuned once, during the installation stage, and being left out until some unwanted events occur to...
Announcing CCX Database as a Service from Severalnines
We at Severalnines are thrilled to announce the release of CCX, our brand new database as a service (DBaaS) offering! It’s a fully managed service built atop the powerful ClusterControl automated operational database management...
Automated Testing of the Upgrade Process for MySQL/MariaDB/Percona Server
Upgrades are always a hard and time-consuming task. First, you should test your application in a test environment, so, ideally, you will need to clone your current production environment for this. Then, you need to...
Automated Testing of the Upgrade Process for PXC/MariaDB Galera Cluster
Upgrading your database for Galera-based clusters such as Percona XtraDB Cluster (PXC) or MariaDB Galera Cluster can be challenging, especially for a production-based environment. You cannot afford to lose the state of your high availability...
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....