Just a quick note that the Colorado MySQL User Group will be have Craig Sylvester in town November 7th 2012 for a MySQL Cluster talk. Please feel free to RSVP and join us!

First of all a big thank you to all of you who attended my two Hands-On Labs (HOL) session at this year’s MySQL Connect. I ended up doing two sessions as there was a last minute cancellation, so in addition to the previously announced session about the Performance Schema, I also did an introduction to MySQL.

The slides and the workbook for the Performance Schema session will become available from the official Oracle OpenWorld/MySQL Connect catalog, but you can also get the files from my blog which for the Performance Schema session will also include the helper functions and procedures used and some sample queries used to create load on the …

This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.

News
Alaska Airlines system crash

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October

read more

Details of Re-execution and Empty Transactions << Previous post: Failover and Flexible Replication Topologies in MySQL 5.6
Next post: Flexible Fail-over Policies Using MySQL and Global Transaction Identifiers >>
This post was kindly translated to Japanese by Ryusuke Kajiyama.

In my previous post, we saw how GTIDs are generated and propagated, we described the new replication protocol, and we saw how these simple elements fit together to …

The Austin MySQL Meetup is this Monday 7PM sharp at the Oracle office at 5300 Riata Park Court Building B. Please RSVP so we can order enough pizza!

If you’re interested in MariaDB & MySQL and happen to be in Tokyo, do drop by the first ever MariaDB/MySQL Tokyo Meetup #1.

It happens October 16 2012, from 18.00-20.00. It is graciously hosted at K.K.Ashisuto (HQ) Salon Space (2nd floor). We have maps in Japanese and English.

See you there!

It's been a little more than two weeks since we launched our SkySQL Cloud Data Suite and SkySQL Enterprise Suite, and we're pleased at the response we've seen so far for these releases.

You've heard what we've had to say about it, but here are also some highlights of what the media is saying about SkySQL's recent move to introduce products to the marketplace...

SkySQL: build the service, then the customers and THEN the products - Computer Weekly - Insight into the ideal business model for start-ups

SkySQL offers tools for Amazon and Enterprise MySQL deployments -  …

As I’ve become a better shell programmer over the last year or two, I’ve been surprised to discover some tools I didn’t know about. It eventually dawned on me, as I did more and more brute-force processing of large datasets, as well as some of the more delicate things that went into Aspersa -> Percona Toolkit, that many tasks I used to do with SQL and spreadsheets can be accomplished easily with well-structured text files and Unix utilities. And they don’t require loading data into a database or spreadsheet (the latter of which almost always performs terribly).

To give an idea, here are some of the relational operations (in SQL speak) you can perform:

1. SELECT col1, col2… can be implemented with several variants of Unix utilities: cut and awk are the two most obvious. I tend to use awk only when needed, or when it’s more convenient to combine …

The MySQL Server has a quite simple interface for plugins to create tables inside INFORMATION_SCHEMA. A minimal plugin for creating a table with nothing but a counter might look like this:

static int counter_fill_table(THD *thd, TABLE_LIST *tables, Item *cond)
{
  ulonglong value= 0;
  
  while (1)
  {
    table->field[0]->store(value++, true);
  }
  
  return 0;
}

static ST_FIELD_INFO counter_table_fields[]=
{
  {"COUNT", 20, MYSQL_TYPE_LONGLONG, 0, MY_I_S_UNSIGNED, 0, 0},
  {0, 0, MYSQL_TYPE_NULL, 0, 0, 0, 0}
};

static int counter_table_init(void *ptr)
{
  ST_SCHEMA_TABLE *schema_table= (ST_SCHEMA_TABLE*)ptr;

  schema_table->fields_info= counter_table_fields;
  schema_table->fill_table= counter_fill_table;
  return 0;
}

static struct st_mysql_information_schema counter_table_info =
{ MYSQL_INFORMATION_SCHEMA_INTERFACE_VERSION };

mysql_declare_plugin(counter)
{
  MYSQL_INFORMATION_SCHEMA_PLUGIN,
  &counter_table_info,          /* type-specific …

This Log Buffer Edition once again touches upon the bold and best blog posts from the wide world of Oracle, MySQL and SQL Server. This Log Buffer #290 is all about ideas and their implementation and much more. Oracle: Reliability is inherently a property of systems, not of people, says Paul Vallee. How to restore [...]