MySQL is arguably one of the leading and widely used opensource database management systems. It's the preferred relational database management system of choice in most web hosting companies and other cloud providers. In this tutorial, we will look at how [...]
Mysql
How to Install MySQL 8.0 on Ubuntu 18.04
In this brief tutorial, we'll look at how you can install MySQL 8.0 on Ubuntu 18.04. MySQL is a free and opensource cross platform database server that is used on many opensource projects and high availability systems such as LAMP [...]
How to Add MySQL Monitoring on Zabbix 3.2
In this article, I will show how to add MySQL database monitoring on Zabbix. I have two Ubuntu Server 16.04 virtual machines. The first one has installed Zabbix Server 3.2 and the second VM has MySQL 5.7 database that should be [...]
How to Add Percona MySQL Monitoring on Cacti
In this article, I am going to show how to use cacti monitoring for MySQL. For test purposes, I will use Ubuntu 16.04 with cacti 0.8.8f and MySQL 5.6 installed. If you don't have anything installed refer to our setup cacti [...]
How to Completely Remove Mysql and Install MariaDB 10
We have some popular database tools which are independent and commonly used. Normally you can use two different relational database management system (RDBMS) on the same server if they don't use the same port but it is not advised if you [...]
How to Install and Use Mycli on Linux
MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. The auto-completion will help you write queries faster and with ease. The REPL (Read, Eval, Print, Loop) will pop up a suggestion menu as [...]
How to Setup Mysql Service with Kubernetes
In this article we are going to follow our series of article about kubernetes (k8s) ecosystem. In the current article we are going to look at the persistent part with k8s mainly, how to setup and get mysql up and [...]
How to Import Data from MySQL to HDFS Using Sqoop
Apache Sqoop is a tool in Hadoop ecosystem which is used to import/export data between RDBMS and HDFS. This data is in structured format and has a schema. There are multiple cases where you want to analyze some data in [...]
Setup Hot Backups of MySQL with Percona Xtrabackup on Ubuntu
When backing up a database, you generally don't want to stop the database. Because if you stop it, your application will become unavailable. But if you do not stop it, your backup might end up inconsistent and useless, due to [...]
How to Backup MySQL Database using Bash Script
Regular backup of mysql databases is also as important as backing up your code. So I wrote this script to backup all of my databases on the local disk. I then added gzip to compress the sql file to save [...]
Shell Script to Backup All MySql Databases
In this tutorial, I will show how to write a shell script to backup all your mysql databases. Its very essential to take database backup in timely manner. The shell script will create dump of all databases from mysql server [...]