… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… all of them. For example stored procedures are handled (because binary logging is done on statements as executed inside stored procedures… is more important you will get into more complicated math of dealing with binary log positions. For example cloning Master (and dropping…
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
…and the slave. You can’t get it with MySQL replication by design because slave only fetches statement after…by “all they use same binary log offsets”. The offsets in the slave binary log can be different if if…sure it is worth the trouble compared to some math you have to do to change positions to the…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
…Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â Â … less than half a database page (the actual math is 16k-(page header + page trailer)/2. For … the result of the COMPRESS function is always binary, so for example, you should use a BLOB …
