learnt
On Wed, Apr 30, 2008 at 5:18 AM, Mihail Manolov <[EMAIL PROTECTED]>
wrote:
> Hi all,
>
> I feel obliged to report on my success with migration from 32bit to 64bit
> platform.
>
> Last Sunday I braced myself and migrated 3 servers (one master and two
> slaves) with approximately 100GB data
Hi all,
I feel obliged to report on my success with migration from 32bit to
64bit platform.
Last Sunday I braced myself and migrated 3 servers (one master and two
slaves) with approximately 100GB data each by simply rsyncing the data
files. It took about 1 hour total downtime.
Everythin
On 4/26/08 Mihail Manolov wrote:
Hi!
MyISAM (MERGE; and therefore not an issue). The only exception is
Falcon, which is only available in MySQL 6.0.
While I haven't had a chance to read the wiki link you posted, as I
write this email offline, it should be noted that Falcon previews even
(cu
Mike wrote:
Hi!
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
Dump the database, restore on the 64-bit box, and all should be well
What is the difference between
, 25 April, 2008 5:33:49 PM
> > Subject: Re: Migration from 32-bit to 64-bit MySQL
> >
> > On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy
> > wrote:
> >
> > > Olaf Stein wrote:
> > >
> > > > Probably not
> > > >
> > > &
Mike wrote:
I not sure
what you mean by binary copy. Can you please explain?
A binary copy means copying the MySQL data directory directly, rather
than do a mysqldump, which converts the data to text format. The text
dump is converted back to binary format for disk storage on loading it
b
I am in process of planning 32 to 64 migration as well. I googled the
following, but it could be only relevant to a specific application:
It should be noted that, when switching between 32bit and 64bit server
using
the same data-files, all the current major storage engines
(with one exceptio
On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy <[EMAIL PROTECTED]>
wrote:
> Olaf Stein wrote:
>
> > Probably not
> >
> > AFAIK it should work in theory if you have no floating point columns but
> > I
> > would not try it.
> > Why cant you take a dump, you can do it table by table, you will have
Mike wrote:
I have so much data that we can't take a mysqldump of our database. The
directory tared is about 18GB.
Worst-case expansion for SQL data from binary to text format is about
5:1, which applies mainly to numeric data, not text. That's only 90 GB;
I carry a bigger hard drive in my
Every statement should be executed on the slave from the masters binary log
so in my opinion you should be ok
On 4/25/08 12:20 PM, "Mike" <[EMAIL PROTECTED]> wrote:
> That what I want to do, but I'm not sure if the data will propagate right.
> Because of lack of documentation for 64bit.
>
> On
That what I want to do, but I'm not sure if the data will propagate right.
Because of lack of documentation for 64bit.
On Fri, Apr 25, 2008 at 12:03 PM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> Probably not
>
> AFAIK it should work in theory if you have no floating point columns but I
> would no
Olaf Stein wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add more 64 slaves.
On
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> As long as you use dumps to restore your databases on the new 64bit system
> (instead of the binary files) you should be fine
>
> Olaf
>
I have so much data that we can't take a mysqldump of our database. The
directory tar
As long as you use dumps to restore your databases on the new 64bit system
(instead of the binary files) you should be fine
Olaf
On 4/25/08 11:23 AM, "Mike" <[EMAIL PROTECTED]> wrote:
> I would like to move from 32-bit to 64-bit MySQL within the next year.
> Unfortunately, there is not a lot of
On Fri, 25 Apr 2008, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
I would just dump the database from the 32-bit platform and import it
into the 64-bit server.
By "dump" do you mean "mysqldump", or some other process?
--
Tim McDaniel, n00b, [EMAIL PROTECTED]
--
MySQL General Mailing List
For li
Mike wrote:
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add a
17 matches
Mail list logo
