1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ53

Architecture

You need to run multiple MySQL Server instances on one host.

Which three approaches are supported?

Choose three
  • 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.
Explanation

MySQL supports multi-instance operation by using systemd instance units with instance-specific settings, by launching mysqld or mysqld_safe with distinct option files, and by assigning every server instance its own --datadir. A complete multi-instance configuration must also give each server unique conflicting resources such as its port, socket, PID file, and log files. MySQL resource groups govern threads within one server instance, and CPU pinning does not configure or manage separate MySQL server instances.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!