MySQL

Using the Sphinx Search Engine with MySQL

Implementing SphinxSE into MySQL proved to be easier than it seemed in the beginning, although it took some time to compile and install everything. With a creative use of views, it could potentially be implemented right away in legacy applications, offering numerous advantages.

MySQL 5.1 and InnoDB Hot Backup Gotcha

Recently while we were building a slave with a newer version of MySQL 5.1 from an InnoDB Hot backup an error occurred The problem is, in MySQL 5.1, it is possible to log the slow query log and general log to tables in the mysql schema. These tables are created by default as CSV tables for performance reasons, even if MySQL is set not to log to tables. CSV tables, however, are not copied as part of the InnoDB Hot Backup process, creating this error. Here is the fix to get the slave working

OpenSQLCamp 2009 presentation videos are online and free!

In record time, less than a week after the conference, all 11 videos that were taken at OpenSQLCamp Europe are online, for those who missed the sessions, or just want to relive the fun! The YouTube videos have the descriptions and resources from the official conference pages, and links to pages. If there is more information to add (for example, the slides from a talk are now online), or if you spot an error, please feel free to add a comment on the YouTube video, or as a comment to this blog post.

Video: Giuseppe Maxia Presents MySQL 5.4

At the May 2009 Boston MySQL User Group, Giuseppe Maxia of Sun Microsystems gave a presentation about MySQL 5.4 with use cases and benchmarks to show how it outperforms all other current MySQL releases (including the Google patches and the OurDelta/Percona releases). Links to the slides and video can be found here.

Dependence on MySQL Documentation

I think many people truly realized how much they take the MySQL documentation for granted during the recent multi-hour outage from mysql.com’s data center. Apparently there is a lot of FUD floating around about the legality of mirroring the documentation…

Pythian Goes to FISL 10

This year, the International Free Software Forum celebrated its 10th anniversary. It happened last week in Porto Alegre. Pythian presented a session on Thursday called 8 Rules for Designing More Secure Applications with MySQL. As promised, here are the slides we used on that session: 8 Simple Rules to Design Secure Apps with MySQL.

Page 14 of 36« First...1213141516...2030...Last »