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
3answers
486 views

Replication or Sharding for a huge table?

I have a table that I'm pretty sure in the very near future (within a year) will reach 14 million rows, and I'm trying to scale out my web app before hitting any bottleneck. I'm in dilemma whether I ...
0
votes
2answers
355 views

Slony - Wait for Event

What is the behavior of Slony waiting for an event after lock set command? Basically I am trying to do a switchover and it takes a lot of time. We are following these steps: Lock Set Wait for Event ...
4
votes
2answers
810 views

How to resolve the master server shut down/unavailability in mysql with master - slave replication

Let us suppose that we have a master/slave setup and the application is running fine for the time being. All of a sudden the master server suddenly shuts down due to some problem. Now how can I ...
0
votes
1answer
884 views

Changing MASTER_CONNECT_RETRY - Anything pit falls to keep in mind?

We run your basic Master + Multi-slave mysql replication setup. We would like to lower the MASTER_CONNECT_RETRY parameter on each of our slaves. Is there anything beyond re-executing CHANGE MASTER ...
3
votes
2answers
2k views

pt-table-checksum with slaves using non-standard ports

Trying to run pt-table-checksum to detect slave drift in MySQL replication. My slaves are not using the standard TCP listening port however, and so when I run the tool I get an error: Cannot connect ...
3
votes
3answers
6k views

How do i set up an Alert that tells me when a replication of data failed?

I've got Database Mail setup and tested fine. Alerts do work when I stop and start the replication agent job, but I cannot get it to throw any alerts when data moves from a publisher db to a ...
2
votes
2answers
2k views

MySQL Replication via DNS Failure

I'm having some trouble using replication when the machines are configured to use host names instead of IP addresses. The "skip-name-resolve" is OFF. If I use IP addresses, everything is fine. Using ...
0
votes
1answer
160 views

Merge Replication Invalid Object ( on an object that no longer exists ) ComErrorException

My merge replication scheme has suddenly started failing. When trying to sync it complains that there is an invalid object. 'dbo.myfunction'. The function used to exist but was removed. There was ...
4
votes
1answer
781 views

setup transaction replication in cross domain

I'm trying to setup transaction replication between two domains under the same active directory. The publisher server is in a DR site domain and the remote distribution server is in the main site ...
3
votes
1answer
6k views

Mysql master-master replication auto flush old logs

I have mysql-5.1.41 master-master setup running on ubuntu machines and below is the configuration of a master: skip-host-cache skip-name-resolve event_scheduler = ON max_connections = 500 ...
7
votes
3answers
283 views

Using Replication for Scale-Out

Having read Using Replication for Scale-Out, how can I route different queries to different servers, for example, SELECTI want to route to slaves and NON-SELECT to master. I assume as loadbalancer I ...
3
votes
1answer
370 views

Is there a generic framework/design pattern/library for real time replication of MySQL database onto other servers?

Summary I need to backup in real time updates/inserts to a MySQL database. Cron/batch jobs appear to be unsuitable for this particular requirement due to the time interval meaning that the data would ...
5
votes
1answer
2k views

PostgreSQL streaming replication broken: invalid magic number, out-of-sequence timeline ID

For some reason, my PostgreSQL slave no longer streaming-replicates changes on the master. It was working before, for a while, but I recently noticed that the slave's database contents is old, and ...
1
vote
2answers
740 views

Mysql master-master permission replication issue

I came to know it's safe to replicate mysql database to have the users and permissions replicated, from a post in ServerFault is-it-ok-to-replicate-mysql-db. I have setup master-master replication ...
1
vote
1answer
174 views

How can I edit a replication subscription to include new articles?

I have some replication subscriptions and I need to add some tables to one of the subscriptions. Is this possible? Publisher/Distributor: Sql 2000 Subscriber: Sql 2008 Thank you. edit: I found this ...
3
votes
2answers
2k views

MySql replication with Raw Data and InnoDB tables

I want to start replication on DB that has many InnoDB tables and MyISAM tables. I did everything according to manual Creating a Data Snapshot Using Raw Data Files. Firstly, I tried copied all ...
11
votes
1answer
4k views

PostgreSQL failover and replication

I'm evaluating PostgreSQL 9.1 and have few questions related to failover and replication details. I have few test scenarios. First one with a Master server and few Slaves. In case Master crashes I ...
1
vote
1answer
143 views

Why is replication attempting to distribute NULL values into Identity columns

We are sporadically getting this error: Explicit value must be specified for identity column in our replication environment. I have checked the transaction command that is reporting the error and it ...
1
vote
0answers
425 views

MySql shell command not replicated to slave - “LOAD DATA INFILE” [duplicate]

I have a shell script that looks something like that: #!/bin/bash mysql -udb_user -pdb_password -e "LOAD DATA LOCAL INFILE '/srv/some_file.csv' INTO TABLE db_name.db_table FIELDS TERMINATED BY ...
2
votes
3answers
1k views

MySql shell command not replicated to slave

I have a shell script that looks something like that: #!/bin/bash mysql -udb_user -pdb_password -e "LOAD DATA LOCAL INFILE '/srv/some_file.csv' INTO TABLE db_name.db_table FIELDS TERMINATED BY ...
4
votes
2answers
262 views

Backup VLDB replicated database in SQL Server?

I have a problem with my backup strategy. Currently I'm doing a Full Backup every night and transaction log backup every 2 hours to TAPE. This used to work without problems, but the size of the DB ...
1
vote
1answer
182 views

Sql Server Agent REPL Jobs

I know that replication uses Sql Agent jobs to pull subscriptions. Are these jobs supposed to stay in an 'executing' state? (Sql 2008 SP1)
13
votes
3answers
3k views

Does PostgreSQL 9.1 Streaming Replication catch up after a lag without WAL archiving?

Context: Let's say that, while using Streaming Replication/Hot Standby on a Postgres 9.1 cluster, a standby node goes down. It stays down for an day, during which time a lot of DML occurs on the ...
1
vote
2answers
658 views

Microsoft SQL 2008 Cluster with replication

i am in the process of setting upi a SQl Server 2008 64 bit Failover cluster. A lot of the database queries that we are running during the days are db intensive and lock a lot of the tables while ...
12
votes
2answers
3k views

Streaming replication and failover on PostgreSQL

I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...
2
votes
1answer
330 views

Has anyone ran into this replication breaking bug before?

I've been having this issue where replication was breaking on colliding primary keys. The annoying thing was these were auto increment generated. I think my issues been tracked down to ...
3
votes
1answer
1k views

Syntax to not write single statement to binlog?

I know you can SET SQL_LOG_BIN=0; to disable writing your session to the binlogs. I was wondering if there was some single serving query syntax to prevent just that one query from being written w/o ...
4
votes
1answer
2k views

SQL Server 2012 replication permissions with virtual user and agent credentials

For development/testing I set up replication in SQL Server 2012 RC0 (11.0.1750) using the default permissions on the agent, and I'm getting this error: Message: Access to the path 'C:\Program ...
1
vote
1answer
7k views

MySQL Replication Error

I am getting an Error on Slave as: could not execute Write_rows event on table mydatabasename.atable; Duplicate entry '174465' for key 'PRIMARY', Error_code: 1062; handler error ...
2
votes
1answer
7k views

Mysql Slave replication: Need to determine where replication left off to start slave in correct location

Idiotically I rebooted a machine that is used as a mysql slave without running STOP SLAVE, FLUSH TABLES first. I had thought mysql automatically handles all of this during a machine reboot, but ...
5
votes
1answer
406 views

Replication of database used by two programs

I have a peer to peer transactional replication set between two identical databases, each one of the databases is being used by a different program on two different servers. Since we implemented the ...
6
votes
1answer
3k views

what are the conditions under which mysql replication might break?

I am running mysql server in master/slave configuration mode. There are multiple slaves replicating from a master. They are working fine and their replication status is monitored. One of the slaves ...
1
vote
1answer
1k views

Duplicate entry in mysql slave

I have a mysql master-slave replication setup. when I checked "show slave status", I got the result as "Slave_Sql_running:No" and Last error as "Duplicate entry 'x' on query." But when I tried to ...
1
vote
1answer
2k views

What is the Best Way to detect if server is a Master inside a Stored Procedure?

I'm want to create a stored procedure/event to do some maintenance tasks. My setups are master/slave configured for failover scenarios (meaning the slave is not used for reporting, just might be ...
2
votes
2answers
12k views

First time running a replication on SQL Server 2008. “The process could not connect to subscriber 'SERVER2'” [duplicate]

I've set up Replication between two remote servers, Using Peer to Peer & Transactional updates. The subscription is all set, but the actual replication doesn't take place. When viewing the ...
1
vote
1answer
601 views

MySQL Replication: Slave with Different Column From Master

I have a Master/Slave replication. I had to change the name of one of my columns in one of my tables from temp_col to sent_at, this column is not being used yet. I've issued an alter table on an ...
2
votes
2answers
4k views

Mysql thinks Master & Slave have the same server-id

I've been setting up a master->slave_a->slave_b relationship and having a little trouble. I currently have the master->slave_a replication working fine. Each of the two slaves have exactly ...
1
vote
2answers
944 views

How to eradicate Mysql Slave Replication delays when huge updates from master

At my environment we had slave replication with mysql server version 5.1.47 enterprise version.When ever there is huge updates from master, slave is lagging behind the master. What is the best ...
2
votes
1answer
296 views

mysql emits BINLOG rows even though binlog_­format=­STATEMENT

We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default) According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in ...
1
vote
5answers
831 views

MySQL Replication monitoring [closed]

Im looking for a tool that could help me and my team monitor our MySQL Replication. I would love for a tool that could alert me if Seconds_Behind_Master passes a threshold Slave_SQL_running is ...
3
votes
1answer
2k views

How to make MySQL replication reliable?

Master version: 5.5.13-1 Slave version: 5.5.14-1 Binary log format: MIXED My Slave database (~ 40GB) has been out of sync from the Master. I cannot find anything interesting in the error log. ...
3
votes
1answer
2k views

What does the base64 BINLOG statements in mysqlbinlog output mean?

I have looked over the mysqlbinlog command as a candidate for rollback method from MySQL 5.5 to MySQL 5.0. When I ran the command on one of the bin-log files in the MySQL 5.5 server, I've noticed ...
2
votes
1answer
287 views

What's the purpose of /*!*/; in mysql binlogs?

The title pretty much sums up the extent of my question. They seem to appear after every statement. Sometimes on a new line following. At other times, at the end before the ;. What's the point?
6
votes
1answer
11k views

Best way to setup master to multi master replication

ORIGINAL QUESTION: I have multiple servers that all need to act as masters, as if one fails the next server kicks in and takes over. I'm just wondering what the best way to replicate is. All servers ...
4
votes
1answer
5k views

Mysql Master-Master Replication Topologies on >2 machines

I have 3 Mysql servers that I would like to replicate: two (including the main server) are local and one is remote. Let's call my main server A, the secondary server B, and a remote, development ...
2
votes
3answers
436 views

Replication chaining with PostgreSQL

We have an unusual replication scenario and I am not sure which tool would be appropriate for that. Basically, we have a legacy non-normalized database that we want to refactor into a normalized ...
4
votes
1answer
6k views

In a MySQL Master/Slave replication, what would happen if I write to the Slave?

Several Questions Would the Slave entry remain until there is an insert/update/delete to the table on the Master that could affect the Slave? If not, how do I ensure that the Slave is in-sync with ...
0
votes
1answer
4k views

Run SQL Server Snapshot Agent automatically

I am trying to setup automatic transactional replication. Basically I have some script files that are executed after each other. They set up a replication from one server to another and this works ...
1
vote
1answer
2k views

How to move data from Primary Data File to other data file without destroying replication

I have one Database which is replicated using transactional replication. Now, I want do spare some data of that database to another partition, because my server running out of disk space. I was ...
1
vote
1answer
162 views

setting up a local database to be updated from a master database

I'm looking for an efficient way to keep multiple databases (on different servers) sync with a master database (also on a different server). Mind you I only need a one way sync (from master to all ...