> install.packages("RMySQL", dependencies = TRUE)
> con <- dbConnect(MySQL(), user="msandbox", password="msandbox", dbname="sakila", host="127.0.0.1", port=5527)
> dbGetQuery(con, "select * from sakila.sales_by_store")
store manager total_sales
1 Woodridge,Australia Jon Stephens 33726.77
2 Lethbridge,Canada Mike Hillyer 33679.79
> sales_by_film_category <- dbReadTable(con, "sales_by_film_category")
> qplot(category, total_sales, data=sales_by_film_category, geom="bar", fill=category)
On October 15 and 16 I’ll take the ferry to be at the MySQL NoSQL Cloud conference in Buenos Aires, and the schedule looks really nice so far. I think it’s a great opportunity for people in this region to get up to date with what’s going on in the MySQL ecosystem, and to have good discussions with members of the community that aren’t usually around here.
I still haven’t decided my complete agenda, as in some cases it’s difficult to pick one track and miss the other one, but for now, here are some highlighted sessions I’m definitely attending:
- “Synchronize your data between MySQL and MongoDB”. Giuseppe’s sessions always include a live demo and I’m very interested to see Tungsten at work in an heterogeneous set up like this one.
- “Analytic/Big Data (Non-Full Text) Search with Sphinx”. I’ve always used Sphinx for full-text searches, so I want to get a fresh perspective on it. Unfortunately, this means I’ll have to skip my colleague Martin’s presentation on Percona XtraDB Cluster, but I have seen him deliver at the Montevideo MySQL Meetup so I’m covered If you’re new to PXC though, I’d recommend his session.
- Naturally, I must attend my own sessions “Proactive measures to minimize MySQL downtime” and “Percona Toolkit Recipes”. These are based on previous deliveries I’ve made, but updated, and in spanish.
- “TokuMX: Alta perfomance en MongoDB con Indices Fractales”. I’ll get to learn more about fractal indexes, and in spanish, what could be better here?
- “Percona Server 5.6 : New features and performance improvements”. Yes, I work with Vadim, but I don’t get to see him present too often If you don’t work with him and therefore don’t have a direct line to pester him with questions, this is a great chance!
There are many presentations I left out of the list, which does not mean they’re not interesting, just that I’m not sure I’ll be able to attend,since knowing myself, I’ll probably spend some time doing last minute tweaks to my talks, and/or helping others with theirs.
For people who will be attending and not worrying about presenting, the chance to see folks like Colin Charles, Ronald Bradford, or Monty Taylor presenting and to ask them questions should be priceless!
I’ll be attending Percona Live NY 2012 next month, co-presenting a tutorial with Marcos Albe (also from Percona) and a couple of sessions with Marcos and Ryan Lowe (of Square).
On Monday, Marcos and I will be doing a hands on tutorial on Percona Toolkit, and on Tuesday, Ryan will join us for a session on Percona Toolkit and one on MySQL performance optimization on EC2 and RDS.
High Availability MySQL Cookbook (Alex Davies, Packt Publishing) presents different approaches to achieve high availability with MySQL.
The bulk of the book is dedicated to MySQL Cluster, with shorter sections on:
- MySQL replication
- shared storage
- block level replication
- performance tuning
The recipes are clear and well explained, based on a CentOS distribution, and it seems any technically skilled person could follow them without issues.
What’s lacking are some design aspects. Based on this material, one probably wouldn’t be able to decide what the best high availability architecture is for a given problem. Actually, one may even be tempted to think MySQL Cluster is the best fit for most scenarios, given the percentage of the book dedicated to it. Nevertheless, there’s a section about Cluster limitations and potential problems, so the cautious reader won’t be tempted to choose this solution for every new project.
I also found that some important considerations regarding replication are missing.
The reader is instructed to rely on Seconds_Behind_Master alone to monitor replication, and there’s no mention to the situations that can cause as slave to go out of sync, nor of a process to fix this problem.
However, this book is a useful addition to any MySQL practitioner’s library, provided you don’t expect to rely only on it to design and deploy your MySQL based highly available services.