The database-replication tag has no wiki summary.
0
votes
1answer
32 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
0answers
8 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
21 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
21 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
0answers
47 views
how to configure postgresql 9.2 streaming replication?
I am new in postgresql 9.2.
I want to achive streaming replication (master-slave) in windows xp os enviorment .
1
vote
1answer
71 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 ...
0
votes
2answers
134 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
126 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
0answers
53 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
139 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
140 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
3answers
2k views
What would cause SQL 2008 Log Reader Agent to fail with “This process could not execute 'sp_replcmds' ”?
I've seen this error message in other posts. They didn't seem to help resolving our issue. We are trying this with two SQL Server 2008 servers. I backed up my database from the source server and then ...
0
votes
2answers
448 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
365 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
160 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
54 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 ...
0
votes
0answers
98 views
Schedule replication of MSSQL Views to MySQL Remote database
I have a Microsoft SQL Server 2005 Database inhouse i've to publish some information on the internet and i can't (for security policy) query this database from the web server.
So i come up with the ...
1
vote
2answers
337 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 ...
0
votes
0answers
236 views
Estimating SQL Server network bandwidth requirements for replication
We are starting to implement replication with four different database SQL SERVER 2008 R2.
All standard editions and merge replication.
The problem right now is how to estimate a minimum required ...
1
vote
1answer
180 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
142 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
186 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
75 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 ...
1
vote
1answer
128 views
Is there a convenient way to manually copy the Log Shipping *.trn files from one SQL 2008 server to another?
We have a remote SQL 2008 server (ServerB) that needs to keep a warm (15 minute interval is OK) copy of production data (ServerA). ServerA is also SQL 2008. Log Shipping looks like it will do the job. ...
0
votes
3answers
845 views
MSSQL Database Replication to MySQL
I have MSSQL 2005 server and I have MySQL database in intranet.
I want to replicate some tables from MSSQL database to MySQL database.
I have created ODBC licnked server and have successfully created ...
2
votes
1answer
344 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
399 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
409 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
1k 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
308 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 ...
2
votes
1answer
270 views
Setup database replication between 2 servers
Is it possible to setup replication of oracle databases, with one server outside the firewall? If so any suggestions on how to setup would be great.
0
votes
1answer
104 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
75 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
211 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
408 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
171 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
93 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 ...
1
vote
2answers
177 views
SQL Server 2008 Replication - Loss Potential
Is there any type of replication over a WAN (cross-country) that can guarantee no data loss in a disaster? Are we always subject to losing a few seconds or minutes up to the point?
If so, any ...
2
votes
2answers
2k views
How to set up multiple web and database servers?
My websites have been growing in terms of traffic and the load on the mysql has been increasing. I wanted a solution that would help deal with the increased load on mysql (all queries already ...
0
votes
1answer
71 views
Performance lag for database replication
My company is really sensitive about keeping up the performance on our core system. Our users also have a requirement to replicate or mirror all data to another location (in another location within ...
0
votes
3answers
954 views
synchronize 2 mysql servers (all databases + users)
We want to sync 2 mysql servers with eachother (products & qa system). We would like to sync all databases, data and users of the production machine to a secondary mysql machine.
What would be ...
1
vote
2answers
71 views
Is it possible to have replication between an unknown number of databases?
In other words, can I have a single central database, that gets data from remote databases, but that does not know which remote databases exist until data from the remote database arrives?
This does ...
2
votes
2answers
603 views
Replicate Oracle to MySQL
I am developing a web apps, this web application will be using MySQL.
Now I need to replicate my client's Oracle database into MySQL, only a few tables will be involved.. a table can be up to 2-3 ...
1
vote
1answer
312 views
How to recover from failed Mysql schema update, with replication?
I have two MySQL servers configured with master-slave replication.
Before we deploy a new application version we:
1) STOP SLAVE
2) Take a MySQL dump of the slave.
However, if a mistake is done ...
0
votes
1answer
137 views
SQL 2008 Replication
I have replicated two database in SQL2008.
The last two days the distribution database from publisher server changed to Suspect Mode and the replication process is down.
I read a lot from Google and ...
0
votes
3answers
82 views
My previous team member “replicated” a database on a server onto another server. But now it's not in sync anymore
Database 1 is a regular database server.
He replicated it to Database 2...a direct clone. Master-Master.
They are in "sync" all the time. They each have 40 million rows.
Today, Database 2 is ...
