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 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). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
