We will be using a DSC SurGard Central Station Receiver to accept transmitted signals from burglar and fire alarm panels. That system has a specific output format (see attached spec sheet). We need an app developed that will:
Easily install and run on CentOS 5
Listen on the TCP/IP port used by the SurGard receiver and accept properly formatted transmissions
Insert the data into a MySQL database specified by DNS name
On SQL Insertion error, insert the data into an identical table on a redundant MySQL server with a different DNS name
On successful SQL insertion, respond with a ACK back to the SurGard receiver
APPLICATION MUST NOT return ACK if the data is not successfully inserted into the primary or secondary SQL table
You will specify the fields needed based upon the attached SurGard spec sheet, and we will create them on our SQL servers (2).