open life blog
One of the greatest things with working in the MySQL community has been to meet so many people and travel in different countries and cultures. In my last blog post I mentioned how I learned that in Southern Europe it is considered offensive to go too early to meet your customer. As the customer is expecting you to come later than agreed (everyone always does), if you show up too early you are taking away time that he was expecting to still use to prepare for the meeting.
Below are the slides from my last talk at this Percona Live Worldwide MySQL Conference. The idea for this talk was proposed by my co-presenter Massimo Brignoli and goes back to a debate on this topic that went through the MySQL blogosphere during last Autumn - which in itself was sparked by an outstanding retrospective published about a MySQL failure at Github.
Slides from my Percona Live talk evaluating the new spatial features in MySQL 5.6 and MariaDB 5.5 are now online. This is new material I have never presented before. It is based on work I have done in my job at Nokia HERE.com location services. So even if at this conference it draws less attention than my HA talks, it is actually what I'm most proud of to present.
TL;DR summary is that PostgreSQL has lots of features but MySQL has much better ease of use and performance. (I copy paste this standard sentence into any PostgreSQL vs MySQL evaluation I do :-) The MongoDB info is basically outdated, as the new 2.4 release introduces completely new implementation based on GeoJSON, new indexing, neither of which I tested.
MySQL Community Awards 2013 were announced earlier today at the MySQL Conference & Expo...
It's time again to award persons, applications and companies in the MySQL Community. This is an annual tradition to highlight and give appreciation to some of the things that make MySQL so great.
The first awards were given out in 2005, and since 2010 the winners have been chosen by a community panel of which myself and Shlomi Noach are the co-secretaries. There has been a public nomination period in January and the final voting is done by a panel who are themselves former winners of the award.
The first category is
MySQL Community Awards: Community Contributor of the Year 2013
The first winner is...
Good morning Percona Live visitors! Attached to this post you can find a spreadsheet (both LibreOffice or Excel, as you prefer) that you can use towards the end of my tutorial. I've also attached the slides so you can download a copy of them.
For reasons that I will blog about in a couple of weeks, several people last week asked me what I think about open core. My answer was that nowadays I don't care much about the topic. Long time readers of this blog might be surprised at such an answer, so I thought this was a good time to reflect on why I don't think it is very important anymore, and more importantly to document the empirical evindence that we now have about open core as a business strategy.
As I hinted yesterday I've tried to automate the deployment of a sharded MongoDB cluster in Amazon. It's unnecessarily difficult (rumor has it 10gen is doing something about it in the future) but it's doable with appropriate amount of persistence.
I occasionally post so called "one liners", shell commands that can be used to filter out some data I need. The main reason I do this is that I can later find this when I try to google for it. This will be my first one liner for MongoDB. Ok, so it is actually 3 related one liners.
If you need to find out if a shard is already part of your MongoDB cluster, try this:
echo "db.shards.find()" | mongo $MONGOS/config | grep Shard4 | wc -l
The result will be either 1 or 0.
Now, if the shard exists, you might want to know a hostname and port number of one of the members of that replicaset: