How to access a remote stored procedure from local database?

Dear Experts,

I came across an issue pertaining to stored procedure in mysql database. I have two offices which both of them are running on mysql. I've created a store procedure named 'UPD_INVENTORY' on mysql server#1. Currently, I am working at an office that has mysql server#2. If I wish to use the 'UPD_INVENTORY' stored procedure on mysql server#1, is there a way that I can make a stored procedure call on mysql server#1 from mysql server#2? Does such syntax exists like this:
CALL server#1location.db_name.procedure_name ? If not what other options do I have besides using php? Will I able to use bash script in linux to accomplish such a task?

Thanks.
Kinderly WadeprogrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

COBOLdinosaurCommented:
You should be able to use FEDERATED tables; though I have never tried to use a stored procedure that way.  Once you have a connect with federated tables you should be able to access just as if the table is local. However you may find you pay a big performance penalty.

The manual description for federated tables is here:

http://dev.mysql.com/doc/refman/5.0/en/federated-use.html

Cd&
0
Kinderly WadeprogrammerAuthor Commented:
Thanks COBOL for the feedback.

I've tried with FEDERATED tables.

Is it possible that I can make a call to a store procedure that's located on a remote mysql DB?
If possible, how can this be achieved?
0
COBOLdinosaurCommented:
Well if it won't let you run the stored procedure with a remote connection, then you will need to have a script on server #1 to run the stored procedure and return the data. Though I would have thought that the remote connection should be enough unless there is a security or permissions issue.

Cd&
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.