Re: Partial replicate InnoDB -> MyISAM

2003-10-27 Thread Jon Hancock
see below... - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> To: "Jon Hancock" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 10:49 AM Subject: Re: Partial replicate InnoDB -> MyISAM > Hmm >

Re: Partial replicate InnoDB -> MyISAM

2003-10-27 Thread Chris Nolan
Hmm How much lag time can you afford between the master's contents being updated and the slave being updated? Taking advantage of MyISAM's compressed table features might help performance if that is an issue. Every independant test out there shows that in the cases where InnoDB is slower for

Partial replicate InnoDB -> MyISAM

2003-10-27 Thread Jon Hancock
This thread started as "Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1". I may want to have one MySQL server as the Read only "Search" server. If I did this and I have all InnoDB table on my Master, then could I replicate only certain columns into the MyISAM slave ? Any other efficien