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:
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[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.
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!
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![Read more]
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 …[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
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!
|All you need to know about migrations and you never dared to ask||…|