Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset …
Read More »MySQL-MariaDB
MySQL master-master replication
Master-Master Replication setup Replication makes data highly available for applications and websites, master-master replication is an active-active cluster kind of solution which can be …
Read More »MySQL Basic Administration Commands
If you are beginner then this post will help you to monitor the mysql server. Here I am listing some most commonly used MySQL …
Read More »Best practice to avoid duplicate entry errors on the slave
In a Master/Slave replication data consistency is a biggest concern and is very easy to break your replication with issues such as duplicate keys, missing …
Read More »Setup a simple MySQL Master Slave Replication
– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …
Read More »How to install MySQL using RPM packages on Linux
The following article is about the installation of MySQL Server on Linux Machine(RHEL) using RPM Packages. 1) Login to the OS using the root …
Read More »How to do MySQL binary installation.
You can download the MySQL binary files from below link. https://downloads.mysql.com/archives/get/file/mysql-5.7.21-el7-x86_64.tar.gz 1:- Add OS group [crayon-673f969ff27c9563296548/] 2:- Add OS user [crayon-673f969ff27cd824849205/] 3:- …
Read More »How to build a MySQL on Linux quickly?
This article introduces how to build a MySQL on Linux quickly. This’s often used to build a temporary MySQL for testing. In short, we only need …
Read More »MariaDB Column Compression 10.3
MariaDB support different type of compression before 10.3.x . Most of them need external packages (lz4,lzo,lzma,bzip2,snappy) to be installed before using them . Default …
Read More »Concurrent MySQL client
CCQL: CCQL is a tool that allow user to connect multiple mysql server node Concurrently at the same time. It comes into picture when a …
Read More »