OurSQL Episode 74: Off the Charts, part 1

This week we kick off a multi-part series on monitoring. In this episode we discuss the MySQL Enterprise Monitor offering from Oracle and the MONyog offering from Webyog.

The Independent Oracle User Group is looking for nominations to the MySQL Council.

The next OTN Developer Day for MySQL will be Thursday, February 9th, 2012 in Frankfurt, Germany. Registration is free.

Percona announced the alpha version of Percona's XtraDB Cluster.

Gerry's 2010 presentation at the MySQL User's Conference and Expo about monitoring, the conference page has a link to PDF slides. Also, there is video of his Ignite talk (5 minutes) on 3 Basic Laws of DB Diganostics.

Nyquist's theorem
Heisenberg's Uncertainty Principle

MySQL Enterprise Monitoring


Sheeri's review of MONyog (note that it is a few years old)

Ear Candy
Innotop, and the online user guide

At the Movies
This week we share a second presentation by Baron Schwartz during a webinar about measuring performance and scalability with TCP. Baron reveals how you have everything you need with the simple tcpdump command and a few tools from the Percona toolkit. Part 2 of Measuring Scalability and Performance with TCP.

Where you can see us
Gerry will be at the February Seattle MySQL User Group on Monday February 6th from 7 - 9 pm. No subject has been set yet. Since the January meeting had to be cancelled at the last moment, it would be nice if you come prepared to share your MySQL year - like what you want to learn and what you’re planning on doing, such as upgrading.

Sheeri will be at the February Boston MySQL User Group on Monday February 13th from 7 - 9 pm. The meetup topic "Scaling MySQL with Transparent Database Sharding", by Liran Zelkha of ScaleBase. Every relational database has some machine scaling limits. In this month's meeting Liran will present the concept of Database Sharding - splitting the database to several independent databases, a solution proven highly effective for scaling MySQL. He will discuss the steps required for building a sharding solution, the implications and limitations of such solution, and will summarize by presenting ScaleBase solution to Database Sharding.