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.
Internal/External Datbase question
Moderator: General Moderators
- chopper_pc
- Forum Newbie
- Posts: 15
- Joined: Fri May 30, 2008 10:55 pm
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Internal/External Datbase question
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.