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
Last activity: May 30, 2020, 08:14 PM