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

learn more… | top users | synonyms

1
vote
1answer
20 views

Restarting a Publisher involved in Merge replication

Our hosting provider would like restart the SQL Server that a publisher in a merge replication topology. I'm not able to clearly understand best practice for doing this from the Microsoft docs. Our ...
1
vote
0answers
77 views

“Replicate” Table structures with sp_addscriptexec

In our customers environment is a massive central server (running SQL Server Enterprise 2008R2) and some distributed PCs (running SQL Server Standard 2008R2). The central server has a replication for ...
1
vote
0answers
2k views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
1
vote
1answer
33 views

In MySQL how do I grant a user access to a read replica only?

I have some users that I want to grant read only access to my database so I setup a replica server, but I don't want to grant them access to the master. I'd assume that this is a common use case, but ...
0
votes
2answers
38 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 ...
2
votes
1answer
78 views

InnoDB: “Only one log file found” after binary import

My first one on DBA... After successful upgrading a master MySQL server 5.5 to 5.6.17 (CentOS 6 VPS serer), I done and moved my binary backups to a slave server (same version 5.6.17 but different ...
1
vote
0answers
69 views

sqlcmd returning NUL instead of NULL for tinyint column

sqlcmd -E -d MyDatabase -Q "sp_helpsubscription" -s "," -o file.csv -W -u Column 23 which is suppose to be a tinyint (subscriber_type) is output as NUL instead of NULL when the value is NULL. I ...
0
votes
0answers
140 views

SQL server replication error - the row was not found at the Subscriber

I am doing transactional replication on specific tables. I am getting an error: The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: ...
0
votes
1answer
469 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
3answers
108 views

Master-master Replication with 3 Nodes

I need to configure mysql master/master replication with 3 nodes. Currently I have master/slave setup and I need to move it to master/master with 3 nodes. I have gone through some posts about ...
1
vote
1answer
19 views

Bypassed, Empty Relay Log

We have a simple 1:1 Master-Slave replication configuration. The Master crashed, but we recovered and replication seems fine (confirmed by pt-heartbeat and SHOW SLAVE STATUS) but we've picked up one ...
0
votes
2answers
53 views

Mysql checksum for master-slave replication returning different values, despite being identical

I've set up a master slave replication in mysql and to make sure that I know if the data starts getting out of sync I created a script that: Locks both databases on both servers. Prints the ...
2
votes
2answers
144 views

MySQL 5.6: Slave_IO thread stops working

Standard replication breaks for no apparent reason. mysql> SELECT @@version, @@version_comment; +---------------+----------------------------------------------------------------------------+ | ...
1
vote
1answer
67 views

Does PostgreSQL support multi-threaded replication?

Is PostgreSQL replication single-threaded ? Are there any tools to achieve multi-threaded replication ? I'm asking this since Mariadb support this and currently I'm learning both these dbs.
2
votes
1answer
102 views

Promotion of PostgreSQL standby and application reconnection

Background: I work for a small company. We have been using PostgreSQL on Heroku as one of our core technologies. While, in general, we've been happy with Heroku, the company has made the decision ...
0
votes
0answers
48 views

Database design for large incoming data

I've been tasked to design a database to handle a large volume of incoming traffic from sensor readings, possibly 1,000s an hour when it's at full strength. Each reading will be relatively short - ...
0
votes
1answer
28 views

mongodb - “replication oplog window” possibly reduced due to profiling - when profiling disabled no change?

PROBLEM I have a 3 member replica set (no sharding) running mongodb version 2.4.8. Using MMS (Mongo Monitoring) I can see that on 7th July 2014 at 12:00 my "replication oplog window" dropped from ...
2
votes
1answer
164 views

Can I replicate a database from SQL Server 2012 to SQL Server 2014 (with 2014 distributor)?

I am planning to have database replication running from SQL Server 2012 (publisher) to SQL Server 2014 (both distributor and subscriber) -- pull replication. Has anyone done this type of ...
0
votes
0answers
45 views

mongodb master slave replication

I Have Setup master slave replication in mongo its working fine for few month then after that suddenly replication fails.I have started again with initial sync but during sync after a specific point ...
0
votes
1answer
109 views

Huge size on mongodb's gridfs. Should I compact ?

I'm running mongodb and grid.fs to store small files (less than 20mbs). These are part of a replica set. I currently have more than 350000 files stored. I've noticed that the chunks collection takes ...
1
vote
0answers
99 views

Error to connect mongos when trying to create replicated sharded cluster

I'm trying to create an replicated sharded cluster in mongodb. Initially I've created two shards and there are a replica set with three members in each shard. And all the shards and replicasets run in ...
0
votes
1answer
365 views

MySQL row-based-replication HA_ERR_KEY_NOT_FOUND… which record is it?

I have a mysql slave (5.1) using row-based replication. The slave has stopped with the error HA_ERR_KEY_NOT_FOUND. OK fine, it's trying to update a record that doesn't exist for some reason. Using the ...
1
vote
1answer
94 views

MS SQL Server 2012: once a day full replication (automatic backup/restore) for reporting

Our company is w/o a DBA, and it has fallen on me (a complete DB noob) to handle some critical database tasks. I'm looking for the best solution for us to be able to "copy" a full database to another ...
0
votes
1answer
26 views

Can I generate binary logs if they weren't turned on?

Ok, so here's the scenario: Our master went down, boom! gone (Call this one DB1) We switched our backup replica server. Ok, life is good, sort of (Call this DB2) Binary logs were not turned on for ...
2
votes
1answer
35 views

Cannot start SQL Server replication as already running

I'm trying to configure a sql replication on the sql server 2012 . I am logged in as "sa", when I attempt to start replication i get the following error : How can I stop this job and restart the ...
2
votes
3answers
1k views

ETL: extraction strategy for 200 source databases

What is the best extraction strategy for approximately 200 SQL Server 2005 source databases (same schema) for a daily load into a staging area in preparation for data warehouse cleansing, ...
3
votes
2answers
394 views

Data sharing between client and server two ways

One of my Silverlight applications is running. This Application is using one central database (SQL Server 2008) and three other client databases (SQL Server 2008) in server other locations. Our ...
1
vote
1answer
61 views

Safely changing innodb_buffer_pool_size on MySQL replication master?

We have a MySQL server which is a replication master. We need to change the innodb_buffer_pool_size and innodb_flush_method to (hopefully) improve performance as the database has grown. What is the ...
1
vote
1answer
43 views

MySQL replication working fine, but still shows “Waiting for master to send event” at 280000 seconds

To repeat the title: MySQL replication working fine, but mytop still shows a thread "Waiting for master to send event". It has been like this for a few days, and is now at 280000 seconds. But ...
0
votes
1answer
25 views

Mongo DB - reading during update

Is it possible in a three-member-replica set (1 primary, 2 secondaries) to update records on the primary, or even delete several records and insert the updated data, and still execute read-ops on the ...
1
vote
2answers
45 views

mysqld is not producing binary log

I'm trying to understand why mysqld is not writing binary log anymore... [root@ip-10-179-155-214 mysql]# grep ^log-bin /etc/my.cnf log-bin=mysql-bin [root@ip-10-179-155-214 mysql]# ll mysql-bin.* ...
0
votes
0answers
39 views

Is there a MySQL setup for my use case?

I have multiple nodes that are mostly independent of each other, meaning 99% of traffic is reads to data contained inside themselves, plus some writes that need to be instantly available for the node ...
6
votes
3answers
6k views

MySQL replication - slave is continuously lagging behind master

I am using MySQL-5.1.50 with a Master-slave replication setup. Most of the time the slave is lagging behind the master. When I run show processlist;, there is no query that's taking a long time. ...
0
votes
2answers
1k views

MySQL Slaves lag behind master

I have one master and four slaves. Sometimes all my slaves lag behind the master. I have implemented the heartbeat for monitoring replication lag. Now I am trying to find why the slaves are lagging ...
0
votes
1answer
33 views

Sync MySQL 4.0 table to MySQL 5.6 server every few minutes

I am tasked with getting a copy of a table on a MySQL 4.0 server synced to a completely different database on a MySQL 5.6 server every few minutes for the purposes of having that table available ...
3
votes
1answer
119 views

How to upgrade MySQL (5.5) production DB to 5.6 with minimal downtime

Our existing Database size around 200GB. We want to use consistent, parallel backups methods. For testing, I migrated my Development DB from 5.5 to 5.6 by running mysqldump with option ...
0
votes
0answers
23 views

Postgres sync database

I have two postgres databases. Master = master_database Slave = database All initial changes are made to master. Upon admin approval, the version is updated, and I want all changes to be copied ...
3
votes
0answers
51 views

Postgres multidisk master replicating to single disk slave

I have an odd situation. I have a postgreSQL database master with multiple large tablespaces divided across 3 physical disks. I am setting up a slave that will be used to offload long, ...
0
votes
0answers
17 views

Replication is broken because of events in wrong order in binlog

I have a master-master replication which is used rather like a master-slave because of replication breaks from time to time. It is always broken on the same table. To find the reason on this problem I ...
0
votes
0answers
34 views

MySQL Chain Replication without log-slave-updates

I have three server's say A -> B-> C B as both Master and Slave.I have enabled log-slave-updates in B server so that replication is possible on C. So what if happens when log-slave-updates is not ...
2
votes
1answer
81 views

PostgreSQL Automatic Failover (Trigger File Creation)?

Is there a way to detect if the master PostgreSQL (9.3) server becomes unresponsive, and if so, create the trigger file (that is specified in recovery.conf) that initiates the failover process? Or ...
6
votes
4answers
2k views

One slave, multiple masters MySql

Is it possible to set-up MySql Replication to have one slave listening to two different masters?
1
vote
0answers
35 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
0
votes
1answer
28 views

Table Not Created On All MySQL Masters

Here is the multi master setup. Table is not created on middle master. log-slave-updates is not enabled in my.cnf file. Master 1 mysql> create database replication; mysql> use replication; ...
0
votes
1answer
115 views

MySQL replication error 1594

Is there a way to restart replication without going over MySQL :: MySQL 5.1 Reference Manual :: 16 Replication. I'm NOT seeing ANY errors on master and I'm not entirely sure why slave is ...
2
votes
1answer
796 views

Cannot get my slave - replication server to start

My replication server will not start. I have followed the instructions here: http://opensourcedbms.com/dbms/setup-replication-with-postgres-9-2-on-centos-6redhat-el6fedora/ As well as several other ...
1
vote
4answers
4k views

Single slave - multiple master MySQL replication

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
0
votes
1answer
24 views

Upgrade mysql from 5.0 to 5.5 in master-master configuration leads to broken replication

We created two new mysql servers running 5.5. Our old server were 5.0. The two servers are set up with master-master replication - this was the case for the two 5.0 servers which had no issues. We ...
4
votes
4answers
8k views

How to change a MySQL previous slave to be a master and remove slave status information?

I have a master -> slave configuration where the master failed. I've been able to reset the old-slave to be a master and the old-master to slave from it. Fine. What I can't seem to do is to remove ...
0
votes
0answers
15 views

Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?

I have small doubt regarding Mysql Active-Active Replication. Can it Possible to do Mysql Master-Master (Active-Active) replication in Mysql between Redhat Linux and Ubuntu? Thanks & regards, ...