MySQL-MariaDB

Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the maximal QPS(Query Per Second), concurrent …

  Numeric data type SAP IQ – supports up to (126, 38) MySQL/memSQL – support up to 65 digits; https://docs.memsql.com/sql-reference/v6.5/datatypes/ ISNULL vs IFNULL SAP IQ …

  Percona XtraDB Cluster is a active/active database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability …

  As a Database Administrator, Monitoring of database is the most important part. As all we know Prevention is better than cure, So. I am …

  The Percona Toolkit contains many tools for MySQL. Usually, we use the pt-archive to archive our data. Pt-archive can archive the table data to …

  Steps to Install & Configure MySQL 3-Node Galera Cluster on CENTOS Step 1: Enabling the Galera Cluster yum repositories. [crayon-67eee68c81ae6320340622/]   Step 2: Install …

  Percona Xtrabackup is  open source  backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing …

  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 …

  Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly) [crayon-67eee68c82458546128715/] Hope this …