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 →Getting MySQL running on a CentOS Linux server
I started playing with MySQL back in the 4.X days, but never invested a lot of my time since my day job required me to support Oracle databases. I'm trying to branch out more now, and recently picked up a copy of MySQL, MySQL High Availability and PHP And MySQL. There are a slew of things I would like to web-enable, so I'm hoping to learn everything I can about PHP and MySQL in the next few months. To allow me to start experimenting with PHP and MySQL, I needed to create a test environment…
$ read more →The state of OpenSolaris
Matty and I haven't really spoken much about the current state of the OpenSolaris project. Oracle has been pretty tight with releasing any type of information about their plans / directions in which they will be taking Solaris / OpenSolaris. Its caused a lot fusteration. The OpenSolaris Governing Board threw down the gauntlet and has threatened to dissolve pending some direct interaction / involvement from Oracle…
$ read more →Awesome MySQL performance blog
I came across Neelakanth Nadgir's blog while doing some research, and his performance analysis tools (cmdtruss and inniostat) are pretty sweet. If you are looking to learn more about MySQL performance, you should take a look at High Performance MySQL and the Sun engineering blogs. There is some awesome stuff out there!
$ read more →