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
It depends a lot on WHY you're using replication (see my earlier question).