MySQL 8.0 Database Administrator — Question 72

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

Answer options

• A. Run MySQL Server docker containers.
• B. Use systemd with different settings for each instance.
• C. Use system tools to lock each instance to its own CPU.
• D. Start mysqld or mysqld_safe using different option files for each instance.
• E. Run mysqld with --datadir defined for each instance.
• F. Use resource groups to lock different instances on separate CPUs.

Correct answer: B, D, E

Explanation

The correct methods to run multiple instances of MySQL Server on a single host include using systemd with different settings, launching mysqld with different option files, and specifying different data directories with --datadir. Other options, such as using docker containers or system tools for CPU allocation, are not standard practices for this purpose.