Say you want to dump a database, or even all databases, but with just a sample of all the data, say, 10 000 records per table of each of the databases.…
If you accidentally lost the /etc/mysql/debian.cnf file, you can simply run:
1 | dpkg-reconfigure mysql-server-5.0 |
Or the equivalent, e.g.: mariadb-server-5.5.…
1 | mysql_upgrade --verbose -udebian-sys-maint -p |
…
1 2 3 4 | apt-get install php5-cli php5-mysql php5-gd php5-snmp php-pear snmp graphviz subversion mariadb-client rrdtool fping imagemagick whois mtr-tiny nmap ipmitool python-mysqldb mkdir -p /opt/observium && cd /opt svn co http://www.observium.org/svn/observer/trunk observium |
add to config:
1 2 3 4 5 6 7 | $config['poller_modules']['unix-agent'] = TRUE; $config['enable_syslog'] = 1; $config['syslog_age'] = "1 month"; ## Entries older than this will be removed $config['syslog_filter'] = array("last message repeated", "Connection from UDP: [", "ipSystemStatsTable node ipSystemStatsOutFragOKs not implemented", "diskio.c: don't know how to handle"); ## Ignore some crappy stuff from SNMP daemon |
syslog
1 2 | mkfifo -m 0600 /var/log/rsyslog-fifo chown syslog.adm /var/log/rsyslog-fifo |
source: http://www.outsidaz.org/blog/2012/04/04/integrating-observium-with-rsyslog/
on client
1 2 3 4 5 | apt-get install snmpd snmp-mibs-downloader xinetd Ubuntu: make sure the SNMPDOPTS line in /etc/default/snmpd looks like this SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -p /var/run/snmpd.pid' |
Replace the default /etc/snmp/snmpd.conf file with something like this, changing the community, location and contact fields
1 2 3 4 5 6 7 8 9 10 | com2sec readonly default group MyROGroup v1 readonly group MyROGroup v2c readonly group MyROGroup usm readonly view all included . |
Update 2: official solution
Update: apparently this is a better solution.…
Create a /etc/init/lxc-custom.conf with the following contents
1 2 3 | start on mounted MOUNTPOINT=/run exec ln -s /shared/run/mysqld /run/mysqld |
This will automatically bind your shared mysql socket (if you have a set-up like mine).…