Before MySQL 5.1 a UDF was the only way to extend MySQL. All you need in a UDF is: init() execute() deinit()my_bool id3_parse_init(UDF_INIT *initid UDF_ARGS *args, char *message) WARNING: use STRICT mode in MySQL, otherwise there are tons of silent failures.
They charge for some of their products because without money, they cease to exist, and then even the free version stops being developed on. “A necessary evil” is a dangerous phrase, and can lead to a slippery slope….but in this case, I do not envision that it is a big problem. Maybe I will regret saying this if things keep getting more and more closed, but I do not believe so.
Architecture of Maria: A New Storage Engine with a Transactional Design
Why the sandbox? To be able to set up 1 server in under 10 seconds. And to be able to set up multiple MySQL instances very quickly, and to use them quickly. The sandbox untars in seconds, for installing alternative servers, not main instance, it creates a separated environment (datadir, port, sockets) — for groups of related or unrelated servers. Really good for testing out new server versions. Save yourself some time and read this post to find out how to automate MySQL Sandbox!
Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. There are links to the slides and video in this post.
Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played from the embedded video at the bottom of this post or directly at YouTube (follow the link in this post)
Reading PlanetMySQL today, I discovered that Alex Gorbachev’s announcement that he has released the first public beta of his Oracle Grid Control plugin for MySQL was not aggregated! Knowing that my feed is aggregated, and not willing to let this news and this amazing work go unnoticed by the MySQL community during the conference (I am at MySQLConf listening to Amazon.com’s CTO speak right now!) you can access the update here.
has finally happened! The first public release of the MySQL plug-in for Oracle Enterprise Manager 10g Grid Control is out. In the last few months, more and more people showed interest in the potential plug-in, and even few guys from Oracle contacted me independently of each other with their own reasons to have a MySQL plug-in available. This interest accelerated the fermentation of thoughts in my brain, and I got down to work. Pythian generously sponsored my development time. Here are the details. The first release version is 0.42 because that’s obviously the perfect number to start something good.
If you can’t attend the MySQL Conference, you can still virtually attend. 2-3 pm PDT on Tuesday, April 15th for the “Best Practices for Database Administrators” session, and, 11:55 am -12:40 pm PDT on Thursday, April 17th for the “Database Security Using White-Hat Google Hacking” session. You need nothing but your web browser; unlike some other live meetings, audio streams from the website too, so there’s no phone number to call or participant code or anything. There’s also a live chat so you can participate and ask questions while the session is going on.
There’s no video for Jacob Nikom’s December 2007 Boston MySQL User Group meeting, but the slides for “Measuring MySQL Server Performance” can be downloaded here.