1Z0-908 practice question 2 of 25
You must run multiple instances of MySQL Server on a single host. Which three methods are supported? (Choose three.)
Full set: 140 questionsTo run multiple MySQL Server instances on a single host, each instance must have its own unique configuration to avoid resource conflicts. This includes distinct data directories, port numbers, socket files, and process ID files.
1. Docker Containers (A): Each container provides OS-level virtualization, creating an isolated environment. This naturally allows each MySQL instance to have its own filesystem, network stack (and port), and configuration without conflicting with other containers on the same host.
2. systemd (B): On modern Linux systems, systemd can manage multiple MySQL services. By creating separate unit files (e.g., using the @ notation like [email protected]), each service can be configured to start with a different option file, ensuring complete separation of resources.
3. Different Option Files (D): This is a traditional method where mysqld or mysqldsafe is launched with the --defaults-file option pointing to a unique configuration file for each instance. Each file specifies all the necessary unique parameters (port, socket, datadir, etc.).
C. Locking an instance to a CPU is a performance tuning (CPU affinity) technique, not a method for enabling multiple instances. It does not resolve port, socket, or data directory conflicts.
E. Specifying only a different --datadir is insufficient. Without also defining a unique port and socket file, the second instance would fail to start due to network binding conflicts.
F. MySQL Resource Groups are an Enterprise feature for managing resource usage by threads within a single MySQL server instance, not for separating multiple server processes on a host.
1. Official MySQL 8.0 Documentation, Section 5.8, "Running Multiple MySQL Instances on One Machine": This section explicitly details the requirement for each server to have unique values for parameters like --port, --socket, and --pid-file. It describes starting servers with different option files, which directly supports option D.
2. Official MySQL 8.0 Documentation, Section 2.5.9, "Managing MySQL Server with systemd": This section explains how systemd is used to manage MySQL. It states, "Support for multiple MySQL instances is available," and describes using the [email protected] unit file to manage different instances, which validates option B.
3. Official MySQL Docker Hub Repository Documentation: The official documentation for the MySQL Docker image demonstrates how to run a MySQL server instance within a container. The fundamental principle of Docker is to run multiple, isolated containers on a single host, which directly supports option A as a valid method. (See docker run examples on hub.docker.com//mysql).
4. Official MySQL 8.0 Documentation, Section 8.12.6, "Resource Groups": This page clarifies that "Resource groups provide a way to manage the consumption of system resources by user and system threads running within the MySQL server," confirming that this feature operates inside a single instance, invalidating option F.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
- Question 9Examine this command, which executes successfully: shell> mysqldump --master-data=2 --sin…
