Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication server, with InnoDB tables only, over a new hardware. Unfortunately, this is the first time I play a role as MySQL DBA,

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi Luis, On Jan 2, 2008 8:53 AM, Luis Motta Campos [EMAIL PROTECTED] wrote: Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication server, with InnoDB tables only, over a

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and using replication. It looks like you have planned well for all but using replication. That's interesting. What kind of activities (besides configuration,

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi, On Jan 2, 2008 10:04 AM, Luis Motta Campos [EMAIL PROTECTED] wrote: Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and using replication. It looks like you have planned well for all but using

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and using replication. It looks like you have planned well for all but using

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi Luis, On Jan 2, 2008 11:12 AM, Luis Motta Campos [EMAIL PROTECTED] wrote: Baron Schwartz wrote: On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and

Re: Database Migration Path / Activity List?

2008-01-02 Thread Moon's Father
I know now how to reply to all mail list On Jan 2, 2008 9:53 PM, Luis Motta Campos [EMAIL PROTECTED] wrote: Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication