When we launched SkySQL at the company meeting in Istanbul, Turkey, in October 2010, I charged the SkySQL Team - then only 13 strong - to “Go Big, or Go Home”. Two weeks ago, while at our company meeting in Athens, Greece, as I listened to SkySQLers - now numbering 40 plus - share their experiences with customers, their ideas for new products and solutions, their suggestions for bettering the company, etc., I found it abundantly clear that the Team had taken my words to heart, and had exceeded my expectations.

It’s been six quarters since our launch, and the company has had a remarkable run. In this short time, we’ve increased our customers tenfold and have more than tripled our staff; we’re now serving customers in 30 countries around the globe. Additionally, thru numerous strategic partnerships with MariaDB and key MySQL ISVs, including Calpont InfiniDB, …

There is a great conference – SELF (South East Linux Fest) taking place in June 8-9 in Charlotte,NC
This conference has a great lineup for MySQL with 2 tracks on Friday dedicated to it. There are many great speakers both from Oracle and community on the list.
From Percona I will speak about Optimizing MySQL Configuration and Baron will talk about Forecasting MySQL Scalability from TCP Traffic.
See you there !

MySQL Innovation Day is June 5th and you should attend in you are in the vicinity of Redwood Shores, California. But if you are not in the area, you can catch the live webcast. By the way, did I mention this is all free!

Agenda
9:00 a.m. Welcome and Introduction
9:10 a.m. Keynote: What’s New and Cool in MySQL
9:40 a.m.

Lightning Talks

Better Availability with InnoDB Online Operations

Calvin Sun, Sr. Development Manager for InnoDB, Oracle

MySQL Replication HA: Global Transaction IDs for Failover & Self Healing

Lars Thalmann, Director of MySQL Replication, Backup and Connector Development, Oracle
Luis Soares, Sr. Software Engineer, MySQL Replication, Oracle

Pinterest: Growing from 0 to Billions of Page Views per Month in a Year …

Summary

The scalability enhancements delivered by extensions to multi-threaded data nodes enables MySQL Cluster 7.2 to deliver over 8x higher performance than the previous MySQL Cluster 7.1 release on a recent benchmark

What’s New in MySQL Cluster 7.2

MySQL Cluster 7.2 was released as GA (Generally Available) in February 2012, delivering many enhancements to performance on complex queries, new NoSQL Key / Value API, cross-data center replication and ease-of-use. These enhancements are summarized in the Figure below, and detailed in the MySQL Cluster New Features whitepaper

Figure 1: Next Generation Web Services, Cross Data Center Replication and Ease-of-Use

Once of the key enhancements delivered in MySQL …

The MySQL Connect conference is taking place September 29-30 in San Francisco. We asked a few questions about the event to Oracle’s VP of MySQL Engineering Tomas Ulin.

Hi Tomas, to start with, what is MySQL Connect?

A: MySQL Connect is a conference delivered by Oracle, with and for the MySQL Community. We’ll have over 60 technical breakout sessions, Birds-of-a-feather sessions and Hands-On labs running throughout the two days, plus the keynotes. So it’s a fantastic opportunity to learn a huge amount in only two days, and to network with Oracle engineers, users, customers and partners.

When will the program be available online?

A: The call for papers ended May 6 and we got an amazing response. The content committee has been working …

One thing still missing from the basic MySQL stuff is some more JSON oriented features. After some use of JSON (here at Recorded Future, JSON is THE data format), I have begun to accept this format, and have even begun to appreciate it. JSON really is a useful, flexible format that even it reasonably well standardized and has suport in most languages.

CSV used to the the obvious data exchange format for RDBMSes, but in the case of NoSQL, I sense that JSON is beginning to take that role, not only in the obvious JavaScript focued NoSQL databases such as Mongo. JSON is more object focused then CSV, is more standardized, has some better features and is in general more flexible.

Of course, a format with nested objects and arrays such as JSON would be hard to import into MySQL in the general case, at least if you want to expand arrays into lookup tables, and foreign keys constructs for keys etc. But export should …

I’m excited to attend the MySQL Innovation Day at Oracle headquarters in Redwood Shores next Tuesday. There are some great sessions planned on MySQL advances, including:

• InnoDB online operations
• Global transaction IDs for replication and failover
• NoSQL interfaces to InnoDB and NDB
• PERFORMANCE_SCHEMA improvements
• Optimizer enhancements

This is a great opportunity for MySQL users to get details straight from MySQL developers on upcoming features.  While the focus is entirely on what is being done in Engineering to drive MySQL forward, I’ll be around to chat about MySQL Support at the community reception in the afternoon.  If you’re a MySQL Support user, or just interested in learning more about the value MySQL Support can offer, stop by and say …

So what plans do you have next week ?

MySQL will have an event for you regardless of your location next week.
We start the week off in Germany at the Spring International PHP Conference. (June 3rd - 6th).  Ulf Wendel will be presenting two sessions: MySQL DB Cluster Usage made easy and  Extending MySQL: developing Server Plugins.

June 5th we have Oracle's MySQL Innovation Day at the Oracle Conference Center.  This event can be attended in person or via a webcast. The registration numbers are great so far so join everyone else who is attending and get an idea of what to expect at the …

Background Knowledge

Using the character set UTF-8 allows for the use of any language, can represent every character in the Unicode character set and is backward compatibility with ASCII. Not to mention is can handle any platform and be sent through many different systems without corruption. With such advantages this is why so many are making the switch.

The following instructions were done on Debian Squeeze v6.04 AMD64 operating system using MySQL v14.14 Distrib 5.1.61.

Solution – Server Configuration

At present MySQL is configured by default to use “latin1″ character set. Here’s how to change MySQL configuration to use UTF-8 character set and collation.

1. Check MySQL’s current configuration, run the following two SQL statements.

   1 2	SHOW VARIABLES LIKE '%collation%'; …

The US Department of Homeland Security (you know that fast growing entity that didn’t exist pre-2001, that no politician wants to be responsible for shrinking for fear of being blamed in case anything happens) has been forced to release their list of keywords they monitor. An article was published by the Daily Mail online: Hundreds of words to avoid using online if you don’t want the government spying on you

Relevance for this blog? Near the bottom, in the category “Cyber Security”, we spotted a keyword “Mysql injection”. How exciting!

Here’s a challenge for you: can you write an innocuous story containing as many words as possible from this list? You can post it as comment here. I will send the winner a copy of the “Manga Guide to Databases” book, which – …