Hi we recently got a notification from AWS requesting us to upgrade our mariadb engine on our AWS RDS from 10.0
as 10.0 will be deprecated an no longer supported.
After the change was done. (from 10.0 to 10.3.20) we began noticing frequent timeouts to our all sites pointing to the remote RDS
The timeouts happen on the average every hour, the initial suspicion was a background job
but after disabling all background jobs we noticed the site timeouts are still happening.
I’ve never experienced what you’re describing. And don’t have any notes about version 10.3 in my wiki. I’ve been running v10.4.6 for quite a long time.
Random Guesses
Without examining the database and logs, and trying to pinpoint a root cause, there are a few things you could blindly try.
One is adjusting certain timeouts. See link below. It’s pretty easy to change them. Then see if there’s a noticeable difference. And if not, revert them back to previous values.
Also, unless you really need it, I recommend disabling DNS lookups for MariaDB. You can modify your configuration as follows.
[mysqld]
skip-name-resolve
If there is a particularly large query (perhaps running hourly?) then you might consider increasing the value of the max_allowed_packet variable. Default value is 1MB.
No guarantee any of these help, but it’s something to try, before you take a deep dive into MariaDB.