Thanks to all who attended my PXC Operations webinar last week.  If you missed it you can watch the video here.

I wanted to take some time to answer the questions I didn’t get to during the broadcast.

Is there an easy way to leverage the xtrabackup SST and IST in an xtradb cluster to take your full and incremental backups of the cluster’s databases?

An SST is a full backup of one of the nodes in your database already.  If you want another backup, you may as well just run xtrabackup yourself (though don’t forget the discussion about locking from the talk).

IST is not affected by wsrep_sst_method …

Percona Server version 5.1.70-14.8

Percona is glad to announce the release of Percona Server 5.1.70-14.8 on July 3nd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.70, including all the bug fixes in it, Percona Server 5.1.70-14.8 is now the current stable release in the 5.1 series. All of Percona‘s software is …

Dear MySQL users,

MySQL Connector/Python v1.0.11 is a new version of the 1.0 production release of the pure Python database driver for MySQL.

MySQL Connector/Python version 1.0 is compatible with MySQL Server versions 5.5 and greater, but should work with earlier versions (greater than v4.1). Python v2.6 and greater as well as Python v3.1 and greater are supported. Python v2.4 and v2.5 are known to work, but are not officially supported.

MySQL Connector/Python v1.0.11 is available for download from
http://dev.mysql.com/downloads/connector/python/#downloads

A brief summary of changes in MySQL Connector/Python v1.0 is listed below. Please check the change log file inside the distribution for a more complete list of changes or online at: …

MySQL for Visual Studio is a new product including all of the Visual Studio integration previously available as part of Connector/Net.  The product is now released as GA and is appropriate for use in production environments.  It is compatible with MySQL Server versions 5.0-5.7 and Visual Studio versions 2008-2012.

If you missed the recent MySQL Cluster 7.3 GA webinar then the replay is now available here.

In the webinar replay you can learn how MySQL Cluster 7.3 has delivered key features enabling the latest generation of web and mobile services to take advantage of high scalability on commodity hardware, SQL and NoSQL interfaces and 99.999% availability; these include:

• Support for Foreign Key constraints – implemented to be as compatibile with InnoDB as possible
• NoSQL JavaScript connector allowing native access from node.js applications to MySQL Cluster, bypassing the SQL layer
• Browser-based Auto-Installer for fast configuration of production-grade clusters
• Connection Thread Scalability …

Join 7500 others and follow Sean Hull on twitter @hullsean.

There’s a lot of talk on the web about scalability. Making web applications scale is not easy. The modern web architecture has so many moving parts. How can we grapple with the underlying problem?

Also: Why Are MySQL DBAs So Hard to Find?

The LAMP stack scales well

The truth that is half right. True there are a lot of moving parts, and a lot to setup. The internet stack made up of Linux, Apache, MySQL & PHP. LAMP as it’s called, was built to be resilient, dynamic, and scalable. It’s essentially why Amazon works. Why what they’re doing is possible. Windows & .NET …

Memcache access for MySQL Cluster (or NDBCluster) provides faster access to the data because it avoids the SQL parsing overhead for simple lookups – which is a great feature. But what happens if I try to get multiple records via memcache API (multi-GET) and via SQL (SELECT with IN())? I’ve encountered this a few times now, so I decided to blog about it. I did a very simple benchmark with the following script:

#!/bin/bash
mysql_server="192.168.56.75"
mc_server="192.168.56.75"
mysql_cmd="mysql -h${mysql_server} --silent --silent"
mysql_schema="percona"
mysql_table="memcache_t"
mc_port=11211
mc_prefix="mt:"
function populate_data () {
  nrec=$1
  $mysql_cmd -e "delete from ${mysql_table};" $mysql_schema > /dev/null 2>&1
  for rec in `seq 1 $nrec`
  do
    $mysql_cmd -e "insert into ${mysql_table} values ($rec, repeat('a',10), 0, 0);" $mysql_schema > /dev/null 2>&1
  done
}
function mget_via_sql() {
  nrec=$1
  in_list=''
  for rec in …

I made a new tutorial for how to use MySQL to develop Big Data Applications. This is a 'Udacity'/explaining-on-paper style of video which I hope you will enjoy and find helpful.
Please 'like' or retweet if you feel it is informative.

As I mentioned in a previous post that I’d mention how I resolved some additional missing include files when building MySQL on Windows.

In this post I cover 4 missing header files, as they are all related and have to do with polling, and headers (and functions) from libevent, and in the folder /sys. I’m not sure if one should even use these functions from libevent on Windows, as these are not needed for Windows, and may not be beneficial either (that last part I’ve just read briefly about, so I’d need to that a bit more myself to be 100%), but including the headers won’t hurt, as it doesn’t hurt if they don’t exist.

At any rate, here were the 4 related missing header file warnings:

-- Looking for include file sys/devpoll.h
-- Looking for include file sys/devpoll.h - not found
-- Looking for include file sys/devpoll.h
-- Looking for include file …

Percona Server version 5.5.32-31.0

Percona is glad to announce the release of Percona Server 5.5.32-31.0 on July 2nd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.32, including all the bug fixes in it, Percona Server 5.5.32-31.0 is now the current stable release in the 5.5 series. All of Percona‘s software is …