[Amenadiel]

Originally Posted by AWS

Set up master/slave.
Why would you use 3 servers for http and only one for mysql when mysql will need multiple servers before http will?

AWS, I'm replicating my vb database with master/slave, but the user I made to allow vbulletin to access slave db doesn't appear in the processes of the slave machine.

I understand that I should change the dbtype to mysql_slave on config.php, but where? there isn't a field for that purpose.

--------------- Added [DATE]1204000231[/DATE] at [TIME]1204000231[/TIME] ---------------

Update: if I set the dbtype in config.php as mysqli_slave or mysql_slave, a few connections spawn on the slave machine, but they stay as "unauthenticated user" just keep trying to login, while my webserver just hangs up.

--------------- Added [DATE]1204001092[/DATE] at [TIME]1204001092[/TIME] ---------------

New update: after giving the slavedb user global select privileges (not just for the vb slave database) and using mysql_slave instead of mysqli_slave, it works.