Just quickly dropping the PDF version of the slides of my presentation at this year's MySQL
Conference.
Enjoy!
Just quickly dropping the PDF version of the slides of my presentation at this year's MySQL
Conference.
Enjoy!
I have published the very first sharable Drizzle Amazon Machine Image (AMI) for AWS EC2, based on the good feedback from my discussion at the Drizzle Developer Day on what options we should try.
This first version is a 32bit Developer instance, showcasing Drizzle and all necessary developer tools to build Drizzle from source.
What you will find on drizzle-ami/intrepid-dev32 - ami-b858bfd1
Ubuntu 8.10 Intrepid 32 bit base server installation:
- build tools
- drizzle dependencies
- bzr 1.31.1
From the respective source trees the following software is available:
- drizzle 2009.04.997
- libdrizzle 0.0.2
- gearman 0.0.4
- memcached 1.2.8
- libmemcached 0.28
Drizzle has been configured with …
[Read more]
Now at LinuxFest NW listening to John
Locke's talk about the Hacking business model
John Locke is owner of Freelock Computing, a small business in Seattle
who is concentrating his business around Drupal.
(Drupal is a tool that allows you to quickly develop web sites).
John is following many of the same principles that are described
in the Hacking business model that Zak Greant and I
created based on our experience with the early days of MySQL Ab. …
I recently noticed several new books based on GlassFish Server, like Yuli's book on Java EE and DBs, Using MySQL and GlassFish and Antonio's book on Java EE 6 with GF v3. Looking a bit more I also found that David also has a new book on NetBeans 6 and Java EE 5 (w/ GF) and Adam has one on the …
[Read more]As I described yesterday, Open Query is doing some tests on SSDs and other devices pretending to be harddisks (SANs, battery-backed RAID controllers, etc). To aid this, I wrote a small tool to test the different kind of I/O operations MySQL would/could do, which is not quite the same as what other general purpose apps would do, and also not what other test tools measure. For instance, it tries Direct I/O as well as fsync() after each write, and also it a range of different I/O block sizes.
In a nutshell, it’s aimed to do what MySQL does, without MySQL! Testing lots of different setups for this particular purpose (even with fantastic tools like MySQL Sandbox) is a complete pest, and changing InnoDB page size requires a recompile. While Percona has tried a larger page size in the past and decided it wasn’t worth it (the default is 16K), I thought it worthwhile to include …
[Read more]Pre-UC I put out a teaser on some dbt2 scores in the 50K range. I mentioned and showed the graphs during my SSD session, but I thought I would show them here for those who skipped the UC or did not attend my session. Basically what most people consider to be a classic “CPU Bound” workload where all of your data easily fits into memory can also see benefits from moving to SSD’s. Remember just because everything fits into memory doesn’t mean your not going to be doing some operations to disk ( logging, flushes, etc ). Take a look:
Test | TPM | % Improvement |
Regular Disk BBU (5.1.33) | 46106.44 | NA |
SSD WO/Drive Cache (5.1.33) | 50606.82 | 9.76% |
Every time I visit the Sun Santa Clara Campus, I’m reminded of
Mel
Brooks’s movie “High Anxiety”. The campus was known as The
Great
Asylum for the Insane in the 19th century, and even includes a
tower.
High Anxiety,
whenever you’re near.
High Anxiety,
it’s you that I fear.
I went to the MySQL Storage Engine (SE) Summit held on the
Sun
campus in Santa Clara. I thought it was a great meeting,
and many
thanks to Sanjay for inviting us. Also attending from
Tokutek were
Zardosht and Tom. We heard interesting points of view from
SE
implementers such as Akiba, ScaleDB, InnoDB, PBXT, and Virident,
as
well as from the Sun/MySQL implementors. Here are a few
highlights:
Everyone agrees that the Storage Engine (SE) API needs
better
documentation.
The InnoDB team suggested that one approach …
[Read more]I'm constantly going out to customers and looking at their database environments and the challenges they are facing. Of course, sometimes my perspective can be rather unique because customers never invite me in to show me how fast their databases are or how great things are. Usually by the time I get called in, the environment has gotten very dynamic.What never ceases to amaze me is how on
I’m writing this entry on my way back to Tokyo from Narita. So, I was in the US all week for MySQL UC, Percona Performance Conference and the Drizzle Developer Day. It was great to meet new people and also catch up with developer friends from all over the world. These events are great excuse to bring together folks that work together online and receive the free beers that were promised on IRC. Looking back, the week just flew! I can’t believe I’m back in Japan already.
What wasn’t pleasant however was Drizzle being introduced as “MySQL Drizzle” and described as MySQL’s technology incubator at the opening keynote. The truth is, Drizzle is a community driven project that is not affiliated with any commercial organization. The project is …
[Read more]