MariaDB

What is MariaDB

MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL, created by the original developers of MySQL. It is designed to be highly compatible with MySQL while offering additional features and improvements.

Key features of MariaDB include:

Compatibility: Maintains compatibility with MySQL, including the same APIs and client libraries, making migration between MySQL and MariaDB straightforward.

Performance: Offers performance improvements and optimizations over MySQL, including advanced indexing, caching, and query optimization techniques.

Storage Engines: Supports various storage engines like InnoDB (default), Aria, and TokuDB, each suited for different use cases.

Scalability: Includes features for scaling databases, such as support for clustering (Galera Cluster) and replication.

Security: Provides robust security features including encryption, access control, and auditing to protect data.

Open Source: Available under the GPL license, ensuring that it remains free and open for community contributions and use.

Advanced Features: Includes additional features like dynamic columns, JSON support, and virtual columns that extend its capabilities.

MariaDB is widely used for web applications, enterprise databases, and data warehousing, providing a reliable and high-performance alternative to MySQL with enhanced functionality.

Getting started with MariaDB Deployment

Log in to portal.antyxsoft.io and during the instance creation at the Select Template section click on the Market Place App tab.

Select the ready-to-go MariaDB template from the list of available templates and deploy it.

Once you select your plan and named the VM. Click on the Review & Deploy button to deploy your new app.

Getting Started after Deployment

After the template is deployed, you will be able to access MariaDB from the console via ssh or using the web console . The standard tool for interacting with MariaDB is the mariadb command. Read the official documentation for more details.

Creating a DB

After you connect to the VM you can create a database by following these steps:

First login to mariadb as root: mariadb -u root -p

You will be prompted to enter the root password.

Create a database: CREATE DATABASE my_database;

Next create a user: CREATE USER 'my_user'@'localhost' IDENTIFIED BY 'secure_password';

Grand all privilegies of the user to the database that was created earlier: GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'localhost';

Reload the in-memory user privileges with:FLUSH PRIVLEGES;

You can confirm that the database was created with: SHOW DATABASES;

Text

Accept connections from the same network

To connect to the database from the private network follow these steps:

Open the MariaDB config file located at /etc/mysql/mariadb.conf.d/50-server.cnf

Edit the line bind-address = 127.0.0.1to bind-address = 0.0.0.0This makes MariaDB listen on all network interfaces. Alternatively, use the specific IP address of the host.

Next update a user to allow access from your network: (% is a wildcard. For tighter security, specify exact VM IPs like 'dbuser'@'192.168.1.12')

Make sure you have the port 3306 open: iptables -A INPUT -p tcp --dport 3306 -s 192.168.1.0/24 -j ACCEPT

Finally restart the mariadbservice: systemctl restart mariadb

You can confirm from a VM from the remote VM with: mariadb -h 192.168.1.10 -u dbuser -p