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:

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.

LevelMax Concurrent UsersResource Recommendation
Small5 - 10
  • 2-4 CPU cores
  • 12Gb ECC memory
  • Storage
    • 20Gb root OS installation
    • 50Gb DB storage
Medium10 - 50
  • 4-8 CPU cores
  • 32-64Gb ECC memory
  • Storage
    • 20Gb root, OS installation
    • 50Gb DB storage
Large50 - 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#heading=h.t72wiklw6qpf).

Enterprise Health Documentation

Last Updated:

Last Build: Wed, 09 Oct 2024 23:08:26 UTC
WikiGDrive Version: 2aacb51f060d0354a678419290943a99bd16aad1