Posted: 14th April 2012 by Darren Cassar in MySQL
Tags: 2012, conference, mysq
It is the day after the conference ended and I feel great. Two days of percona live and a day of skysql, drizzle and sphynx presentations were just awesome. I can say that IMHO it is one of the best MySQL conferences since I started attending four years ago. Well done Percona.
There were some great tracks by very very smart people and I have started compiling my list of things to build/setup to make my own deployment better, faster and easier to manage. Full track list can be found: http://www.percona.com/live/mysql-conference-2012/
I should also thank SkySQL and MariaDB for the free days of sessions I attended yesterday, organized and delivered by these two community focussed companies.
Posted: 26th September 2011 by Darren Cassar in MySQL
Tags: hack, malware, security
As per amorize.com MySQL.com was hacked and quote “infecting visitors with malware” .. true or false? …
More reading at krebsonsecurity.com too.
About a month ago I needed to compare tens of thousands of tables in hundreds of databases between a few different servers. The obvious choice was, mk-table-checksum! The only problem was, that the tool needs to know the minimum and maximum value of the column by which each table is to be subdivided into chunks and checksummed. This select min(col), max(col) from table locks all write operations on the table and on a big table it meant downtime.
Looking at the source it was clear we could make mk-table-checksum run the select min(col), max(col) from table on the read-only slave and use the values to checksum the master.
It was subtle code changes in function:
my $cxn_string_dc = “DBI:mysql:;host=slavehost;port=3306;mysql_read_default_group=client”;
my $user = ‘user’;
my $pass = ‘password’;
my $dbh_slave = DBI->connect($cxn_string_dc, $user, $pass);
and changing $dbh connection to $dbh_slave in the rest of the function where the min,max values were being calculated.
Good luck and enjoy a much less intrusive checksumming on your masters.
Because sharing is caring
Posted: 20th April 2011 by Darren Cassar in MySQL
Maybe you heard about salaryshare.me or maybe you haven’t, but either way, if you are a MySQL DBA in the US you should participate (ananymously) in order to learn how you compare to other MySQL DBAs. Fair enough, people have different experience level, some contract, some live in Santa Clara and some live in Ohio, some get free health insurance and awesome 401ks while others don’t … the list can go on forever, but it’s at least a guideline!
This website is anonymous and there must be at least four people submitting their salary (again, anonymously) for it to show salary statistics, no one will know what you exactly make but doing so you’ll help yourself and others.
PLEASE do not use the link unless you are in the US so as not to skew the results but feel free to create one for your own country for free by going to http://www.salaryshare.me.
Because sharing is caring …