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.
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 :
- 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.
- 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 :
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
- Install MySQL server using command : $mysql-server
- Run script :
- sudo apt-get update
- sudo apt-get install mysql-server
- Test MySQL connection :
systemctl status mysql.service
- You will see the following 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
- Then use this command to start:
mysqladmin -p -u root version
You should see output like this:
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:
- MariaDB offers packages for the following Linux distributions : Redhat , Debian, Cent OS, Ubuntu, Fedora, Open SUSE.
- Login with root user
- Download the MariaDb package for Linux distribution from the site Download MARIADB.
- Navigate to the directory containing MariaDB package
- Import the GnuPG signing key with code – $sudo apt-key adv –recv-keys –keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
- Add MariaDB to the source List : $sudo add-apt-repository ‘deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntuprecise main’
- Refresh the system : sudo apt-get update
- Install MariaDB with the folllowing :
$sudo apt-get install mariadb-server
POST – INTSALLATION STEPS :
- 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
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 🙂