Root conf is a community and conference on DevOps and cloud infrastructure. Root conf is one of the India's well known conference on DevOPS and IT infrastructure. It is organised by Hasgeek. This year (2018) it is scheduled at 10-May & 11-May Mydbops is one of the Exhibition Sponsor along with companies like MySQL , … Continue reading Mydbops Delighted to be part of Root Conf 2018
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/
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 … Continue reading 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 … Continue reading 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 … Continue reading 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 … Continue reading 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 … Continue reading 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 … Continue reading 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 … Continue reading 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 … Continue reading Security: MySQL Password Validation Plugin