Data Warehousing strategy

1 post / 0 new
deano
deano's picture
Offline
Last seen: 1 year 3 months ago
Joined: Sep 22 2011
Junior Boarder

Posts: 15

Dean Kamali
Data Warehousing strategy

I have a busy MySQL database with 1.6 million records a day, I'm looking to replicate this data to another server (infinidb), then run a clean up job on production database to maintain small database in production.

I thought about Master / Slave setup, but I'm not sure how can I prevent deletes from replicating to slave (during clean up process).

I'm sure other BD admins / developers have run into same situation, I would appreciate any suggestion / recommendation

Thank you