I'm probably Overthinking my problem but I'm trying to learn anyways.
Intro: I'm running 2 servers (Development & Live)
Live Server is Running Ubuntu Linux 11
Development Server is Running Ubuntu Linux 12
Both are running on converted Windows Boxes, but are servicing less than 100 clients.
The server running MySQL for the Database, Apache for Web Services (Primarily used via SOAP & WSDL to custom C# .NET Applications)
Right now any changes in the database have to be polled for, with our user count it's not a real issue (each active user might send a SOAP Request every 500ms for a Check of Timestamps of the tables)
Now what I want to do is Configure this as a PUSH Server. So when there are any changes, the Ubuntu server will PUSH out a notification to all active users that the Data has been updated. I'm hoping to have this work both on the local network and to any offsite clients.
We're also looking at adding an Android Application to subscribe to the PUSH Server for notifications of data changes.
1) Can Apache be configured as a PUSH Server (If so, how?)
2) If not, do I need something like Meteor (and can I install that in parallel with Apache?)