Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
594 blog posts in 13 categories

Webinar Replay & Slides: Deploying MongoDB, MySQL, PostgreSQL & MariaDB’s MaxScale in 40min

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 Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online.

ClusterControl Tips & Tricks: wtmp Log Rotation Settings for Sudo User

ClusterControl requires a super-privileged SSH user to provision database nodes. If you are running as non-root user, the corresponding user must able to execute sudo commands with or without sudo password. Unfortunately, this could generate another issue where performing remote command with “sudo” requires an interactive session (tty).

Become a MySQL DBA blog series - 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 different places, on different hardware and within different environments. It’s also highly configurable. All those features make it great product but they come with a price - sometimes some settings won’t work correctly under certain conditions.

ClusterControl Tips & Tricks: User Management for MySQL

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 a user that has enough privileges to perform an xtrabackup.

ClusterControl Tips & Tricks: 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 ClusterControl UI. Navigate to Manage > Configurations.

Become a MySQL DBA blog series - Optimizer Hints for faster 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 might not have enough information about the data and plan queries in a non-optimal way.

Severalnines’ Vinay Joosery named UK top 50 data leader & influencer

Information Age today unveiled the inaugural list of the UK’s top 50 data leaders and influencers. “Very strong on product and technical development of open-source databases, Vinay has helped global and UK businesses like BT, AutoTrader Group and Ping Identity to scale, manage and develop (data) cloud operations.” - as just announced by Information Age.

Posted in:

Become a MySQL DBA blog series - Using Explain to improve SQL Queries

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 processed, is the query using the correct indexes, or is it creating a temporary table? In this blog post, we’ll look at the EXPLAIN command and see how it can help us answer these questions.

How to Deploy and Manage MaxScale using ClusterControl

We were delighted to announce that ClusterControl now supports MaxScale, the intelligent database gateway from the MariaDB team. In this blog, we will show you how to deploy and manage MaxScale from ClusterControl. We previously blogged about MaxScale, read it if you’d like a quick overview and introduction. We also published a quick benchmark of HAProxy vs MaxScale.

ClusterControl 1.2.11 Released

The Severalnines team is pleased to announce the release of ClusterControl 1.2.11. This release contains key new features, such as support for MariaDB’s MaxScale, along with performance improvements and bug fixes. This is also our best release yet for PostgreSQL users.