mysql podcast

Episode 2 of OurSQL: The MySQL Database Podcast is here! It’s a bit late due to a computer crash and the fact that I sprained my ankle, but I think it’s worth waiting for. Particularly since this week’s feature is everyone’s favorite — performance tips!

It’s best to subscribe to the podcast by clicking the “podcast” graphic at http://www.technocation.org , or searching for “mysql” in your favorite podcast directory (including iTunes). But if you want to play episode 2 in your browser, visit http://technocation.org/index.php?option=com_content&task=view&id=22&Itemid=29

Please consider promoting the show — we have a 40 second promo ready for download at:

http://www.technocation.org/podcasts/oursql/OurSQLpromo1.mp3
Show …

From time to time I receive requests from friends who are interested in learning more about managing MySQL on Solaris 10. To help them (and myself), I am planning to write about the internals of both MySQL and Solaris.

So if you have any questions that relate to adminstering and managing MySQL on Solaris, post them as comment, and though I don't promise, I will do my best to answer them.

What I usually recommend my friends is that they should start learning by finding a good authoritative book. In my opinion, reading one good authoritative book on the subject is better than reading three normal books.

BTW, I used to spend a lot of time finding the right book before buying it. Earlier this year I signed up for Safari Books Online (by O'reilly). My membership gave me a ten slot bookshelf. I …

Very few of the times I have spoken has it been caught on tape, and
in this case it wasn't when I was trying to say something brilliant:
http://blip.tv/file/115874

This is from the http://igniteseattle.com/ event that happened in
Seattle last week. Brady should be thanked, it was a lot of fun.

A couple of thoughts:

1) I work on Apache modules, not directly Apache (and while I have
been asked to donate code I never have). Someone is likely to
nitpick, so I mention this.
2) Somehow in my head I was trying to get out "geeks who go into
basements and create incredible things". Its like the myth of Silicon
Valley inventors who go off into garages and come out with billion
dollar companies (and I don't know where Mark lived when he …

We’ve been getting some nice feedback on our recently introduced Monitoring and Advisory Service that’s part of MySQL Enterprise. In talking with many of you, I know anything that makes MySQL less of a black box with respect to what’s going on underneath the covers is welcome.

If you’re a MySQL DBA or a dev/sysadmin who’s got the responsibility of taking care of one or more MySQL servers, check out the latest article I wrote on our dev zone that highlights some things in our new service that you’ll likely find appealing. And as always, let me know what you think so we can keep making things better.

MySQL 4.0 has now reached the final stage of its active development life cycle. As I noted on 12 July 2006 when announcing the MySQL Lifecycle Policy, keeping legacy versions of our software alive is expensive and time-consuming. While we know that database administrators hate to upgrade their databases, we believe that the vast majority of our customers and our community are better served by us focusing our attention on newer releases. However, we don’t want to abandon users of our older products — so we are asking them to help subsidise the cost themselves.

This means that those who wish to continue to receive our support for MySQL 3.23 and MySQL 4.0 will need to be covered by a MySQL Enterprise subscription, starting 1 Oct 2006 for MySQL 4.0.

In …

We'll have a MySQL Miniconf at LinuxConfAU 2007 in Sydney on Monday, January 15th, before the conference proper starts. Some weeks ago we posted a call for papers and we've received excellent submissions! There's a few slots left - so if you were pondering putting in for a talk, now is your (last) chance....

Please submit an abstract of your suggested presentation via email to
m y s q l - m i n i c o n f ( a t ) m y s q l . c o m

(see also my original post)

Chad and Brian have already mentioned how MySQL does indeed support Debian and Ubuntu, but I thought I would add my thoughts on the secret measure of how well an OS is truly supported.

Regardless of what is on the checklists and the advertising and everything else, the best supported operating systems and configurations are the ones that the developers themselves actively use. You better believe that when a bug pops up on the operating system I use on my desktop, it’s going to be fixed a lot faster than a bug I can’t see on a more obscure platform. I’ve believed this for a long time, and that is why I have done things like send 64-bit Windows machines, OpenSolaris machines, etc. to developers for daily use in order to improve the quality of our Windows and Solaris …

It's been a while since I released an update to innotop, but I have not been idle. I'm currently working hard to add major new features and functionality. Here's a quick list of what's coming.

This morning I am working on a bug with Monty Taylor for a customer
who is having an issue with multi-cpu capabilities on Debian. Which
makes me surprised to read:
http://developers.slashdot.org/developers/06/12/13/1515217.shtml

Huh?

MySQL supports Debian. We have in the past and we will continue to do
so in the future. As this link points out:
http://developers.slashdot.org/developers/06/12/13/1515217.shtml

We don't build Enterprise binaries on debian yet. The Enterprise
project is new and we are just starting to roll out binaries for it.
Ubuntu is on schedule to be supported next year (I believe first
quarter). We don't build binaries for Debian in …

I just got word today that I will be speaking at the 2007 MySQL Conference.

I’ll be doing a three hour tutorial version of my popular 2006 session on Managing Data Hierarchies (strangely they backdated my title in last year’s session listing; I was a Technical Writer for MySQL AB at the time).

This year session I plan to add more depth to the existing methodologies I cover as well as cover additional methodologies for managing hierarchical data in MySQL.

Last conference the session was standing room only and I entertained several requests for additional information when the session was complete, so I hope this next session will be equally well received and I look forward to meeting old friends and associates.

See you there!