Mysql

How to Install MySQL 8.0 on Ubuntu 18.04

install mysql ubuntu

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 and [...]

Jamie Arthur 5:34 am

How to Add MySQL Monitoring on Zabbix 3.2

zabbix mysql monitoring

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 [...]

Pavlo Maiorchyk 4:53 am

How to Add Percona MySQL Monitoring on Cacti

percona template 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 [...]

Pavlo Maiorchyk 2:00 am

How to Completely Remove Mysql and Install MariaDB 10

mariadb remove mysql

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 [...]

Alain Francois 2:00 am

Mycli - Command Line Autocomplete Tool for MySQL with Syntax Highlighting

mysql autocomplete tool

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 [...]

Dwijadas Dey 7:13 am

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 [...]

Mohamed Ez Ez 3:00 am

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 [...]

Linoxide 3:00 am

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 [...]

Mihajlo Milenovic 3:00 am