How to migrate few content from a table of mysql master to another table without choking the master read and writes?
I have written an api to read a row from table1 of mysql master and write into table2 of mysql master (few columns of table1 with additional computed columns). I want to execute it for all the records of the table1 of mysql master. Since both read and write operations will be on mysql master box, it might choke up currently happening read and write on mysql master box. Any suggestion on how should i decide the throughput or other metrics like threads etc should that this migration activity can happen smoothly. Also any suggestion with api are also appreciated. Total number of records are approximately : 50 million
