Switch from Linode 80GB to dedicated server

Portal Home > Knowledgebase > Articles Database > Switch from Linode 80GB to dedicated server

Posted by arya6000, 02-24-2017, 02:44 AM
Currently I am hosting a database server on a Linode 80GB plan, but I need more computing power. I am considering the following from Liquidweb Intel Dual Xeon E5-2680 v4 14 Cores Up to 3.3 GHz per Core 128GB DDR4 SDRAM 1TB SSD My Linode has 20 cpu cores, the CPU Linode uses is Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz From what the specs look like, I should be able to at increase my CPU power by 50% since it's not shared and the processor of the dedicated server is more powerful. I'd like to hear what you guys think about this upgrade. Would I notice a big difference worth my time to move my database over?
Posted by madRoosterTony, 02-24-2017, 12:45 PM
What database server are you using? MySQL / MariaDB is highly known for as it runs out of RAM, CPU use will spike and spike fast. What is your current RAM allocation? If you are not on SSD, having the SSD drive will help as well. Also it appears you do not need 1TB of disk space, I would consider RAID10 4 x 128GB SSD as the speed increase you would get will help your performance greatly. If you are using MS SQL then feed it as much CPU as you can as well as disk IO. Not saying skimp on RAM, but the coding between the two is different enough that I would make different recommendations
Posted by arya6000, 02-24-2017, 12:56 PM
I am using Postgresql, I have modified the postgresql.conf to allocate almost all the ram available.
Posted by madRoosterTony, 02-24-2017, 01:15 PM
Postgresql is not as bad as spiking the CPU usage as it runs out of ram, but it still will. We have found that giving Postgresql faster Disk IO and dedicated SWAP / cache drive speeds things up nicely. So I still would recommend multiple drives, still go with 4 x 128GB, but do two RAID1 setups. 1st - OS, SWAP, Cache, 2nd - Database. With as much ram as you can afford. Also in your case having more cores will always be beneficial, even if they are lower speed. For example stepping up to the E5-2683 v4 with 16 Cores each would be more beneficial to you. But you probally will need to reach out to some companies for pricing as this is not a standard CPU that would be advertised.
Posted by arya6000, 02-24-2017, 01:41 PM
I just checked how much free memoery I have on my system by running free -m The system is not running out of memory.
Posted by madRoosterTony, 02-24-2017, 01:48 PM
I would suggest your free memory during a CPU spike and see if you are getting different results? Postgre is fairly good about releasing memory. Also have you tweaked Parallel Query Execution based on your system?