Rebooting Linux temporarily loses (some) limits.conf settings

Like any wildly managed environment, you probably have to create custom-defined settings in your /etc/security/limits.conf because of application specific requirements. Maybe you have to allow for more open files. Maybe you have to reduce the memory allowed to a process. Or maybe you just like being ultra-hardcore in defining exactly what a user can do. […]

Never change anything on Friday at 5pm.

SEVERE: Socket accept failed SSL handshake error No available certificate or key corresponds to the SSL cipher suites which are enabled. at at$ at Source) This is the reason you never change anything on Friday at 5pm. While attempting to update the SSL certificate for the MySQL Enterprise Monitor (for […] » Tshark to the rescue (MySQL snooping)

And while I was at it. I figured out I could do something similar with mysql queries. Instead of turning on full Query-logging in mysql (which probably means a restart of a running production mysql) I could just sniff it tshark -i eth0 -aduration:60 -d tcp.port==3306,mysql -T fields \ -e mysql.query ‘port 3306’ » […]

Four Short Links, Oct 14, 2009

Larry Ellison hates cloud computing – funny clip of Ellison lambasting the idea of clouds. Yes, really, clouds have been around for over a decade, we just didn’t know it (or realize it). Dynamic general and slow query log before MySQL 5.1 – This is an interesting way of handling the slow and general query […]

Encrypted MySQL connections (for client and replication)

There are four basic things you need to do when attempting to set up encrypted MySQL connections. Make sure your MySQL installation is configured with SSL. Create a set of certificates for your master, your slave, and your client(s). Configure your master and slave my.cnf with the correct ssl-* options. Configure the replication with the […]

Query partially completed on the master (error on master: 1053)

So, I walked into the office this morning to the following lovely alert from our MySQL Enterprise Monitor installation (MEM) which, thankfully, was working again after I had to rebuild it last week. Server: seawasp:3306 Time: 2009-07-08 01:33:28 GMT Advisor: Replication – Slave Has Experienced A Replication Error Problem Description When a slave receives updates […]

Encrypting MySQL connections

One of the things I’ve been tasked with implementing is support for serving Category 1 data from our MySQL servers.  Historically, this has been shied away from because of the complexity associated with managing the SSL certificates for all of the potential clients.  This came up again after I took over.  There are customers inside […]

Confusing service types

One of the problems we face in ITS is promoting, yet differentiating, the types of MySQL services we provide.  I hear you thinking, “But you’re ITS!  You only provide one type … it’s just mysql!”  Yes and no.  I’m in this weird spot where I’m tasked with being the lead MySQL person for ITS Systems […]

The Trouble with MySQL Tribbles

Well, I’ve been back at UT for almost two months now and finding it to be a pretty enjoyable experience.  For those who don’t know me, my name is Travis Campbell.  I work in ITS Systems Unix managing the hosted MySQL database services for the University.  As I get deeper into UT’s MySQL infrastructure, I’ll […]