Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

asked on

Considerations PHP using multiple locations

We have an apps in php and wants EE opinion in what to consider when using db from different locations.  What is the best practice?
SOLUTION
Avatar of Nicholas
Nicholas

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

We have an apps in php and its db located in the same site using mysql; say www.domian1.com.  What we want is to point the said apps to another db location address, not where the apps is located.  For example, the apps is location in www.domain1.com and database is location in www.domain2.com.  What should we consider in order to make this work?
SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That is a rather technical question.

Just to help us understand right I drew the setup that I think im reading from your text.
User generated image
Is this right?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Great info guys!

As for the image of the logic flow, yes, your in the right track Chris (see your pix below):

User generated image
As for the interface program in PHP, makes great sense - "... will allow you to implement security measures in your app and the interface program to prevent people from breaking into your database."

This last one we would like some links to read on for internalizing this portion of the project.

Thanx lots!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Ok.  Briefed the link but didn't find actual related topic, but will go over it in detail to see.