MySQL Forums
Forum List  »  Federated Storage Engine

Using Federated engine unable to create multiple connections
Posted by: srinivas mokkarala
Date: May 16, 2006 03:44PM

Using MySql 5.0.21-max on Solaris 10. Apparently CONNECTION string is not allowing me to define more than one connection. Here is my screen shot.


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.02 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.00 sec)


Please let me know how to specify multiple connect strings in the CONNEXTION statement.

Thanks,
Srinivas



Edited 2 time(s). Last edit at 05/16/2006 03:50PM by srinivas mokkarala.

Options: ReplyQuote


Subject
Views
Written By
Posted
Using Federated engine unable to create multiple connections
4287
May 16, 2006 03:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.