A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds. What should the database specialist do to accomplish this task?
A.
Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
B.
Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
C.
Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
D.
Modify the default DB parameter group and set the wait_timeout parameter value to 900.
A. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
wait_timeout: The number of seconds the server waits for activity on a non-interactive TCP/IP or UNIX File connection before closing it.
Managed RDS needs parameter grou.
wait_timeout: The number of seconds the server waits for activity on a non-interactive TCP/IP or UNIX File connection before closing it.
For me, answer is A
https://aws.amazon.com/fr/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-3-parameters-related-to-security-operational-manageability-and-connectivity-timeout/
Yes, the correct answer is A
From part one of that blog series:
"You can set parameters globally using a parameter group. Alternatively, you can set them for a particular session using the SET command."
https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-1-parameters-related-to-performance/
You can't edit files directly on the RDS servers, must use SET command or Parameter Group
Actually, I think all the answers could be wrong because you are not supposed to edit the .cnf file in RDS, but you could set the parameter globally with SET GLOBAL wait_timeout = xxxx; there should be an option for that
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
novice_expert
3 years, 1 month agoAriraAWS
3 years, 4 months agoShunpin
3 years, 5 months agoodba2014
3 years, 5 months agoMBO80
3 years, 5 months agogrekh001
3 years, 5 months agocynthiacy
3 years, 6 months agojove
3 years, 5 months agoSp230
3 years, 6 months agojohnconnor
3 years, 6 months agojohnconnor
3 years, 6 months agojohnconnor
3 years, 6 months ago