Hello,
Can anybody tell me if I can use the WordPress MU with an external MySQL DB?!
If yes, can you please tell me how i should configure the DB config file to point to an example DB?
Hello,
Can anybody tell me if I can use the WordPress MU with an external MySQL DB?!
If yes, can you please tell me how i should configure the DB config file to point to an example DB?
If you mean a database on another host then just change "host" bit of the db config from "localhost" to the IP of the remote host.
doesnt that affect performance? wouldnt it beasier to install mu local to the DB and admin it remotely?
It depends actually. If you only have a few thousand blogs then it's best to have the db on the same server. However, if you have 40K+ then you really need to have the database(s) on a separate machine.
Thank you for your help andrewbillits, that is what i was asking for, to host the DB in another host.
I was wondering if you could give me a sample of the config file in the following lines. I would appreciate that a lot and i am thanking you in advance :)
define('DB_HOST', 'localhost');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
define('VHOST', 'VHOSTSETTING');
$base = 'BASE';
You need to configure the remote DB host to accept logons from a non-local user.
Then you change the db_host to the hostname of the machine hosting the DB.
like this:
define('DB_HOST', '100.100.100.100');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
define('VHOST', 'VHOSTSETTING');
$base = 'BASE';
thank you all for your helpful replies.
srry, one more question. should i also include the port number in the ip?!
You shouldn't - assuming you are using the default port.
thanks a lot SteveAtty, you have been rly helpful.