So you have followed the recipes to create a standby database, setup the database to switch logs automatically, and now, as with any good database, the space required to support the application grows and grows and grows. Eventually, using your monitoring software (in my case, Pythian’s avail or dailies), you get an alert suggesting that you [...]

Interface21, the company behind the Spring framework for Java has raised $10 million in venture capital from Benchmark Capital.  Benchmark is one of the leading VC firms in Silicon Valley and has invested widely in open source companies including MySQL, Red Hat, Collab.net, Terracotta, Zimbra.

Benchmark partner Peter Fenton was also named one of the top VC's under 40, along with Danny Rimer from Index Ventures, another regular open source investor.

• Interface21: Company, …

This is an example of running two connections in a single test case and I will go step by step through the test case with explanation.

Create the File
In the MySQL source directory you will find a mysql-test directory where the test files and executables used in this tutorial will be found. We will be creating a test case called cfoo.test in the mysql-test/t/ directory where all test cases are stored.

Import Include Files
Like using libraries in C++, the *.inc files found in mysql-test/include help save time in writing code used by multiple tests. In this test we will be using the InnoDB engine so I included have_innodb.inc.

-- source include/have_innodb.inc

Clean Tables Needed for Test
Previous tests may have used the table needed in the test so we remove it.

--disable_warnings …

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 …

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.