Database sharding, used by Facebook, Tumblr and Mozilla, is an incredibly powerful way to ensure MySQL systems scale-out and drive consistent, fast app performance to handle more users, more data, and more workloads. But home-grown sharding is hard, full of caveats, and very often ends up as non-cost effective.     ScaleBase provides an easy to use platform [...] Read More

On Thursday, I will travel to Boston, MA, to attend the Northeast LinuxFest, which includes also an edition of the Open Database Camp. The events will be at one of my favorite places on earth: The Massachusetts Institute of Technology, a.k.a. the MIT. Every time I speak at an event there, I feel at home, and I look forward to be there once more.

The Open Database Camp is organized, as usual, with the formula of an un-conference, where the schedule is finalized on the spot.

There are a few ideas for sessions. I have proposed two of the topics I am most familiar with:

  [Read more...]

Once again, Pythian is organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week.

Here are the details:

What: The MySQL community pay-your-own-way dinner
When: Tuesday April, 23 – Meet us at 6:30 pm in the lobby of the Hyatt Santa Clara, or at 7 pm at Pedro’s (you are welcome to show up later too!)
Where: Pedro’s Restaurant and Cantina – 3935 Freedom Circle, Santa Clara, CA 95054
How: Comment on this blog post to add your name to the list of probable attendees

Pedro’s can handle large groups of people, but we would like to have an idea of

  [Read more...]

The last MySQL User Group NL meeting was last Friday. It's always nice to learn about MySQL and meet other MySQL users. There were two presentations: one about MySQL User Defined Functions (UDF's) and one about MySQL TCO. The slides are available from the meetup page.

There are already a number of MySQL events announced for the next few months. I'll only list events in the Netherlands and Virtual events.

MySQL Virtual Developer Days
This is a virtual event which will take place on March 19 (EMEA region, NA event is on March 12). There are many interesting topics: Performance Schema, New 5.6 Features, Replication, MySQL Enterprise Monitor
The eVite

SkySQL and MariaDB roadshow
21 March 2013 in Amsterdam
This event  have









  [Read more...]

Thousands of new online and mobile apps launch every day…but what happens when demand climbs and databases can’t keep up?   Matt Aslett of 451 Research will discuss: Scaling-out your MySQL databases New high availability strategies Centrally managing a distributed MySQL environment Matt is the Research Director for Data Management and Analytics at 451 Research, covering operational and analytic databases, with a [...] Read More

This webinar will examine the benefits of Read-Write splitting. 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 – translation: Database performance [...] Read More

Choosing a Next-Gen Database: The new world order of NoSQL, NewSQL & MySQL Tuesday, November 13, 2012, 12:00 PM – 1:00 PM EST The database market is becoming increasingly complex and is changing on an almost daily basis.  Matt Aslett is the Research Manager for Data Management and Analytics at 451 Research.  He has overall responsibility for the coverage [...] Read More

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

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 the 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 (

  [Read more...]

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.  

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  [Read more...]

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


  [Read more...]

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! Sunday 2012-02-05 Event Speaker Room When All you need to know about migrations and you never dared to ask Ralf Gebhardt   [Read more...]

I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

Summary:







  [Read more...]

Read the original article at Seattle Web Tech Meetup Nov 21

I'll be one of two speakers at the next Seattle Web Technology Bi-Weekly Meet up on Nov 21 at the Citrus Lounge.

They've sexed it up a little by calling it a face-off between Windows Azure and Amazon EC2  (no prizes for guessing which side I represent) but really it's going to be a primer on the Platform-as-a service and Infrastructure-as-a-service models. I expect some lively discussions during Q&A.

I'll

  [Read more...]

It’s a busy summer at Pythian, with our continuing wave of speaking sessions at upcoming community and regional industry events.

Coming to a city near you, watch for Pythian presenting hot Oracle and Microsoft SQL Server database topics:

IN CANADA:

Oracle Technology Days – Montreal
August 9, 2011 – 8:30am – 1pm, Hilton Montreal Bonaventure

• 11:00 am – Join Marc Fielding for Mixed Workload Management for Oracle Exadata
• More Pythian Oracle Exadata resources
• View the Evite
• Register/Inscrire

Oracle Technology Days – Toronto
August 25, 2011

  [Read more...]

MySQL, the world's most popular open source database, powers today's most demanding web sites and applications. With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL.
Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools.

Register now for this seminar that will be held in Rome on the 19th of May. Agenda and location details are available on the event registration page.

Cost?
None,





  [Read more...]