I got couple questions about database application design and installation.
I need to develop an application using PHP+MySQL+Oracle. PHP+MySQL are on server A with apache 2, Oracle is on server B, and all of them have been installed and working properly. Oracle will be holding big chunk of raw data, and any updates or insertion to Oracle should be also apply to MySQL.
My question is that is there any way we can make Oracle itself directly 'talk' to MySQL? (Oracle automatically inserts any update it gets to MySQL; will trigger work?) Or I have to write a script in PHP to do this.
Also, I know I have to recompile PHP to enable Oracle API, but do I have to install oracle client on server A since Oracle is on server B? and anything else I need to do? I'm looking for an installation plan with minimum server down-time.
Thank you very much for any input.
PHP + MySQL + Oracle System Design and Installation Issues
Moderator: General Moderators