List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:January 2 2008 3:20pm
Subject:Re: Database Migration Path / Activity List?
View as plain text  
Hi,

On Jan 2, 2008 10:04 AM, Luis Motta Campos <luismottacampos@stripped> 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 replication.
>
> That's interesting. What kind of activities (besides configuration,
> maybe?) are interesting to add?

Lots of experimentation!

Let me ask it another way: how are you planning to use replication?
-- for load balancing/scaling reads, backups, a hot standby machine?

> > Unless you are familiar with it, that is likely to be a bigger change
> >  than the version upgrade and switch to InnoDB.
>
> That's alarming. I was expecting replication to be a lesser change, not
> something this big. Isn't predicting that the replication is one of the
> three biggest changes I have in my database a bit of an exaggeration?

Definitely not.  It is a huge change.  From one server to a two-server
replication setup is a quantum leap.  You'll have all kinds of new
things to think about, such as data consistency, dealing with
replication lag, performance changes on the master due to binary
logging, etc.

It depends a lot on WHY you're using replication (see my earlier question).
Thread
Database Migration Path / Activity List?Luis Motta Campos2 Jan
  • Re: Database Migration Path / Activity List?Baron Schwartz2 Jan
    • Re: Database Migration Path / Activity List?Luis Motta Campos2 Jan
      • Re: Database Migration Path / Activity List?Baron Schwartz2 Jan
        • Re: Database Migration Path / Activity List?Luis Motta Campos2 Jan
          • Re: Database Migration Path / Activity List?Baron Schwartz2 Jan
  • Re: Database Migration Path / Activity List?Moon's Father3 Jan