Connecting to more Database

[rashmiks]

Hi ,

We have 10 web sites running and having 10 database stored in same server .
i need to check in all the 10 database that particular id has repated .
if it is repated i should not allow the user the create that id .

as it is we have 100k qry hitting the database per minute .. so have some performace issues .

if i write code to connect all the database is same file . will there be any performance issue .

or is there any other method to do that ...

[sashi]

Hi ,

We have 10 web sites running and having 10 database stored in same server .
i need to check in all the 10 database that particular id has repated .
if it is repated i should not allow the user the create that id .

as it is we have 100k qry hitting the database per minute .. so have some performace issues .

if i write code to connect all the database is same file . will there be any performance issue .

or is there any other method to do that ...

Hi there,

Instead of checking for the particular id in each database, why not let trigger to the work. Yeah, there will be some performance issue since your code will intend to connect to all the 10 databases simultaneously.

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

MySQL Trigger