I want to clear one my doubt.Currently I am working on one php-codeigniter project and there I need to display feeds/comments for authenticated users. So here is my architecture:
So I just want to clarify is it a good architecture to display feeds/comments on your home page or any changes could be done to make it more better?
Depending on the amount of traffic your site may get, you may want to use a NoSQL database like MongoDB which you can access both from PHP and Node.js.
For simple text data (like comments), you may not necessarily need a relational database like MySQL.
You may have to write your own library wrapper around PHP's MongoDB driver/functionality, but that is doable.
As long as you have a single database for persisting the feed/comment data, you will not have any issues with inconsistencies.
Sounds like a fun project!