Description:
MySQL-Max 5.0.21 doesn't support multiple connect strings in the CONNECTION statement for a table using FEDERATED engine. This is a very desirable feature.
At present, only the last CONNECTION statement is effective.
How to repeat:
mysql> create table dellater_niagara (id int(4)) ENGINE=FEDERATED
-> CONNECTION='mysql://mokkarala:mokkarala_123@ottawa/mokkarala/dellater_ottawa'
-> CONNECTION='mysql://mokkarala:mokkarala_123@zazu/mokkarala/dellater_zazu';
Query OK, 0 rows affected (0.03 sec)
mysql> show create table dellater_niagara;
+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dellater_niagara | CREATE TABLE `dellater_niagara` (
`id` int(4) default NULL
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://mokkarala:mokkarala_123@zazu/mokkarala/dellater_zazu' |
+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
Suggested fix:
Please provide a workaround to use multiple connect strings within the CONNECTION statement.
Description: MySQL-Max 5.0.21 doesn't support multiple connect strings in the CONNECTION statement for a table using FEDERATED engine. This is a very desirable feature. At present, only the last CONNECTION statement is effective. How to repeat: mysql> create table dellater_niagara (id int(4)) ENGINE=FEDERATED -> CONNECTION='mysql://mokkarala:mokkarala_123@ottawa/mokkarala/dellater_ottawa' -> CONNECTION='mysql://mokkarala:mokkarala_123@zazu/mokkarala/dellater_zazu'; Query OK, 0 rows affected (0.03 sec) mysql> show create table dellater_niagara; +------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | dellater_niagara | CREATE TABLE `dellater_niagara` ( `id` int(4) default NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://mokkarala:mokkarala_123@zazu/mokkarala/dellater_zazu' | +------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) Suggested fix: Please provide a workaround to use multiple connect strings within the CONNECTION statement.