Does hardware help boost performance?
When not to upgrade Hardware?
What hardware to upgrade to increase MySQL Performance?
- The number of HDD is more important than the space. This might seem shocking at first but there is a reason for that. There are cases of people adding 1 TB HDD and reducing performance.
The trick is to get 4 x 250 GB HDDs with a RAID array. This helps the effective load distribution and increases performance greatly. Most top performing servers use RAID 10, which is safer and faster. This allows multiple queries to be balanced on multiple hard drives, giving faster response time, throughput and easier scalability.
- Adding more RAM does help in terms of cache. However, the trick is to make the application utilize the added RAM. So there is a software tweak involved. This can be achieved by customizing the MySQL server configurations.
- Adding more CPU depends on what type of application is being run. If the application is a number crunching, statistical application, yes adding more CPU power can affect the MySQL performance a great deal. If it were just a standard web/database server, then probably adding more HDDs would serve better.
- Adding more servers is a key challenge, but a fruitful one if successful. For a large-scale application, a single server can’t obviously handle the entire load, so it is better off having two or more servers. So in the case of two servers, 50% of the traffic is routed to the other server, improving speed and balance load.
The load balancing can be achieved by setting up the second server with dual-master replication. This technology keeps both the servers in sync and also serves as a backup system.