Bug #36919 Backup: Ability to choose Backup drivers
Submitted: 23 May 2008 15:10 Modified: 11 Oct 2010 12:15
Reporter: Hema Sridharan Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:mysql-6.0-backup OS:Linux
Assigned to: Thava Alagu CPU Architecture:Any

[23 May 2008 15:10] Hema Sridharan
Description:
According to the current design, user does not have the privilege or option to choose drivers for the specific engines.
 There are three drivers Native Driver (supports only Myisam engine and very fast compared to other drivers), CS driver (Innodb and Falcon, better than default driver), default drivers (Supports all engines if they are not supported by Native and CS drivers)

The user should be able to choose the drivers depending on the usability and requirement. 
For example: For some reason, if user feels that he does not require CS driver for Innodb and wants to go for blocking driver, he/she should have the option to do such changes.

How to repeat:
One can check the type of driver used for Backup by using Online Backup table,
SELECT * FROM mysql.online_backup\G

mysql> create database x;
Query OK, 1 row affected (0.00 sec)

mysql> use x;
Database changed
mysql> create table t1(id int)engine=falcon;
Query OK, 0 rows affected (0.08 sec)

mysql> insert into t1 values(1),(2);
Query OK, 2 rows affected (0.02 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> backup database x to '/tmp/x';
+-----------+
| backup_id |
+-----------+
| 1         |
+-----------+
1 row in set (0.04 sec)

mysql> select * from mysql.online_backup\G
*************************** 1. row ***************************
          backup_id: 1
         process_id: 0
         binlog_pos: 0
        binlog_file: NULL
       backup_state: complete
          operation: backup
          error_num: 0
        num_objects: 1
        total_bytes: 12
validity_point_time: 2008-05-23 15:05:38
         start_time: 2008-05-23 15:05:38
          stop_time: 2008-05-23 15:05:38
host_or_server_name: localhost
           username: root
        backup_file: /tmp/x
       user_comment:
            command: backup database x to '/tmp/x'
            engines: Snapshot
1 row in set (0.00 sec)

From the above table, we notice that Consistent Snapshot driver is used for backup of database that has Falcon storage engine.Instead user should have option to select the drivers for specific engine type.
[23 May 2008 15:22] MySQL Verification Team
Thank you for the bug report.
[2 Feb 2009 12:45] Rafal Somla
It is not planned to have options for selecting backup drivers in the first release of online backup (in 6.0 server).
[2 Feb 2009 16:02] Hema Sridharan
Changing the status to verified as this defect is feature request for 6.x