Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 109

How can mysql_multi be configured to allow MySQL instances to use the same port number?

    Correct Answer: B

    MySQL instances can use the same port number if they are configured to listen on different IP addresses. This is because each IP address and port combination is unique, allowing multiple instances to use the same port on different IPs.

Discussion
LrnsTghOption: B

I choose B because more logic. socket doesn't mention any port. https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-connection-socket.html

FelipeKOption: C

Each MySQL instance should use a different socket file to avoid conflicts. You can specify the socket file for each MySQL instance in their respective configuration files (typically my.cnf or my.ini).

marklvOption: B

B. If each mysql instance has a unique port, they can all listen on that port.

marklv

I mean if they all have a unique ip address, they can use the same port. So B. Not C, sockets have nothing to do with ports.