Re: Replicate_Ignore_DB does not take effect

[Shobri Utomo]

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