Internal/External Datbase question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
chopper_pc
Forum Newbie
Posts: 15
Joined: Fri May 30, 2008 10:55 pm

Internal/External Datbase question

Post by chopper_pc »

I have an internal "intranet" web application that runs off of LAMP.
I now need to set up a public web application that can acces (read/write) to the same database. I have a spare ip address I want to set up a standalone server for this.
For security purposed the external server will host it's own databas as I cannot allow external connections to my internal server.
Any suggestions of how to securly allow each server to share information between them without allowing the extenal acces to the intenal such as ssh into the external and execute commands. If so how would I script them PHP/Perl?
Or is there an mysql funtion(s) that will allow this. I do not want to open any ports to my internal network but for it to do all the work of merging certain records from an outgoing connection.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Internal/External Datbase question

Post by jaoudestudios »

I think the mysql databases can communicate with each other. Similar to trigger. But one of them will need to be the master and one the slave, otherwise conflicts will not be resolved.
Post Reply