Simon Phipps, Sun's Chief Open Source Officer, speaks to The Wall Street Journal.

I just checked the "Sun Contributor Agreement" (SCA) signatories list, and there are already 11 people who have signed the contributor agreement with an intent to contribute to MySQL.

Among the signatories, you will also notice Paul McCullagh of PrimeBase/PBXT fame. (To learn about how to submit your SCA paperwork, see here.)

Signing the SCA with an intent to contribute to any given Sun-sponsored open-source project would also suffice when it comes to contributing to any other Sun-sponsored open-source project.

So, as an example, Nils Goroll is both an OpenSolaris and MySQL contributor. (See Nils' OpenSolaris …

I just checked the "Sun Contributor Agreement" (SCA) signatories list, and there are already 11 people who have signed the contributor agreement with an intent to contribute to MySQL.

Among the signatories, you will also notice Paul McCullagh of PrimeBase/PBXT fame. (To learn about how to submit your SCA paperwork, see here.)

Signing the SCA with an intent to contribute to any given Sun-sponsored open-source project would also suffice when it comes to contributing to any other Sun-sponsored open-source project.

So, as an example, Nils Goroll is both an OpenSolaris and MySQL contributor. (See Nils' OpenSolaris …

I just checked the "Sun Contributor Agreement" (SCA) signatories list, and there are already 11 people who have signed the contributor agreement with an intent to contribute to MySQL.

Among the signatories, you will also notice Paul McCullagh of PrimeBase/PBXT fame. (To learn about how to submit your SCA paperwork, see here.)

Signing the SCA with an intent to contribute to any given Sun-sponsored open-source project would also suffice when it comes to contributing to any other Sun-sponsored open-source project.

So, as an example, Nils Goroll is both an OpenSolaris and MySQL contributor. (See Nils' OpenSolaris …

Today I come back from the dentist, if that wasn’t bad enough news, I get an email from Google AdWords titled Your Google AdWords Approval Status.

In the email, all my AdWords campaigns are now disapproved, because of:

SUGGESTIONS:
-> Ad Content: Please remove the following trademark from your ad:
mysql.

Yeah right. I can’t put the word ‘MySQL’ in my ads. How are people to now find me? It would appear that many ads have been pulled not just mine. Is this a proactive measure by Google? is this a complaint from the MySQL trademark holder Sun Microsystems?

I’d like any comment, feedback or suggestions on how one can proceed here.

It reminds me of the days CentOS advertised itself as an “Open source provider of a popular North American Operating System”, or something of that nature.

The MySQL marketplace today is far more complex then simply choosing between a particular version of MySQL that Sun/MySQL produces.
The MySQL server product in general is released under the GNU General Public License (GPL) v2, however you should carefully review the MySQL Legal Policies as a number of exceptions and different license agreements operate for companion tools such as MySQL Cluster, MySQL client libraries and documentation for example.

Looking into the MySQL ecosystem for products, I’ve produced the following categories:

• Sun/MySQL Official Products
  • MySQL Versions
• MySQL Variants
  • Community
  • Enterprise
  …

I’ve just started using the CSV engine for a practical application and I’ve come across a few subtle and unexpected issues/limitations.

First, you can’t create any columns in your CSV table nullable.

mysql> create table t1(i INT) ENGINE=CSV;
ERROR 1178 (42000): The storage engine for the table doesn't support nullable columns

RTFM shows this was introduced in 5.1.23. See CSV Limitations

The second and more annoying was creating a CSV table, inserting a sample row (just to check the syntax), then replacing the file ([datadir]/[schema]/[table].CSV) with the same format, but with additional generated rows. This was to no avail when attempting to SELECT from the table.

The solution was to do a REPAIR TABLE [table] in order to see the newly refreshed data.
Futhermore, some more RTFM shows in …

The March NY MySQL Meetup featured a presentation from Infobright, a data warehousing solution built on the MySQL Product.

With a pitch of “Simplicity, Scalability and low TCO” I became more impressed with the capability to delivery on these as the presentation proceeded. Here are some highlights.

• The company and product has been around for a few years. Infobright started as a compression engine to sit beside Teradata, providing a significant cost saving to clients, and allowing a two way data transfer between Teradata.
• In September 2008, a open source community edition was released, called ICE. (Which I didn’t know)
• The technology is based on a Rough Set theory, a mathematical approach
• Using a …

I was having problems recently with a dedicated production server, that runs my MySQL Server and a number of websites. It’s most annoying when your system crashes without any reporting in /var/log/messages

The tool of choice from the host provider SoftLayer was PassMark BurnInTest Linux which is installed with every dedicated server.

I will need to investigate open source alternatives, as this is a commercial product, but for the purposes of my pain, this included tool was well worth the investment.

**************
RESULT SUMMARY
**************
Test Start time: Sun Feb 22 16:02:48 2009
Test Stop time: Sun Feb 22 16:07:49 2009
Test Duration: 000h 05m 01s

Test Name Cycles Operations Result Errors Last Error
CPU - Maths 261 488 Billion PASS 0 No errors
Memory (RAM) 2 3.081 Billion FAIL 1 Error verifying …

Monitoring MySQL Memory is a rather critical task because you can’t limit MySQL’s usage of physical memory resources. Improperly configured servers running MySQL can crash because you don’t understand memory usage.

MySQL uses memory in a number of different ways. Using the Oracle analogy, you can divide the mysqld memory usage into main areas of:

• SGA - System Global Area
• PGA - Process Global Area

The SGA is the footprint that MySQL uses for startup. This is attributed to the base footprint of the mysqld process and a number of buffers including:

• key_buffer_size - For MyISAM Indexes (note you can define multiple key_buffer’s The MyISAM Key Cache) …