Background:
Prior to version 3.10, MySQL Enterprise Backup (MEB) used zlib compression for in-memory compression of datafiles. The compression worked by splitting the innodb datafiles into fixed size blocks and compressing each block independently.After searching on the web we found there are many compression algorithms available which can be used for compression. This triggered the idea of testing the performance of available compression algorithms. If the benchmark shows improved performance we can make backup and/or restore faster by adding the new compression algorithm to MEB.
Implementation :
The idea to implement the algorithms procceded as follows .
1. Select a "long list" of algorithms based on literature and
what Google and other databases are using.
2. Create a prototype of MEB supporting the algorithms in the
long list.
3. Run comparison tests of algorithms with the MEB …