MariaDB Error Reading Communication Packets
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:
- increased maxallowedpacket to 1GB
- increased netbufferlength to 1000000
but nothing changes!
here is mariadb variable :