We have an existing email marketing software in PHP. Now, we are going to setup Web Server, Database Server, Multiple Email Server 1 - 10
Two things we need to settle:
1st: Our edm software script need to be installed in web server using database server then distribute all emails evenly via Email Server 1 to 10 - means 1st email will go to email server 1 and 2nd email will go to email server 2, and so on...
2nd: Our MySQL database is having only 1 table for "member". If we import 10 emails in List1, then follow by 100 emails to List2, all 110 emails will be added to same "member" table. So, we need to have multiple table for List1 and List2, etc... rather than all dumped into only 1 single "member" table. When our user create a new mail list in our software, then MySQL will automatically create new a table for new mail list.
Reason why is, our software will take a very high load (memory usage) to read whole database even if you just send to a small mail list. By separating the mail list to different table, our software will only read selected table only.
Anyone can help?