Other people have already drilled into the Oracle purchase of Sleepycat enough so I only have one question. Does any MySQL user really care that Oracle bought Sleepycat? Was anyone using BDB in production? Why?

I’ve been working on populating the new Sakila schema with some data, mainly by copying data from the existing Sakila 0.1 schema.

The 0.5 version is available for download as a zip archive at http://www.openwin.org/mike/download/sakila-0.5.zip.

This version has two files, sakila-schema.sql and sakila-data.sql, load the schema file first, then the data file.

This is just a rough fill-in of the data, intended to provide context for discussion. Some data related suggestions have been made in the past, if they have not been met please point out any continuing issues.

Thanks again to all who take the time to review and provide feedback!

The forums are also available for discussion at http://forums.mysql.com/list.php?121

I added some views and stored …

From what I understand, there are at least three ways one can go about replicating/mirroring MySQL databases to different servers overs the Internet

1. Use MySQL Replication.
All incoming data will be sent to a master which will then read the binary logs to the slaves. The replication can be ?circular? or ?one-master-to-many-slaves?

2. Use MySQL Clusters
Pros: Delivers ?99.999%? availability
Cons: Need a lot more RAM and hardware for heavy load system

3. Through Application (Redundant)
Application first sends the data / operation to a master for replication. Following the success of the above, the application then sends data to a third independent server (that is not replicated)

Since 2004, I have been using replication and it works fine except when for some reason the slaves get behind the master.

I would like to ask the MySQL gurus here a few …

Looks like I'm headed to Montreal for PHP Quebec in the end of March, giving a session on setting up and managng MySQL Cluster (I believe details are coming to the PHP Quebec site soon). There is quite a lineup of speakers and sessions, I'm looking forward to them. As a person who does a lot of Perl in the day and PHP only at night it will be nice to spend some time focused on PHP and around PHP folks. The conference has presentations on a few different databases. Looking forward to them as well, getting a look at how it feels to use something other than MySQL.

The conference is a mix of French and English speaking sessions, as I do not speak any French mine will be in English (Bostonian english).

If …

Yesterday I gave an hour long interview to a firm that ranks top 10 within it's industry. Out of the many people interviewing me, most of them were pro-MS SQL server even though the company had everything on MySQL.

The interviewers repeatedly asked me about how will I migrate to MS SQL server from MySQL? I on the other hand kept pushing for MySQL telling them that there is no need to go with MS SQL server as they can do everything they want with MySQL. I did ended up telling them about how I would go about migrating in the end.

I felt a concern that for some reason they weren't sure about MySQL's future and the acquisition of Innobase by Oracle (Heck they didn't know about BDB's acquisition).

Anyway, I am currently waiting to hear from them.

Frank

April 1st is still more than a month away and at least one rumour about Oracle’s upcoming purchases is true: today the software giant annnounced their acquisition of Sleepycat Software, the makers of Berkeley DB (and various other products).

One interesting point is that Berkeley DB was already seeing competition from SQLite (which is an excellent, fast and free (as in beer and freedom) RDBMS). I wonder how much the acquisition is going to drive adoption of SQLite?

Additionally, Oracle now owns both half of MySQL’s transactional storage engines, which perhaps gains them another measure of control over the Swedish upstart. (The other engines are …

After buying PeopleSoft for $11.1 billion and Siebel Systems for $5.85 billion dollars, Oracle has finally bought Sleepycat, the makers of Berkeley DB (or BDB) for an undisclosed amount.

According to the media reports, Oracle has spent nearly $20 billion in acquisitions in the last 2 years. That's 10 billion dollars a year and close to a billion dollars per month.

The troubling thing is the fact that "stopping" is not in Oracle's dictionary. The company is also after Zend and JBoss.

From what I see Oracle felt very threatened by MySQL and Open Source, and as a result is trying to drive MySQL out of the market.

Is this Game over?
As my fellow blogger, Markus has been pointing out for some …

In MySQL 5.1.6 there’s a new INFORMATION_SCHEMA table.

Currently, it only has information on files for NDB but we’re hoping to change that in a future release (read: I think it would be neat).

This table is a table generated by the MySQL server listing all the different files that are/could be used by a storage engine. Three (may) be table to file mappings (or not) depending on the engine.

Basically, NDB does files like so:

A table is stored in a tablespace.

A tablespace has datafiles.

Datafiles are of a set size.

Space is allocated in datafiles to tables in a unit called an extent.

If you don’t have any free extents you cannot have new tables store data on disk.

If you don’t have any free extents you may still be able to add data to a table as …

Noticed this about our web based forums today:

the “Re: What is this? “Can’t find record in ‘'’ on query.”" post on the cluster forum from 10/02/06 07:53:20 isn’t the last message in that thread. there are currently 6 messages of which I only see 2.

Not only that, but from looking at the RSS, I can’t even see this post.

argh! So I shot off an email to our internal guys. The reply was that they don’t have hacking Phorum on their radar (fair enough). Of course, this just means that Phorum sucks[1] (or at least did in the version we do) and adds to the list of reasons why web based forums are much like doing $adjective to $noun.

What is it with new internet lamers and the inability to use an email program? Or even an nntp client (okay, usenet is officially crap now unless you just want spam and …