Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
1
vote
2answers
68 views
How to avoid lagging when enabling log-slave-updates?
Master:
48GB RAM
16-core
my.cnf: https://clbin.com/hlkUo
Slave:
64GB RAM
24-core
my.cnf: https://clbin.com/viLm0
Both are running 5.5.28.
For the incremental backup purpose, I need to enable ...
0
votes
0answers
48 views
MM Replication and Zabbix in slave, Error code 1032
I have multi-master replication and using Zabbix for server monitoring. Since the replication is row based, I get this error in slave everytime which also breaks my replication. The error I get is:
...
1
vote
1answer
130 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
0
votes
0answers
70 views
PostgreSQL: Slave doesn't replicate the Master's data
I'm using PostgreSQL 9.2.3 on both computers, both of which run Win2008R2. I've setup streaming replication by following this guide: ...
4
votes
1answer
71 views
“Arithmetic overflow” when initializing SQL Server 2012 replication from backup
I'm initializing SQL Server replication from a backup, by following instructions from here:
http://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/
...
2
votes
2answers
173 views
MySQL replication: most important config parameters for performance on slave server?
I'm setting up a mysql master-slave configuration, where slave is located on a much weaker sever.
Since, if I understand correctly, slave only works on updates/inserts, what are the most critical ...
1
vote
2answers
79 views
Is it safe to delete mysql-bin files?
I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those ...
0
votes
1answer
34 views
mysql replica ignoring server-id [closed]
I've setup a mysql replica slave a couple months ago. After a couple hickups lately, I've decide to restore it from a clean master export.
I'm trying to start my mysql instance with this command :
...
0
votes
0answers
22 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
4
votes
2answers
84 views
Transactional Replication Concerns
We are debating an architecture that employs sql server 2012 and transaction replication. Idea is to offload reporting activity to a secondary server and have the ability to include/exclude what is ...
0
votes
0answers
25 views
Oracle Downstream Log transfers
I am attempting to create a downstream capture process for two Oracle 11 databases running on Linux servers. The replication will be one-way and asynchronous using archive logs as the transfer ...
0
votes
0answers
32 views
MySQL replication is not happening when piping sql into mysql client
Today I noticed a very strange issue where if I cat a SQL file and then pipe it to MySQL client, replication doesn't happen. These MySQL statements aren't also written to the binlog. But replication ...
3
votes
1answer
120 views
Switch MySQL lag slave to new master and keep lagging (5.1)
We have the following scenario:
Set of slaves replicate from the master, separate standby master (a.k.a slave with binlogs) replicates from the same master; lag slave, powered by pt-slave-delay, ...
0
votes
1answer
88 views
SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers
We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for ...
1
vote
1answer
62 views
MySQL replication — issue with mysql.proc during replication from 5.0 to 5.5 host
We are replicating from a mysql 5.0.45 host to a 5.5.26 host over WAN. Every once in a while one of our databases does not accept a query and halts the replication.
"'Column count of mysql.proc is ...
1
vote
2answers
78 views
Is there a way to stop MySQL Replication on the master?
I want the master to stop replicating data to the slave. I know I can do that on the slave with STOP SLAVE;, but I wonder if there is a way to do it in the master.
One possible solution might be to ...
1
vote
2answers
135 views
Loading data in mysql using LOAD DATA INFILE, replication safe?
I am trying to load data into mysql database form CSV file. I found that we could use LOAD DATA INFILE command to do it. But as per the mysql documentation it is not replication safe. (See here)
Is ...
0
votes
2answers
41 views
Pull Subscription: process cannot read file due to OS error 5
I am trying to migrate a working pull subscription for transactional replication from one subscribing server to a new one. The subscribing server is at another site and is connected via a VPN tunnel. ...
0
votes
3answers
133 views
Single slave - multiple master MySQL replication
I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
0
votes
1answer
30 views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
0
votes
0answers
31 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
0
votes
1answer
51 views
MySQL replication using a lot of IO
I'm having big troubles on a database pool I've setup recently.
There is a master, and 4 slaves replicating one DB. All using MyISAM engine.
Thing is, during the replication period (when the slave ...
1
vote
1answer
53 views
MySQL statement-based replication and stored procedure
When you have a MySQL statement-based replication and you create a stored procedure that modify some rows (INSERT, UPDATE, DELETE commands...), What is really replicated on the slave when you call ...
0
votes
0answers
50 views
MySQL failover - Master to Master Replication
My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
0
votes
1answer
41 views
Syncronize mysql databases between local and hosted servers automatically
We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
0
votes
1answer
50 views
MySQL: replicating to a different table engine type
According to the replication documentation from MySQL, it is possible to set up replication from InnoDB source tables to MyISAM destination tables. Unfortunately, the documentation has little to say ...
0
votes
2answers
81 views
which sql server edition is good for practice [closed]
Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
3
votes
0answers
80 views
Streaming Replication Failover - how to point second slave at new master?
I have a Postgres database HA cluster I've set up in a lab. I'm using PgPool-II to manage fail-over.
For the cluster itself, I have three identical Postgres 9.2 servers set up like so:
Server A - ...
0
votes
1answer
43 views
Replication Monitor reports little to no latency, but my tracer token is taking hours to go from Distributor to Subscriber
I sent a tracer token through a replication job that was reporting about 2 seconds of latency about two and a half hours ago. I sent the token through because I noticed a row that was inserted on a ...
1
vote
1answer
60 views
Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
How do i get the list of all Tables, Views, Stored procedures that are NOT added in a publication for replication?Can you help me to make the stored Proc for that?I am new to Replication....Thanks
0
votes
0answers
24 views
What is the quickest way to recover from an “Incorrect key file for table” replication error?
I'm trying to figure out the quickest way to recover from a replication error.
The production site replicates to a DR site. There are two databases at each site. So prod_master replicates to ...
0
votes
0answers
28 views
Slave lags ONLY when long running sql runs
I have mysql Master/Slave setup.
Master in 5.0.77 and Slave in 5.5.28.
The Master serves 24/7 with 82.06 inserts/s, 94.39 updates/s, 0.00 deletes/s, 22613.29 reads/s.
They both are in sync every ...
0
votes
0answers
46 views
Huge sizes Replication Tables in Sql Server db, how to deal with?
I've a sql server database that is configured to work with old software, i've no details about the software, but i know that DB uses replication.
the DB size dramatically increases.
When i ...
0
votes
2answers
115 views
Should I disable triggers, timestamps in a slave in mysql?
We're using MySQL. We have a master that eventually will have 2 slaves. There are triggers in the db that execute when data changes in certain tables. I am wondering whether to disable the triggers in ...
1
vote
1answer
33 views
After adding a slave to Master - Master configuration, slave syncs from only one master
Futher to my previous question,
Here is what we have
+<------+
| ^
V |
S1<---M1 M2
| ^
V |
+-------+
what happens is Upon ...
2
votes
1answer
145 views
Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
We have two mysql servers running in master - master configuration.
Now we have to add a slave to the existing configuration.
But upon adding the third DB server and starting slave on it, it throws
...
0
votes
0answers
34 views
Merge Replication is Slow for Uploads
I have implemented merge replication with pull subscriptions in production environment. Initially it was working fine, but now a days, its too slow to upload any changes to publisher , but subscribers ...
0
votes
0answers
22 views
What will happen if i change the compatibility level of Distribution Database [duplicate]
I have implemented merge replication in production environment, initially it was in SQL Server 2005, then it was upgraded in-line to SQL Server 2008 R2. Later on all databases compatibility level was ...
1
vote
0answers
44 views
Write performance of Postgresql 9.1 with read-only slave
I have a Postgresql 9.1 database that is being hosted by Heroku. It currently has a read-only "follower". I need to truncate several large tables (over 100GB) of data and reloads them. Is the ...
0
votes
1answer
49 views
Circular replication with servers in different locations
My service runs on single machine, and database (mysql 5.1.66) is replicated to 2 other identical slaves (with lesser system resources, mysql 5.1.66) via chained replication. Machines are located in ...
0
votes
1answer
28 views
How to have MySQL Slave Replicate From a Master's Master
We are using the Following:
MySQL 5.1.63-community-log MySQL Community Server (GPL)
OS : Red Hat Enterprise Linux Server release 5.4
We have three servers and all servers are enabled with binary ...
2
votes
2answers
117 views
Bandwidth comparison between log shipping and transactional replication
Which technique uses more network bandwidth:
Log shipping
Transactional Replication
Can some one share any benchmarks for the same ?
What would be the Memory and I/O impact on the Primary server ...
4
votes
1answer
75 views
How to reinsert corrected rows from the conflict table?
I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how ...
1
vote
1answer
60 views
Will deleting data in master automatically delete data in slave?
I have data replication setup on MySQL. If I delete data on the master, will replication know data was deleted and automatically delete the same data on slave?
0
votes
2answers
62 views
Can I use replication/mirroring to have a “Current” database and a “Full History” copy?
I have a database that is used for current operations. The amount of data is starting to get a bit to much for the applications using it.
Most of the data is older and is very rarely needed.
I am ...
0
votes
1answer
425 views
MySQL slave stuck in “Reading event from the relay log”?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
2
votes
1answer
66 views
Bi-directional replication for the same MySQL table
AppA stores/retrieves data from dbA.tableA
AppB stores/retrieves data from dbB.tableA
tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA ...
3
votes
1answer
97 views
mysql second slave not syncing while first slave works fine
I have a master (m) - slave (s1) setup using mysql 5.1.45
When I try to add a second slave (s2) the slave lags behind and never catches up on the sync.
Even after having synced the s2 with the whole ...
0
votes
1answer
77 views
Advise On SQL Server Data Replication
We have a huge enterprise system, with geographically seperated SQL servers.
We have some requirements related with data replication between these servers.
We have considered the Sync Framework ...
0
votes
1answer
55 views
Do I need client certs for mysql ssl replication?
I'm setting up mysql replication using SSL, and have found two different guides.
The first one creates both client and server certs, while the second one only creates server certs.
I don't know ...
