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)

1
vote
1answer
44 views

Triggers on Slave database (in the context of replication) for auditing purpose in MySQL

I have a requirement for auditing in MySQL database. It means I am interested in what data is changed in my database and when. For fulfilling this requirement I am thinking about the triggers. I am ...
1
vote
1answer
69 views

How Merge Replication Works

I'm not DBA at all but I need to do something to synchronize four SQL server databases. I just discover there is a Merge Replication system in SQL Server 2008. At this moment I'm reading the ...
2
votes
1answer
66 views

Can I add an Arbiter node in the same server of my Config-Server?

I'm using MongoDB and I want to know if I can add an Arbiter node in the same server that I'm hosting my Config-Server. Is it possible? Let's say that I have 3 sharded clusters with 6 servers (2 per ...
0
votes
0answers
78 views

Is there replication by “pushing” instead of “pulling”?

Here is the situation: pg 9.4 pg instance "A" in intranet which is often loosing connection with WAN because of satellite problems (primary). This server has dynamic public ip. pg instance "B" ...
2
votes
2answers
64 views

Prevent SQL Server publisher from running out of disk space

I have an issue with transactional replication which leads to running out of disk space. The scenario is following. Database A is replicated to another computer via local distributor with command ...
0
votes
0answers
19 views

Mongodb slave shut down

i started a mongodb master slave but due to technical issues the slave server crashed. I restarted it and the mongod proccess as well with the host parameter, but for some reason the slave isnt ...
0
votes
1answer
270 views

MongoDB replica set: members with different versions of mongod

The primary is running mongod 3.0.6 and the secondaries running mongod 3.0.7 is a mixing of versions allowed in the same replica set? For upgrade it's best practise to not all nodes the same time. ...
1
vote
2answers
35 views

When one of masters is unreachable all other replica sets work too slow in mongodb 2.6.11 and web application throws error 71

When one of masters is unreachable all other replica sets work too slow in mongodb 2.6.11, also I can not list the databases on mongos servers, and that is because of one replica set. How to solve ...
1
vote
0answers
14 views

Snapshot replication error two days in a row

We have a mature replication system to move data from OLTP to BI. It's been working for years with relatively few troubles. This week we've run into the same problem two days in a row with snapshot ...
2
votes
1answer
25 views

Refreshing a table using CREATE TABLE, DROP and Rename

A read-only database (database1) is updated via log shipping every minute, then a procedure queries multiple tables in it and refreshes a large table on database2. For this process I run an ...
1
vote
0answers
71 views

Redis master and slave use different memory

I deployed a redis replica set which consist of one master and one slave. From top command output, I figure out each memory usage. master: 8176352Byte * 8.5% = 678MB slave: 2050116Byte * 75.6% = ...
0
votes
0answers
99 views

Golden Gate replication from primary to secondary database, WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rgg1ab.prm: SQL error 1403

I am using golden gate to replicate data from primary(Oracle) to secondary (Oracle). I have inserted records in the primary database, but replication abdends with error message WARNING OGG-01154 ...
0
votes
0answers
68 views

Galera Cluster crashes because of “ALTER TABLE” statement?

We use on RHEL7 # rpm -qa | grep maria mariadb-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.41-2.el7ost.x86_64 mariadb-galera-server-5.5.41-2.el7ost.x86_64 Do I analyze logs correct that Galera ...
1
vote
0answers
50 views

SQL Server 2012 Merge replication not replicating all changes

Having a problem with replicating a database between two servers, both running SQL Server 2012. We have a table where each site that stores the database updates a record every minute with the current ...
2
votes
1answer
290 views

How to recover Postgres replication slave after fatal error

On 4 Debian 8 Jessie servers, I have PostgreSQL 9.4.3 master + 3 slaves. After substantial data changes on master, slave logs showed this error: LOG: started streaming WAL from primary at 182/0 on ...
1
vote
2answers
67 views

SQL Replication across the internet give named pipe error

We've had a db replication working between two servers across the internet. Server A is sitting on our server network (Windows Server 2008 + SQL Server 2008 R2) Server B is sitting on a different ...
0
votes
0answers
74 views

PostgreSQL streaming replication with slots works for one slave, but not for another slave

Master (10.0.0.1): Edit postgresql.conf listen_addresses = '*' wal_level = logical max_wal_senders = 3 max_replication_slots = 3 hot_standby = on Edit pg_hba.conf host replication ...
1
vote
1answer
74 views

How to Properly shutdown and disassemble SQL Database Replication

While testing SQL Server Replication we setup Replication on our ERP Test DB from SQL Server Enterprise to SQL Server Standard. We have since got replication up-and-running on our Live database and ...
1
vote
1answer
62 views

Options for creating a read-only replica of a DB2 database

We are a dev company that develops and supports an application based on DB2 LUW 10.5 for a customer. We have a VPN that gives us access to our customer's production environment, and we often connect ...
1
vote
0answers
65 views

Is it possible to synchronize multiple databases in to 1 database with the same tables?

We are facing a situation where we have 5 different businesses with comparable data and are building 1 single application to deliver their data to common customers. In order to do this, the plan is ...
1
vote
1answer
219 views

mongo converting standalone to replica set causes services down

I have standalone node1 already running for a long time. Now I want to convert it to replica set. I followed steps in https://docs.mongodb.org/v2.4/tutorial/convert-standalone-to-replica-set/ to ...
0
votes
0answers
176 views

Mysql dump import shows error 1556 (HY000) “you can't use locks with log tables”

I'm trying to setup a replication slave for an existent MySQL server. Therefore I dumped all data from the master like this: mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob ...
0
votes
1answer
47 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
1
vote
2answers
40 views

Should I convert timezones when moving data to a report server/data warehouse

I'm writing an SSIS Package to take data from a production DB to a reports server/data warehouse. The other databases on my reports server are all in Mountain Time but this DB is in UTC should I ...
1
vote
1answer
28 views

How to setup multi master replication in mysql

After hours of searching I find lots of tutorials that do only 2 server Master Master. Now I wonder how to setup multi master setup because this is more suitable in my business. Because when the WAN ...
1
vote
1answer
49 views

Postgres 9.3 copy data from another table with relation [closed]

Hi I have two tables in my database which is related, which is forms and qa_forms. forms ->id ->name -address -phone -calldatetime and then ` qa_forms ->id ->forms_id ->name ...
1
vote
1answer
70 views

Replication: Procedure or function sp_MSupd_PROC has too many arguments specified

Source is one service pack behind destination (2012). I know service packs can be issues here, but it looks like this is only for versions 2000 and 2005. When using sp_helptext sp_MSupd_PROC the ...
0
votes
0answers
96 views

Remove column from transactional replication

I have a situation where in I need to remove 1 column from transactional replication without actually dropping the column from table. Is it possible to remove it? When I try to do it from GUI it ...
0
votes
2answers
33 views

Replication Setup what's the value of MySQL auto_increment and offset in my.ini

I have setup master master MySQL replication to sync changes in both servers. Now I want to setup 6 servers, is that possible? I'm making 6 because when an area lost it connection over WAN it will ...
1
vote
2answers
132 views

MySQL replication - database size is different

I have enabled MySQL master-master replication with 2nd master acting as read-only. Recently I checked the out the size of the databases in both master and slave and I found that database size in two ...
0
votes
1answer
133 views

Error “The publication '[Name]' does not exist.” running sp_article_validation

DECLARE @p SYSNAME, @a SYSNAME SET @p = N'[NAME]' SET @a = N'[ARTICLE]' EXEC sp_article_validation @p,@a I'm using the exact name of the publication provided by the table MSpublications (even using ...
1
vote
2answers
33 views

Replication fails exactly after a week

We are application developers trying to decode why replication is failing. It fails every week on the same day pretty much same time. This has been happening for about a month now and our vendors ...
0
votes
2answers
34 views

Distribution Server (1) Replicating Source Server (2) To Destination Server (3)

I'm setting up replication from a source server to a destination server using a third party distribution server. I've added the source server to the list of publishers on the distribution server ...
0
votes
0answers
36 views

postgres: async statement based replication?

I've noticed that all SBR replication solutions listed on PG site are also synchronous. Is it a mere coincidence? Can there be an async SBR? e.g. a statement is received by a master (or some ...
1
vote
0answers
61 views

Restoring MySQL Master-Master Replication

I am trying to restore Master-Master MySQL 5.6 servers. The replication failed between DB1=>DB2 and so DB2 went out of sync. GTIDs are enabled. I have done an export and import from DB1 to DB2 and ...
1
vote
1answer
64 views

Merge table from master slave replication

I have a dual master-slave replication (server1 is master AND slave of server2). After a problem with server1, the replication broke. After some skipped logs the replication came back to life. Then ...
3
votes
1answer
22 views

Is it possible to JOIN to a Primary database from a Replication instance?

I have a database on a Replication server that doesn't exist on the Primary server. There are stored procedures on the Replication server's DB that join to tables in other databases on the ...
0
votes
0answers
26 views

is there a way to control mysql replication errors?

I have a mysql master server and a mysql slave server replicating the master, when an error occurs the slave replication stop's by default it's set this way. With "slave_skip_errors" flag you can set ...
0
votes
2answers
28 views

PostgreSQL: What is data replication?

I read from a post about comparing MySQL and PostgreSQL, there is one who said: The biggest disadvantage of PG for me had been the lack of replication, but it's recently gotten both asynchronous ...
0
votes
1answer
141 views

Postgresql Streaming replication - monitoring

I have setup streaming replication for my postgres servers. I am using PostgreSQL 9.2.6. Replication seems to be working fine. I am monitoring this with two ways using nagios: Log_delay and ...
2
votes
1answer
68 views

SQL Server replication over internet error

I have 2 SQL Servers connected over internet, I can connect (with no problem) from each one to other using SQL Server Management Studio by using publicIP,1433\server as server address. So, I created ...
2
votes
2answers
181 views

ssms - how to format T-SQL scripts?

as part of the process to add articles to my publication I use the stored procedure sp_addarticle: use [Returns] exec sp_addarticle @publication = N'USReturns', @article = ...
0
votes
0answers
89 views

Mysql server does not start if binary logging is disabled

I have been trying to disable binary logging on a slave server, since I do not use it as a master for another one, I have no use for the logs and I am trying to reduce lag so cut out everything that ...
1
vote
1answer
48 views

Replication not updating all tables

Master db MySQL db Server 2012 Slave db MySQL Win7 XAMPP DB size 500MB Table count 42 I have setup the replication successfully however it stopped last week and my slave was showing the error ...
0
votes
1answer
125 views

Error 1236 'Found old binary log without GTIDs' after master restart

So after quite a few attempts to build a slave and getting the error above, I decided to start with no binlogs from scratch so on the latest slave rebuild I issued PURGE ALL BINLOGS BEFORE NOW() on ...
0
votes
0answers
42 views

How do you create a custom replication between normalized and denormalized form using SQL Server

I have a table (on SQL Server 2008) that is denormalized like so: Table: PhoneNumbers Field: Partial varchar(8) -- 123-1234 Field: [Data] -- Refers to 800-123-1234 Data Field: ...
1
vote
4answers
89 views

Execute a script after transactional replication setup completes

We successfully set up transactional replication with 15 articles. After successful of article changes Done in subscriber, we need to execute ".SQL File" at subscriber database. Please help on this. ...
0
votes
0answers
34 views

Replication of MySQL databases, but only some of the data

I need to set up a system to do basically a partial backup/replication of a couple of MySQL databases (actually Percona XtraDB 5.5, all tables are InnoDB). There are a few hundred tables in one of ...
0
votes
0answers
41 views

restart master == slave breaks

I have been struggling with keeping replication working. This is what happened before (also my topic): mysql 5.6 gtid replication slave stuck (system lock)? on top of this getting into system lock ...
1
vote
1answer
75 views

PostgreSQL Streaming Replication - corruption on master

We have PostgreSQL 9.3.9 streaming replication between Master DB and Slave DB. Is there issues can happen on Master that can cause persistency problems or full failure of Master and Slave DB both ...