MySQL Forums
Forum List  »  Replication

Re: Replicate_Ignore_DB does not take effect
Posted by: Shobri Utomo
Date: March 24, 2022 08:13PM

here, what the show slave status showed

|Slave_IO_Running|Slave_SQL_Running|Replicate_Do_DB |Replicate_Ignore_DB |Replicate_Do_Table|Replicate_Ignore_Table|Replicate_Wild_Do_Table|Replicate_Wild_Ignore_Table|L
-+----------------+-----------------+-------------------------------------------+---------------------------------+------------------+----------------------+-----------------------+---------------------------+-
6|Yes |Yes |dashboard,data_warehouse,sso,etest,live_dev|interim,mysql,kate,etest_loadtest| | | | |
5|Yes |Yes |dashboard,data_warehouse,sso,etest,live_dev|interim,mysql,kate,etest_loadtest| | | | |
4|Yes |Yes |dashboard,data_warehouse,sso,etest,live_dev|interim,mysql,kate,etest_loadtest| | | | |
7|Yes |No |dashboard,data_warehouse,sso,etest,live_dev|interim,mysql,kate,etest_loadtest| | | | |

and here's the last error

Error 'Unknown database 'kate'' on query. Default database: 'dashboard'. Query: '/* ApplicationName=DBeaver 22.0.1 - SQLEditor <Script-83.sql> */ DELETE FROM kate.urls WHERE id=1142'

as you can see, there's already the directive for the DB "kate" in replicate_Ignore_db

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Replicate_Ignore_DB does not take effect
92
March 24, 2022 08:13PM


Sorry, only registered users may post in this forum.

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.