Re: problem with a trigger

[Jean-Yves Beaujean]

My project is composed of 4 geographic sites. The main contains a users table. When a user is created, his profile is located on the main server but his datas will be in one of the three others. However, some data from user profile (such as login or password ) are necessary in the secondary server. I use the FEDERATED tables like that :

MAIN DB .................................... DB 1..................... DB2..................DB3
================================================================
user
user_r_1 -------FEDERATED -----> users
user_r_2 -------FEDERATED -------------------> users
user_r_3 -------FEDERATED -------------------------------> users
servers
id
table_name -> ( contains user_r_1 or user_r_2 )

On the users table, I've created a trigger AFTER INSERT. When it runs, I know only the SERVER_id. With it, I select the table_name in the servers table. When I've the tabe_name, I would like to insert datas in the table.

I hope that you understand what I want to say ( My English is not very good)