It’s no surprise, MySQL users want more scalability and better manageability. Heavy use of Web, e-commerce and other applications calls for higher availability and capability, according to a recent survey sponsored by MySQL storage engine provider Solid Information Technology. We covered MySQL AB’s efforts to improve scalability in our February 2007 report on Falcon, the company’s own storage engine for high-end customers needing transactional speed and reliability. Thanks to open source, MySQL is not alone in responding, and all MySQL database users should eventually benefit from Google enhancements for better manageability and reliability. These patches are free and open source, available from Google, and will eventually make their way into official MySQL …

In the two years since we first created opentaps, we've had the opportunity to work with a number of companies large and small on implementing open source ERP and CRM solutions. In the process, we realized that most companies want the same things:

1. Bring together all the people in the organization
2. Automate their business processes
3. Record all the transactions taking place in the organization, both internal and external
4. Analyze that data to help make better decisions

As we had to the 1.0 release of opentaps, we've made a lot of progress in making this a reality. From Apache OFBIZ we have a very rich (and complex) data model and a scalable and stable framework for record enterprise data in large volume. We also now have a suite of opentaps modules which are designed around the way business users work, whether they are in sales, marketing, customer service, finance, warehouse, or …

Recently I have seen storage companies being evaluated at various occasions. I have talked to various vendors and their customers to get an idea of experiences, frustrations and most importantly, sustained performance. At this month's New York MySQL Meetup Marc Simony brought up something I hadn't heard of: SATA Beast. On a quick glance it seems it has some impressive features at what seems to be an amazingly low cost.

Update: To clarify, SATA Beast was of interest to me for storage solutions where sequential IO is needed, vs. random IO that is generated by databases such as MySQL. I was working on finding storage solution for our media, not databases. Using something like SATA Beast for our non-db storage will allow us to use 3Par solely for database purposes, the IO of which can then be further optimized.

Thank you, …

I'm not sure how I forgot this classic ditty from Bill Gates, but it does show a certain consistency in Microsoft's thinking...stretching over the last 31 years:As the majority of hobbyists [open source developers] must be aware, most of you steal your software...[Y]ou...prevent good software from being written. Who can afford to do professional work for nothing? What hobbyist can put 3-man years into programming, finding all bugs, documenting his product and distribute for free? [Red Hat, MySQL, JBoss, Alfresco, Zenoss, etc. etc.]...I would appreciate letters from any one who wants to pay up...Nothing would please me more than being... READ MORE

I manage /etc/my.cnf from a template id. Since I use servers in pairs, all master-master setups, I need to ensure that the server id is unique and consistent for the server mysql is running on. Managing the id's is a pain in the ass, especially when servers change roles. For instance rotating a server in from another cluster, or recovering a server from backup.

So, I create a my.cnf.tmpl file and that is deployed to all database instances.

The /etc/init.d/mysql script executes a perl script to generate my.cnf from my.cnf.tmpl right before a start executes.

!/usr/bin/perl -w 
#
#

use strict;


my $HOSTNAME = `hostname`;
chomp($HOSTNAME);

my ($name,$alias,$addrtype,$length,@addrs) = gethostbyname($HOSTNAME);

my ($a,$b,$c,$d) = unpack('C4',$addrs[0]);

my $cnfContents ='';
while(<>) {
    $cnfContents .= $_; …

Just a quick reminder for those of you located near Hamburg, Germany: on Monday, June 4th at 19:00 there will be our 7th MySQL Meetup. As usual, we will gather at the Chinese Restaurant "Ni Hao". This time, Sönke Ruempler will give a talk about the PHP-ORM-Framework "Propel". If you'd like to join, don't hesitate to RSVP via meetup.com or Xing.com right away! Thanks - see you there!

Since my last post I have been working on Pre-fetching relay binlogs to speed up MySQL replication. While I will be writing more and eventually posting my script, I wanted to mention that I am extremely satisfied with the results I am seeing. Very soon I will be posting a before and after graph so stay tuned.

I recently had the opportunity to return and speak at the Brisbane MySQL Users Group. I spent some time talking about MySQL User Conference 2007 Summary and Life as a Consultant. My summary of included:

• Overview
• Keynotes
• Marten Mickos - MySQL
• Guy Kawasaki
• Michael Evans - OLPC
• Rasmus Lerdorf - PHP
• Paul Tuckfield ? YouTube
• Community Awards
• Product Road Map
• Google
• Storage Engines
• Dorsal Source
• What’s Next

One question was posed to me. “What new did MySQL do this year?” being from the last User Conference. …

"But what happens if Microsoft sues us?"

"What if they shutdown the Internet?"

Both are examples of statements that have been IM'ed to me today.

Guess what, Microsoft is bluffing.

They say these things, and then hope people either people will switch
to Suse, or more likely question everything they are doing with open
source.

The Suse angle is new, and frankly I don't believe its very thought
out either.

Basically though, this is a shakedown.

I've been in several companies where we have gotten the MS form
letter that states "you are in violation!".

One company actually did ante up some cash to them. Paid the fee and
agreed to some IO audit every X number of years. It was pretty silly,
since once we admitted to the IP they had to spend a few weeks to
determine if we were even …

Microsoft speaks out on sotware patents and Linux. MySQL Conference survey shows scalability as top concern. Sybase and Red Hat partner for database appliance. (and more)

Scalability, Manageability Top Priorities for MySQL Users, Solid Information Technology (Press Release)

Sybase and Red Hat Announce Plans for Expanded Alliance to Unlock Customer Value, Sybase / Red Hat (Press Release)

Black Duck Software Extends Software Governance Leadership at Third Anniversary of Flagship Product’s Debut, Black Duck Software (Press Release)

OpenSEA Alliance …