When a replica halts because the SQL thread encounters an error, you can resume replication by skipping the problematic event(s). Two common approaches are available. Methods to Skip Errors 1) Skip a specific number of events Use SQL_SLAVE_SKIP_COUNTER to advance the SQL thread past N events. Skip o...
Environment macOS 10.13.3 Docker 17.12.0-ce Image: mysql:5.7.21 Example container: CONTAINER ID: 478bbac9137b IMAGE: mysql:5.7.21 PORTS: 0.0.0.0:3306->3306/tcp NAMES: mysql.5.7.21.plus Start the container and connect as root Start the MySQL container and connect from the host using the MySQL clie...
When Zabbix server starts and reports Z3001 with "Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’", it typically means Zabbix is pointing too a socket path that does not exist or differs from the one MySQL/MariaDB actually created. Symptom Example log excerpt...
When installing MySQL from Oracle’s .deb packages on Ubuntu, dpkg can leave the server unconfigured if a required library (libmecab2) isn’t present. This typically shows up when installing multiple local packages in one go. Example install command (local .deb files): sudo dpkg -i ./mysql-common_*.de...
When working with MySQL 8.0, you might encounter the following issue during remote connection attempts: # mysql -h10.254.73.103 ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No suc...