This webinar will examine best practices around scaling MySQL databases. To register, click here. There are thousands of new online and mobile apps launching every day…but what happens when demand climbs for these apps and databases can’t keep up?  The long-term success of any app hangs on a company’s ability to provide uninterrupted access and availability – [...] Read More

Latest training class schedule & events calendar just published

We’re excited to see that it’s going to be a busy time for the MySQL & MariaDB communities over the coming months! Plenty of community events are taking place, and we’re doing our best to support and attend most of them.
With that in mind, this is where you’ll find the SkySQL Team, often in cooperation with the MariaDB Team, at the following events in the coming months:

read more

Oracle OpenWorld 2012 is just over a month away, and yes, we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld.

What: Oracle Bloggers Meetup 2012

When: Wed, 3-Oct-2012, 5:30pm

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 ( …

Tuesday, September 18, 2012, 6:30pm – 8:00pm 

Cambridge Innovation Center,  1 Broadway, Cambridge, MA (map) http://www.meetup.com/boston-java/events/75357012/ Doron Levari Doron will be speaking at the Java Meetup.  Doron is a long-time veteran of the database industry and the publisher of the Database Scalability Blog, has extensive experience in building and scaling-out database systems as well as the organizations and infrastructure necessary to support them.  Please find a [...] Read More

October 1-2, 2012 New York Discover the Power of MySQL » MySQL is the world’s most popular open-source database, powering web-scale applications such as Facebook, YouTube, and Twitter. MySQL continues to evolve rapidly, reaching more markets and powering more applications every day. Click here to register for the conference.  

The SkySQL & MariaDB: Solutions Day for the MySQL Database (the first of its kind) took place last Friday (April 13th) in Santa Clara, and we’d like to thank everyone who attended, participated and generally helped make it the successful day that it was!

read more

The SkySQL booth ready for the stampede of visitors that stopped by each day.

We hope it was as productive and fun for all of you as it was for us at SkySQL! We started out the week at Percona Live, which was an excellent conference. Thanks to the Percona folks for making this a great get-together for the MySQL community. Excellent job, guys!

We welcomed two new partners, hastexo and PalominoDB, which means our customers will see even better MySQL service and support with SkySQL. And many of our current …

On March 21st I will be in Paris, to attend the OTN MySQL Developers Day. Oracle is organizing these events all over the world, and although the majority are in the US, some of them are touching the good old European continent. Previous events were an all-Oracle show. Recently, the MySQL Community team has been asking for cooperation from the community, and in such capacity I am also presenting at the event, on the topic of testing early releases of MySQL in a sandbox. Of course, this is one of my favorite topics, but it is quite appropriate in this period, when Oracle has released a whole lot of preview features in its MySQL Labs. Which is another favorite topic of mine, since I was the one who insisted for having the Labs when I was working in the …

I was recently talking with a few people and the concept of summary tables came up as solutions for them. The issue is, they never thought of it. Hopefully this post will help them as well as others.
Summary Tables are not a new concept. They are exactly what they sound like, basically summary of existing data. Aggregated tables, materialized views and summary tables are very dominate in data warehouses. You can also take advantage of these concepts as part of your reporting systems as well.
So summary tables are real tables. So you can take advantage of indexes and etc with them. In the examples I am using, I consider them more of a summary table than aggregated tables . Depending on your application and needs it could grow into more of an aggregated tables and or materialized views situation.
How you separate your data and tables is dependent on your reporting and application needs.
The following is a high level example of …

The MySQL DevRoom at FOSDEM is ready. The schedule has been voted. Thanks to all who have participated. Now, let's make sure that the event is successful. The schedule is juicy, and not only because I have three talks in it!