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
26 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
0answers
25 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
16 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
2answers
25 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
37 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
58 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 ...
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
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
45 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 ...
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 ...
2
votes
1answer
72 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 ...
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 ...
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 ...
7
votes
2answers
278 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
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 ...
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
21 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 ...
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
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 ...
1
vote
0answers
19 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
37 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 ...
0
votes
1answer
43 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
22 views
postgres-xc: ERROR: cannot set transaction read-write mode during recovery!
I am trying to make a HA in postgres-xc After creating an environment of streaming replication I am trying to create a table in default database as coordinator logged in. But it gives me the following ...
0
votes
0answers
35 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 ...
0
votes
0answers
33 views
Data deleted from replicated table
I have two servers (one publisher and other is subscriber). The replication is succesfully running for a long time. I am using transactional replication with updateable subscription.
Couple of days ...
0
votes
0answers
23 views
MySQL Err 1032 on only 1 Slave
I'm getting a very strange error on one of my MySQL servers and I'd appreciate some help.
The Setup
I have a separate environments.
* Environment 1 consists of the Master Server and 1 Slave.
* ...
0
votes
1answer
25 views
How to achieve this sql server replication scenario?
I want to achieve below illustrated scenario via sql server replication.
Client A and Client B are client databases containing same article Table A. This article needs to be published by Client A ...
3
votes
1answer
59 views
Best strategies to have a backup of an RDS MySQL database
I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited.
I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup.
I know ...
3
votes
1answer
28 views
Will creating a view on a MySQL replication slave break the replication?
We need to run some very ugly queries on a MySQL replication cluster.
Does anyone know if creating a view directly on the slave will break the replication of the other, otherwise untouched data ...
2
votes
1answer
60 views
Percona Node fails to join: Operation not permitted
Joining a new Percona node fails with:
130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
1
vote
2answers
50 views
Replicating schema changes between production and development databases [duplicate]
Not too sure if this would be a good and proper way to go about things, so I apologize if I'm kind of far off.
Currently running Microsoft SQL Server 2005, and in this we have a database for a ...
2
votes
1answer
29 views
How to schedule PostgreSQL replication?
I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen.
I'll be using postgres internal replication solution but as far as I ...
1
vote
1answer
53 views
Which one to use? InnoDB Replication or MySQL Cluster?
I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
0
votes
2answers
72 views
MySQL Master/Slave. Actual use of Slave Machine
We have a MySQL server running in a mobile production trailer. The trailer is out on the road for weeks at a time. We have cell internet and wifi access is nearly all of our locations. Our office ...
0
votes
4answers
40 views
Master/Slave without populating tables
So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
1
vote
0answers
39 views
How to sync mysql remote database daily ?
I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master ...
0
votes
1answer
36 views
How to install and configure Postgres-XC in windows?
Can anybody suggest me any resources of the complete installation procedure of postgres-XC in windows. I've installed postgresql-9.2 in my windows and can use it. Now I need to know the installation ...
0
votes
1answer
33 views
distribution.dbo.MSdistribution_history comments explanation
The comment column of distributor.dbo.MSdistribution_history contains comments such as
<stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880">
...
0
votes
2answers
77 views
mysql replication successful but slave not replicating
I have created a mysql master-slave configuration and things look fine .
the " show master status;" on slave doesnt show any error . this is the output
Slave_IO_State: Waiting for master to send ...
1
vote
1answer
92 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
1
vote
1answer
69 views
Merge Statement + Replication difference for SQL Server 2012
We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
0
votes
1answer
21 views
Is it possible to upgrade mongodb cluster without upgrading arbiters?
Is it possible to have running real nodes with version 2.4 and arbiter nodes with 2.0 or 1.8 in the replica set?
Upgrade guides for version 2.2 and 2.4, did not tell anything about upgrading ...
0
votes
2answers
66 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 ...
2
votes
1answer
63 views
Is replication from SQL Server 2008 to PostgreSql possible?
Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
2
votes
2answers
48 views
Modifying replication distributor & publisher
I have a SQL Server 2008 transactional replication setup as follows:
192.168.100.1 <-- Distributor
192.168.100.2 <-- Publisher
192.168.100.3 <-- Subscriber
Our network team want to change ...
2
votes
2answers
62 views
Does MySQL 5.6 support fan-in replication?
I've known for quite awhile that Continuent's Tungsten Replicator supports fan-in replication (example).
By fan-in replication I mean combining multiple datasources into a single instance (like a ...
0
votes
0answers
34 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
