Archive
Posts from 2012
Enabling MySQL query logging
I recently installed the LogAnalyzer graphical syslog analysis tool. After the install completed I went to the "Show Events" page and noticed that no data was being displayed. I wanted to see which queries were being sent by LogAnalyzer to my MySQL database instance, so I enabled query logging by adding the following two statements to the [mysqld] block in the /etc/my.cnf configuration file: The first line enables logging, and the second line tells MySQL were to write the logs. Once enabled you can see the queries executed against your server by paging out the contents of /var/log/query.log…
$ read more →Installing ZFS on a CentOS 6 Linux server
As most of my long term readers know I am a huge Solaris fan. How can't you love an Operating System that comes with ZFS, DTrace, Zones, FMA and Network Virtualization amongst other things? I use Linux during my day job, and I've been hoping for quite some time that Oracle would port one or more of these technologies to Linux. Well the first salvo has been fired, though it wasn't from Oracle…
$ read more →Using the rsyslog MySQL plug-in to send syslog data to a SQL database
I have been experimenting with ways to better manage the logs my servers generate. Depending on who you ask, folks will recommend sending your logs to a remote syslog server that writes the logs to disk, some may recommend sending it to a log analysis tool similar to splunk, and others would recommend feeding it to a SQL database. I've talked before about setting up syslog-ng for remote logging, and in this case I wanted to experiment with something new. I also didn't have money to buy a tool like splunk, so I decided to start experimenting with funneling syslog data into a MyQSL database…
$ read more →Display the default values of MySQL my.cnf settings
MySQL is configured through the my.cnf configuration file, which typically resides in /etc. There are dozens of configuration settings that can be added to this file, and you can view the full list by running mysqld with the "--help" and "--verbose" options: The configuration directive will be printed on the left, and the current value of the directive will be displayed on the right. When I get a "how do I do X" thought I typically will cross reference directives with the official documentation to see how to configure the server to do what I need it to. It's also just plain useful to know what you can do with the server.
$ read more →Slides from my introduction to gluster presentation
I gave a talk on Gluster this evening at our local UNIX users group. I had a good time talking, and enjoyed interacting with everyone that came out. The introduction to Gluster presentation slides are available in the presentation section of my website, and I'll make sure to get them linked to the users group website. I would like to thank everyone for coming out…
$ read more →