You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
To run multiple instances of MySQL Server on a single host, you have supported methods such as running MySQL Server docker containers, which allows for isolation and easy management; using systemd with different settings for each instance, to manage multiple instances through service files; and starting mysqld or mysqld_safe using different option files for each instance, which allows each instance to have its own configuration. Using docker containers (A) allows for isolated environments, systemd (B) can manage system services efficiently, and different option files (D) enable clear configuration separation between instances.
ABD A ocker B systemd and specify different config option files D mutiple things need to be changed, so different configurations
BTW, not E because you just specified the datadir, what about the port, the logfiles, etc.
--datadir with --initialize
A. Run MySQL Server docker containers: Docker containers are a popular way to isolate and run multiple instances of MySQL on the same host. D. Start mysqld or mysqld_safe using different option files for each instance: You can start multiple instances of MySQL by specifying different option files for each instance, which allows you to configure them separately. E. Run mysqld with --datadir defined for each instance: You can specify a different data directory for each MySQL instance using the --datadir option.
The correct options are BDE