We all know the purpose of the uptime command in Linux. This is used to check the uptime of the Linux system and how long the system runs without restarting. The Linux admin job...
MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.This will help us to write queries faster and easy which was written in Python prompt_toolkit. The REPL (Read,...
There are no changes in table or index formats on MariaDB 5.5, MariaDB 10.0 & MariaDB 10.1. So, most of the servers the upgrade should be painless from MariaDB 5.5 to MariaDB 10.0 &...
MariaDB is a drop-in replacement for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB is a logical choice for database professionals looking for a robust, scalable, and...
MariaDB is a drop-in replacement for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB is a logical choice for database professionals looking for a robust, scalable, and...
MySQL master-slave replication is a process that automatically copies data from one MySQL database server (master) to one or more MySQL database servers (slaves). MySQL supports various replication methods, but Master-Slave is the best...
There are many ways that we can connect the remote MySQL/MariaDB database. You can use the GUI client called MySQL Workbench. Alternatively, we can access it right from Linux terminal. It’s very simple but...
Some times we may forget MySQL/MariaDB root user password. It’s happening everywhere. It’s human mistake and it known things. It’s happening for everyone and not only for me. If so, how to reset the...
A simple shell script can automate Linux admin job, which will reduce the human effort and save lots of time. As a server administrator you should take a regular backups of your databases. It...
MySQL/MariaDB is an opensource database management software, which is very famous, user friendly and widely used for data storage. This will allow the user to create a database, database user, grant different permission based...
