I’ve a local subscriber database with about 2million records, I will connect to 4 remote servers with a TPS of 5 on each. These servers contain real time subscriber data usage. I need to monitor subscriber data usage and notify them when the usage reaches a certain threshold. Below is how I plan to execute this task.
- Create 20 worker processes using poolboy and maintain a MINT connection in these processes
- A process to fetch the records from the database (more processes to fetch records asynchronously)
- Send the records across to worker processes.
Kindly advise if this is the most efficient way to implement the notification server.