Thank you for all of you who dropped by the MySQL booth at Drupalcon to say ‘Thank you’ for MySQL. At every show there are several folks who do this but at Drupalcon it seemed like half the 3,000 attending dropped by to say ‘thanks’, grab MySQL stickers, OurSQL Poscasts disks, and talk about MySQL 5.6. I’ll see all y’all next year in Austin.
As you probably know, Tungsten Replicator can replicate data from MySQL to MongoDB. The installation is relatively simple and, once done, replication works very well. There was a bug in the installation procedure recently, and as I was testing that the breakage has been fixed, I wanted to share the experience of getting started with this replication.
Step 1: install a MySQL server
For this exercise, we will use a MySQL sandbox running MySQL 5.5.31.
id="attachment_13396" class="wp-caption alignright" style="width: 257px">
class="size-full wp-image-13396" alt="Percona Server for MySQL version 5.5.31-30.3" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" />
class="wp-caption-text">Percona Server for MySQL version 5.5.31-30.3
This 35-minute video from the recent Google I/O conference explains how to use Go’s concurrency primitives — goroutines, channels, and the select statement — to do things elegantly, correctly, and safely in a few lines of Go, which would otherwise turn your brain into a pretzel in most programming languages.
I recently had to do some customer work involving the McAfee MySQL Audit Plugin and would like to share my experience in this post.
Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this involves a lot of data you don’t need too, and isn’t flexible at all. The specific problem of logging failed connection attempts has been discussed on a
title="auditing login attempts in mysql" href="http://www.mysqlperformanceblog.com/2012/12/28/auditing-login-attempts-in-mysql/">previous post in our blog.
Wow, talk about an industry that’s overcrowded with look-alike me-too products. Online agile project management tools are a dime a dozen, which makes me think that they are probably all very similar and probably don’t solve most people’s needs. I’ve observed that when this is true, nearly-indistinguishable tools get reinvented, until the burden of evaluating the options is greater than the burden of just building yet another one, thus perpetuating the cycle.
Here are some of the products I looked at yesterday:
class="alignleft wp-image-12668" style="margin-top: 5px; margin-bottom: 5px;" alt="Percona XtraBackup for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" width="206" height="78" /> Percona is glad to announce the release of
href="http://www.percona.com/software/percona-xtrabackup">Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download site