MariaDb or MySQL ?

Posted by

Nowadays students in colleges and universities spot a sweet project for their academics, they often wonder which database management system would be most efficient and stable for handling a large amount of data and also which outputs a desirable power for managing the front end web interface.  According to the recent statistics and development, MySQL and MariaDB are the two most trending database developments technologies available on the markets online.

open_source_img2

Some more amazing features of MariaDB are Speed improvements, extensions, new features, better testing, fewer bugs and truly open sources. The following features of MongoDB are listed below which have more advantage over MySQL :

  1. Column Storage Engine: MariaDB Columnstore is a storage engine that utilizes a massively parallel distributed data architecture. Released under GPL license, it is designed for big data scaling to process petabytes of data, linear scalability, exceptional performance and real-time analytical queries. For more Info click here.
  2.  MyRocks: Is a storage engine that adds the RocksDb database to MariaDB. RocksDb is an LSM database optimized for flash storage. For more information about RocksDb for MariaDB click here.

The entire comparison matrix of MariaDb and MySQL is shown in the diagram given below :

comparison
Comparison Matrix for MariaDb and MySQL

ALERT ! ALERT ! ALERT !

As MariaDb can be installed and located on MySQL server itself, it will give an error for root password. If you install MySQL and MariaDb both on a single MySQL Server Engine, a collision will occur for both the passwords of a MariaDb and MySQL as the engine is common for both.

Solution to the problem : You just cannot installl both the Db techs on one single system due to above mentioned contingencies. There is a solution to operate both these techs on a the same system by making some configurations in the MySQL.ini file, but it is more tedious and can cause fatigue to the engine as well. So it is best recommended to use one sin gle database instance out of the both at one time above one engine.

INSTALLATION GUIDE FOR MYSQL AND MARIADB

MySQL Installation:

  1. Install MySQL server using command : $mysql-server
  2. Run script :
    • sudo apt-get update
    • sudo apt-get install mysql-server
    • mysql_secure_installation
  3. Test MySQL connection :
    systemctl status mysql.service
  4. You will see the following output :
Output
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: active (running) since Wed 2016-11-23 21:21:25 UTC; 30min ago
 Main PID: 3754 (mysqld)
    Tasks: 28
   Memory: 142.3M
      CPU: 1.994s
   CGroup: /system.slice/mysql.service
           └─3754 /usr/sbin/mysqld
  1. Then use this command to start:
mysqladmin -p -u root version

You should see output like this:

Output
mysqladmin  Ver 8.42 Distrib 5.7.16, for Linux on x86_64
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version      5.7.16-0ubuntu0.16.04.1
Protocol version    10
Connection      Localhost via UNIX socket
UNIX socket     /var/run/mysqld/mysqld.sock
Uptime:         30 min 54 sec

Threads: 1  Questions: 12  Slow queries: 0  Opens: 115  Flush tables: 1  Open tables: 34
This means MySQL is up and running.

MariaDB Installation Steps:

  1. MariaDB offers packages for the following Linux distributions : Redhat , Debian, Cent OS, Ubuntu, Fedora,  Open SUSE.
  2. Login with root user
  3. Download the MariaDb package for Linux distribution from the site Download MARIADB.
  4. Navigate to the directory containing MariaDB package
  5. Import the GnuPG signing key with code – $sudo apt-key adv –recv-keys –keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
  6. Add MariaDB to the source List : $sudo add-apt-repository ‘deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntuprecise main’
  7. Refresh the system : sudo apt-get update
  8. Install MariaDB with the folllowing :

$sudo apt-get install mariadb-server

POST – INTSALLATION STEPS :

  1. After successful installation of MariaDB, set a root password. A fresh install will have a blank password. Enter the following to set the new password −$mysqladmin -u root password “[enter your password here]” ;Enter the following to connect to the server with your new credentials −$mysql -u root -p
    Enter password:*******

This was all about installing MySQL and MariaDB on your systems !

I hope you like this way of sharing information with all the followers and fellow friends. In our next post, we’ll be showing simple steps to install big data plugins and frameworks such as Hadoop, Apache Hive, Apache Pig, Spark and all the necessary ingredients necessary to cook data in Big data technology 🙂

—————————————————————————————————————————————–

FESTIVAL OF LIGHTS AND HAPPINESS IS HERE..!WISH YOU ALL A VERY HAPPY DIWALI AND A PROSPEROUS NEW YEAR !! STAY HAPPY AND KEEP BLOGGING. SHARES AND COMMENTS WILL BE APPRECIATED 🙂

happy-diwali-wallpapers

—————————————————————————————————————————————–

 

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s