Do you know what is MariaDB and what the purpose of the MariaDB service is? Don’t worry, we will explain and dig deeper into the meaning of it, and what can be achieved using this type of service.
MariaDB is one of the most popular open-source database servers in the world. Designed by the MySQL developers, MariaDB offers fastness, scalability, and robustness. It has a reach storage engine and many tools designed as replacements for MySQL. As a service, MariaDB is offered by our RoseHosting Cloud platform and more about the installation, configuration and benefits will be explained in the next few paragraphs. Let’s start!
Table of Contents
The complexity of the configuration of MariaDB
In standard hosting, you have a virtual private server and access to it. If you want to install and configure MariaDB you have to do multiple steps such as installing from scratch, configure it and optimize it according to the need of the application. Also, it is very important to make some strategy for daily or weekly backup of the databases as well in case something went wrong.
Let’s say that everything is OK, and suddenly your server crashes and you face downtime. Ok, that is not a very big problem you will revert the database from the backup and everything will be ok. If somehow this happens again, then the next step will be another virtual server with replication of the MariaDB and load balancer. Do you know how much time you lose during this most common scenario? Now you see how hard was to install configure, optimize, do the backup strategy, revert the database from backup, make another installation, and all from scratch. All these steps took a couple of hours to be completed, and the downtime was very long.
Do not worry, we have a solution for this and the solution is only a few clicks away, on our RoseHosting Cloud Platform. In the next paragraph, we will explain what is MariaDB-as-a-Service result of and how it changes the complexity of the configuration.
MariaDB-as-a Service in RoseHosting Cloud Platform
As years were passing by, with MariaDB hosting there were too many issues with the configuration of replica databases, their optimization, and configuration. Also, big-sized databases were a very big problem for restoration and there was a downtime that sometimes costumers made without their websites accessible a couple of hours. Downtime is not what the customers want neither the hosting companies. That is why this solution is now available as an option in our RoseHosting Cloud platform.
There are a couple of benefits that MariaDB offers on our RoseHosting Cloud platform:
- Simplified installation – One-click installation, against step by step
- Multiple Choices – Three different MariaDB replication schemes, SQL load balancing, and easy scalability.
- Optimization – Already optimized databases according to the needs of the application.
- Reliability – Multiple database instances that eliminate the risk of downtime.
Database Replication Scheme
As we said previously RoseHosting Cloud platform offers three different replication schemes of MariaDB like primary-secondary replication, primary-primary, and Galera cluster replication. In this paragraph, we will explain in more detail what are the main differences between these replications.
Primary-Secondary Replication:
With this replication are provisioned two nodes, one is primary and another one secondary. For load balancing servers are provisioned two ProxySQL servers. For this topology are inherent the following lines of parameters:
Server-id = {nodeId}
binlog_format = mixed
log-bin = mysql-bin
Log-slave-updates = ON
expire_logs_days = 7
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
replicate-wild-ignore-table = performance_schema.%
replicate-wild-ignore-table = information_schema.%
replicate-wild-ignore-table = mysql.%
Primary-Primary Replication:
With this replication are provisioned two database nodes, and two of them are working as primary nodes. For load balancing servers are provisioned two ProxySQL servers. This topology is used when the application needs writing and reading from the database and the following lines of parameters are inherent:
server-id = {nodeId}
binlog_format = mixed
auto-increment-increment = 2
Auto-increment-offset = {1 or 2}
log-bin = mysql-bin
log-slave-updates
expire_logs_days = 7
relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
replicate-wild-ignore-table = performance_schema.%
replicate-wild-ignore-table = information_schema.%
replicate-wild-ignore-table = mysql.%
Galera Cluster Replication:
For this replication, we have three database nodes of MariaDB and like previous replications two ProxySQL nodes for load balancing. This is suitable for geographically distanced regions. For this topology are inherent the following lines of parameters:
server-id = {nodeId}
binlog_format = ROW
# Galera Provider Configuration
wsrep_on = ON
wsrep_provider = /usr/lib64/galera/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name = cluster
wsrep_cluster_address = gcomm://{node1},{node2},{node3}
wsrep-replicate-myisam = 1
# Galera Node Configuration
Wsrep_node_address = {node.ip}
Wsrep_node_name = {node.name}
This tutorial was an explanation of what is MariaDB as a service and what makes it popular against the traditional MariaDB hosting. We manage to provide you with some important information about MariaDB replication schemes and of course if there are any unclear configuration issues you can always contact our RoseHosting support. We are available 24/7 to help you.
If you liked this post on what is MariaDB as a service in RoseHosting Cloud, please do not forget to share with your friends on the social networks, or you can leave a comment in the comments section. Thanks for your time!