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)

0
votes
0answers
90 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
84 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
70 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
81 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
261 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
205 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
48 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
41 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
29 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
79 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
115 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
34 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
151 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
162 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
38 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
68 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
67 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
27 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
31 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
159 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
189 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 = N'...
0
votes
0answers
104 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
53 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
138 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
46 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
97 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
47 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
79 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 ...
1
vote
1answer
103 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
1
vote
1answer
171 views

Promoting warm standby to master with Postgresql 9.4 using streaming replication

I've currently got 2 database servers running Centos 6 and Postgresql 9.4 (identical clones on the same network). They are set up as a primary and a backup created using pg_basebackup from the primary,...
0
votes
1answer
34 views

MySQL Database Replication in Fedora 21

I have a MySQL 5.6 Community Edition server running on a machine with Fedora 21 which was installed via the YUM repository. I want to enable MySQL replication on the Server, but since I am limited to ...
0
votes
1answer
142 views

MySQL percona 5.6 to MySQL 5.5 replication

Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it to MySQL 5.6. while doing this we see that 5.6 is running slow, were as it runs perfectly on 5.5 backup. Scenario ...
1
vote
1answer
902 views

mysql 5.6 gtid replication slave stuck (system lock)?

I have set up 5.6 gtid based replication (on 5.6.26) it seemed to work when I did it, it replicated my random test db over that I created beside normal data. However at some point something must have ...
1
vote
2answers
81 views

MySQL Replication - Accidentally Dropped Database on Slave

I am using MySQL replication and I executed DROP DATABASE against my slave by accident (long story). Can I execute DROP DATABASE IF EXISTS against my master to safely drop the schema on my master ...
0
votes
1answer
210 views

MySQL replication : Query partially completed on the master (error on master: 1053)

I got the below error. Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your ...
0
votes
0answers
109 views

What happens if there is missing data in the slave MySQL server

At the data center there was electricity outage. And it appears that at that time my replication stopped syncing because it said something like this; "I cannot find the next position. Last proper ...
3
votes
0answers
117 views

transaction replication causing too many deadlocks after adding a indexed view - what to monitor in order to avoid this?

I have created the following indexed view and its clustered index: This view was created on a subscriber database and all the tables used in the view are constantly being written to through the ...
0
votes
1answer
18 views

Prevent MySQL to connect Master

We switched a slave to master today and after restarting the new master it tries to connect to the old master. Even with stop slave;, it tries to connect after restarting.
0
votes
1answer
62 views

Prevent replication of ALTER commands

I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like to prevent ALTER commands on master to replicate (such as CREATE, ALTER, DROP...) whatever ...
0
votes
2answers
1k views

How to replicate data between two SQL Server 2012?

I have two SQL Server 2012 databases running on two different Windows Server instances, I want the Server A (DB1) to be in full sync with the new Server B (DB2). How can I make this connection ...
0
votes
0answers
26 views

events not getting completely written in binary log file MySQL 5.0.32

referring this question : Records not getting replicate from Mysql 5.5.32 to MySQL 5.6 i found that binary log files which has been created at master database server , i see following surprising ...
3
votes
1answer
125 views

PostgreSQL + Docker: incorrect resource manager data checksum in record at 46F/6A7B6D28

I'm running PostgreSQL 9.3.9, Docker 1.8.2 and Ubuntu 14.04. I have an issue where my hot standby keeps failing with the following error message: incorrect resource manager data checksum in record at ...
1
vote
1answer
86 views

how to find the name of the distributor server and publisher server from the subscriber server/subscriber database

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column That I am already doing, and also adding ...
1
vote
0answers
44 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...