Quote:
Originally posted by icedemon
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.
|
So, you're saying instead of setting user to localhost in mysql, you would set it to IP or nameserver name of server?
"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."
Actually, I think it is very possbile to get 500K to 1million simultaneous users within a few minutes. That is why I meantioned howard stern. If he gives out name of site, people near computers go to that site right away. They probably aren't going to wait till end of day.
As you meantioned, 500K users a day might not be a problem if it is spread throughout day. All at once, though and CPU will prob get maxed out regardless of amount of bandwidth.
I've played around with Round Robin for dns in past. Someone meantioned that as option, but that seems not as good to me as load balancer server. Problem with load balancer seems that it is going to be hit hard with all the traffic and have to forward it to servers. It seems like it might be hard for load balancer to stay up under all of this traffic.