On-Premise MySQL Server Hardware Requirements
Dedicated Server Minimum Requirements
Deployment of a dedicated MySQL instance for the WebChart system requires several factors to be taken into consideration, to properly allot hardware resources needed to handle everyday usage, peak usage, and capacity planning for future usage. The following are minimal software and hardware resource recommendations for a dedicated MySQL database server.
The following required software/configuration may have other required dependencies:
- 64-bit Linux OS
- Percona Server latest version 5.5
- Percona Toolkit
- Percona xtrabackup
The minimum hardware resource recommendations for a dedicated MySQL instance fall into three levels: small, medium and large. These levels directly relate to the number of concurrent WC users (i.e., the number of users accessing the WebChart system at the same time). Memory and storage recommendations vary, and may be influenced by a number of factors that may increase requirements (e.g., large data set, the migration of legacy system data, and the expected growth of users).
Experience has shown, MySQL requires sufficient memory to provide optimal performance and depends on the quantity of information stored in the tables. By caching hot datasets, indexes, and ongoing changes, InnoDB is able to provide faster response times and utilize disk IO in a much more optimal way. From a CPU standpoint, faster processors with many cores provide better throughput with large concurrent workloads. Storage formatted as EXT4 and mounted with noatime, barrier=0 running the deadline IO schedule provide optimal performance.
The table below represents rough estimates of hardware requirements and are based on WC experience, MySQL documentation, and other recommendations. These are meant for illustration and may vary significantly depending on workload and storage.
|Level||Max Concurrent Users||Resource Recommendation|
|Small||5 - 10||* 2-4 CPU cores * 12Gb ECC memory * Storage * 20Gb root OS installation * 50Gb DB storage|
|Medium||10 - 50||* 4-8 CPU cores * 32-64Gb ECC memory * Storage * 20Gb root, OS installation * 50Gb DB storage|
|Large||50 - 100||* 8 or more CPU cores * 128-256Gb ECC memory * Storage * 20Gb root, OS installation * 50Gb DB storage|
WC offers consulting and database managed services that can help plan, deploy and manage your WebChart system. Please contact your account manager for more information and/or see our Database Managed Services Summary.