Archive for May 2011

The SkySQL Reference Architecture

I have a bunch of notes from the O’Reilly MySQL Conference & Expo 2011, and I figure its about time I started blogging it. These are notes from the panel on the SkySQL Reference Architecture, led by Kaj Arno and Ivan Zoratti. The notes are raw (read their FAQ for more), and I talk a little bit about the SkySQL Configurator at the end (a tool I immediately used, and submitted some bugs/improvements for – 7 at last count, which I hear got fixed in the 0.02 release, which got pushed last night!).

There were 7 panelists. The MySQL world needs:

  • technical support
  • monitoring & administration tools
  • simplified interfaces
  • development & user tools
  • consulting & training
Services & consulting generally are difficult to scale.
The most comprehensive architecture around MySQL, scalable, adaptable and cloud ready
Implementation:
  • select and test specific components
  • integrate components
  • provision the components in a simple interface
  • simplify monitoring & administration
  • technical services & support
  • validate solutions
  • improvements and new releases can be done
  • knowledge sharing related to the reference architecture
Technologies selected from Webyog, Sphinx, Drizzle, Monty Program, Calpont, Tokutek, ScaleDB, Schooner, Linbit, Zimory, Canonical.

SkySQL Provisioning tools:

  • SkySQL Manager – control and administer the SkySQL/MySQL environment
  • SkySQL Configurator – configure and update SkySQL reference architecture modules
  • SkySQL Tuner – analyse the configuration and prepare the packages

I did a test, and it seemed like I got binaries built in under 5 minutes. Custom configurations with a stock build. You get a 70MB binary. Hosted at http://www.enovance.com/. A lot of people never configure their my.cnf, so I think having a GUI on the web might be a good idea to help people have sensible defaults.

lovegood:skysql byte$ ls
total 143352
drwxr-xr-x    3 byte  staff       102 14 Apr 06:13 ./
drwx------@ 598 byte  staff     20332 14 Apr 06:13 ../
-rw-r--r--@   1 byte  staff  73395132 14 Apr 06:12 SkySQL-mariadb-poboffcfrm5bi054559q8iea74.tar.gz

lovegood:skysql byte$ tar -zxvpf SkySQL-mariadb-poboffcfrm5bi054559q8iea74.tar.gz
x etc/
x etc/my.cnf
x install
x packages/
x packages/xtrabackup-1.4-74.rhel5.x86_64.rpm
x packages/MySQL-client-5.5.10-1.rhel5.x86_64.rpm
x packages/MySQL-server-5.5.10-1.rhel5.x86_64.rpm

SkySQL is also going to have a customer advisory board, and they are starting it this week. (I don’t know any further details about this as of yet.)

The SkySQL Configurator can only get better. I expect it will do custom packages including things like Sphinx/SphinxSE, Drizzle, and other things in due time.

DiGi’s awesome customer service

People are always in shock & awe when they find out that DiGi, one of the largest three telcos in Malaysia, had an employee that went out of their way to help me solve a problem in February 2011. So I naturally wrote to their CEO, Henrik Clausen, on Charlie’s can-do attitude. This was sent on 22 February 2011 14:35:10 GMT+08:00. I’m publishing it here so I don’t have to retell the story at bars, meetups, etc.

Dear Henrik,

As I am about to get on the same weekly call that I got disconnected from last week, I figured now is the best time to write a quick can-do note for one of your employees who went out of their way to solve my problem – Charlie Chia.

A little backstory. I’ve been a DiGi customer since March 2009, when MNP was enabled. It seemed time to become an Enterprise customer, so that was what I decided on the 10th or 11th of February 2011. My DiGi assigned provider told me that the numbers that were to be ported in would need new SIM cards but the current DiGi numbers should be fine.

On February 14, he was rather frantic that the DiGi SIMs also needed to be changed, but there was no way he could pass me the SIM cards then. On February 15 at about 4.30pm while I was on a conference call, my line went dead it just said “emergency calls only”. It was a public holiday of some sort, but I work most times when I’m in the country (I’m sure you understand running a business is tough and requires commitment).

I tweeted at about 5pm, thinking nothing of it. The @DiGi_Telco account seemed to also be on vacation. But what happened later was what was most amazing. Twitter user @CharlieChia told me that he will solve this problem for me, and by about 10.15pm or so, he brought the SIM card to me at Royal Oak in Jaya One, where I was wrapping up my second last meeting for the night.

Now that is service. And a total Can-Do for Charlie Chia

On the morning of the 16th February, I received all the other SIM cards for my accounts. All is well. We’re happy DiGI Enterprise customers now

And I am your loyal evangelist, because I cherish good service, and I ensure it is rewarded


i