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.

Software

The following required software/configuration may have other required dependencies:

Hardware

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

Managed Services

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.

WebChart Documentation
Last Build: Wed, 08 Sep 2021 00:26:00 EDT Legacy Documentation