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
35 views

Is there any drawback of MIXED replication mode?

So, recent mysql server allows three types of replication mode: STATEMENT, ROW, MIXED. They all have pros/cons, and I pick the mode according to site characteristics. When I get a replication error I ...
0
votes
2answers
68 views

Live Partial Table / column replication

I want to know if there is a way to achieve the following with SQL Server 2012 Enterprise Edition? I have Table A: on Server 1 with say 10 columns. Table A: | col1 | col2 | col3 | coln | col10 | ...
1
vote
0answers
38 views

MySQL Cluster Master Master Replication - broken Leg

I have two MySQL Clusters which normally operate with Master - Master Replication between two of their nodes. Site 1 gets the majority of the write traffic, with Site 2 writing small amounts of ...
0
votes
1answer
59 views

RAID drives or replicate data?

I have an old Microsoft SQL server that, for financial reasons, I cannot replace until later in the year. The OS, DB and temp files are on one 10k RAID 5 array (I didn't design it) The server is ...
0
votes
0answers
75 views

Bucardo doesn't do fullsync

I have a 2 computers, one of them called master, and the other called slave both using PostgreSQL 9.3.5, but has different OS (32-bit and 64-bit) I have installed and setup the bucardo on the server ...
0
votes
0answers
16 views

mysql replication error 1236 need to restart replication process

I'm using mysql replication and the slave/master crashed in the process and then I got: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in ...
0
votes
1answer
60 views

How to use mysql live update on a mysql table between localhost and remote server?

I have mysql table created/modifying in localhost, and I need to update those in my remote database. I have gone through lot of post regarding this scenario and I found out that I need to use mysql ...
0
votes
2answers
36 views

Create table on a Master - Master config avoiding replication

I have a Master-Master configuration. What I want is to create an auxiliary table only for a report project so it's not necessary to replicate it. Is there a specific way to make this in the CREATE ...
0
votes
0answers
16 views

MySQL - Checksum won't match between master and slave hosts despite dumping and reloading the table [duplicate]

I am playing around with table checksums and I am puzzled as to why I cannot get two checksums to match. I have two hosts, one being a slave for replication. I have a particular problem table that ...
0
votes
0answers
265 views

“ORA-00936: missing expression” setting up Oracle Publisher in SQL Server

I'm trying to set up an Oracle publisher in SQL Server so I can perform replication. I've gotten connected to Oracle, the drivers work great (I have other linked servers), I can select an article I ...
0
votes
1answer
63 views

Why does my MySql Savel replicate changes that are neither in binlog_do_db nor replicate_do_db?

I have a standard simple master slave replication that usually runs fine. But sometimes, all of a sudden, I get replication errors on the "phpmyadmin" table. I have explicitly only specified one ...
1
vote
2answers
46 views

How to swap roles of Master-Master?

I've just taken over the responsibility of managing our MySQL databases. We're running Percona Server (GPL), Release rel24.1, Revision 217. Our setup involves two servers both running as master and ...
1
vote
1answer
69 views

Pre-production database replication solution

I would like to start by specifying I am no DBA and have basic understanding of advanced DB concepts. I am trying to find the optimal solution to replicate our production database to our ...
1
vote
2answers
87 views

MySQL Slave has unmanagbly higher IO load than master

A MySQL slave having a higher disk load than the master or not being able to keep up is not unusual, nor are questions about it on Stack Exchange, but I did want to run my issue by here, because in my ...
0
votes
0answers
275 views

MySQL 5.6: explicit_defaults_for_timestamp

I have the following replication topology: DB1 (MySQL 5.5) -> DB2 (MySQL 5.6, explicit_defaults_for_timestamp = 1) -> DB3 (MySQL 5.6, explicit_defaults_for_timestamp = 1) - "date" field: ...
1
vote
0answers
127 views

MySQL master slave replication not working

I had MySQL master slave running and working fine but suddenly it stopped. I don't know which commands have been executed but now replication is not working. I am very new to MySQL can anyone help me? ...
0
votes
2answers
71 views

for archive_command use an script rather than a command

I want to create a configuration to get a PostgreSQL HA. In my Master I want to configure a postgresql.conf file with this: archive_command = 'local_backup_script.sh "%p" "%f"' instead of: ...
0
votes
1answer
59 views

CRC checkup in MongoDB

I am new to MongoDB and currently working on a project. I read tutorials but I'm unable to find any information about Cyclic Redundancy Check (CRC) in MongoDB. Is there any way to check that the data ...
0
votes
0answers
196 views

How to split task (read and write) between two mysql server via HAproxy load balancing?

I have done some test and setup two (A and B) different database server from the following link - https://www.digitalocean.com/community/tutorials/how-to-use-haproxy-to-set-up-mysql-load-balancing--3 ...
0
votes
1answer
59 views

How the xlogs files travels form Master to Slave

I have some doubts about how the workflow proccess in PostgreSQL replication using archiving logs. If I have this configuration in Master postgresql.conf: archive_command = 'test ! -f ...
0
votes
1answer
18 views

When do I have to use archive_command and when not

I have some doubts about PostgreSQL replication command. I am doing some research and I found severals configurations. first one is: archive_mode = on archive_command = 'cd .' second one is : cp ...
0
votes
1answer
22 views

Automatic slave reconfiguration after updating master

I have development mysql master and slave servers and a prod server. I need to set up regular (once a week) syncronization of dev and prod databases. It would be easy for me to use prod# mysqldump > ...
0
votes
0answers
20 views

MySQL Replication problem with VIEWS and “Sub-Databases”

I've got three servers that should do a master-master replication. On server 1 i got "01_maindb" which holds the master tables. I replicate this table to the two other servers without problems. ...
1
vote
2answers
58 views

Did a SQL Server instance ever participate in replication?

How can I tell whether a SQL Server instance ever had replication in use or not? I'm debugging an issue with a 3rd party software. This software (Red Gate SQL Backup) reports the distribution database ...
2
votes
3answers
475 views

MySQL replication - some values are not being replicated

MySQL Replication issues I might sound clue less here as i am :) , I am having problem with mysql replication, i.e. replication seems to be missing in some random occasion. My structure looks like: ...
0
votes
0answers
22 views

why is latency growing

I have a 4.4TB database that I've been transactionally replicating to 2 different subscribers just fine. Yesterday I added a 3rd subscriber that is all flash drives to test how much better it will be ...
0
votes
1answer
50 views

How to delay replication start

I'm creating a new publication for replication using the @allow_initialize_from_backup option to avoid the snapshot immediate creation and therefore locking all objects replicated on articles. The ...
1
vote
1answer
41 views

Binlog not consistent between slave and master

Initially I don't see binlog on slave is updating. Today I discovered and add log-slave-updates option to slave, now it is updating. However, the filename does not match between slave and master. ...
1
vote
0answers
68 views

How can I correct MySQL replication while using federated tables?

This is an overview of what I have going I have 2 server A (10.0.4.22) AND B (10.0.4.29) A is a replication of B and B is a replication of A (yes it is a ring replication) ON A I have 2 table uat and ...
0
votes
2answers
3k views

Replication on MySQL server

I had to stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server On the problematic server mysql> SHOW SLAVE STATUS\G ...
2
votes
1answer
66 views

postgres: Database replica with some schemas writable

I have two computers. Computer A is dedicated to collecting data and storing it in its local database. Computer B is for analysis. A is running flat out just with the data collection, so I want to ...
0
votes
0answers
38 views

Best upgrade path for MySql 4.1 to 5.5?

Background Our production environment runs on a system that nobody wanted to update for a long period of time. With a new sherrif in town, we're going to update it. Production is MySql 4.1 with ...
1
vote
1answer
83 views

MongoDB - Replica sets - Syncing and DC issue

I have 3 instances of MongoDB running on my local machine. One is native and the other two are on a Virtualbox Windows 7 VM. LocalMongo = My local mongo. VM1a and VM1b = My two instances of mongo ...
0
votes
0answers
21 views

Bidirectional transactional replication for failover system: Managing sql server jobs

I have set up Bidirectional transactional replication for failover system. I have taken care of Identity columns (have reseeded their values from a higher value) and all other things. But how can I ...
2
votes
2answers
2k views

Master - Master replication Duplicate entry

I've got a Master - Master replication setup and it worked fine for a couple of days but I keep getting: Duplicate entry errors after a few days... My setup is as follow: One server in The ...
1
vote
0answers
33 views

pt-online-schema-change with circular replication

So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
1
vote
1answer
160 views

distrb.exe & Logread.exe using huge SQL.txt file in C:\Users\sqlsrvacct\AppData\Local\Temp folder

I have the following situation: SQL server 2008 R2 SP2 I have both the Distribution and Subscription database in this server. LogReader agent and Distribution agent are running in continuous mode the ...
0
votes
2answers
187 views

Replicated timestamp column in different timezone

I have the master running Mysql 5.5.38 on Ubuntu 14.04 LTS. The timezone in the master is UTC+5:30. The slave is in AWS RDS which runs in UTC. The slave is primarily used for running for SQL queries ...
0
votes
1answer
60 views

FDW, replication and CREATE SERVER - will it work?

We have two servers (master, slave) and we want to use the FDW. The two databases to be connected with the FDW are both on the master (and the slave of course). When we are to CREATE SERVER we would ...
0
votes
0answers
34 views

How to do multi master replication on Database with Triggers in Oracle

I need advise on how to go about multi master replication on Database with Triggers in Oracle. i have "Database A" with Triggers on every transaction. need to have 2 more db's as hot standby,problem ...
0
votes
0answers
48 views

How many Slaves Can I to replicate with one Master Server with MySQL?

How many Slaves Can I to replicate with one Master Server with MySQL?, because I have a inconvenient, I have three servers that replicate a MySQL database. I've maked all the configurations and the ...
1
vote
1answer
959 views

Add database to existing replication which uses binlog_do_db?

We have two MySQL 5.5 servers running on Ubuntu 12.04. We are successfully replicating 3 databases from server01 to server02, but need to add a 4th (new) database. Our my.cnf on the master has: ...
3
votes
1answer
174 views

Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID? [duplicate]

I'm setting up 5.6 Percona Mysql, in order to enable GTID should I have to enable log_slave_update on both Master and Slave ? If I should enable log_slave_update, then I'm counting this to CONS for ...
1
vote
1answer
34 views

Understanding pg-pool in details

I have following problem regarding the pg-pool (3.3.3) When master fails, automatic failover happens and standby is promoted to master. But this new master don't have any replicators. Other slave ...
0
votes
1answer
58 views

PostgreSQL replication with periodic log shipping

I'm using Windows Server 2008 R2 with 64-bit PostgreSQL 9.2 on both test machines. What I wish to achieve is that one server will be a master and other will be a slave. This is just for tests, finally ...
0
votes
1answer
283 views

Error 1236 From Master After Restored Replication

I've been trying to restore a broken replication caused by power interruption. upon checking the slaveDB, it was already broken so I setup a new replication. And upon supposedly completing the ...
0
votes
1answer
135 views

MySQL replication - slave hangs during ALTER table or BULK update - v5.1.71

We are facing the above mention issue. In this case if we try to STOP SLAVE then it hangs and we even can to restart DB. As I search in google for the same it looks like a bug. Id 38205 in V5.1. My ...
0
votes
1answer
263 views

Drop & re-add subscribers to transactional replication

I'm trying to get Stored Procedures to execute on the subscribers, as seems to be best practice. I already have transactional replication running happily. I add a new sproc, and set properties of ...
2
votes
1answer
127 views

MongoDB ReplicaSet reconfig when primary and majority don't exist

http://docs.mongodb.org/manual/tutorial/reconfigure-replica-set-with-unavailable-members/ Is there anyway to reconfigure a replica set in the event the primary as well as a majority of the servers ...
2
votes
0answers
48 views

Master and Read Only Oracle Database synch is unacceptable [closed]

Not a DBA, I am a developer, currently my team uses a Database set up created by the DBAs which we have little control over. All write's go to a master and then from there it is synched out to read ...