I am facing a little problem on mysql replication...
In my test system,
master-slave replication(it replicate only one table putting replicate-do-table value in slave my.cnf)
In Master database,
prod_table(where i want to insert data from other source)
trigger after insert(this trigger will insert data to replicate table when data inserted into prod_table)
replicate_table(after data inserted, data will replicate to slave table)
now the problem is,
when i manually insert data into replicate_table, it replicate to slave database but when i insert data into prod_table, in insert data using trigger into replicate_table but does not replicate to slave database....
can anyone tell me where i am doing wrong???