Tomorrow @10 am Central European time we will host the first part of a new series of MySQL for Online Applications - finally!

Registrations and details are here: http://www.mysql.com/news-and-events/web-seminars/online-apps.html

If you are a MySQL and webinar aficionado, you may remember the successful series that we ran in Spring 2007. Two and more years ago it was a great event, with huge participation - it is still available here.

Now we have renewed the material and we have added more hints and information re HA, performance and tuning, online architectures. There is, as usual, some content for developers, for IT managers, for DBAs and for architects. I hope nobody will be disappointed.

This time we …

For one reason or another, many times we find ourselves changing the hostname of a machine. It's been repurposed or moved - or perhaps the original installer didn't know what name it should have. To achieve this on most modern Linux distributions there are 2 key files you need to update.

1. 
   
2. /etc/hostname needs to be updated with correct hostname to be set on boot, and
   
3. /etc/hosts needs to be updated for DNS lookups of the local hostname. This is more important than you might think and will break many applications if not updated.
   

Some people also take the third step of updating the hostname on the fly with the 'hostname' tool, which if you do that means the gotcha I'm about to describe take you completely unaware in some weeks or months.

If you are using MySQL replication, there are two key options which depend on the hostname. These are the 'log-bin' and …

Last weekend, I finally got some time to look around Drizzle. I had already compiled it on my laptop, but hadn't really looked at the code.Then, I thought that looking over some of the blueprints on Launchpad, would be a good way to get familiar with the code base. After a quick search, I found move function/time/ functions into plugin(s)

This blueprint is basically to create UDF plug-ins for the different time related functions. There was no priority assigned and it was on the low hanging fruit milestone. Which was perfect for …

Last Week was busy!

In Seattle we hosted a developer meeting for Drizzle, Memcached, and Gearman.

The highlights for Drizzle?

Aloha Milestone was completed. Last tarball for that release tree has now been posted.

Bell was announced. The major pieces for Bell include a deliverable source tree for distributions, completion of the replication applier, and work on the Performance Schema. More details about Bell can be found here: https://launchpad.net/drizzle/trunk/bell

Cherry. Cherry will be the release after Bell. We will begin to solicit ideas for what should be in that release.

There were a number of lively discussions. …

The SSB scaling numbers trended reasonably well as the system scaled. 

2 -> 4 node scaling and 4->8 node scaling delivered a scalability factor averaging .552 with a range from .512 to .608.   Perfect linear scaling would be .500, i.e. doubling system resources cuts elapsed time in half.

1 -> 2 node scaling averaged .284 (better than linear) due to elimination of physical IO with a larger cache.   Queries ranged from .128 to .499 scalability factor. 

Software is available for trial via our Early Adopter Program at www.calpont.com .

We ran a quick scalability test of Calpont join behavior across using a Star Schema Benchmark data set at a scale factor of 1000. The Star Schema Benchmark transforms a TPC-H / DBT-3 data to a more standardized data warehouse star schema data model, and the 1000 scale factor includes 6 billion rows in the primary fact table. Information on the star schema bench (SSB) can be found at http://www.cs.umb.edu/~xuedchen/research/publications/DataWarehousePerformanceDissertationProposal.pdf .

-----------------------------------------------------------------------------------------------------------------------------------------
-- Note that these queries are run without any tuning or indices created for these joins or filters.
-- Basically, this is just 1) Create tables (without index or …

LINBIT will be a proud sponsor at this year’s LinuxCon in Portland, OR, held on September 21-23. We will also participate in the Linux Plumbers Conference, co-located with LinuxCon.

Phil is to speak at LinuxCon about DRBD 8.3 and beyond. At LPC, we will primarily focus on building highly available storage systems with DRBD, Pacemaker, and the STGT and LIO …

Goal: Build a PHP 5.3 package, that I can install and upgrade on new ubuntu slices as needed, without having to compile on each box.

This is an amalgamation of different blog posts that did certain things really well, but not everything I wanted. The post I refer to specifically Installing PHP 5.3 on Ubuntu by Brandon Savage .

Prep your system

Setup your development server to be able to compile things. By default, most installations will not come with compilers installed.

apt-get install checkinstall

Say yes, and let it follow the dependencies as needed.

Get the development headers for some of the extensions you’ll be compiling in.

apt-get install postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common postgresql-server-dev-8.3
aptitude install mysql-client …

In my years of teaching MySQL topics, I've noticed that many people write bad queries. It's not necessarily their fault. It could be that they don't understand some aspect of SQL, or that they solved the problem with the first technique that came to mind, or that their query is fine except that MySQL optimizes it poorly. I'll give a few examples.

Correlated vs. Non-Correlated subquery
For those that don't know what a correlated subquery is: it means that the subquery relies on values from the outer query. If the subquery could be executed by itself, then it would be non-correlated. Here's an example of a non-correlated query. Using the `world` database, I want to return all cities that have a population larger than New York's population:

SELECT name FROM City WHERE population > (SELECT population FROM City WHERE name = 'new york');

Since the subquery can be run by itself, it's non-correlated. …

What: SMUG#9 – In-depth MySQL with Arjen Lentz

When: Monday, September 7, 2009 5:30 PM

Where: Please make sure to RSVP (even “Maybe”) so that we know how many are coming!
Sydney Mechanics School of Art
Level 3, 280 Pitt Street
Sydney
02 9262 7300

I’m very excited to announce a very special guest at this user group meeting!

Arjen Lentz is in town doing his Sydney training program 7-Sep to 9-Sep and kindly agreed to drop by and talk about something interesting in the MySQL world – …