Let’s try MariaDB

Posted by in MariaDB

I should have written this entrance before, because the original in spanish was published on September 2013, one year ago!

After installing MySQL and all the entrance related to MySQL upgrading versions, here for 5.6 and here for 5.7, I must try MariaDB.

Let’s try MariaDB 10

It has been on alpha state (in developing mode) for a long time, but now you can download it and give it a try. And, as you can see, the installation process is quickly, clean, and easy. I am using a vistual machine with Windows XP, so I download the 32 bits versions from downloads.mariadb.org/mariadb/10.0.4. (this is the version I tested when I created the original entrance. Now, you can try 10.0.12, that you can download here: https://downloads.mariadb.org/mariadb/)

Instalando MariaDB

Install MariaDB

After the initial windows, accept the licence:

Licencia de uso para MariaDB

Licencia de uso para MariaDB

Next, you are asked to create a new database instance, or upgrade existing instances. In my case, I create a new one:

Instalando MariaDB

Install MariaDB

Next, you need to select the path where everything will be install:

Instalando MariaDB

Install MariaDB

The next step is the root password, and some basic options. It is important to select the UTF8 coding as default!

Instalando MariaDB

Instalando MariaDB

Next step is to name the service, select the port (default port is 3306, the same used by MySQL), but in my case, I am using 3307 (basically because on this vistual machine I have installed also MySQL with the 3306 used).

Creando el servicio de MariaDB

Create a service for MariaDB

And last, you can enable feedback:

Instalando MariaDB

Install MariaDB

Everything is ready to start:

Instalando MariaDB

Install MariaDB

A few minutes lates, the new MariaDB server is ready to use:

Servidor MariaDB instalado

MariaDB server is ready

 

Verifying that MariaDB is running

So, let’s open heidiSQL, selecte port 3307, and introduce the data to log in, verifying that the new MariaDB server is up and running.

Probando que MariaDB está funcionando

MariaDB server running

So, by now, no errors during installation is very positive (after a few errors when installing MySQL). So, …

The match begins, and MariaDB 1 – MySQL 0

As you can imagine, it doesn’t worth anything, compared with new features of MySQL if you need to solve errors when installing, so I encourage Oracle to avoid this “important” details, becuase MariaDB is a very serious competitor for MySQL!

Have a nice day!