One of the things I really like about Solaris (and OpenSolaris) is the Services Management Framework (SMF). And one of the things I like about my job is the opportunity to learn and work with new stuff. And, of course, the best way to learn something "non-lethal" is to try it yourself and do something with it.
So, how about using SMF for managing a MySQL Cluster setup? Something simple like two data nodes, one mgmt node, and one MySQL server node running on one OS instance? Sounds like a good exercise and, from a quick search, I couldn't find where it had been done before. Loaded up the latest release of OpenSolaris (2009.06) into a Virtual Box VM, downloaded the latest tar ball of …

In a prior blog post , I explained how the "open source + paid support " business model only works for software products that address extremely large markets. However, even those large market products rely upon a rich collection of niche market products that combine to deliver solutions.

As the book Crossing the Chasm explains, every technology product must make the move from its early adopter or hobbyist roots to a mainstream application. The hobbyists are willing to accept tinkering with the product to make it work, but the much larger mainstream market wants to buy proven solutions .

As John Donne once said, "no man is an island." Similarly, no software application is an island; each one relies on an orchestra of tools, applications and services necessary to …

This is the 150th edition of Log Buffer, the weekly review of database blogs. Someone accidentally left Dave Edwards‘ cage unlocked, and he escaped, thus leaving me with the pleasurable duty of compiling the 150th weekly Log Buffer.

Many people other than Dave are finding release this week. Giuseppe Maxia explains some details of MySQL’s New Release Model. Andrew Morgan announces a New MySQL Cluster Maintenance Release. Aleksandr Kuzminsky of the MySQL Performance …

A few days after Jaunty was pushed out of the door the new release cycle was opened soon after. Karmic repositories were set up and syncing packages from Debian unstable started. A lot of developers were busy preparing and attending UDS in Barcelona during the month of May. It didn’t prevent them to start merging packages from Debian. Here are some highlights from the archive:

No-change rebuild to gain FORTIFY defaults

kees has been busy uploading packages for no-change rebuilds. Intrepid saw the integration of some compiler hardening which are only applied if the package is rebuilt with the new toolchain. The  goal here is to have all packages in main rebuilt by the next LTS release to gain all the fortify defaults.

MIT krb5 update …

We are proud to announce the release our first Release Candidate of Workbench 5.1. After publishing another alpha version of Workbench 5.2 (the version that will include querying and administration) we have concentrated on getting 5.1 closer to GA. We have fixed 45 bugs since our last beta release and the last tweaks planned for the final product are in place now.

We are now tightening our release circle while moving closer to the planned GA date of the 5.1 version. We will release two additional Release Candidates at the end of upcoming two weeks and plan to complete the final GA build by the end of June - on all our major platforms.

Please head over to our Download page to get the new release and give it a try:

http://dev.mysql.com/downloads/workbench/5.1.html

For the complete list of …

In a prior blog post , I explained how the "open source + paid support " business model only works for software products that address extremely large markets. However, even those large market products rely upon a rich collection of niche market products that combine to deliver solutions.

As the book Crossing the Chasm explains, every technology product must make the move from its early adopter or hobbyist roots to a mainstream application. The hobbyists are willing to accept tinkering with the product to make it work, but the much larger mainstream market wants to buy proven solutions .

As John Donne once said, "no man is an island." Similarly, no software application is an island; each one relies on an orchestra of tools, applications and services necessary to …

This month in Database Journal we start a two part article on tuning the dials of your new MySQL database.  After you install and setup your first database, you’ll need to set various parameters in your my.cnf file.  These control memory, logfiles, temp table usage, sorting, joins, and a whole lot more.  We’ll review some of the more important wants and start you on your way to more nuanced tuning of your MySQL instance.

Read the article: Ten Dials To Set at DatabaseJournal.com

The example below shows how to export the entire data from a table into a CSV/TSV file.

# Generate CSV file

use database_name;

SELECT *
FROM table_name
INTO OUTFILE ‘/path/to/dumpfile.csv’
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

# Generate TSV file

use database_name;

SELECT *
FROM table_name
INTO OUTFILE ‘/path/to/dumpfile.tsv’
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'

If you need customized/filtered data (filtering data with where condition) then the SQL command is as follows


# Generate CSV file

use database_name;

SELECT *
FROM table_name
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH …

Yahoo opens up Hadoop distribution. Microsoft and Novell claim customer wins. And more.

Follow 451 CAOS Links live @caostheory

The elephant in the room
Plenty of news emerged form the Hadoop Summit this week, including Cloudera announced support for Amazon Elastic Block Storage (EBS) and introduced Sqoop, open source tool for importing databases into Hadoop, while Yahoo! Released! The! Yahoo! Distribution! Of! Hadoop! opening up its Hadoop developments to the wider community. As Savio Rodrigues noted, there has been a surge in the number of contributors for the Hadoop project in the last year.

Best of the rest
…

Platform: Linux/Unix

MySQL Server can create a number of different log files that make it easy to see what is going on. However, you must clean up these files regularly to ensure that the logs do not take up too much disk space.

To remove the 'error log', 'general query log' or 'slow query log', You can just remove the related files manually and then re-start the