Posts

Showing posts from April, 2020

MySQL BLACKHOLE Engine as Replication Filter

Image
Today, I am going to tell very interesting use-case where we have used Blackhole engine as replication filter. We have an Aurora Cluster (let's call it C1) where multiple db's are hosted and multiple applications are writing data into it. While in another project one application wanted to read the data from one of the db's hosted on aurora cluster C1 & this new project is hosted into another account. Now the challenge is we don't want self hosted db which supports  replication filters (replicate-do-db) and bring only one db while wanted to use aurora only to in the new project as per the company standards, But problem is Aurora DB doesn't support native replication filters So we were not able to setup replication. To solve this problem we tried multiple approaches: Approach 1: Introducing intermediate Slave with replication filters, But using this approach we were introducing more infra and node management and that too self hosted will DB.