MySQL-MariaDB

  Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …

  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 …

  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 …

  MySQL Community Edition: MySQL Community Edition having feature of auditing but I cannot having feature  filter the users To activate audit log: [crayon-6aa52e07b56d4371549767/]   …

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 …

  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 …

  GTID replication is a simple High Availability solution (HA) offered in MySQL and MariaDB though the implementation technique is unique but compared to MySQL …

  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 …

  Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-6aa52e07b6043583953297/]   –extra-lsndir:  save …

  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 …