Webinar Replay: The MySQL Replication Blueprint
Thanks to everyone who participated in this week’s live webinar introducing our blueprint for MySQL Replication. If you missed the session and/or would like to watch the replay in your own time, it is now...
New Whitepaper: MySQL Replication for High Availability
MySQL Replication is probably the most popular high availability solution for MySQL, and widely used by top web properties like Twitter and Facebook. Although easy to set up, ongoing maintenance like software upgrades, schema changes,...
MySQL Load Balancing with ProxySQL – An Overview
Year 2015 was a good year for proxies in MySQL environments. First, MariaDB released a GA version of MaxScale, a new proxy that understands MySQL Replication and Galera topologies and supports read-write splitting. Later in...
Webinar Replay: Managing MySQL Replication for High Availability
Thanks to everyone who participated in this week’s live webinar on Managing MySQL Replication for High Availability led by our colleague Krzysztof Książek, Senior Support Engineer at Severalnines. The webinar included theory discussions bundled with...
Webinar Replay: Polyglot Persistence for the MongoDB, MySQL & PostgreSQL DBA
Many thanks to everyone who took the time yesterday to participate in our last webinar of 2015! Here are the recording of the session as well as the slides that were used by our colleague...
MySQL Troubleshooting with pt-stalk: Part 2
In our last post, we showed you how to use pt-stalk to help gather a bunch of data that can be used for troubleshooting. But what type of data does it collect? How do we...
Severalnines Tools: Docker, Puppet, Chef, Vagrant and More
ClusterControl integrates with a number of popular third-party tools for deployment and monitoring - from Docker images to Puppet modules, Chef cookbooks, Vagrant images, and Nagios/Zabbix/Syslog/PagerDuty plugins. In this blog, we’ll have a quick look...
MySQL Troubleshooting with pt-stalk: Part 1
In our previous posts, we have covered different log files and how to use them to troubleshoot MySQL, but that is not all that MySQL has to offer. But what do you do when the...
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...
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...
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...