The latest from the MySQL community

1. Download and install BitKeeper. There is a guide here explaining how to download and install it.
2. Using BitKeeper the execute the command:
   

       bkf clone bk://mysql.bkbits.net/mysql-5.1 mysql-5.1

   to download the latest MySQL 5.1 source tree to directory "mysql-5.1".
3. Change directories into "mysql-5.1" and run: BUILD/compile-pentium-gcov

4. If you encounter any errors in the build process my previous post has a list of a dependencies that cause a few common compilation errors.
5. To run the test suite run: make test-force-full
6. Download lcov from http://sourceforge.net/project/showfiles.php?group_id=3382
…

I realized when I released my very crappy version of My ?hourly? MySQL monitor script I really should have included my standard logging.

So I did that the night I wrote my original blog, but never published it. I’ve had need to use it again today, so a few more usability tweaks for parameterization and we are good to go.

Now Version 0.03 includes three files:

• hourly.sh
• common.sh
• mysql.conf

Simple use is:

$ cd /directory
$ vi mysql.conf
# correctly specify MYSQL_AUTHENTICATION
$ chmod +x ./hourly.sh
$ nohup hourly.sh &

This gives you the following files

-rw-r--r-- 1 rbradford rbradford  2643 2007-05-29 15:47 mysql.innodbstatus.070529.154757.log
-rw-r--r-- 1 rbradford rbradford   414 2007-05-29 15:47 …

I realized when I released my very crappy version of My ‘hourly’ MySQL monitor script I really should have included my standard logging. So I did that the night I wrote my original blog, but never published it.

I realized when I released my very crappy version of My ‘hourly’ MySQL monitor script I really should have included my standard logging. So I did that the night I wrote my original blog, but never published it.

Q from Olivier - Are the data nodes MySQL servers too ?
No, the data node is handled by a separate process, ndbd, that only manages data.

Q from Olivier: So, what is MySQL Cluster? A MySQL AB product ?
Technically speaking, MySQL Cluster is a storage engine, based on a network distributed database. From a commercial point of view, we refer at MySQL Cluster as a product. We also provide APIs to access to the Cluster database directly, bypassing the MySQL Server and the storage engine architecture.

Q from Ludovico: Are there load balancing mechanisms to balance sql requests between active sql server nodes?
Yes, absolutely. The SQL nodes all see the same data, and load may well be balanced between them, if necessary.
The only caveat is that transactions must be locked into the same SQL server for the duration of the transaction.
In real …

Putting aside the infrastructure that Amazon has put into place for
S3 Service, think about the S3 from an API standpoint vs Webdav.

Webdav is an HTTP protocol for sharing files. It makes an http server
appear as though it is a local filesystem. For webdav the HTTP
protocol was extended for PROPFIND, PROPPATCH, MKCOL, COPY, MOVE,
LOCK and UNLOCK. It also makes use of the DELETE and PUT keywords. S3
is a bit different, it takes a REST approach and uses just GET, PUT,
and DELETE.

Its simple, straight forward, and very easy to code too.

S3 though is not a protocol, it is a service.

S3 as a popular service creates a de-facto API.

Now does S3 do everything that webdav provides? No, but it does the …

OSBC last week provided an opportunity for three open source funding announcements (MuleSource, Zmanda, and SnapLogic), and real-time Linux vendor Concurrent announced a sale of common stock the week before. Here are the details…

MuleSource: May 22nd funding announcement (press release) of $12.5m in Series B led by Lightspeed Venture Partners. The company raised its initial $4m Series A last year from Hummer Winblad Venture Partners and Morgenthaler Ventures. MuleSource maintains the popular open source ESB, Mule, and is focused on open source options for integration and SOA.

Concurrent: May 16th funding announcement (press release) of …

You would think I’d get very use to seeing the power of the Web and open source in action working at MySQL. However, recently I got another dose of “wow” on the power and speed of both.

As a project for a Master’s program I’m in, I created a new web site and organization. I was amazed at how quickly I got everything out on the Web. I’m not a “host it yourself” kind of guy, so I picked a highly rated web hosting outfit and after filling out a single form and giving them an obscenely small amount of money, my domain was registered and I upload my entire site in under 10 minutes.

As part of this same project, I needed to create Podcasts, so I downloaded Audacity, which is a FOSS audio mixing product. Before long, I had professionally sounding Podcasts which surprised even my friends in terms of how good they sound (all I used was Audacity and a $40 mic headset). One friend commented that a family member had recently …

In this version we updated both PHP versions (to 4.4.7 and 5.2.2), MySQL (5.0.41) and phpMyAdmin (to 2.10.1). In the Windows beta we also fixed the security vulnerability published April 28th.

Get the downloads and more details on the specific XAMPP project page.

Hi,

Been a long time since last I posted.

I just got back from the Cluster Summit in Stockholm.

During this meeting we covered topics such as Design and Internals of MySQL Cluster, Dolphin Express for MySQL Cluster, Road Map discussion, Cluster & Replication Troubleshooting, Benchmarks with new performance patches and of course QA.

Items brought up during the QA Discussion included:

* HA Testing (High Availability)
* Log Events Testing
* Large Data sets
* Backup/Restore
* Configuration Testing
* Functional testing (Regression testing of Standard Functionality)
* Profiling
* Performance

So as you can see from above, I will be busy for some time to come :-)

Many of the above are being done now. We discussed how to take them to the next level.

During this meeting I was asked to take …