Webinar Replay: Performing Live Database Upgrades in Replication & Clustered Setups
Thanks to everyone who joined us for our recent live webinar on performing live database upgrades for MySQL Replication & Galera, led by Krzysztof Książek. The replay and slides to the webinar are now available...
Troubleshooting Galera Cluster Issues: Part 2
This is part 2 of our blog on how to troubleshoot Galera cluster - SST errors, and problems with network streaming. In part 1 of the blog, we covered issues ranging from node crashes to...
Troubleshooting Galera Cluster Issues: Part 1
In this blog post, we are going to show you some examples of things that can go wrong in Galera - inexplicable node crashes, network splits, clusters that won’t restart and inconsistent data. We’ll take...
A Guide to Max Open Files for MySQL
Requires ClusterControl 1.2.11 or later. Applies to MySQL single instances, replications and Galera clusters. You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a...
Using NGINX as a Database Load Balancer for Galera Cluster
Nginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend services, provided these passed some health...
Understanding the MySQL Galera Cluster and MariaDB Cluster Diagnostic Logs
In a previous post, we discussed the error log as a source of diagnostic information for MySQL. We’ve shown examples of problems where the error log can help you diagnose issues with MySQL. This post...
Webinar Replay: Deploying MongoDB, MySQL, PostgreSQL & MariaDB’s MaxScale in 40min
Live demo recording of ClusterControl 1.2.11 and its new features Thanks to everyone who joined us for our recent live webinar on ‘ClusterControl 1.2.11 - new release’ led by Art van Scheppingen , Senior Support...
Understanding the MySQL Error Log
We are yet to see a software that runs perfectly, without any issues. MySQL is no exception there. It’s not the software’s fault - we need to be clear about that. We use MySQL in...
A Guide to MySQL User Management
Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. In this example we will look at how you can use ClusterControl to create a user and assign privileges to the user. We will create...
Updating Your MySQL Configuration
Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. From time to time it is necessary to tune and update your configuration. Here we will show you how you can change/update individual parameters using the...
Optimizer Hints for Faster MySQL Query Execution
MySQL uses a cost-based optimizer to determine the best way to execute a query. It usually does a great job, but not all the time. There are different reasons for that. In some cases, it...
Using Explain to Improve SQL Query Performance
When it comes to the query tuning, EXPLAIN is one the most important tool in the DBA’s arsenal. Why is a given query slow, what does the execution plan look like, how will JOINs be...