Currently using Amazon RDS for MySQL. Which dedicated server should I go for ?

Portal Home > Knowledgebase > Articles Database > Currently using Amazon RDS for MySQL. Which dedicated server should I go for ?

Posted by neeraga2, 02-19-2017, 06:11 AM
I am currently using Amazon RDS for mysql but it is getting very expensive for me. I am currently using this RDS config. db.m4.xlarge vCPU: 4 ECU: 13 Memory (GB): 16 EBS Optimized: 750 Mbps Network Performance: High I have 2000 Provisioned IOPS which cost me $200 extra. I don't understand how much IOPS will the dedicated server will support ? What would be the equivalent dedicated server config ? I am looking for Vultr $120 server. Will it be ok ? https://www.vultr.com/pricing/dedicatedcloud/
Posted by HRR--, 02-19-2017, 07:09 AM
IOPS will depend on your drives configuration. For better performance you might want to go bare metal. Is cheaper. Unless you need to upgrade and downgrade frequently. You can get an E3 with 2 SSD's and 16-32GB RAM nowadays for under 150 a month. However based on Vultr dedicated plans, it say its dedicated resources so you should get standard SSD speed, which is more than enough. I feel that you might be measuring your needs incorrectly. How much RAM are you actually using? How is the database being used? How is your CPU load? Are you maxing those 4 core access? My recommendation: Analyze your needs. Determine what you consume more: is it CPU or RAM? Places to Check: DigitalOcean, Linode, in adittion to Vultr which is excellent.
Posted by avirizal, 02-19-2017, 08:00 AM
Maybe you can try hetzner's EX SSD servers and add 2 extra ssds and get a raid 10 for below $150 pm
Posted by vpsineu, 02-21-2017, 08:19 AM
Check the https://budgetvm.com/ prices.
Posted by madRoosterTony, 02-21-2017, 12:56 PM
When it comes to MySQL there are two things you have to worry about. RAM and Disk IO. As either one of these starts to run out of resources, then that causes CPUs to climb. So using SSD and High Ram always helps. Depending on the amount of Disk Space you need, you might also look at Semi-Dedicated Servers which can get you the performance of modern CPU with dedicated resources over shared resources of some VPS providers. Also as others have mentioned, you can get a full dedicated server with 16GB of RAM, the latest CPU (e3-1230v5), and SSD for under $150.00 and blow away the performance you are seeing from Amazon.
Posted by HostColor, 02-21-2017, 01:26 PM
@neeraga2 it looks to me that you'd paying for "proprietary" technologies that have fancy names, but offer standard functionality. I'd suggest you to either go for a bare-remetal, physical dedicated and SSD-based server... or get a proper Cloud solution that offers high performance SSD-powered storage, which is priced reasonably.
Posted by PrimeCrown, 02-21-2017, 07:41 PM
Adding one more thought to above point, failure is inevitable and I would argue that AWS RDS like services provide more tools to deal with those failures in an automated way than a dedicated server. If you are considering running critical data, you should have a well defined disaster planning.