linux app to accept data from DSC SurGard II, then insert into MySQL table

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).