Real time synchronization of two web applications is required. The scenario is that there is an E-commerce website which will display a super market products on its website plus E-commerce website has its own products too.
The super market's inventory management system will be in real time sync with E-commerce website. New Products, price and quantity change on super market's inventory management system will be reflected in the E-commerce website in real time.
The E-commerce website will automatically notify the super market on new orders generated.
How do I implement this system? The E-commerce website has MySQL database