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||…|
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!
Oracle released many …
This year again, MySQL will be represented by its Community.
If you want to discuss with friend’s of MySQL it’s the place to be in February !
Like every year, FOSDEM takes place the first week-end of February in Brussels.
The MySQL and Friends devroom is Room H.1309 (150 seats). We (the MySQL Community) will have the room on Sunday 5th February 2012, all day.
We are organizing a MySQL & Friends dinner on Saturday night, more to come later on this.
If you want to propose a talk (you are in fact invited to propose
one !), the deadline is December 26th.
Like we did on past editions, as soon as the talks are submitted, we will ask everyone to vote on the talks via …
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 be covering questions such as what cloud computing is, what EC2 provides, what is datacenter automation and the …[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:
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
Oracle Technology Days – Toronto
August 25, …
Oracle is running MySQL seminars during the next few weeks in Europe! Those free events represent a great opportunity to learn, to meet Oracle’s MySQL team members face to face & have all your questions answered, and to network with other MySQL users & customers.
Here are the details and how to register:
- Rome, May 19th - Register here
- Zürich, May 25th - Register here
- Langen (near Frankfurt), May 26th – Seminar dedicated to channel partners - …[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.
None, it’s a free event! But places are limited and the seminar is …
Only few more hours, it is almost here. The long awaited Reference Architecture from SkySQL is going to make its first appearance at the MySQL User Conference in Santa Clara this week.
SkySQL is going to contribute to the evolution and innovation of MySQL from both coasts of the United States. A total of 10 between presentations, tutorials and events will help the MySQL users in Santa Clara and in Orlando in understanding how they can leverage the use of MySQL, improve performance, scalability and high availability. You can find the complete schedule of the MySQL UC and Collaborate 11 here (UC) and here (C11). Regarding the SkySQL …[Read more]