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)

2
votes
2answers
10k views

Mysql replication and ignore tables

When setting up master/slave replication in Mysql, do you then need to ignore any tables in /etc/mysql/my.cnf or should replicate_wild_ignore_table be leaved out under normal circumstances? This is ...
5
votes
1answer
7k views

MySql - Changing expire_logs_days without restarting the server

I'm using MySql 5.5. Is it possible to change expire_logs_days and have the changes take effect without restarting the server?
1
vote
0answers
55 views

Merge Replication Finding Session Id

I am using merge replication with SQL 2012. I am writing a custom business logic handler, and would like to know if there is a way to get a session id? For instance if the custom business logic ...
1
vote
2answers
329 views

Mix of Cyclic and Chained MySQL replication - What do you do with “log-slave-updates”..?

I have the following MySQL replication topology set up: Master1 (M1) replicates to Master2 (M2) Master2 (M2) replicates to Master1 (M1) Master1 (M1) replicates to Slave1 (S1) Pictorial View +<-...
6
votes
3answers
2k views

InnoDB Master-Master replication goes inconsistant after power failure tests

Afternoon gents, I'm currently stress testing a Master-Master replication setup using InnoDB as database engine. We're using this simple script for testing which we run in Linux CLI from a remote ...
2
votes
1answer
767 views

Do I have to filter the percona.checksums table in replication for use with pt-table-checksum?

I've set up MySQL replication, one master and one slave. Now I just starting to check the data for integrity on both sides by using Percona's pt-table-checksum. Wonderful tool to detect any changes or ...
4
votes
2answers
2k views

MySQL replication problem: slave has become out of sync

I have a Master & Slave setup. Embarrassingly I managed to execute some data changing statements (INSERT and UPDATEs across 3 tables) on the Slave. Obviously this stopped the Slave replication. I ...
0
votes
2answers
461 views

SQL Server 2005 replication for a data warehouse

We are trying to implement some kind of Data Warehouse at my current employer. Most of our data is in a SQL Server 2005, but we might also integrate some Access databases and some databases in a SQL ...
0
votes
1answer
338 views

How to understand what Columns Have Changed in Merge Replication

I am using merge replication in SQL 2012. Some of my merge articles use column level tracking. I am trying to understand how to use the 'lineage', and 'colv1' fields in the MSmerge_contents table to ...
2
votes
3answers
3k views

Table with identity column in merge replication

I have a table in SQL Server 2005 and I have an IDENTITY(1,1) property set for an ID column. Records are inserted in a table at a local server as well as a remote server. I am using Merge ...
15
votes
3answers
6k views

SQL Server database synchronization

Problem definition Our users need the ability to query a database that is mostly up to date. The data can be stale up to 24 hours and that is acceptable. What would be the lowest cost approach to ...
2
votes
1answer
297 views

PostgreSQL asynchronous replication (and possible data loss)

I'm trying to wrap my head around Postgres' asynchronous replication. The way I'm reading the documentation, if the master goes down after data was committed, but before it's shipped to slaves, the ...
2
votes
1answer
122 views

mysql read slave to fetch entire database on start

I am building a standart infrastructure, where writes are going to master db, and reads are going to slave dbs. The idea is that when I need more read power - I just spawn more MySQL slave servers. ...
2
votes
1answer
381 views

Post replication powershell script - on subscriber

I need to execute a command before a replication executes on the publisher, and after, on the subscriber. I seem to have it working on the publisher, by adding another step in the replication agent. ...
2
votes
2answers
896 views

Oracle symmetrical one-way replication for cheap HA: unfashionable or technically unfeasible?

We have two smallish unrelated databases on two big Oracle Enterprise servers. Instead of buying more licenses and servers for high-availability replicas, can we replicate database B to server A and ...
2
votes
2answers
1k views

What is the Maximum Merge Articles in Merge Replication [duplicate]

Possible Duplicate: Hard limitation for merge replication article count? I am using merge replication in SQL 2012. I am looking here: Maximum Capacity Specifications for SQL Server (2012) ...
2
votes
1answer
715 views

3 Databases, Best Replication Setup?

We have 3 DB servers, two of them i.e. db1, db2, are located in the same data center. The other one i.e. drdb, is located in a different site. Currently, the replication setup for these servers is of ...
0
votes
1answer
70 views

Mysql restore all data from Master

MySQl Slave replication server got crashed and I am missing around 60 tables, some table structure and data which present in master and by DB size is more than 25Gb, How I Can restore to resolve issue....
2
votes
1answer
1k views

Restoring MySQL database with db dump and binlogs

I have a database running on our production web server that I have set up as a master with a single slave in another datacenter. When reading through the MySQL replication setup instructions, they ...
6
votes
2answers
4k views

Scaling Percona datacenters: setup and replication

Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you. We have already scaled alot of our application stack: we offloaded ...
1
vote
2answers
158 views

Will changing server_id on master break replication?

I have few MySql absolutely isolated trees, each one of them has one master and few slaves. For purposes of automation I need to set the same server_id to all masters (this will simplify the usage ...
1
vote
1answer
1k views

Length of LOB data (%1) to be replicated exceeds configured maximum %2

We recently hit this error shortly after enabling replication on a table. Length of LOB data (%1) to be replicated exceeds configured maximum %2 I've found solutions to this problem already: http:...
0
votes
1answer
908 views

Resuming Replication w/ Database Mirroring when Principle is unavailable

I'm trying to setup a disaster recovery scenario and I'm stuck at this particular point. Here's what I've done so far: A) Created principal database on Server A and and mirror on Server B B)...
0
votes
0answers
442 views

Real time replication issue - can't use transactional replication

We have an existing Microsoft SQL Server 2008 R2 database that we need to real time replicate to an identical off-site live web database. Transactional replication and merge replication will not be ...
8
votes
1answer
943 views

Transactional replication from SQL Server 2000 to 2008

I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication. The 2008 server is not in the same LAN, so I am ...
3
votes
0answers
131 views

Once in a while synchronization of the independently updated mysql databases problem

I have a production database and a test database running on MySQL with MyISAM and InnoDB tables, which are updated independently. The Production database is updated by system and sometimes by a user. ...
1
vote
1answer
5k views

Pgpool install - libpq is not installed or libpq is old

Based on the documentation here, I want to create a pgpool II with PostgreSQL databases. When I try to install, I encounter this error: configure: error: libpq is not installed or libpq is old ...
5
votes
2answers
4k views

How can you stop MySQL slave from replicating changes to the 'mysql' database?

I have my slave set to not replicate the 'mysql' database as described in this SHOW SLAVE STATUS\G; Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 ...
3
votes
3answers
676 views

How can I replicate MySQL data from many servers to one?

All over the internet I can find manuals on how to replicate databases from master(s) to slaves. What I need is to continuously keep a copy of table from 5 different servers in sync. We have one ...
5
votes
4answers
180 views

Replicating only changes made by a specific database user

I am performing parallel testing. We have upgraded the legacy batch jobs to a new framework which we need to test against the existing batch jobs. In the existing setup, I have web application which ...
2
votes
1answer
627 views

Can I replicate to a pre-existing database?

I am going to test this out, however I'd like to know what the forum would say. I have 2 SQL servers with replication setup between them. I am now adding another new SQL Server and I want this one ...
8
votes
1answer
2k views

Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?

I am looking at snapshot replication between two servers. Here is what I have: 500GB database ~500MB nightly bcp loads ~50MB daily transactions I was asking other DBAs in the company about which ...
2
votes
2answers
357 views

Can I replicate views with Slony?

Can I feed some SQL that creates a view to Slony? I have some SQL that does CREATE OR REPLACE VIEW name_of_view and so on, passes it to slonik_execute_script, and then tries to run slonik_create_set ...
0
votes
2answers
1k views

Some queries slower in MySQL 5.5 than 5.0?

We have an exceptionally inefficient process (1.3 million selects, 232k updates) that I'm now recoding to be 1 select and 50 updates. In the meantime, though, today's process ran. We recently updated ...
2
votes
1answer
88 views

Replicate from master-master setup

I have MySQL Master-Master replication on 2 servers. I want to replicate to another slave server. When I configure the slave to replicate from master1, only data added on master1 is replicated. ...
2
votes
2answers
3k views

Looking for an efficient way to fix “Could not parse relay log event entry…” error

I have a corrupt relay log in MySQL 5.0 and looking for the steps to fix replication without having to reprocess all the binary logs from the master again. Here is the full error message if you are ...
2
votes
1answer
3k views

Slave I/O thread dies very often

I have MySQL Replication working between two servers in master-master mode. Replication has been working from day 1. The IO Thread and the SQL Thread has never died. However, the Slave SQL thread ...
4
votes
2answers
2k views

Replicate DB2 table to SQL Server 2008

I need to replicate data from a DB2 database into a SQL Server Database (along the lines of about 80 tables). I can create an SSIS package, to just flat copy the data from one to another pretty easy, ...
1
vote
1answer
1k views

MySQL Master-Slave Replication Cross Database

I am setting up Replication for cross Database as i have set 2 variables in Slave' s my.cnf as replicate-do-db=database_name and Replicate-wild-do-table=database_name.% ,But i am not able to get ...
1
vote
1answer
167 views

Is MySQL replication suitable for a Write Mostly application?

I'm considering adding another server to my one-server setup application with 600GB MySQL DB. The db and the apache are both running from the same server. In order to avoid backup downtime and improve ...
1
vote
2answers
238 views

PostgreSQL replication and large import

I am tasked with making large PostgreSQL imports to master instance, and then replicate it across the nodes as read-only data. Still, the CMS system has to be able to write data and replicate across ...
5
votes
2answers
2k views

Removing Archive Logs after PostgreSQL PITR online-recovery

I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2. Replication mode is "on" Load balance mode is "on" (between primary and standby1) I followed the official ...
4
votes
2answers
989 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 ...
5
votes
1answer
1k views

Replicating multiple databases into one database

I would like to replicate multiple databases on different servers into one master database. I have 5 different instances on separate servers all running SQL 2008 R2. The schemas and structure are all ...
2
votes
1answer
449 views

MySQL : Does 'bytes_sent' and 'bytes_received' include mysqldump data?

I'm trying to estimate my db traffic not including backups (mysql 5.1.41). I use show global status; to get the parameters bytes_sent and bytes_received. Questions Do these numbers include ...
0
votes
2answers
2k views

MySQL replication fails due to duplicate keys after master is restarted

I'm new to MySQL load balancing, I want to try the master-slave concept. Whenever I setup master-slave for the first time, and both have up-to-date fresh data, that works perfectly fine. However, ...
1
vote
0answers
92 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
3
votes
2answers
995 views

Rows already DELETEd on MySQL slave; How to DELETE on master?

I have a handful of rows that exist in my MySQL master but not in my slave. Replication is running ok and these rows are unlikely to ever be referenced as it is a store-and-forget type of table. ...
3
votes
1answer
130 views

MySQL - Partially restore binary log

I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500. How can I do that?
2
votes
1answer
136 views

Reformatting master MySQL server and temporary solution

We have MySQL master and replication servers both running on different machines. We have noticed some system files showing integrity issues in the master machine. Temporarily we would like to make the ...