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

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

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.