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.