Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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 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.

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 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.

Webinar Replay: Replication Topology Changes for MySQL

Thanks to everyone who joined us for our recent live webinar on ‘Replication Topology Changes for MySQL and MariaDB’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online.

An Overview of MySQL Database Indexing

An index is a data structure that sorts a number of records on one or more fields, and speeds up data retrieval. This is to avoid scanning through the disk blocks that a table spans, when searching through the database. So, what kind of indexes are available in MySQL and how do we use them to get the most performance? This will be the topic for this blog.

ClusterControl Helps BT Expedite Global Expansion for Its Retail Customers

Stockholm, Sweden and anywhere else in the world - 30 September 2015 - Severalnines, the provider of database automation and management software, today announced its latest customer, BT Expedite, BT’s specialist retail arm hosting its customers’ eCommerce applications and omni-channel marketing operations.

High Availability MySQL on cPanel with Galera Cluster

In this blog post, we will show you how to integrate Galera Cluster for MySQL into cPanel to provide a high availability database hosting solution. By default, cPanel uses localhost to host the MySQL databases created by cPanel users. It is not uncommon to find MySQL to be the culprit when it comes to overloading the server. By having a remote MySQL server or cluster, we can offload some of the burden and increase the availability of other important services on the server.

Posted in:

Wordpress Application Clustering Using Kubernetes with HAProxy and Keepalived

In this blog post, we’re going to play with Kubernetes application clustering and pods. We’ll use Wordpress as the application, with a single MySQL server. We will also have HAProxy and Keepalived to provide simple packet forwarding (for external network) with high availability capability.