MySQL Forums
Forum List  »  Replication

CREATE VIEW with join to non-replicated schema in replication
Posted by: Krzysztof Wróblewski
Date: February 27, 2020 03:49AM

Hi,
I have some puzzle example to resolve :)

I have 2 databases with tables:
database1.table1
database2.table2

I replicate only database 1.
I would like to create view like :

create view example_view as select id1, t.id2 from database1.table1 natural join database2.table2 t;

Of course replication will be broken on this query.
Is there any option to create view in database1 like this and ignore it in replication?

I don't think about modification of SLAVE and adding 'database2.table2'.
I also don't think about moving view to database2 instead database1.
Of course I can skip query manually on SLAVE, but replication will stop in any view change.

I couldn't find way for resolving this puzzle in MySQL.

Chris.

Options: ReplyQuote


Subject
Views
Written By
Posted
CREATE VIEW with join to non-replicated schema in replication
787
February 27, 2020 03:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.