The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
57 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 ...
0
votes
0answers
13 views

SSL error: ccs received early

I'm getting this error on my slave postgresql server. 2014-11-21 10:30:05 CET FATAL: could not receive data from WAL stream: SSL error: ccs received early 2014-11-21 10:30:05 CET LOG: invalid ...
2
votes
1answer
164 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
105 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
58 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. ...
0
votes
0answers
56 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
1answer
57 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 ...
0
votes
1answer
71 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
314 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
42 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
108 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
317 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
82 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 ...
3
votes
0answers
394 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
239 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
278 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
244 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
427 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
124 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
576 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
199 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
437 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
36 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
122 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
2answers
989 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
174 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
204 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
122 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
376 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
887 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
2k 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
894 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
251 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
68 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
988 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
246 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
228 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
239 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
86 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 ...
2
votes
1answer
470 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
1
vote
3answers
707 views

MySQL slave reporting incorrect values for Seconds_Behind_Master

I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which ...
0
votes
1answer
831 views

MS SQL New Publication Wizard - Unable to connect to server 'Server Name'

I am trying to create a new publication. SQL Standard 2008 windows 2008 r2. I am logged into the sql server management studio on the server that sql is installed. I have logged into the sql server ...
2
votes
3answers
2k views

PostgreSQL 9.0.X or 8.4.X - performance, replication, stability

I've been developing an app w/ server infrastructure for a while now, and I'm getting ready to release soon(ish). So far the server backend has been running on PostgreSQL 8.4.7, and it's working as ...
1
vote
2answers
498 views

Exchange 2010 mailbox server role on a secondary dc - what is your opinion

I'm looking at the database availability groups in regards to creating a constant replication of the mailbox database. Here are three options I'm thinking of (and sorry if I'm wrong with my ...
0
votes
1answer
121 views

Replication on system databases

Is it possible to replicate system databases? I only ask because I had an issue previously (described here) that appeared to be impossible but has come back up again this week. This time TempDB log ...
1
vote
1answer
80 views

MySQL Database Replication and Server Load

I have an online service with around 5000 MySQL databases. Now, I am interested in building a development area of the exactly same environment in my office, therefore, I am about to setup MySQL ...
0
votes
2answers
246 views

How to keep Ms-SQL database always UP: mirroring or replicationg?

I have several Tb databases in the Windows Server 2008. I would like to keep alive the service when the server is failing or the raids are needs to be rebuild. Which model to choose Replication or ...
0
votes
2answers
447 views

What server hardware are people using for replicated mongodb servers?

Since mongodb, couchdb are for horizontal scaling and have inbuilt support for replication, what hardware is being used for them ? Specifically looking for hardware for replicable mongodb instances. ...
0
votes
2answers
200 views

Replication keeps popping up on SharePoint databases

My typical discovery scenario: We receive an alert that the transaction log is growing quickly. We are in Simple Recovery so I go to check it out. Log is already sized to 100GB and is at 80% ...
0
votes
1answer
118 views

What is the best of two approaches to achieve DB Replication?

we have two approaches to achieve DB Replication: Master-Master replication. Master, 1 Primary Slave, 1 Secondary slave. I am planning to analyze these two approaches and prepare a comparison ...