The latest from the MySQL community

This is more of an "behind the scenes" update and I hope that you won't see any (negative) changes on the PlanetMySQL front page or the RSS feeds: I just finished and commited the conversion of the backend script that performs the parsing and aggregation of feeds from requiring MagpieRSS to SimplePie.

This will provide better support for a wider range of feed types and should also fix a few quirks, e.g. that some postings (for example the one from Kevin Burton) only showed up as an "A" in the Planet's RSS feed. It hopefully also fixes a weirdness with time zones that …

This is more of an "behind the scenes" update and I hope that you won't see any (negative) changes on the PlanetMySQL front page or the RSS feeds: I just finished and commited the conversion of the backend script that performs the parsing and aggregation of feeds from requiring MagpieRSS to SimplePie.

This will provide better support for a wider range of feed types and should also fix a few quirks, e.g. that some postings (for example the one from Kevin Burton) only showed up as an "A" in the Planet's RSS feed. It hopefully also fixes a weirdness with time zones that …

While we've seen a groundswell of support for the GNU General Public License (GPL) and its variants among commercial open-source companies, including MySQL, Funambol, Alfresco, SugarCRM, and others, Appcelerator is bucking the trend and changing from the GPL to the Apache Public License for its Rich Internet Application developer ...

I've mentioned Infobright before as an interesting solution to getting more performance to BI analytics solutions. Today's news are interesting: Sun invests in the company, and the baseline product is open sourced. Too busy to write more about it today, but I'm certainly watching this one closely.

In a previous post, I was trying to figure out the most optimal way to switch from two large innodb table space files to using innodb_file_per_table to take advantage of some of the benefits of this setting. I had one part of it solved, which was to stop MySQL, add innodb_file_per_table to the my.cnf, then restart, perform a "no-op" alter of "ALTER TABLE t1 ENGINE=InnoDB" which would cause the table to be re-created an it's own .ibd file. The remaining problem was how to be able to resize the huge table space files after converting all the tables to a smaller size (in my case from 10GB to 10MB).

Someone suggested a better way:

1. Alter all innodb tables to MyISAM
2. Stop the server
3. Add innodb_file_per_table to my.cnf
4. Change innodb_data_file_path to new settings (10MB tablespaces) in my.cnf
5. Move all innodb files (logs, data) to a backup directory
6. Restart MySQL
7. Alter …

It’s been over two years since I left MySQL to work for Message Systems and I’ve really been happy with things here. I work with a great team on interesting work for a good company who treats us well. Not much more you could ask for.

Except for more coworkers. We’re in need of a few new additions to the 2009 team:

We need engineers and tech trainers, scroll down for the details. If you’re interested send an email to mike@thisdomain!

Technical Trainer / Curriculum Developer

This position designs, develops and delivers online and in-person instructor led trainings on the Message Systems products and services for a variety of audiences including customers, partners and internal staff.
You will design courses and instructional material for everything ranging from short informational quick-
starts to multi-day workshops.
The audience for these training programs will primarily be mid-senior …

Rumors circulate that HP is building a desktop version of Linux to compete with Mac and Windows. READ MORE

It’s been over two years since I left MySQL to work for Message Systems and I’ve really been happy with things here. I work with a great team on interesting work for a good company who treats us well. Not much more you could ask for.

Except for more coworkers. We’re in need of a few new additions to the 2009 team:

We need engineers and tech trainers, scroll down for the details. If you’re interested send an email to mike@thisdomain!

Technical Trainer / Curriculum Developer

This position designs, develops and delivers online and in-person instructor led trainings on the Message Systems products and services for a variety of audiences including customers, partners and internal staff.
You will design courses and instructional material for everything ranging from short informational quick-
starts to multi-day workshops.
The audience for these training programs will primarily be mid-senior …

Until this week Infobright’s claim to open source fame was its partnership with MySQL that enabled its analytical data warehousing software to act as a storage engine for the open source database.

However, the company is now taking the open source route itself by releasing the code behind its Infobright data warehouse (formerly Brighthouse) as Infobright Community Edition.

Earlier this month the company announced that it was moving to a subscription model for the commercial version of the product, Infobright Enterprise Edition, which comes with “enhanced features, services and support, warranty” amongst other things.

The company has also announced a $10m Series C investment …

If you’re already building LAMP applications (linux/apache/mysql/php), and you’re looking to port them to Oracle, or you’re new to this technology stack, and you want to use Oracle as your database, this article is for you.  We cover the basics of gettings started, and where to look for more information.

Intro to PHP + Oracle - Database Journal - Aug 14, 2008