hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Todd Lipcon <t...@cloudera.com>
Subject Re: Hadoop / MySQL
Date Wed, 29 Apr 2009 20:22:46 GMT
On Wed, Apr 29, 2009 at 12:25 PM, Edward Capriolo <edlinuxguru@gmail.com>wrote:

> The .frm and .myd are binary platform dependent files. You can not
> even move them from 32bit-64bit. Generating them without native tools
> would be difficult. Moving then around with HDFS might have merit,
> although the RSYNC could accomplish the same thing.

Nope -- MyISAM data files are completely compatible between 32-bit and
64-bit as well as different different architectures. From the MySQL manual:

"All data values are stored with the low byte first. This makes the data
machine and operating system independent. The only requirements for binary
portability are that the machine uses two's-complement signed integers and
IEEE floating-point format. These requirements are widely used among
mainstream machines. Binary compatibility might not be applicable to
embedded systems, which sometimes have peculiar processors."

> Derby-DB might be a better candidate for something like this since the
> underlying DB is cross platform.

Yep, but for shops that already have a big MySQL infrastructure, it makes
sense not to introduce more software.


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message