How to setup and install Elasticsearch: From a single node to a cluster of nodes
Elasticsearch is a complex software incomparable to other mainstream database software, whether it's RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics....
10 Considerations for Architecting a Multi-Cloud Database
Thinking about architecting a multi-cloud database? It’s an increasingly common topology nowadays. The adoption rate of a multi-cloud approach has been growing fast for years. It’s a solid option for a disaster recovery plan (DRP)...
Best Practices for Scaling A Multi-Cloud Database Infrastructure
Scaling a multi-cloud database infrastructure can be a complex and challenging task, but it's essential for businesses that require high scalability, availability, and reliability. With multi-cloud becoming increasingly popular, organizations are leveraging the benefits of...
What’s new in SQL Server 2022
SQL Server 2022 is the latest database version released by Microsoft in November 2022. The release builds upon previous versions to add more choice for SQL Server users when it comes to development languages, data...
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...
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,...
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...
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...
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...
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...
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,...
ClusterControl Helps BT Expedite Global Expansion for Its Retail Customers
BT’s retail arm Expedite uses ClusterControl platform to scale MySQL and achieve agility on BT Cloud Stockholm, Sweden and anywhere else in the world - 30 September 2015 - Severalnines, the provider of database...
High Availability MySQL on cPanel with Galera Cluster
cPanel is a very popular Linux hosting control panel, used not only by hosting providers but also enterprise and goverment bodies. For large scale hosting environments hosting mission critical databases, how do you integrate cPanel...
WordPress Application Clustering Using Kubernetes with HAProxy and Keepalived
In a previous blog post, we showed you how to install Kubernetes on CentOS 7. Since then, there’s been a number of changes and we’ve seen the first production-ready release. The “minion” term has been...
High Availability Galera Clusters for Indonesia’s leading eCommerce Payment Gateway
Indonesia, the fourth most populous country in the world, is emerging as an economic powerhouse in Asia Pacific. With 60% of a population of 250 million being under 30 years of age, growing internet penetration...