Author: Josh

A frequent task when working with MySQL is to restore a single table from a backup. This is typically an exercise where the admin must restore a full database to another MySQL instance and then export only the table in question. This is a great way to do it most of the time. Another option…

When making changes to users or grants and the changes don’t appear to take effect, be sure to check any warnings that result from these changes. mysql> flush privileges; Query OK, 0 rows affected, 4 warnings (0.24 sec) mysql> show warnings; +———+——+————————————-+ | Level | Code | Message | +———+——+————————————-+ | Warning | 1292 |…

Simple haproxy logging setup: # /etc/rsyslog.d/haproxy.conf $ModLoad imudp $UDPServerRun 514 $template Haproxy,”%msg%\n” local2.=info -/var/log/haproxy.log;Haproxy local2.notice -/var/log/haproxy-status.log;Haproxy ### keep logs in localhost ## local2.* ~ Don’t forget to rotate the logs: # /etc/logrotate.d/haproxy /var/log/haproxy.log /var/log/haproxy-status.log { daily rotate 10 missingok notifempty compress sharedscripts postrotate /bin/kill -HUP `cat /var/run/syslogd.pid 2> /dev/null` 2> /dev/null || true /bin/kill -HUP…

The Jenkins script console can be used to list all installed plugins and their versions fairly easily: Jenkins.instance.pluginManager.plugins.each{ plugin -> println (“${plugin.getDisplayName()} (${plugin.getShortName()}): ${plugin.getVersion()}”) } This can then be used to provision a new node or migrate to a new environment and have the destination Jenkins instance ready to go.