The Arcive of Official vBulletin Modifications Site.

MYSQL database to a separate server · **Released**: 12-03-2006

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

UltimateOreo! · #2 12-04-2006, 04:11 AM

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

Kihon Kata · #3 12-04-2006, 04:23 AM

Quote:

Originally Posted by UltimateOreo!

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

Dismounted · #4 12-04-2006, 04:24 AM

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

jason|xoxide · #5 12-04-2006, 08:28 PM

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.

Ntfu2 · #6 12-12-2006, 09:35 PM

Quote:

Originally Posted by UltimateOreo!

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

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.

Kihon Kata · #7 12-12-2006, 10:38 PM

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.

Ntfu2 · #8 12-13-2006, 04:54 PM

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:

Kihon Kata · #9 12-13-2006, 06:33 PM

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

Quote:

Originally Posted by Ntfu2

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:

Ntfu2 · #10 12-13-2006, 08:14 PM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04497 seconds Memory Usage 2,283KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!