Xtrabackup is the most widely open source hot backup tool for MySQL. Xtrabackup support InnoDB and MyISAM engines.It supports both MySQL Server , Percona Server and MariaDB. This presentation covers some of the important features in Xtrabackup. Pic Courtesy : https://www.flickr.com/photos/robbiewendt/8108744459/ Advertisements
Open Source India (OSI) is the premier Open Source conference in Asia targeted at nurturing and promoting the Open Source ecosystem in the subcontinent. Started as Linux Asia in 2004, OSI has been at the helm of bringing together the Open Source industry and the community since its inception. The objective of OSI is to convince … More Mydbops Delighted to be part of Open Source India -2017
In this post, we are going to see how we can backup encrypted tables using Xtrabackup. InnoDB supports data encryption for InnoDB tables stored in file per table tablespaces. For the application to access encrypted tablespace, InnoDB will use master encryption key to decrypt the tablespace key. The master encryption key is stored … More Xtrabackup for handling Encrypted Tablespace
In this blog we are going to explore about innodb tablespace encryption technique, which will be useful for securing data. In MySQL 5.7, a new feature “Innodb Tablespace Encryption“has been added to protect the data at rest. This is a most awaited feature in security. This encryption supports all file per table tablespaces and it … More MySQL Tablespace Encryption ( TDE )
Optimiser is the brain of the RDBMS. Optimiser decides the right access method , algorithms , join order and right index to be used for better execution of the query. This blog is made to shed some lights on Cost based optimiser in MySQL 5.7. The cost or statistics are stored in the data dictionary … More Cost-based Optimization in MySQL 5.7
In this blog we are going to share my recent experience with an issue which we faced during migration between two Ubuntu servers. The activity was pretty simple, the client had bought a new machine with enhanced memory and faster disk, so the data has to be transferred to the new server and live MySQL replication … More InnoDB and Linux mount point.
We had faced a weird error for one of our client under Emergency MySQL Support, it was a slave server. Client stated that whenever he tries to Start the replication it goes of loop of restarts. We had a sharing session with the client, At first we intended to rebuild the slave with a fresh … More InnoDB ‘Linux aio’ returned OS error 0. Cannot continue operation.
TokuDB is a high compression Engine for MySQL. It uses Fractal tree pages and huge data pages to achieve the The Percona TokuBackup library intercepts system calls that write files and duplicates the writes on backup files. It does this while copying files to the backup directory. The TokuBackup library must be installed into the mysqld … More TokuDB hot Backup and Recovery.
Introduction: Password is be like the words, numbers and string of characters. On database and server side, the username and password were should needed for certain access. The password should be structured and security based. In this section we are going to take a elaborate view on validate_password plugin in MySQL. We have seen about … More Security: MySQL Password Validation Plugin
MySQL Enterprise Backup (MEB) is a high performance hot backup tool. It is a stable tool and evolved with changes in IT industry. The recent versions has support to direct cloud backup in S3. It is an enterprise backup tool from Oracle MySQL and integrated quite well with MEM ( MySQL Enterprise Monitor ). This … More MySQL Enterprise Backup ( MEB)