Databases
Getting started with Cassandra
With the motivation from today’s public news on Twitter’s move from MySQL to Cassandra , my own skills desire following in-depth discussions at last November’s Open SQL Camp to consider Cassandra and yesterday’s discussion with a new client on persistent key-value store products, today I download installed and configured for the first time.
Read moreThe correct approach to rolling MySQL logs
I say correct because there are several incorrect approaches to managing MySQL logs. In MySQL you have two important log files, the MySQL error log (configured with –log-error ) and the MySQL slow query log (configured with –log-slow-queries or –slow-query-log and –slow-query-log-file which is available from 5.
Read moreWhat’s your MySQL version?
I’ve heard that the mechanic’s wife always has a car that needs repair or tuneup, the painter’s wife always had walls of peeling paint, you get the picture. What about MySQL DBA’s and their own databases?
Read moreMigrating MySQL latin1 to utf8 – Character Set Options
Continuing on from preparation in our MySQL latin1 to utf8 migration let us first understand where MySQL uses character sets. MySQL defines the character set at 4 different levels for the structure of data.
Read moreChecked your MySQL recovery process recently?
I sound like a broken record with every client when I talk to about the resilience of their production environments. It’s very simple in theory, however in practice many organizations fail.
Read moreThe Blue Pill or the Red Pill
At the recent FOSDEM 2010 event, I presented in my keynote Dolphins, now and beyond a option which I termed the “Blue Pill” or the “Red Pill”. The following slide produced noticed interest in a packed room, and subsequent conversation.
Read moreMigrating MySQL latin1 to utf8 – Preparation
This article is Part 1 of a series of articles regarding MySQL character set conversion. Be sure to also check out character set options and the process for more information.
Read moreBeyond MySQL GA: patches, storage engines, forks, and pre-releases – FOSDEM 2010
Kristian Nielsen presented “Beyond MySQL GA: patches, storage engines, forks, and pre-releases”. This included a history of current products: Google Patches (5.0 & 5.1) included improvements in : statistics/monitoring lock contention binlog malloc() filesorts innodb I/O and wait statistics SHOW …STATISTICS statements smp scalability I/O scalability semisync replication many more Percona Patches (5.
Read moreMulti-Master Manager for MySQL – FOSDEM 2010
The next presentation by Piotr Biel from Percona was on Multi-Master Manager for MySQL. The introduction included a discussion of the popular MySQL HA solutions including: MySQL Master-slave replication with failover MMM managed bi-directional replication Heartbeat/SAN Heartbeat/DRBD NDB Cluster A key problem that was clarified in the talk is the discussion of Multi-Master and this IS NOT master-master.
Read more10x Performance Improvements in MySQL – A Case Study
The slides for my presentation at FOSDEM 2010 are now available online at slideshare . In this presentation I describe a successful client implementation with the result of 10x performance improvements.
Read moreState of phpMyAdmin – FOSDEM 2010
Following the opening keynote “Dolphins, now and beyond”, Marc Delisle presented on “State of phpMyAdmin”. phpMyAdmin is an DBA administration tool for MySQL available today in 57 different languages. This is found today in many distributions, LAMP stack products and also in cpanel.
Read moreDolphins, now & beyond – FOSDEM 2010
I had the honor of opening the day at the MySQL developer room at FOSDEM 2010 where I had a chance to talk about the MySQL product and community, now and what’s happening moving forward.
Read moreBe sure to know your my.cnf [sections]
The MySQL configuration file, e.g. /etc/my.cnf has a number of different section headings including [mysql], [mysqld], [mysqld_safe]. It is important that you ensure you put the right variables into the right section.
Read moreProblem of the day, DESC gives error.
I hit this interesting problem last night on 5.0.51a. mysql> use information_schema; mysql> desc routines; ERROR 1 (HY000): Can't create/write to file '/home/tmp/#sql_fea_1.MYD' (Errcode: 24) mysql> show create table routinesG *************************** 1.
Read more