Introduction of MariaDB

MariaDB is one of the most popular open-source relational database management system and could be used as a great replacement of MySQL. It is developed by original developers of MySQL. MariaDB can also stores data in various tables. It is also part of most cloud offerings and default in most Linux distributions. To establish the relationship between these tables, primary keys and foreign keys are used.

Features of MariaDB

  • It is fast, scalable and robust.
  • It has rich ecosystem of plugins, storage engines, etc which makes it very versatile for a wide variety of use cases.
  • It is licenced under GPL, LGPL, or BSD.
  • It uses a standard and popular querying language. It runs on different operating systems and supports variety of programming languages.
  • It also offers support for PHP and offers Galera cluster technology.

Installation of MariaDB

1. Download MariaDB.
2. Read their terms and conditions and accept them if you think it would be fine to do so. Then in the next step simply click next.
3. Set the root password and enable access from remote machine option.
set-password-mariadb
4. Now set the port number and set engine buffer pool. It is recommended to keep them as default.
setting-port-engine-mariadb
5. Then click on install. Mariadb would be installed in a minute after this.
6. In order to verify the installation, Go to your installation directory and bin folder in that(by default it is “C:\Program Files\MariaDB 10.5\bin”).and open cmd through address bar and write the following command there.

mysqld.exe --console

veriffying-mariadb
Note: Mariadb installs a client for its working named as heidi, so it could even be used to work with mariadb.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


2


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.