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: 23rd April 2011 by Darren Cassar in MySQL
Tags: manhattan, meetup, MySQL, new york, new york city
A few months ago Ronald Bradford took it upon himself to reinvigorate the MySQL community in NY. It was then that Ronald came up with EffectiveMySQL, a much needed breeze of fresh air in the big apple’s for us MySQL users.
This coming Tuesday, 26th April 2011, there is going to be the second (of many more to come) presentation, this time about “Silent data truncations because of overlooked configuration / design”. The actual title is: “MySQL Idiosyncrasies That Bite” presented by Ronald Bradford himself in midtown Manhattan. More details can be found here.
See you there!