All Servers, MySQL Change

[Corey]

I have just purchased another server. This server's starting out main function will be to handle only MySQL. By offloading MySQL from the free servers to a centralized server will free up a lot of CPU power on all the current servers. We decided this was the best move for now and will benefit EVERYONE.

After we get this setup we hope to also move the mail server over which will also greatly reduce the load and make it much easier for us to maintain.

This server will be online today. We haven't decided which server will go first but we will have to bring down MySQL to copy the databases over to the new server and switch the connections. There should be minimum if any work for the end user. We'll update in the news and here as we get more information.


New Server Specs:
4x2.4 Ghz
4 Gigs Memory
1x73GB 15K Raptor HDD
1x250GIG SATAII

[Archkronos]

Will I have to change the server setting in a connection script, so it doesn't use localhost?

[Corey]

We are going to forward port 3306 to the new server via iptables. I would guess that it would be a few milliseconds faster if you put in the address of the server instead of iptables forwarding. We will release the connection details of the new database server when we start moving the databases over. But all scripts will continue to work.

The new server is on the same network and has an internal connection to the other servers so each request does not have to go out to the internet and come back.

-Corey

[Jamesy]

So I won't have to reinstall programs using MySQL after you move it?

[FootballG]

Great idea! Can't wait to see the performance boost!

[Christopher]

So I won't have to reinstall programs using MySQL after you move it?

You will not have to.

Does this include the paid servers?

[Xemnas]

We will release the connection details of the new database server when we start moving the databases over. But all scripts will continue to work.

Will this include the server's MySQL directories? I'm asking because I have a game I'm working on, and I want to be able to use one of my databases as a game account DB, but I need to get the location of mysql.sock to get it working (I'm using the MySQL Connector/Net Visual Studio extension), not so I can hack

[online87]

What sort of performance boost willl we be seeing?

Also - I sincerely hope this solves the consistently high server loads (on stoli at least, dunno bout the others).

Good job guys keep it up.

PS: YAY http on stoli :D (bit sluggish tho...)

Peace.

[ramj1]

YAY for the switch; this ought to be good.

[phoenix mystic]

I take it this is the reason as to why I'm unable to connect to my site? (http://tollesbpa.exofire.net)