Databases

MySQL Community Photo Day Prizes

I forgot to mention in Support the MySQL Community Photo Day that PrimeBase Technologies is providing 3 prizes for the best photos uploaded. First Prize <td> $150 Amazon Gift Voucher </td> Second Prize <td> $100 Amazon Gift Voucher </td> Third Prize <td> $50 Amazon Gift Voucher </td> So, take your photo with other community supporters — they’ll also be wearing their open source t-shirts.

Read more

Where’s the News?

It’s been six weeks since the completion of the acquisition of MySQL by Sun Microsystems . In this time, on the MySQL News and Press Releases there has only been one (1) Press Release here .

Read more

The pursuit of a synchronous world

Well at least your MySQL database world. As Paul eluded to , PrimeBase Technologies has a project to provide synchronous replication for MySQL in a High Availability environment. It is more then an idea, there is a plan.

Read more

Support the MySQL Community Photo Day

Updated On good advice from Sheeri I made a few comments clearer. It has been proposed that the integral “MySQL Community Photo Day” be on Thursday April 17 2008, the final day of the MySQL Users Conference.

Read more

Replication++, Replication 2.0, Replication.Next

There has been some discussion recently regarding the death of MySQL Read Replication starting with Brian Aker and then Farhan , Arjen and Paul have all chimed in. Whatever you want to call it, the next generation of replication approach is clearly on the agenda of the industry leaders and pack followers.

Read more

The MySQL SandBox

This week I’d expected to hear good friend Giuseppe (CCO) Maxia speak about MySQL SandBox at the Hamburg MySQL April Meetup . This is product I’ve thought about using, wanted to use, but just never got to the point to using.

Read more

Storage Engines at the MySQL Conference

I’ll be following closely the progression of Storage Engines available in the MySQL Database server, well soon to be available when 5.1 gets to GA (hopefully by end of Q2 which is what we have been told).

Read more

Hamburg MySQL Meetup – Apr 2008

Tonight’s Hamburg MySQL Meetup was a packed room of 60-70 people at Sun in Hamburg. The most I’ve seen @ a MySQL Meetup across three cities, countries, continents and years (my first Oct 5, 2004).

Read more

Unexpected SEO results

I had need to show the official MySQL business shirt to somebody, so I did a Google Search on “mysql conference photos” (without the quotes) as I know I’ve seen photos of staff at the conference online before.

Read more

Come and get a t-shirt at UC2008

Here I am at my desk sporting the PrimeBase supporters t-shirt that will be available at the exhibitors booth at the 2008 MySQL Conference . The front is rather uneventful with the official logo, but the back will be worth the experience.

Read more

Not Stuck

Contrary to my earlier April Fool’s Stuck – No country to call home I’m alive and well in Hamburg Germany with my new job. Thanks for those concerned MySQL souls that fell pray to my “Evil Genius” as Farhan called it.

Read more

A day with Paul McCullagh – Architect of PBXT and BlobStreaming

Continuing on from my lightning visits with Jan Kneschke and Michael Zinner , today I got to spend a day with Paul McCullagh at his home in Hamburg Germany .

Read more

Limiting your result set, but getting count of all rows

In reviewing some of my notes I thought it was relevant to ensure this small MySQL gem is documented for my history purposes. Historically I’ve seen people do a complex SELECT statement twice, first to get a COUNT(*) and then to retrieve the data, perhaps in a paginated format.

Read more