MYSQL database to a separate server
 

How hard is it to move one's MYSQL database to a separate server?

I am interested in doing this:

1 separate server everything else connected to the db
1 separate server Mysql databases

Any thoughts and/or help files on how this could help a server with slow loading times and higher than normal loads.

Thanks in advance

i highly doubt you can without some heavy code editing. I dont think its even possible.

LOL, really? This forum that you are on right now, runs a separate DB server ;)

HELLO?? :P

You just need to transfer the database to the new server, then change the DB access details in config.php to reflect the changes.

As was already said, it's pretty easy. Just use mysqldump to backup the DB from the first server, use FTP or scp to transfer it to your new server, and then restore it. Make sure that when you create your new mysql user that you give it the ability to connect from a remote server, otherwise your board won't work.

I dont think i'd post much more unless you know what you're talking about.

Its simple. All you have to do is.

1. Get MySQL server and make sure to install MySQL on it.
2. Shut your forum off.
3. Backup your database
4. Move your back up to new host
5. restore it. Give it a db user and the correct permissions
6. edit /includes/config.php and enter the IP address where it says localhost

If you use this configuration, you should check with your hosting company to make sure you get free private bandwidth. It consumes boatloads of bandwidth and will rackup your bill if you don't get free private bandwidth.

Thanks Ntfu and others. I own the servers so, I would have to check with myself LOL.

Anyhow, I fixed my issue for now. I was running the wrong kernel and it wasn't loading up to run on both my processors. But now it is :)

Thanks and I may still do this soon.

Your welcome.

Its a huge performance increase when its done right. I've got it running like this on one of my sites and its awesome :yesway:

Oh ok. Which server would need to be beefier? The DB or the HTTP server?

DB server.

I have mine with 4GB of ram 73SCSI drives in Raid 1+0 with a low end AMD for processor power and it handles quite a few requests just fine :). loads never above 1 on that machine