[FIXED] How can I interconnect a Node.js Application server and a LAMP stack?

Issue

My current web-application requires a LAMP stack and a Node.js WebSocket server to operate. Interaction between the MySQL database and the Node.js webserver is absolutely critical.

How may I have them communicate? I am likely going to host the LAMP stack and the Node.js server on different AWS instances.

Insight is much appreciated, thanks!

Solution

Nodejs has many modules that can connect with a MySQL database. node-mysql is one of the more popular ones.

Instead of using the default localhost you will need to specify the remote address of your LAMP stack.

As long as both your LAMP stack and the nodejs server are located in the same availability zone you should not have any major performance issues.

Answered By - saeed