First of all: mysqldump is not converting tables. It is something else. Here is the story:

One of my clients had a case when they were migrating to a new mysql server: they used mysqldump to export data from the old server (all InnoDB) and imported it to the new server. When finished, all the tables became MyISAM on the new server. So they asked me this question:
“Why mysqldump is converting my tables from InnoDB to MyISAM?”

First of all we made sure that the tables are InnoDB on the old server. It was true.
Second we run “show engines” on the new server:

+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| …

Is MySQL’s GIS really worth using?

Is GIS worth using in MySQL? In the past few post, I have explored what GIS is and how it is used. GIS encoded data is wonderful and can help with all kinds of cool queries.  I’m late getting this article written so lets get right to it.

The most common geographical  query is for all the point within some distance from a given point. I’ll try to focus on ways to answer this type of query. Accuracy of the answer is always important. Think carefully about your query. Do you want every pizza place within a radius of a port or within a square mile? Or, do you really want it within a miles walking distance?

I’m using the common city_lookup table for these tests. Here is the schema.

CREATE TABLE `city_lookup` (
`city_id` INT(7) NOT NULL DEFAULT '0',
`feature` VARCHAR(20) NULL DEFAULT NULL,
`name` VARCHAR(50) NULL DEFAULT NULL,
`pop_2000` INT(10) NULL DEFAULT …

Topics for this podcast:

*Our latest CAOS Special Report – Control and Community
*Red Hat releases RHEL 6
*Symbian and Oracle highlight community challenges
*The latest on government adoption of OSS from GOSCON
*Open core issue continues, now with Linux and evil twins

iTunes or direct download (31:02, 8.5MB)

Talend raises $34m, acquires Sopera. Red Hat releases RHEL 6. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have to.”

# Talend raised $34m funding and acquired Sopera.

# Twilio raised $12m in series B funding.

# Red Hat released Red Hat Enterprise Linux 6.

# Savio Rodrigues noted a change in emphasis from Red Hat to focus on value, rather than cost.

# Joyent officially …

A few days ago, a friend of mine asked me if I knew of a way of filtering a bunch of binary logs, to extract only statements related to a single table. The task was about filtering a few hundred binary log files.

It's a tricky problem. Even with my experience with regular expressions, I knew that using a script to extract statements related to a single table was going to be a nasty business.
However, I know of an entity that can filter by table name efficiently, and that's the MySQL replication system. So I suggested using replication to a sandbox with a replicate-wild-do-table statement to get the job done.
My friend was skeptical and did not want to go that way. I was busy writing an article for an Italian magazine and did not follow up immediately. But today, with the article safely in the editor's hands, I did a quick test, and guess what? It works!

Here is a step-by-step procedure to do it. I started …

Next Thursday we'll be running a Webinar entitled:

"MySQL Enterprise Edition & Oracle Database 11g: World Class Web Scalability & Infrastructure"

During his presentation, Luca Olivari will cover the following points:

• MySQL overview to help you better understand what makes MySQL the database of choice of leading Web properties including Facebook, Google, Wikipedia and thousands of others.
• The different infrastructures you can implement to deliver highly scalable and highly available Web applications powered by the world's most popular open source database.
• How to integrate MySQL with Oracle 11g for the backend infrastructure of your Web applications.

We'll run the webinar on Thursday Nov 18th at 9.00 am Pacific Time/18.00 CET. You can register at: …

This is the story of a tweet...

Last week Adam went to QCon San Francisco to talk about "The Road Ahead for Java". Adam covered the Java SE Strategy, presented by Oracle at JavaOne via a PR, keynotes and sessions like S319476 by Paul and Henrik. The relevant section from the PR is:

The Oracle JDK and Java Runtime Environment (JRE) will continue to be available as free downloads, with no changes to the existing licensing models.

Premium offerings such as JRockit Mission Control, JRockit Real Time, Java for …

My branch that updates the innobase plugin in Drizzle to be based on innodb_plugin 1.0.9 has been merged. For the next milestone, we’ll probably have 1.0.11 as well.

How’s the progress getting 1.1 and 1.2 in? Pretty good actually. We’ll have it for either this milestone or the next one.

and merging newer innodb into HailDB? It’s going well too, expect more news “soon”.

The Apache Software Foundation’s latest statement on the Java Community Process highlights continued dissatisfaction and dissent from Oracle’s stewardship and involvement in open source software.

This comes after some ups and downs for Oracle and its oversight of Java and other open source software that was previously under the auspices of Sun Microsystems. Oracle started off on a rough path when it sued Google over its implementation of Java in Android without preemptively or clearly stating that it was not attacking open source. At about the same time, it let OpenSolaris die a slow, somewhat confusing death. …

(NOTE: If you’ve come here from http://planet.mysql.com my apologies. I’ve notified them to only follow my database related posts and hope they’ll not follow my full blog feed shortly.) I recently came across a new site which offers a GUI configuration tool for FreeSWITCH. Despite buying the FreeSWITCH 1.0.6 Book which is a very good [...]