The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
21 views

mysql prevent update other salve-master db while any record update in slave db

I have master and 3 slave (slave1,salve2,slave3) db in same host. So when I update any record in slave1 db its affected on all other master and salves db. My Question is: How to prevent update all ...
1
vote
2answers
33 views

postgreSQL hot_standby pg_dump on slave

I have master-slave (hot_standby) pgsql configuration and I want to make backups from one of my slaves. I don't want PITR, just good old database dump. I switched to postgres from MySQL. With MySQL ...
0
votes
0answers
10 views

problems with database replication mysql_config_editor

I would like to share with you the problem I have been having for almost a week. I am trying to create a replication between 2 servers. One is in hostgator and the other is a virual machine in Azure. ...
0
votes
0answers
10 views

Setting up multiple databases in Vagrant

Currently I am using Vagrant 1.4.3 in-conjunction with VirtualBox running Unix (Centos) for my development server (using MariaDB). I didn't setup the box myself (so my knowledge of setting this up ...
0
votes
1answer
21 views

How to improve mysql replication performance reading the relay logs in slave?

I have a mysql 5.5 row-based replication being done. The slave is slowly getting delayed relative to the master. On show slave status I see the distance between Master_Log_File and ...
0
votes
1answer
44 views

Size of data in secondary exceeded primary after its initial resync from primary in MongoDB

I step down the primary node, deleted its data and performed the initial resync from new primary. But when i checked the size of data after the completion of initial resync, I found that the size of ...
1
vote
0answers
18 views

Replica Set In Mongo Are All Primary

So I saw a thread on here for when all the replica sets are Primary. The fix was to do rs.Add(hostportStr) on the master server before you do rs.initiate() on the server you want to become a ...
0
votes
0answers
11 views

Amazon rds read-replica, use as archive database

I have hosted my database (MySql) on Amazon RDS service and also created read-replica in the same availability zone. I have send my read queries on that read-replica. Now a days my database is become ...
0
votes
1answer
19 views

Delayed transactional replication setup?

I will need to setup transactional replication for a big database. I use backup/restore to initialize the database because it's too big to use snapshot over slow network. So the following steps are ...
0
votes
0answers
44 views

MySQL replication: most important config parameters on slave for performance on master server?

This query is almost the same as this question. But in this case, a configuration to make the master perform faster or just the same. Case We have a Master-Slave setup on a Mysql 5.0.77 - MariaDB ...
0
votes
1answer
51 views

can we use a mongodb 3.0 and mongodb 2.6 in same replica set?

i know that replicas using different storage engines can coexist in a replica set on MongoDB 3.0 but can we add a MongoDB 3.0 replica to a replica set that consists of MongoDB 2.6 instances ? That ...
0
votes
0answers
9 views

How many postgresql / BDR database can be replicated from a server? [duplicate]

I've been reading the postgresql bdr docs found here: https://wiki.postgresql.org/wiki/BDR_User_Guide I came across this comment in the above doc: BDR operates per-database, not per-cluster ...
2
votes
2answers
91 views

What SQL Server database version do I need?

I am not a database experts but part of the project I am currently interested in accepting requires to do a DB replication. The system will have many outlets... says Site A, Site B, Site C, etc.. ...
1
vote
0answers
35 views

Replicaiton and synchronizing to a central database

My client will have many outlets and each outlet will have a local db. But there is only one outlet which will have a central db. Ideally, my client wants to put everything on a cloud but due to the ...
0
votes
1answer
56 views

The message “Running the Merge Agent process would exceed the maximum number of processes allowed” appears, but it doesn't seem likely

The full text of the message is "Running the Merge Agent process at this time would exceed the maximum number of processes allowed by this publication. The process will run when resources become ...
1
vote
0answers
39 views

Postgresql service run failure

Trying to setup replication through the wal shipping using Postgresql 9.3 x64. Used this instruction from youtube. The problem is - the slave postgresql service won't run. This is what in logs ...
3
votes
1answer
116 views

Oracle Data Pump Import with running advanced replication

In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the ...
0
votes
1answer
21 views

MYSQL Group Replication

I have setup a Master-Master-Slave replication where say A B and C, I want to replicate data from A to B (which is working) and B to C (also working) and from A to C which is not working with two ...
0
votes
1answer
63 views

Notification when the status on sql server replication is “Not Running”

We have a lot of replications set up. Sometimes for some reason, the status of the replication changes to "Not Running/Expired Soon or Expired". Could you please let me know if there is a way we can ...
1
vote
1answer
97 views

Replication consistently fails to bring new rows to subscriber

Short description of the problem: Initial synchronisation to the subscriber works fine. Subsequent synchronisations fail to download new rows. Re-initialising the subscription "fixes" the issue and ...
0
votes
1answer
659 views

Postgresql doesn't accept replication connection

Plain old streaming replication. PostgreSQL: 9.2.7 Windows 8.1 64 bit My primary and secondary clusters are on same windows machine. I have already done pg_start_backup() and everything, so both ...
0
votes
1answer
30 views

MSSQL 2000 replication, incrementing an integer column on a single row using an update statement

I have 2 web servers, both of which connect to separate mssql 2000 database servers, these two servers use merge replication in order to collate tracking data. Now each web server runs an update ...
0
votes
1answer
93 views

I noticed that my MySQL slave's DB size is smaller than the Master's DB

I have a very simple setup of a master MySQL DB with one slave MySQL DB replicating from it. Initially, when setting up the slave, I used mysqldump to get an initial DB dump from the master like ...
0
votes
0answers
8 views

MySQL : Cannot add to the replication Ignore list [closed]

The my.cnf file already had 17 replicate_ignore_db = [Database Name] entries. I added one more. Then I restarted mysql. Then I logged in to mysql and did SHOW SLAVE STATUS \G; but still the newly ...
0
votes
2answers
277 views

SQL Server 2005 to 2012 Replication, cannot access replicated data

I have created publication (snapshot, small table with 10 rows) on MS SQL Server 2005. Then, I created push subscription on MS SQL Server 2012. When I try to select data form table, process takes ...
1
vote
0answers
141 views

How can I correct MySQL replication while using federated tables?

This is an overview of what I have going I have 2 server A (10.0.4.22) AND B (10.0.4.29) A is a replication of B and B is a replication of A (yes it is a ring replication) ON A I have 2 table uat and ...
3
votes
1answer
81 views

SQL Server Replication w/o network connection

Is there a way to use SQL Server Replication without a network connection? My would-be publisher is an SQL Server 2005. It is on the "outside" as it is connected to my company's primary LAN, which is ...
1
vote
1answer
58 views

Mysql Server version: 5.0.77-log Source distribution

I have a master(M)-slave(S) replication on MySQL. During a failover test, the master was brought down and the slave was made the master by doing STOP SLAVE; RESET MASTER;. Since there are only 2 ...
0
votes
0answers
52 views

replication error Error Duplicate entry… for unique key

I have two database that one of them is replicated of another one,my tables have unique key on some column ( NOT primary key ),so if in replication process an Error Duplicate entry..... occur,these ...
1
vote
1answer
474 views

PostgreSQL Slave has more files in pg_xlog than /wal_archive

Background: for various reasons I am switching PostgreSQL Slave from a Streaming replication to a warm standby replication. The streaming replication was setup using this guide: ...
0
votes
0answers
14 views

Distribute data from a temporal database

I'd like to know whether there are some best practices for distributing data contained in a temporal data base. My application will make some changes to a master data, which are then stored in a ...
0
votes
1answer
49 views

MySQL replication issue when master gets restarted

I have the following environment: NodeA and NodeB in NDB cluster. NodeC InnoDB outside cluster. NodeB is replication master and NodeC is slave. I have set up replication and it works fine. The ...
0
votes
2answers
50 views

Mysql replication with c

I have huge database on MySql and It's become more and more huge. So, Now I am facing performance issues with my database. Some of tables has millions of records in it. like my login detail table ...
0
votes
0answers
55 views

Mysql 5.5+ replication heartbeat feature

I am writing scripts to monitor replication, and while analyzing effect of MASTER_HEARTBEAT_PERIOD keeping in mind about 3 TCP parameters viz : tcp_keepalive_time, tcp_keepalive_intvl, ...
0
votes
1answer
1k views

Move Oracle database to new server

I have a Oracle 11g R1 Standard Edition database on production server working on Windows 2008 R2 SE. Unfortunately server it not working properly (os/hardware failure) and I need to move it to ...
3
votes
1answer
157 views

Replicating 3000+ SQL Server databases

I'm currently investigating the different options there are setting up a DR site for our main data centre. In an ideal world, we would have fewer, larger databases, however due to architectural ...
2
votes
1answer
343 views

Best design of mongo replica set for DB read/write speed

I'm building a Node app that uses MongoDB. Whilst it would probably be fine to have node and mongo sitting on the same VPS, I want to ensure that the MongoDB is backed up and maintain high ...
1
vote
1answer
2k views

How to Configure PostgreSQL Hotstandby Automatic Failover

So I have configured two postgeSQL servers to have hotstand by streaming, now my question is, how can I configure it so that when the master server goes down, the slave server will become the new ...
0
votes
0answers
216 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
1
vote
0answers
105 views

MySQL SSL Master-Slave replication not syncing

I have originally posted this thread on stackoverflow and after a comment I moved it here. The original post can be found here. I have setup a typical Master-Slave replication scheme for my MySQL ...
7
votes
2answers
1k views

Migrate heroku database to Amazon RDS with minimum downtime

I have a heroku postgres database and want to migrate it to Amazon RDS to save cost. What's a way to do so with minimum downtime? Usually this involves replicating database in real time and then ...
0
votes
1answer
592 views

MySQl master - master replication not working [closed]

I'm trying to setup a master - master setup and I see both masters connect to each other in workbench: server 1: -- Thread Id: 112 -- User: slave -- Host: 207.244.73.38:55164 -- DB: None -- ...
0
votes
1answer
87 views

Identity Column Behaviour After Replication

Say we have two Servers: Server A and Server B. Data is being replicated (vanilla Transactional Replication) from A to B. For one of the Tables, we have data as follows: Server A - Server B ...