I have a problem. When I split my MariaDB from main server to another server (my database server is running MariaDB docker from latest tag) I got an error:
Got an error writing communication packets
i have 2 server the one is a webserver (no db) the other is a ubuntu 20.04 with 4gig ram and 4 core(2gh per core)
The port is open and my PING is less than 1ms.
I tried with a basic WP site DB and the connection is OK, there was no problem, but my database is about 1GB and I guess this made this problem.
I also try to connect over private network (192.168.100.25) instead of public IP, but the problem is same.
Here is my MariaDB log
Aborted connection 3 to db: ‘wpdb’ user: ‘root’ host: ‘myip’ (Got an error reading communication packets)
Aborted connection 5 to db: ‘wpdb’ user: ‘root’ host: ‘myip’ (Got an error writing communication packets)
I also edited MariaDB config:
but nothing changes!
here is mariadb variable : https://pastebin.ubuntu.com/p/yHFRh7CnVC/
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
take a look on this article would help to fix: https://stackoverflow.com/questions/57706924/how-to-fix-mysql-got-an-error-reading-communication-packets-error
other possibility is : TIME_WAIT max_allowed_connections limit
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.