If you’re in Nuremberg Germany next week (November 15-17th) and have anything to do with Oracle or their products, then the DOAG (German Oracle User Group) conference is the place to be. I will be representing SkySQL Ab at the conference, giving a talk about the internal architecture of MySQL Cluster. The talk will look at the internals of MySQL Cluster and at the different processes that ensure the High Availability of MySQL Cluster. Beyond that, the talk will also look at how the data is stored on the data nodes, how different types of queries are resolved in the cluster, and how a primary key lookup is executed differs significantly from a tree index search. The talk will also look at the resources involved in resolving the queries.

So if any of the above sounds interesting come and listen to my talk in room Singapur at 13:00 on Tuesday!

 
This version includes support for “SELECT … FOR UPDATE” as well as displaying table “create time” and “last update time” via “SHOW TABLE STATUS”. The release also addresses a number of other bugs and fixes such as “point update” and “replace into” deadlocks. For more details, see the release notes section of the user’s guide, available here. To get the latest version of TokuDB (free for evaluation, development, testing, qualification, experimentation, and POCs ) click here. Starting with this release, we’ve also streamlined the installation process by creating a combined tarball that includes both MySQL and TokuDB.

Note that we’ll be hosting an upcoming webinar on November 15th for those who want to learn more about TokuDB in general as well as …

A friend of mine was asking me for my recommendation of a good desktop database program to use to keep track of his inventory of cargo containers. I suggested to him that he should use MySQL and write a web page interface to do everything that he needed. He then reminded me that he is a lawyer by trade, and that he doesn’t have any computer programming experience. Then I remembered that he has almost zero computer skills. And his Texas Hold-Em skills are even worse, but I don’t mind taking his money. In his case, he should just use a notepad and a pencil. (As for the question – what is a lawyer doing with cargo containers? – that is a different story.)

If he did decide to broaden his horizons a bit, he could easily write his own software web application for creating and storing almost any kind of data. In this post, I will show you how to create a MySQL database and then the web pages needed to create new addresses, edit the same …

This week we have a big announcement about Sarah, 3 hosts and an extra special guest.

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA.

To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

Main content
Previous podcasts about securing MySQL

read more

I want to keep a record of the configuration of the MySQL servers I manage. The configuration of some servers differs from others and over time the configuration may vary, partly as a result of upgrades in the mysql version or the use of the particular mysql instance, so tracking this is important.

Configuration items in MySQL can be thought of in 2 separate parts: the static configuration files which determine the behaviour of the server when it starts up (my.cnf) and the running configuration of the server in question. The latter information is usually obtained by running SHOW GLOBAL VARIABLES and SHOW SLAVE STATUS if the server is a slave.

I’d also like to compare the 2 sets of configuration so I can see if a local change has been made to the running server which is not reflected in its configuration file. I might want to correct this, or at least be aware of it.

However, collecting and …

"Re-inventing MyISAM is  not a selling point" (c) Mark Callaghan

Finally, this gets into one of the highest-profile NoSQL blogs:

http://nosql.mypopescu.com/post/12466059249/anonymous-post-dont-use-mongodb

Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245. [...]

One common cause for deadlocks when using InnoDB tables is from the existence of foreign key constraints and the shared locks (S-lock) they acquire on referenced rows.

The reason I want to discuss them though is because they are often a bit tricky to diagnose, especially if you are only looking at the SHOW ENGINE INNODB STATUS output (which might be a bit counter-intuitive since one would expect it to contain this info).

Let me show a deadlock error to illustrate (below is from SHOW ENGINE INNODB STATUS\g):

------------------------
LATEST DETECTED DEADLOCK
------------------------
111109 20:10:03
*** (1) TRANSACTION:
TRANSACTION 65839, ACTIVE 19 sec, OS thread id 4264 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1024, 3 row lock(s), undo log entries 1
MySQL thread id 3, query id 74 localhost 127.0.0.1 root Updating
UPDATE parent SET age=age+1 WHERE id=1
*** (1) WAITING FOR THIS LOCK TO BE …

Part of my job at Percona is to perform customer audits.  I’ve had fun the last week getting up to speed on some of the great tools in the Percona Toolkit.  I’m sure people have talked about these before, but to be honest, I always found it hard to take the time to learn new tools, and at my previous job there were often a lot of tools in-house that made it easier to avoid learning something new.  The great thing about the Percona tools is that they aren’t environment dependent (as much as is possible), they typically only require Perl to run.

So, with that being said, I wanted to just go through a few of the tools I learned about this last week that I found useful.

pt-collect:

The collect script collects information.  A lot of information.  I ran it for 10 minutes on a customer’s server and …

Part of my job at Percona is to perform customer audits.  I’ve had fun the last week getting up to speed on some of the great tools in the Percona Toolkit.  I’m sure people have talked about these before, but to be honest, I always found it hard to take the time to learn new tools, and at my previous job there were often a lot of tools in-house that made it easier to avoid learning something new.  The great thing about the Percona tools is that they aren’t environment dependent (as much as is possible), they typically only require Perl to run.

So, with that being said, I wanted to just go through a few of the tools I learned about this last week that I found useful.

pt-collect:

The collect script collects information.  A lot of information.  I ran it for 10 minutes on a customer’s server and …