Blog
Don’t Assume – Session Scope
MySQL system variables and status variables have two scopes. These are GLOBAL and SESSION which are self explanatory. This is important to realize when altering system variables dynamically. The following example does not produce the expected results.
Read moreDon’t Assume Series – MySQL for the Oracle DBA
As part of my MySQLCamp for the Oracle DBA series of talks to help the Oracle DBA understand, use and appreciate MySQL I have also developed a series of short interesting posts I have termed “Don’t Assume”.
Read moreA Cassandra twitter clone
Following my successful Cassandra Cluster setup and having a potential client example to work with running Ruby On Rails (RoR), I came across the following examples in Ruby. up and running with cassandra Twissandra Not being a ruby developer, I thought it was time to investigate further.
Read moreConfiguring a Cassandra Cluster
Continuing on from Getting started with Cassandra I’m now trying to configure two servers as a cluster. The Getting Started Step 3 was not clear the first time I read it (after writing this is makes sense), so a Google search yielded the second link as Building a Small Cassandra Cluster for Testing and Development .
Read moreEdward Screven of Oracle to Answer Questions for future of MySQL
For those of you on the O’Reilly MySQL conference list you will no doubt see this email, but for readers here is the important bits. _ Oracle Executive Will Speak at O’Reilly MySQL Conference & Expo
Read moreIneffective concatenated indexes
In MySQL significant performance improvements can be achieved by the correct use of indexes. It is important to understand different MySQL index implementations and one key improvement on indexes defined on single columns is to use multiple column or more commonly known concatenated indexes.
Read moreGetting 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 more