Failed to connect to database RDS MySQL

0

I have an RDS MySQL, which used my owner DB instance parameter group, where I have:

max_connections =6000 table_open_cache = 6000 thread_cache_size = 4000 require_secure_transport = OFF max_prepared_stmt_count = 65536

I am doing a new rollout using this RDS MySQL, my client system opens around 5000 connections simultaneously, but when my client system tries appear this message error many times

23May24 07:35:10 05B3 00000 Failed to connect to database: SSL connection error: unknown error number 23May24 07:35:10 0B96 00000 Failed to connect to database: SSL connection error: unknown error number 23May24 07:35:10 05AE 00000 Failed to connect to database: SSL connection error: unknown error number 23May24 07:35:10 0B90 00000 Failed to connect to database: SSL connection error: unknown error number

Enter image description here

When I try again to reboot my client system

23May24 03:07:24 ---- ----- Can't connect to DB Host '172.31.16.180' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 23May24 03:07:24 ---- ----- Starting Bind

I am not used SSL connections,

My target RDS MySQL was not being restarted/failover, during the error.

What is the error o what I need to setup in my RDS MySQL.

1回答
0

If a specific host receives too many connection errors before a successful connection is established, then the host will be prevented from attempting to connect. This is a security feature by the MySQL engine to prevent unwanted connections from attempting to connect to the database. The default value is 100 and can be tuned to your security requirements and environment.

Resolution

  1. Increase the max_connect_errors value suitable to your use-case. Please see[1] , (Please use customer parameter group to modify the parameter)

  2. Unblock hosts using ‘flush hosts;’ command by using below command [Use EC2 to run the following command] mysqladmin -h <RDS_ENDPOINT_URL> -P <PORT> -u <USER> -p flush-hosts.

  3. Reboot the instance

[1] https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-3-parameters-related-to-security-operational-manageability-and-connectivity-timeout/

AWS
JackieE
回答済み 2ヶ月前
profile picture
エキスパート
レビュー済み 2ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ