Multiple hostnames in the config.php for load balancing / round robin

[SnapOff Racing]

Originally Posted by Dismounted

That's difficult to achieve due to the current internal design of vBulletin. It assumes that only one server exists, and this is merely a hacked-up way of getting around that. A solution would be to comment out that server's IP in config.php whenever you take it offline.

Ahhh that makes sense, I suppose that would work then. I was also just thinking of creating a new domain specifically for the MySQL database and then just put that one single domain in the config.php then use DNS to round robin the IP Addresses.

But so the script you provided should work just fine with all the connections working then correct? vBulletin will then round robin all of the addresses that I put in that array correct?

Originally Posted by Angel-Wings

Thanks for ignoring me but still mysqlproxy can do exactly what you're looking for

Sorry but your post wasn't really all that specific on how this could help my situation. You simply just said I should read the MySQL documentation but didn't specify what exactly I should be looking for. Hence the reason for my paying attention to Dismounted's posts as he has given me something to work with