Difference between revisions of "MariaDB"

From Coders.Bay Wiki
Jump to navigation Jump to search
 
(22 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{short description|Database management system, relational, open source, community developed fork of MySQL}}
==What is MariaDB==
{{Infobox software
====Introduction to MariaDB====
| name = MariaDB
| title = MariaDB
| logo = MariaDB colour logo.svg
| screenshot = MariaDB monitor screenshot.png
| caption =
| collapsible =
| author =
| developer = MariaDB Corporation Ab, MariaDB Foundation
| released = {{Start date and age|2009|10|29|df=yes}}<ref>{{Cite web |url=https://mariadb.com/kb/en/library/mariadb-5138-release-notes/ |title=MariaDB 5.1.38 Release Notes |website=MariaDB KnowledgeBase |access-date=2019-01-14}}</ref>
| latest release version = <!-- If you update [[Template:MariaDB version]], it will automatically update this page and [[List of content management systems]]--> MariaDB version
| latest release date = MariaDB version|releasedate
| discontinued =
| programming language = [[C (programming language)|C]], [[C++]], [[Perl]], [[Bash (Unix shell)|Bash]]
| operating system = [[Linux]], [[Windows]], [[macOS]]<ref>{{cite web|title="Download MariaDB"|url=https://mariadb.com/downloads/|access-date=2019-01-16}}</ref>
| platform =  
| size =  
| language = English
| genre = [[Relational database management system|RDBMS]]
| license = [[GNU General Public License|GPLv2]], [[GNU Lesser General Public License|LGPLv2.1]] (client libraries)<ref name="MariaDB licenses">{{Cite web|url=https://mariadb.com/kb/en/library/mariadb-license/|title=MariaDB License|website=MariaDB KnowledgeBase}}</ref>
| website = {{URL|https://mariadb.com/}} (MariaDB Corporation Ab, formerly SkySQL Corporation Ab)<br />{{URL|https://mariadb.org/}} (MariaDB Foundation)
}}


MariaDB is a database management system using a language called SQL and included in Mageia. It is a fork of MySQL, so it often uses file and folder names including "my" or "mysql" in them. In Mageia, the configuration file is /etc/my.cnf and the databases are stored in /var/lib/mysql. Databases are not human-readable files and MariaDB doesn't include a GUI (graphic user interface). A good way to read and manage MariaDB data is PhpMyAdmin. Many applications use MariaDB to manage their data, without the final user having to know it at all.
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.


== Installation ==
MariaDB is intended to maintain high compatibility with MySQL, with library binary parity and exact matching with MySQL APIs and commands, allowing it in many cases to function as drop-in replacement for MySQL. However, new features are diverging.[7] It includes new storage engines like Aria, ColumnStore, and MyRocks.
In most cases, you will need a LAMP (Linux, Apache, MariaDB, PHP) pile, plus PhpMyAdmin. To install them, go to Mageia control center (an icon in the tool bar usually at the bottom of your screen) then choose "Software management" → "Install & remove software". In the upper left part of the window, there are 2 rolling lists: in both of them, choose "All". In the "Find" field, type "lamp", press the "Enter" key and choose in the list "task-lamp-php". You will probably be asked to install required packages: click on "OK". Then in the "Find" field, type "phpmyadmin", press "Enter", check phpmyadmin's box, click "OK" if asked for dependencies. Then click on "Apply" at the right bottom of the window and read carefully the upgrade information message for MariaDB.
The installation of MariaDB also set a user and a user group both called "mysql" and who will own the files.


The same way, you can install just MariaDB and PhpMyAdmin, looking for "mariadb" in Mageia Software management, and choosing in the list the version of "mariadb" corresponding to your system: x86_64 for a 64 bits system, i586 for a 32 bits system.
Its lead developer/CTO is Michael "Monty" Widenius, one of the founders of MySQL AB and the founder of Monty Program AB. On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $1 billion. The acquisition completed on 26 February 2008. Sun was then bought the following year by Oracle Corporation. MariaDB is named after Widenius' younger daughter, Maria. (MySQL is named after his other daughter, My.)
== Configure the database ==
 
All commands below need be entered as root.
=====advantages of mariadb=====
* Start MariaDB (i.e it was just installed) cmd|systemctl start mysqld ''It seems installing the rpm also sets MariaDB to start at boot (should it not, issue 'systemctl enable mysqld' )''
 
* Issue {{cmd|mysql_secure_installation}} to set/edit MariaDB administrative "root" password and perform a few security measures - just reply to the questions.
1.Key Benefits of MariaDB Platform
* Then log in using that password: cmd|mysql -uroot -p, and there you can create a first database.
 
2.User-friendly Installation. ...
 
3.Support for Big Data Operations. ...
 
4.Offers Columnar Storage for Faster Analytics Performance. ...
 
5.Scaling Ad Hoc Data Requests. ...
 
6.Cost-effective Cloud-based Storage. ...
 
7.Seamless Scaling. ...
 
8.Straightforward Data Imports. ...
 
9.Greater Business Agility.
 
 
=====Licensing=====
The MariaDB Foundation mentions:
 
MariaDB Server will remain Free and Open Source Software licensed under GPLv2, independent of any commercial entities.
 
 
=====Third-party software=====
MariaDB's API and protocol are compatible with those used by MySQL, plus some features to support native non-blocking operations and progress reporting. This means that all connectors, libraries and applications which work with MySQL should also work on MariaDB—whether or not they support its native features. On this basis, Fedora developers replaced MySQL with MariaDB in Fedora 19, out of concerns that Oracle was making MySQL a more closed software project. OpenBSD likewise in April 2013 dropped MySQL for MariaDB 5.5.
 
However, for recent MySQL features, MariaDB either has no equivalent yet (like geographic function) or deliberately chose not to be 100% compatible (like GTID, JSON). The list of incompatibilities grows longer with each version.
 
 
=====How to install MariaDB=====
 
Download MariaDB
To download MariaDB, you go to the download page and select the latest version to download:
 
Download MariaDB
 
Install MariaDB
 
To install MariaDB on Windows, you follow these steps:
 
Step 1. Start installation
Double-click the installer to start the installation process.
<br/><br/>[[file:Step1.png|500px]]
 
Step 2. Accept the end-user license agreement
Read the end-user license agreement and click the Next button:
<br/><br/>[[File:Install-MariaDb-Windows-step-2.png|500px]]
 
Step 3. Select features
Choose the directory that stores the MariaDB files and click the Next button. The default location on Windows is C:\Program Files\MariaDB 10.4\.
<br/><br/>[[File:Install-MariaDb-Windows-step-3.png|500px]]
 
Step 4. Set root’s password
Type a password for the root user account. You will use this password to connect to MariaDB later. The root user is the default user of the MariaDB, which has all privileges.
 
If you don’t want the root user to login from a remote machine, you need to uncheck the Enable access from remote machines for 'root' user checkbox.
 
The Use UTF8 as the default server's character set option allows you to use the UTF8 as the default character set when you create new databases and tables.
 
Once you complete selecting all options, click the Next button to go to the next step.
<br/><br/>[[File:Install-MariaDb-Windows-step-4.png |500px]]
 
Step 5. Configure Database
In this step:
 
First, install MariaDB as a service by selecting the Install as service option. It allows you to rename the service name.
 
Second, configure the port for the MariaDB. By default, MariaDB uses 3306 port. However, you can change it to your port if you want.
 
Third, specify the parameters for the Innodb engine including buffer pool size and page size.  16KB page size is suitable for most databases.
 
Finally, click the Next button to go to the next step.
<br/><br/>[[File:Install-MariaDb-Windows-step-5.png|500px]]
 
Step 6. Submit usage information
If you want to submit anonymous usage information so that MariaDB developers can improve the system, check the checkbox and click the Next button.
<br/><br/>[[File:Install-MariaDb-Windows-step-6.png|500px]]
 
Step 7.  Ready to install MariaDB
Click the Install button to start installing MariaDB
 
<br/><br/>[[File:Install-MariaDb-Windows-step-7.png|500px]]
It will take a few minutes depending on the system.
 
 
Step 8. Complete the MariaDB setup
Click the Finish button to complete MariaDB setup
 
<br/><br/>[[File:Install-MariaDb-Windows-step-8.png|500px]]
You can find the MariaDB tools in the startup menu:
 
Install MariaDB
<br/><br/>[[File:Install-MariaDB.png|300px]]
 
==External links==
 
* [https://mariadb.org/ MariaDB Foundation website]
* [https://mariadb.com/ MariaDB Corporation website]

Latest revision as of 10:24, 8 April 2022

What is MariaDB[edit]

Introduction to MariaDB[edit]

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.

MariaDB is intended to maintain high compatibility with MySQL, with library binary parity and exact matching with MySQL APIs and commands, allowing it in many cases to function as drop-in replacement for MySQL. However, new features are diverging.[7] It includes new storage engines like Aria, ColumnStore, and MyRocks.

Its lead developer/CTO is Michael "Monty" Widenius, one of the founders of MySQL AB and the founder of Monty Program AB. On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $1 billion. The acquisition completed on 26 February 2008. Sun was then bought the following year by Oracle Corporation. MariaDB is named after Widenius' younger daughter, Maria. (MySQL is named after his other daughter, My.)

advantages of mariadb[edit]

1.Key Benefits of MariaDB Platform

2.User-friendly Installation. ...

3.Support for Big Data Operations. ...

4.Offers Columnar Storage for Faster Analytics Performance. ...

5.Scaling Ad Hoc Data Requests. ...

6.Cost-effective Cloud-based Storage. ...

7.Seamless Scaling. ...

8.Straightforward Data Imports. ...

9.Greater Business Agility.


Licensing[edit]

The MariaDB Foundation mentions:

MariaDB Server will remain Free and Open Source Software licensed under GPLv2, independent of any commercial entities.


Third-party software[edit]

MariaDB's API and protocol are compatible with those used by MySQL, plus some features to support native non-blocking operations and progress reporting. This means that all connectors, libraries and applications which work with MySQL should also work on MariaDB—whether or not they support its native features. On this basis, Fedora developers replaced MySQL with MariaDB in Fedora 19, out of concerns that Oracle was making MySQL a more closed software project. OpenBSD likewise in April 2013 dropped MySQL for MariaDB 5.5.

However, for recent MySQL features, MariaDB either has no equivalent yet (like geographic function) or deliberately chose not to be 100% compatible (like GTID, JSON). The list of incompatibilities grows longer with each version.


How to install MariaDB[edit]

Download MariaDB To download MariaDB, you go to the download page and select the latest version to download:

Download MariaDB

Install MariaDB

To install MariaDB on Windows, you follow these steps:

Step 1. Start installation Double-click the installer to start the installation process.

Step1.png

Step 2. Accept the end-user license agreement Read the end-user license agreement and click the Next button:

Install-MariaDb-Windows-step-2.png

Step 3. Select features Choose the directory that stores the MariaDB files and click the Next button. The default location on Windows is C:\Program Files\MariaDB 10.4\.

Install-MariaDb-Windows-step-3.png

Step 4. Set root’s password Type a password for the root user account. You will use this password to connect to MariaDB later. The root user is the default user of the MariaDB, which has all privileges.

If you don’t want the root user to login from a remote machine, you need to uncheck the Enable access from remote machines for 'root' user checkbox.

The Use UTF8 as the default server's character set option allows you to use the UTF8 as the default character set when you create new databases and tables.

Once you complete selecting all options, click the Next button to go to the next step.

Install-MariaDb-Windows-step-4.png

Step 5. Configure Database In this step:

First, install MariaDB as a service by selecting the Install as service option. It allows you to rename the service name.

Second, configure the port for the MariaDB. By default, MariaDB uses 3306 port. However, you can change it to your port if you want.

Third, specify the parameters for the Innodb engine including buffer pool size and page size. 16KB page size is suitable for most databases.

Finally, click the Next button to go to the next step.

Install-MariaDb-Windows-step-5.png

Step 6. Submit usage information If you want to submit anonymous usage information so that MariaDB developers can improve the system, check the checkbox and click the Next button.

Install-MariaDb-Windows-step-6.png

Step 7. Ready to install MariaDB Click the Install button to start installing MariaDB



Install-MariaDb-Windows-step-7.png It will take a few minutes depending on the system.


Step 8. Complete the MariaDB setup Click the Finish button to complete MariaDB setup



Install-MariaDb-Windows-step-8.png You can find the MariaDB tools in the startup menu:

Install MariaDB

Install-MariaDB.png

External links[edit]

Retrieved from "http://wiki.streampy.at/index.php?title=MariaDB&oldid=1392"