|
To get connect to mysql from mulitple servers, you just need to setup the host table and a user in the user table to accept a user from a different host. My concern would be if mysql as the best choice for a ton of connections.
Your not going to get millions of connections at once. Maybe over the period of one day. I have had 500,000 unique visitors in one day on one dedicated server with no problems.
If your running a alot of programs that are going to hog resources when visitors visit your site, then you might want to look into load balancing. If it's mainly going to be static webpage with mysql and some programs being used now and then. Then just one dedicated server should do it for you. Just setup the OS, webserver, mysql and what ever else as optimised as possiable.
|