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 https //portal antyxsoft io and during the create compute instances docid\ ciydd3c exqsdqonp7uev 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 connect with ssh docid\ f bllmth4ottbay58beva or using the console access docid\ ssqmeqx8qhr2sotokwdcx the standard tool for interacting with mariadb is the mariadb command read the official documentation https //mariadb com/kb/en/mariadb command line client/ 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; + + \| database | + + \| information schema | \| mysql | \| performance schema | \| my database | + 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 1 to bind address = 0 0 0 0 this 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') replace '192 168 1 %' with your actual subnet create user 'dbuser'@'192 168 1 %' identified by 'strongpassword'; grant all privileges on your database to 'dbuser'@'192 168 1 %'; flush privileges; 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 mariadb service systemctl restart mariadb you can confirm from a vm from the remote vm with mariadb h 192 168 1 10 u dbuser p