On-Premise MySQL Server Hardware Requirements

Dedicated Server Minimum Requirements

Deployment of a dedicated MySQL instance for the Enterprise Health 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:

• 64-bit Linux OS
  • Red Hat® Enterprise Linux 6.7 or 7
  • CentOS 6.7 or 7
• Percona Server latest version 5.5
• Percona Toolkit
• Percona xtrabackup

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 EH users (i.e., the number of users accessing the Enterprise Health 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 EH 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

EH offers consulting and database managed services that can help plan, deploy and manage your Enterprise Health system. Please contact your account manager for more information and/or see our [Database Managed Services Summary](https://drive.google.com/open?id=1YX-G0aO0wZ13vsiHUtroPGSzE3q6yjKeLdzgX3fvMrs).