ha scritto:
>
> Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql
> database
> A: "MariaDB discuss"
> Data: Mercoledì 31 agosto 2016, 23:39
>
> Thanks to everyone
>
> Here is the solution:
>
> On the slave:
I never used replicate_ignore_db='mysql'. But I know some people does. Did you
check if it has side effects?
Federico
Mer 31/8/16, Игорь Пашев ha scritto:
Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql databa
Thanks to everyone
Here is the solution:
On the slave:
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table: foo.%
Replicate_Wild_Ignore_Table:
On the master:
USE mysql;
CREATE PROCEDURE whatever() BEGIN END;
_
Per the MySQL documentation, it is noted that replicate-*-table
options do only apply to tables, and replicate-*-db options are
suggested to filter stored procedures, functions and events. I
imagine that applies similarly to MariaDB.
The various *-db filters can be problematic[1], but perhaps wil
A question for you is why is it important not to have it on the slave?
Because the slave already has this procedure with a slightly different
implementation,
and different owner (definer).
As a workaround to not stop/break the replication you could run the slave
with
slave-skip-errors = 130
master.
Federico
Lun 29/8/16, Игорь Пашев ha scritto:
Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database
A: "Daniel Black"
Cc: "MariaDB discuss"
Data: Lunedì 29 agosto 2016, 15:44
2016-08-
2016-08-29 1:25 GMT+03:00 Daniel Black :
> A question for you is why is it important not to have it on the slave?
Because the slave already has this procedure with a slightly different
implementation,
and different owner (definer).
> If the slave is a failover it should have the procedure.
If I
On 28/08/16 21:06, Игорь Пашев wrote:
> Hi all,
>
> I'm using multi-source replication with "white list" options only:
>
> foo.replicate_wild_do_table = foo.%
> foo.replicate_ignore_table = foo.beep
> foo.replicate_ignore_table = foo.tmp
>
> The masters are writing row-based binary logs as is
Hi all,
I'm using multi-source replication with "white list" options only:
foo.replicate_wild_do_table = foo.%
foo.replicate_ignore_table = foo.beep
foo.replicate_ignore_table = foo.tmp
The masters are writing row-based binary logs as is (no filtering at masters).
This works almost as expected:
9 matches
Mail list logo
