|
This week we present how to use pt-archiver and pt-find, two Percona Toolkit tools. We focus on the common usage of the tools and the gotchas we ran into using them.
News/Events/Feedback
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!
This week we talk about MariaDB - explaining features, and comparing to Percona's patched MySQL and Oracle's MySQL. MariaDB is touted as "a better MySQL, not a different MySQL". MariaDB is the 2nd most popular open source database, even more popular than Postgres.
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!
This week we talk about package and configuration management with MySQL.
News/Events:
Don't forget to send us questions to answer for future versions of Ear Candy, see the "Feedback" section below.
There are 2 free webcasts on Efficiently deploying new MySQL applications on Windows coming up: in French on Thursday April 5th and in German, on Thursday, April 19th.
News:
Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.
Percona's XtraDB cluster announcement
XtraDB Cluster at the San Francisco MySQL Meetup on Wednesday, March 21st
XtraDB Webinar on Wednesday April 4th
News/Feedback:
This week we have some fun audio feedback from Patrick Hurley, a MySQL DBA in the UK.
The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the Santa Clara, CA Convention Center. Early bird pricing ends March 12th, 2012. Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule.
This week we play a bunch of bloopers, some you have heard, some you haven't, as our year-end gift to you. We hope these make you laugh!
This week, we continue our discussion about MySQL and its forks. We discuss the Percona server and MariaDB.
Percona Live comes to Washington, DC on Wednesday, January 11th, 2012 at the Walter E. Washington Convention Center. There is a 50% discount for students, faculty and staff of educational organizations, and a 35% discount for government employees. http://www.percona.com/live/dc-2012/
Percona Server
Percona software
Reminder: Due to busy summer conference schedules, we are going to be publishing the podcast every other week.
This week we talk about a monitoring plugin from PalominoDB that uses caching (like the cacti templates) and allow for arbitrary calculations of thresholds based on status and system variables, and items from the PROCESSLIST.
Nagios
pnp4nagios - from the site, "PNP is an addon for the Nagios Network Monitoring System. PNP provides easy to use, easy to configure RRDTools based performance charts feeded by the performance data output of the Nagios Plugins."
This week, Sarah's off, and Sheeri interviews Brian Aker of Data Differential, mostly about the MySQL Ecosystem.
Among the topics discussed are whether the MySQL Ecosystem has peaked yet, the exciting talks coming up at the O'Reilly MySQL Conference including the state of the community keynote, and when the Drizzle software is going GA.
Some parts of the MySQL Ecosystem that were mentioned:
phpmyadmin
Percona Server
Percona free InnoDB hot backup tool
OpenDatabaseCamp, also known as OpenSQLCamp - http://planet.mysql.com/entry/?id=26922 will be held in Sardinia, Italy on May 6-7-8, 2011.
Google Group for OurSQLCamp: http://groups.google.com/group/opensqlcamp
Manual chapter for subqueries in MySQL - http://dev.mysql.com/doc/refman/5.1/en/subqueries.html
The WorkLog entries for “subquery” http://forge.mysql.com/worklog/search.php?t=tds&k=subquery&v=0&s=0&p=0
All are low/medium priority. out of 29 worklog items, 9 are complete, almost all are scheduled for 6.0. Of the remaining 20, 1 is in progress, 4 are in the in-design stage, another 4 are simply “assigned”, 11 are unassigned. None are on hold or cancelled, so that’s good.
In the past few days it has come to my attention that some people are having problems with Percona's blog at http://www.mysqlperformanceblog.com. I was told that trackbacks seem to be broken and some comments were not showing up.
Anyone else having any problems with what looks like censorship? [edit: trackbacks were a technical error, Dave's comment was trapped in a spam trap. Still looking for people to comment whether or not they're seeing a similar issue, as it's important for people to check to see if their comments are showing up.]
Giuseppe Maxia spoke at the May 2009 Boston MySQL User Group about MySQL 5.4 and what it can do, the new performance features, etc.
Video for the presentation at the 2009 MySQL Conference:
Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)
The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009
Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.
The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.
From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:
We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.
Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.
The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.
From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:
We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.