Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Manage MariaDB 10.3 with ClusterControl

In this blog post, we would like to give you an overview of the MariaDB 10.3 administration with ClusterControl.

An introduction to Full Text Search in MariaDB

Querying text data used to be hard in InnoDB. Luckily, InnoDB in MariaDB comes with FULLTEXT indexes which make full text search works just fine. In this blog post we will go over the features related to full text search available in MariaDB.

Handling Large Data Volumes with MySQL and MariaDB

Handling large data volumes is always problematic. In this blog we’ll discuss several options to make it more manageable when using MySQL or MariaDB as the database technology.

How to Use the Failover Mechanism of MaxScale

A load balancer similar to the likes of ProxySQL & HAProxy, MariaDB MaxScale has its own diverse features and capabilities. MaxScale has the ability to do auto-failover which can save you from catastrophe as well as a switch over mechanism to make your life easier during maintenance. This blog explores this failover feature and how you can leverage it as part of your setup.

How to Setup Asynchronous Replication Between MariaDB Galera Clusters

Asynchronous replication is commonly used between Galera clusters. In this blog post we show how to set it up for MariaDB Galera clusters and how ClusterControl can help you with it.

Database User Management: Managing Roles for MariaDB

Managing privileges on a database can be a hard and time-consuming task if we’re working in large organizations or if you have a complex privilege structure created on the database side. In this blog, we’ll see how we can cope with the database user management by using roles and how to use them on MariaDB.

A Guide to the MariaDB Columnstore for MySQL Admins

Big data processing and data warehousing plays an important role in analytics, forecasting, statistical reports, and more. This blog will help MySQL DBA's leverage the MariaDB ColumnStore (a columnar-storage engine system which is part of MariaDB AX) for these types of tasks.

Posted in:

MariaDB MaxScale Load Balancing on Docker: Management - Part 2

In the previous blog, we looked at how to deploy MaxScale on Docker, and how to use Swarm service to run multiple replicas. This part focuses more on management operations with advanced use cases like service control, configuration management, query processing, security and cluster reconciliation.

MariaDB MaxScale Load Balancing on Docker: Deployment - Part 1

In this two-part blog series we are going to give a complete walkthrough on how to run the MariaDB MaxScale load balancer in a Docker environment. This first part covers the deployment using a standalone Docker container and MaxScale clustering via Docker Swarm for high availability.

Using the MyRocks Storage Engine with MariaDB Server

One of the advantages of MariaDB is to have options for different types of storage engines depending on our specific requirements. In this blog, we’ll see what the MyRocks storage engine is and how we can implement it with MariaDB.