Category: Databases

Using mysqldump

1) Is mysqldump text backup or binary backup It is a text backup . If you open the backup file you will see all the statements that can be used to recreate databases and objects …

Percona xtrabackup tool

Percona XtraBackup is an open source, free MySQL  hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups that complete quickly and reliably …

Percona XtraDB Cluster 5.6 in 3 nodes

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel …