Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …
Read More »MySQL-MariaDB
MySQL Schema comparison between PROD and UAT/DEV Servers
Hello Folks, Today I’ll be writing an article on how to do schema comparison of MySQL database between 2 servers(For eg. : PROD and …
Read More »Installation of MySQL Enterprise Monitor
MySQL Enterprise Monitor is a tool that register several MySQL Instances and provide complete details i.e. performance graphs and other details for analysis, Costly …
Read More »MySQL Auditing
MySQL Community Edition: MySQL Community Edition having feature of auditing but I cannot having feature filter the users To activate audit log: [crayon-66ff7809adce1291902193/] …
Read More »About SQL Server and Comparison with Other Relational Database Management Systems
SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …
Read More »MySQL Enterprise Backup
Pre-requites: Must have MySQL Enterprise Edition installed Download media file : meb-4.1.0-el6.x86_64.rpm (For Linux Platform) Installation of MySQL Enterprise Backup Command to install …
Read More »Implementation of GTID replication using MariaDB
GTID replication is a simple High Availability solution (HA) offered in MySQL and MariaDB though the implementation technique is unique but compared to MySQL …
Read More »Mysql Incremental Backup using Percona Xtrabackup
Previously i just shared the full backup script. Now we will take incremental backups using last_checkpoints. Basically, what this script will do is that …
Read More »Mysql Database Backup Using Percona Xtrabackup (Automated Bash Script)
Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-66ff7809ae6e3161280336/] –extra-lsndir: save …
Read More »MySQL updatable/Insertable views
In MySQL, views are not only query-able but also updatable. It means that you can use the INSERTor UPDATE statement to insert or update rows of the base table through the …
Read More »