Tag Archives: MySQL

  Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this …

  Below is the simple script for monitoring & auditing mysql general logs.This can be set as per the need(eg. daily,horly).It will help in capturing …

  Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset …

  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 …

  If you are beginner then this post will help you to monitor the mysql server. Here I am listing some most commonly used MySQL …

– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …

  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-67444a2b2d161471911031/]   2:- Add OS user [crayon-67444a2b2d166885829098/]   3:- …

This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …

  pt-online-schema-change is a binary part of Percona-toolkit packages by Percona. It’s one of the most stable and efficient, tools for performing large MySQL table structure change in …

  Do the operating systems kill your MySQL instances from time to time? Are some database servers swapping constantly? These are relatively common problems. Why? …