LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 02-13-2019, 06:17 AM   #1
Akshayjaiswar
LQ Newbie
 
Registered: Feb 2019
Posts: 1

Rep: Reputation: Disabled
Mariadb replication issue.


Hi all,

I am using Mariadb 5.5.56 version and configured statement based replication, also there is one master server and other is slave server, the issue faced by me is whenever the grant is executed for particular Mariadb user on master server the same grant is being executed on slave server for the same Mariadb user.

It should't be executed as i have ignored mysql db in my.cnf file of both the servers,
please look at my.cnf file of both the servers.

Master server

# Replication (Master)
# -- modify iptables to allow port 3306 connections
log-bin
server-id=1
log-basename=mysqlbinarylog
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=test
binlog-ignore-db=tracs_testdata
innodb_flush_log_at_trx_commit=1
sync_binlog=1
expire_logs_days=14
#expire_logs_days=0
#
key_buffer_size=4G


Slave server

# Replication (Slave)
server-id=3
relay-log=mysqlrelaylog
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-ignore-db=test
replicate-ignore-db=tracs_testdata
replicate-ignore-table=tracs_dataG.camasterd
replicate-wild-ignore-table=tracs%.norep%
### Only super and repl can write ###
read_only
#########

Please help me with the issue and do let me know in case of any required info.

Regards,
Akshayj
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Step by Step guide for creating Master Slave replication in MariaDB LXer Syndicated Linux News 0 11-26-2017 10:15 AM
MariaDB Cluster with Galera Replication - max_allowed_packet issue artemidis CentOS 6 01-14-2016 05:51 AM
MariaDB 10 Multi-Master replication question imadsani Linux - Server 0 05-25-2015 10:45 PM
mariadb/mysql slave replication andrewm659 Linux - Server 2 07-25-2014 02:34 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:23 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration