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
2
votes
1answer
15 views
MySQL, optimize and replication
I have two MySQL (MariaDB actually) servers, a master and a slave with standard replication.
Two times already in less than a month I've had my slave become unusable.
This is what I experienced:
...
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
19 views
Mview replication
We are setting up a large scale replicated environment and would like to know if there is a way to skip certain dml for eg. deletes during data trasfer with simple mview replication. Also, is it ...
0
votes
0answers
14 views
How to delete orphaned records from sysmergesubscriptions table?
I have some old orphaned records for old subscriptions that I want to delete from the sysmergesubscriptions table.
Each time I delete unnecessary records, it show up again after it syncs with any ...
0
votes
0answers
13 views
How to properly clean Merge Replication Setup
What is the proper way to completely clean Merge Replication setup ?
I have tried to delete the subscriptions, then delete the publication then "Disable Publishing & Distribution" & delete ...
1
vote
1answer
36 views
Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?
I've set up a Postgres database on a server with 2 CPU cores, 4GB of RAM and an SSD volume (on top of RAID 10 of course). This is our (sort-of) "beefy" production database server (I can easily add ...
1
vote
2answers
56 views
SQL Server Replication Alternative Software
We have used SQL Server Replication for a long time and had some issues with it that sometimes we needed to reinitialize subscriptions to fix some issues & other times we needed to destroy the ...
0
votes
1answer
43 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
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 ...
5
votes
2answers
171 views
Initializing Transactional Replication From Backup
There is an option when setting up a publication for replication to Allow Initialization From Backup. We have been creating replicated databases for several years now and have always initialized from ...
1
vote
1answer
38 views
PostgreSQL: How can I setup Master-Slave replication with DML changes in Slave
I have a master database (PostgreSQL 9.0) and I need to setup a streaming replication on a slave. Slave db can read/write and make schema level changes too which shouldn't write back to master. Can ...
0
votes
1answer
31 views
MySQL replication as both master and slave (replication loop?)
I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
0answers
19 views
PostgresPlus advanced server replication testing issue
I made the replication on my Windows Server 2003 system as master DB and another XP system for slave DB. I just made the configuration, but I don't know how to check the replication of database.
I ...
0
votes
2answers
453 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
1answer
19 views
Need a log based replication / CDC solution to publish postgres to oracle subscribers
We have a moderately large postgres 9.1 db that is currently 3TB and will likely grow much larger over the next couple of years. we need a reliable and fast solution for moving this data into either ...
0
votes
2answers
44 views
Percona XtraDB Cluster and MySQL Replication
I've setup a 3-node multi master replication with percona xtradb cluster, it works perfectly.
Now I've tried to add some read-only slaves setting up replication as usual but it seems the binlog ...
2
votes
1answer
71 views
SQL Server Many-to-One replication
I have 8 individual SQL Server 2008 R2 machines, each hosting 1 database. Each database has an identical table structure and schema, and entirely unique data.
I would like to establish a reporting ...
3
votes
1answer
75 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
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 ...
7
votes
2answers
276 views
Is a geographically distributed application with SQL Server replication a good idea?
We are currently thinking about a target architecture for a geographically distributed application.
This application tracks and schedules the movements of all material units across various production ...
0
votes
2answers
64 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
0answers
17 views
Having trouble connecting tungsten replicator from EC2 to RDS
I am testing using Tungsten Replicator to help migrate large databases to RDS. I have no trouble setting up the service on the EC2 "master". I am using a second EC2 instance as a kind of relay server ...
0
votes
1answer
32 views
mysql replication goes out of sync for some tables
We are running mysql 5.1.61 on redhat systems and have the following setup
One master and four slaves replicating from the master, we recently added a new slave for replication and over a few days we ...
0
votes
0answers
13 views
“Row not found at subscriber” with a row filter
I had a production issue today where delivery of a handful of update statements failed at the subscriber with "row not found". What's odd about it is that I have a horizontal filter set up on the ...
1
vote
1answer
182 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 ...
0
votes
1answer
27 views
Database replication using wamp?
I have created a POS system for our corporation, in the HQ we have a wamp server with the main database, we also have more than 25 branches across the country.
I will setup a wamp server on each ...
5
votes
4answers
450 views
Is there a way to measure replication lag in MySQL with a resolution less than 1 second?
Is there a way by which you can measure replication lag in MySQL with a resolution of less than 1 second?
That is, can replication lag be measured on the microsecond or millisecond level?
2
votes
1answer
103 views
Maatkit shows the MySQL replication error in one table, but won't fix it
We use MySQL 5.1 with a primary/secondary replication setup. I use mk-table-checksum from Maatkit to generate checksums on the master and perform consistency checks on the replica.
mk-table-checksum ...
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 ...
3
votes
2answers
127 views
PostgreSQL: Can the archive command for master and standby point to the same directory?
I use streaming replication and PITR (WAL files) in my cluster, currently I have different versions of postgresql.conf for the master and the standby server.
The only difference in the files is the ...
1
vote
2answers
93 views
Does pt-table-checksum point out rows that are different between Master and Slave?
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
2answers
64 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 ...
1
vote
1answer
552 views
How do I configure multi master replication on WAMP?
I want to configure mysql multi master replication, but I've not seen any comprehensive article or tutorial on how to do that on WAMP. I will be grateful if some will point me to a tutorial, or ...
0
votes
0answers
21 views
How to setup a Postgres-xc streaming replication with master-slave(for HA)?
Can you guys please help me about how to make streaming replication with master-slave configuration using Postgres-xc to confirm an HA environment?
Thanks
0
votes
0answers
44 views
Replicate database without Internet connection
I'm working on a company where I have a central DB and several agency databases. See the diagram at here. All the databases are identical, just the data can change and in some cases. I've no internet ...
3
votes
2answers
137 views
IBM DB2 v9.7 HADR TSA failure on the standby server
I have an environment here where I have 2 servers running DB2.
One is the primary and the other one is standby. They replicate with HADR and failover is made automatically by TSA.
What's the default ...
2
votes
1answer
1k views
Mysql thinks Master & Slave have the same server-id
I've been setting up a master->slave_a->slave_b relationship and having a little trouble. I currently have the master->slave_a replication working fine.
Each of the two slaves have exactly ...
0
votes
0answers
32 views
How should I arrange a database replication for my site?
Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that database is the bottleneck.
I have two servers to handle the site: A and B, on the same ...
0
votes
0answers
20 views
All four data nodes in MySQL Cluster in same node group
I am testing MySQL Cluster 7.2. I have two servers, mysql1 and mysql2. I want the management server and two data nodes to run on mysql1 and two other data nodes to run on mysql2. My config.ini file ...
1
vote
1answer
81 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 ...
0
votes
1answer
35 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
84 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
2answers
1k 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
0answers
21 views
Issue with slony-I replication on postgres master and slave database
I have two system with OS windows 8 and windows XP. I installed the postgres plus advance server for database replication on both system. I followed this link for whole process. But there is one issue ...
3
votes
1answer
149 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 ...
0
votes
2answers
126 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 ...
0
votes
1answer
36 views
Repairing Broken Binary Replication in PostgreSQL 9.0
I have a binary replication that was stopped for so long that the WALs were removed and as a result, it ended up being old. I'm trying to reestablish the replication and the best way I've found so far ...
1
vote
0answers
15 views
CouchDB - painfully slow replication
we intend so replicate a database around 500GB in size from one host to another and use a loadbalancer splitting up the requests.
On small test databases that worked great, yet repliating the main ...
0
votes
1answer
42 views
SQL Server: subscriber as publisher and hierarchical replication
In Oracle Streams one way replication from one DB to another is a basic block for many replication topologies (N-way, hierarchical, combined and so on), and changes could be captured and applied for ...
0
votes
0answers
31 views
MySQL asynchronous multi master replication conflict resolution
I have setup Multi Master replication, following this blog thread:
http://0wned.it/geek-bits/guides/mysql-multi-master-replication/
And now it synchronizes perfectly, up until the moment the ...
