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
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
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.
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!
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 …
[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
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 …