Sample Header Ad - 728x90

MariaDB Replication - Replicate only specific tables and views

0 votes
1 answer
5780 views
Note: A backend developer here with little to no experience in setting up database servers and replication. **What needs to be done** Setup DB replication of an existing database with the following constraints: 1. Replicate **only a specific list** of tables/views with different names in the replicated database. 2. Change the name of the tables/views in the replicated database (during the replication process) 3. Setup a user on the replicated DB with further restrictions with which only a set of table/view can be viewed/updated/deleted **Progress so far** I have already read the document here , however, I did not find anything concrete to help me move forward with all the use-cases I wish to support! **Use Case** Show only essential data to the external vendor. PS: If there are any other approaches other than replication, would be happy to consider and implement that as well.
Asked by qwertynik (3 rep)
May 30, 2020, 09:34 AM
Last activity: May 30, 2020, 08:14 PM