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
875 views
Mongo replicated shard member not able to recover, stuck in STARTUP2 mode
I have following setup for a sharded replica set in Amazon VPC:
mongo1: 8G RAM Duo core (Primary)
mongo2: 8G RAM Duo core (Secondary)
mongo3: 4G RAM (Arbiter)
Mongo1 is the primary ...
0
votes
2answers
91 views
Replication on MySQL server
I had to stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server
On the problematic server
mysql> SHOW SLAVE STATUS\G
...
0
votes
2answers
65 views
How can I replicate some tables without transferring the entire log?
I have a mysql database that contains some tables with private information, and some tables with public information.
I would like to replicate only the tables containing public information from one ...
0
votes
2answers
265 views
How to sync MySQL database between two servers
I need to sync a MySQL database between two servers.
If a new record will be added in server A, then server B fetch new record.
If a new record will be added in server B, then server A fetch new ...
0
votes
2answers
109 views
Replication master binlog rotation when network is unavailable
I recently experienced an issue where the binlog file in master rotated because network connectivity between the slave and master was unavailable.
After solving the network issue, the slave was not ...
3
votes
1answer
126 views
SQL Server 2005 Replication
I am in the process of creating Replication between 2 Remote Servers, server 1 is the Distributor and Publisher and server 2 is the Subscription.
server 1 windows 2003 server 192.168.10.1 connected ...
3
votes
1answer
70 views
PostgreSQL replication for archiving
I've looked around a bit and haven't found a very clear strategy or method for what I'm trying to do, which is surprising because I would think it would be a fairly common practice.
I currently use ...
2
votes
1answer
63 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 ...
2
votes
1answer
88 views
mysql second slave not syncying 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 ...
1
vote
1answer
65 views
SQL Server replication conflicts after migration from 2000 to 2008
I got a suggestion over at Stackoverflow to post here....greatful for any and all help.
Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
1
vote
1answer
71 views
Replication issue - CREATE SELECT alternative?
I've an MySQL 5.1 slave for our BI team.
They need to make some CREATE SELECT with big select queries (several million lines).
As CREATE SELECT is a DDL, if the replication attempts to update some ...
1
vote
1answer
66 views
sp_startpublication_snapshot Parameter(s)
I am creating a stored procedure that:
Restores a DB from a .bak giving the .mdf and .ldf a new name (so we have have several copies of the same DB up
(If specified in the SP's parameter) Creates ...
1
vote
1answer
127 views
oracle streams apply: how to get a reason why LCR message was not applied
I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't.
...
1
vote
1answer
168 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
1
vote
1answer
424 views
Replicating data from Oracle to MySQL
I work with a vendor that does data analytics, and they currently receive a replication stream from some of our databases using a product called Goldengate (which is very expensive). Goldengate has ...
1
vote
1answer
82 views
Does Pt-table-checksum point out rows that are different from that of the Master
Trying to verify replication integrity of my replica. And I found that pt-table-checksum is one of the best ways of doing it.
I have a simple Master->Slave set up. Have created a sample table with 10 ...
0
votes
1answer
36 views
MySQL Replication and Triggers
I have stumbled upon an interesting MySQL Error message that I do not really know how to interpret.
The setup:
There are two tables A and B.
When data is written or updated in the table A, then a ...
0
votes
1answer
45 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 ...
0
votes
1answer
21 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
1answer
43 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 ...
0
votes
1answer
36 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
33 views
Is it possible to have extra tables in a Slave with MySQL Replication
As my title mention I have a Master and a Slave database.
Master if for operations data and my slave mainly for reporting stuff.
The issue is that I need to create extra tables on reporting that ...
0
votes
1answer
47 views
MySQL Slaves lag behind master
I have one master and four slaves. Sometimes all my slaves lag behind the master. I have implemented the heartbeat for monitoring replication lag. Now I am trying to find why the slaves are lagging ...
0
votes
1answer
66 views
MySQL replication between VPS and shared host
I have a VPS where I have ssh access and shared host with CPanel. Both have MySQL.
I need to create a master/slave setup among the two server.
As per this tutorial: How To Set Up Database Replication ...
0
votes
1answer
59 views
Breaking Semisynchronous Replication in MySQL 5.5
I've set up Semisynchronous Replication between two MySQL 5.5 servers running on Windows 7.
My application is running and updating the database of the master server and same is being updated in the ...
0
votes
1answer
41 views
MySQL Replication using SSL
I am in the process of replicating my database so i can have a master slave configuration, one of the issues i have is with security i am basically generating my server/client keys and certificates ...
0
votes
1answer
48 views
Two slaves using the same server-id
I have a MySQL master with two slaves. Due to poor configuration both slaves had the same server-id.
My questions are:
Is the slaves' data fully synced with the master or did they miss transactions ...
0
votes
1answer
59 views
Mysql restore all data from Master
MySQl Slave replication server got crashed and I am missing around 60 tables, some table structure and data which present in master and by DB size is more than 25Gb, How I Can restore to resolve ...
0
votes
0answers
52 views
Streaming replication WAL files pg_xlog
We are using this awesome tool repmgr developed by 2nd Quadrant for streaming replication.
We set 1000 WALs to be archived. What I noticed though is that on master we have about 600 WALs in the ...
0
votes
0answers
37 views
How we can synchronize a MySQL database to an Oracle database?
How we can synchronize a MySQL database to an Oracle database?
The Oracle database is in secure zone that can only be accessed by application servers. We have multiple MySQL databases in different ...
0
votes
0answers
62 views
Single slave - multiple master MySQL replication?
I need to replicate different MySQL databases from multiple master servers into a single slave server. Have installed multiple mysql instances on single machine with 2 different my.cnf & my1.cnf ...
0
votes
0answers
31 views
High memory consumption using Bucardo tool
I am using Bucardo tool on PostgreSQL 9.0 with RHEL-6 as OS. Suddenly I have encountered high memory consumption and the database is running slow. So I had stopped and restarted PostgreSQL; this ...
0
votes
0answers
54 views
Oracle: Mirror database changes between two databases
I need to keep two whole databases constantly synchronized.
That includes:
Data (of course)
DDL Changes (also changes to stored procedures and pl/sql packages)
All changes need to be propagated ...
0
votes
0answers
37 views
Merge Replication Finding Session Id
I am using merge replication with SQL 2012.
I am writing a custom business logic handler, and would like to know if there is a way to get a session id?
For instance if the custom business logic ...
0
votes
0answers
119 views
Real time replication issue - can't use transactional replication
We have an existing Microsoft SQL Server 2008 R2 database that we need to real time replicate to an identical off-site live web database.
Transactional replication and merge replication will not be ...
0
votes
0answers
77 views
How to user the Tablediff Utility with Replication Filters
I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence.
I see a problem with this approach though. This is because I am using parameterised filters to ...
0
votes
0answers
255 views
Potential cause for memory leak
I have a replication setup where one of those nodes started experiences a slow but steady memory leak.
The setup is kind of like this
M---->S
|
\/
FilteringSlave
| | | |
R1 R2 R3 ...
0
votes
0answers
171 views
How To Speed up Merge Replication
I am running SQL2012 merge replication on a netbook using SQL Express as a subscriber. The netbook has 1GB of RAM.
The replication process works quite well, but it is when it comes to applying the ...
0
votes
0answers
122 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
0
votes
0answers
280 views
MySQL Multi-Master Replication with federated tables failing
Overview
We are trying to implement multi-master replication with MySQL using Federated tables (see explanation below). We have one central Linux server with a LAMP stack. We currently have two ...
0
votes
0answers
462 views
Slave IO Thread not running but check port 3306 is open on master server
I have setup a slave machine and check the port 3306 on the master is open. The problem on the slave is keep showing me this. I have drop and add this user on the master again but still the same.
...
0
votes
0answers
54 views
Replicating Results of Queries on Oracle
I wan to setup a database such that its data come from queries run on a remote database. Basically the source database is very slow and we have no control over it. So, I want to create a second ...
0
votes
0answers
369 views
MySql shell command not replicated to slave - “LOAD DATA INFILE”
I have a shell script that looks something like that:
#!/bin/bash
mysql -udb_user -pdb_password -e "LOAD DATA LOCAL INFILE '/srv/some_file.csv'
INTO TABLE db_name.db_table FIELDS TERMINATED BY ...
0
votes
0answers
204 views
Making chain of Master-Slave servers in mysql
I have three servers, Server X, Y (Version 5.1.54-1ubuntu4-log), and Z (version 5.5.18-2build1~ppa1~oneiric-log).
I have the main mysql DB on X (innodb DB).
now I have created Master-Slave from X to ...
