When mysql shows Slave_IO_Running and Slave_SQL_Running is false, then there is much evidence that the current slave relay log is broken. show slave status \G then looks for example like this: mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master.example.com Master_User: […]
To secure replication over ssl, mysql must support ssl. mysql -u root -p show variables like ‘%ssl%’; If the result looks like this ssl is not configured yet. have_openssl DISABLED have_ssl DISABLED ssl_ca ssl_capath ssl_cert ssl_cipher ssl_key First, the directory for the ssl-keystore is created on both servers. mkdir -p […]
You can either put a log file for all queries (mysqld –log=log_file_name or log = log_file_name in your my.cnf) or write the queries in table mysql.general_log. The use of the table can be done without restarting mysqld and the stored values could be filtered much easier. The table can create […]
If you’ve accidentally deleted the debian-sys-maint user, you can easily re-create the user. The password is stored in /etc/mysql/debian.cnf: # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = debian-sys-maint password = TOP-SECRET socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user = debian-sys-maint password = […]
I had a few problems with the update of the MySQL server from 5.5.31 to 5.5.33. apt-get upgrade only led to Error: Sub-process /usr/bin/dpkg returned an error code (1). For me it has helped to enter the full path for log-bin in /etc/mysql/my.cnf and .to set innodb_data_home_dir. I changed log-bin […]
The solution from Block outdated clients won´t work with syslog-ng 3.4.2, because syslog-ng syslog-ng uses “lseek()” to get the end of /proc/net/xt_recent/something while the program() destination just starts the program. Withe the destination file you get log-entries like: Aug 29 00:00:44 mx03.schaal-24.de syslog-ng[20351]: Error suspend timeout has elapsed, attempting to […]
First note: what I describe here is not an Bug in ISPConfig, but rather a concatenation of unfortunate circumstances. If you have two ore more database-servers in ISPConfig and they are also running in a mysql-replication (what is conventional), in certain circumstances the mysql-replication could crash with an error 1007 […]
I use stunnel to secure my MySQL-replication. MySQL itself offers SSH, but it´s not so simple to install. If stunnel works on your sytsme, you can use it for much more daemons/ports (secure imap, pop3, http). With stunnel only the remote connects to the master server use the tunnel. Local […]