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
Hi Dipti,
[Sure, I ll take note of it to use googlegroups email ID for maxscale
questions].
That's true. I tried to use 5308 port as mentioned in maxscale
configuration sample for binlogrouter. When I configured and try to start
maxscale, its failed due to unable to connect to master. I enabled 5
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
Among other settings, you can make use of WAN segments (gmcast.segment),
outlined here :
http://galeracluster.com/2015/07/geo-distributed-database-clusters-with-galera/
HTH
- Nirbhay
On Tue, Aug 23, 2016 at 10:38 AM, l vic wrote:
> Thanks for the link but it seems to deal with "traditional"
You should keep those procedures in a different database, not mysql. Then you
can avoid replication with replication filters:
https://mariadb.com/kb/en/mariadb/selectively-skipping-replication-of-binlog-events/
But first, be sure you understand what happens when you call the procedure on
the mas
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
Karthick:
Please ask MaxScale question on maxsc...@googlegroups.com - I have cced
here.
The port 5308 in documentation is for listener for a mysql client that you
would use as following to register MaxScale with Master as slave
srvr:/home/my-usr$ mysql -u root -p 5308 -h
>CHANGE MASTER TO MAST
Hi all,
When I try to configure maxscale for binlogrouter, I noticed that
documentation examples using port as 5308. When I try to configure
similarly, it says, 111 connection refused or unable to connect master from
maxscale.
I have enabled the port in centOs7 using firewalld on both master serv
Hi, Lukas!
On Aug 21, Lukas Lehner wrote:
> Hi
>
> I have lots (> 10) of MongoDB T-Shirts, but I prefer to run MariaDB. Howto
> get cool MariaDB Shirts and Hoodies?
>
> Witch a search engine I found only "Support MariaDB" products (CafePress).
> That's not my taste :-(
It seems like CafePress i
9 matches
Mail list logo
