I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of ...
I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...