The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
29 views

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server ...
-2
votes
1answer
33 views

Error when I run “bucardo add database mybd”

This is the message error: install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl ...
0
votes
0answers
88 views

How to recover a Standby in Postgres Slot Replication

I am using 4 nodes of Postgres 9.5 server in a Slot replication set up. One node is acting as a Master and three other nodes as Standby nodes. Everything ran fine for few days and suddenly one node ...
1
vote
0answers
191 views

How to automate failover of master in PostgreSQL 9.5 on Windows?

I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I ...
0
votes
1answer
185 views

Postgres 9.5 server not starting due to already active replication slot

I have a Postgres (version - 9.5 Beta) server replication set up where there are 3 slaves and a primary server. After all required configuration is done, I start 1st slave after taking base backup and ...
0
votes
1answer
104 views

Slot replication not working in Postgres 9.4

I am using Postgres 9.4 on Windows 2008 server. There are three such instances that I am using. One as master and the rest of the two are slave/standby. The version of Postgres is 9.4 in all the three ...
1
vote
1answer
25 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated ...
0
votes
1answer
817 views

repmgr - after a failover switch, both nodes act as a master

I have a two node PostgreSQL cluster configured through repmgr. The database topology looks like this: db1 - 10.10.10.50 ( master ) db2 - 10.10.10.60 ( standby ) wit - 10.10.10.70 ( witness ) The ...
2
votes
1answer
361 views

CouchDB replicate ALL databases?

I have a CouchDB I'd like to replicate to another server in order to do backup dumps without taxing the production server. The production CouchDB has a varying number of databases and I'd like to sync ...
0
votes
0answers
155 views

How do I run slony as a service on Ubuntu with /etc/init.d/slony1

I am investigating setting up Slony-I replication for 2 PostgreSQL databased on Ubuntu Trusty 14.04. I have gotten the basic replication working. But I have to start the slon command manually on each ...
1
vote
0answers
54 views

How can I efficiently create daily write replicas of an RDS instance?

We're looking to create a replica of a postgres RDS instance that our developers can write to (not just a simple read replica that AWS can easily provide). Currently we run a script nightly that ...
2
votes
1answer
819 views

Mongo secondaries stuck at startup state

I have a MongoDB replica set with secondaries that won't make it past the STARTUP state. The database is large but they should have moved to STARTUP2 by now. The correct ports are open as I can ...
3
votes
0answers
157 views

combine two mysql replication log files

So I use a master-master replication of a mysql database and load balance traffic between the two. This results in server A with a binlog of all it's transactions and Server B with a binlog of only ...
0
votes
1answer
661 views

Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication

I'm trying to setup a 2 Node Cluster with Postresql 9.3 and Streaming Replication. Streaming Replication is successfully configured. Master is listen up and is sending to slave. I can do failover ...
3
votes
1answer
1k views

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so ...
2
votes
1answer
479 views

mongodb keep looping while trying to sync data

I'm converting my my standalone mongodb into a replica set. I've added one more member (and I want to add two more members later, and to shutdown the primary server). My primary mongodb is running ...
0
votes
1answer
707 views

Communication errors while trying to replicate mongodb

I'm trying to replicate my mongodb database, I've crated 2 VM on my windows azure account. both of them are Ubuntu 14.04. I've opened 27017 port on both of them, and installed mongodb latest version. ...
3
votes
1answer
574 views

Multiple Postgres Servers (one writer, multiple reader) with Shared Disk

Here's the scenario: One shard disk (Gluster) Multiple Postgres servers Requirements: Use the shared disk to store the database files Use a configuration which provide maximum efficiency ...
1
vote
1answer
179 views

Very strange disk-usage for replica in Mongodb

tl;dr: the new 2.6 replica eats up a lot more disk space than the 2.4 members. We're heavy users of MongoDB's GridFS. We're currently on 2.4, and are intending to upgrade to 2.6 by simply adding a ...
0
votes
0answers
947 views

RockMongo Connection Issue with MongoDB Slave

I have a MongoDB Replication with Master-Slave (not RepliSet) I have configured RockMongo on two servers. But I able to login to master server through rockmongo but when I login to slave with rock ...
1
vote
1answer
166 views

Running a database heavy webapp in the UK and Aus server setup

I am running a webapp from a uk datacenter. Speed is fine as expected. The webapp relies heavily on a database. I would like to open the webapp to Australia and New Zealand but maintain good response ...
0
votes
1answer
616 views

Scheduled copy of production database into test database

My question is similar to this one. I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and ...
0
votes
1answer
442 views

PostgreSQL 9.1 on CentOS 6.5 - recovery.conf causing process exit with error code

I did setup streaming replication on the Ubuntu 12.04 LTS with rsyncing of the WAL files in case of failure. Now I was trying to do the same on the CentOS 6.5. To do this I've added official RPM from ...
1
vote
2answers
134 views

MySQL Replication threeway

We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good. The management tool in our office connects directly to ...
4
votes
0answers
666 views

UDP Overflow / UDP Drops on Standby Postgres Service

I am stumped trying to prevent an overflowing UDP buffer on a standby Postgres service. Any help would be most appreciated. Essentially a UDP buffer associated with the pg_standby process on my ...
1
vote
0answers
522 views

SQL Server Replication - How to connect to a system via computer name rather than IP address in Amazon AWS?

In Amazon AWS, VPC, I am trying to setup replication in SQL Server, and have three servers setup with port 1433 RDP open (1 web, two SQL). I can RDC into each server. From the web server, I can ...
1
vote
0answers
624 views

CouchDB v1.2.0 - Timeout error on replication

Currently, I have a replication task that looks something like this: { "continuous": true, "create_target": true, "owner": "admin", "source": "https://remote/db/", "target": "db", ...
0
votes
1answer
1k views

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it ...
1
vote
3answers
653 views

Replicating databases using Dell equallogic

Can the Dell Equallogic 6100/4100 replicate databases like mysql, MS SQL 2012, and Oracle 11g? I would like to set up my web applications and their databases in VMWare 5. They would run off the ...
-1
votes
2answers
238 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
1
vote
1answer
2k views

“Could not create IPv6 socket” postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
0
votes
1answer
405 views

Postgresql replication lag EU/US

I've a Postgres 9.2.1 server master (geolocalized in EU) and 2 slave replica (one in EU and one in US). The EU slave is used also for read queries, the US only for failover. Is it possible to have a ...
0
votes
1answer
2k views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
0
votes
1answer
70 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
0
votes
1answer
157 views

Introduce artificial delay in streaming replication

I have set up PostgreSQL with streaming replication. It replicates very fast, in a fraction of a second. I'd like to insert a delay of 5, maybe 10, maybe 15 seconds, so that bugs related to ...
0
votes
1answer
2k views

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 ...
0
votes
1answer
232 views

MySQL and MariaDB replication

Did anyone configure the replication from mysql to mariadb if yes can let me know how he did it thx in advance. My problem occurred after getting replication to start and the error is saying Error ...
1
vote
1answer
328 views

Copy Exchange Database from Passive to Active

I have a CCR running with a total of 6 servers 2 MB, 2HT, 2 CAS. I had a failure on active node this morning and everything failed to my passive server, i had some issues with the logs, as the werent ...
1
vote
0answers
186 views

Recreate Dynamcis CRM “Filtered Views” for use on SQL server replicated by Scribe RS

I'm considering moving from CRM 2011 on premise to CRM Online. The major concern for me is the lack of SQL access, but I understand Scribe RS has a replication solution that will keep a copy of the ...
4
votes
1answer
693 views

MongoDB Replica-Set with Replication Lag on one node only

we experience a strange behaviour in our MongoDB Replica-Set, setup of 3 Nodes (all Xeon Quad-Core-Class CPUs, 16GB of RAM for one, 24GB for the other two nodes) The one node with less RAM is normal ...
0
votes
1answer
2k views

what port should I open for mysql master-master replication?

I have two servers running php5-fpm and a load balancer running nginx, the three servers share /var/www/drupal using nfs. nfs is working correctly. I replicated the two servers' database using mysql ...
0
votes
2answers
5k views

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on ...
1
vote
2answers
1k views

Best PostgreSQL replication solution that minimizes network costs

I'm looking into PostgreSQL replication solutions. I know two varieties of these solutions Low level - which involves streaming log-shipping, hot-standby features available in PostgreSQL 9.x High ...
1
vote
2answers
297 views

mysql replication 1x master, 1x slave

I have just setup one master and one slave server, but its not working.. On my website I connect to the slave server and I insert some rows, but they do not appear on the master and vice versa.. What ...
2
votes
0answers
70 views

SQL Server 2008 R2 Replication conflict

We have software that during the installation or updates it drop and adds all of its views, triggers, and stored procedures. This became a problem when we tried to implement a snap shot replication on ...
1
vote
2answers
2k views

How should I back up multiple in-use MS Access databases?

Disclaimer: I'm a software engineer, not an IT professional, sorry if some of my suggestions are silly or otherwise ridiculous. A windows application, which will remaining running at all times, is ...
1
vote
1answer
308 views

MongoDB not replicating properly

I am using mongoDB for my application hosted on 3 amazon instances. I have a got a Primary Node with highest priority (100) and 2 Secondaries with priority 99 and 98. A few days ago I started getting ...
0
votes
2answers
287 views

Fault tolerant DBMail with PostgreSQL Replication - what are my options here?

I'm currently planning a more fault tolerant setup for my organizations Mail setup. We currently have two machines available in different datacenters, that we're planning to use for this, one being a ...
0
votes
1answer
280 views

Server mirroring strategy questions SQL Server replication, MySQL replication, file replication, etc

I'm working as an application developer for a company that I've been with for for some time. The business would like to mirror their existing windows server (server A) to a new server (server B) with ...
1
vote
1answer
95 views

SQL Server 2005 to Mysql Replciation DATA duplication

I set up Replication between SQL Server 2005 and Mysql 5 using following articles : http://ratecontrol.blogspot.com/2010/12/one-way-transactional-replication-from.html and error setting up ...