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

4
votes
1answer
4k 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
412 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
5k 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
3k 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
160 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 ...
6
votes
2answers
4k views

Difference between Row based and statement based replication in Mysql?

What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave. If I am using Row based replication then whats is the ...
2
votes
3answers
191 views

Synchronise two databases (but not really)

I'm trying to design the following system. An arbitrary number of of embedded systems will each record data constantly and indefinitely. It is required that these devices upload their data to a ...
2
votes
2answers
5k views

Does MySQL support replicating all databases?

I’ve been doing some investigation into properly configuring MySQL replication. From what I understand after reading the documentation, you can only replicate specific databases, and each database ...
3
votes
1answer
1k views

Master and Slave having same id's

I am working as a remote DBA for some of the production servers. There was replication from Master to Slave. There is something changed in the scenario they have made one of the Slaves as master ...
2
votes
1answer
2k views

PostgreSQL replication: out-of-sequence timeline ID, when former master made slave

I've configured master slave replication in PostgreSQL, following this tutorial: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Binary_Replication_in_6_Steps It worked fine. Now I've ...
1
vote
1answer
1k views

Problem with MySQL Master/Slave reboot when in replication

There is a master and number of slaves connected to it. Due to some patches, we have to Reboot the Master and Slave. Afterwards, we have to make sure replication is running fine. While doing this ...
3
votes
1answer
5k views

Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working

I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands: $ pt-table-checksum h=master,u=user,p=password ...
2
votes
2answers
2k views

How To Restore A Replicated Database

I am replicating our live database using transaction replication. This is basically to have a backup copy of our database in the case of server failure. The replicated database is read only, so I ...
3
votes
1answer
2k views

Does `Seconds_Behind_Master` show exact Slave Lag from Master?

Does Seconds_Behind_Master always show the correct number of seconds the slave is behind the master? I have also Implemented the mk-heartbeat replication monitoring. It was showing the other result ...
1
vote
2answers
7k views

Set up a MySQL slave using mysqldump to get the initial data

I have a master database which already has some data in it. The tables in the master database include both MyISAM and InnoDB engines. Now I want use mysqldump to dump the initial data of my slave ...
3
votes
1answer
304 views

How Commit works in a transactional push replication with updatable subscribers

I want to know if in a transactional push replication with updatable subscribers, a commit is only done when all subscribers have succeeded to make it, or if it only guarantees the correct commit in ...
2
votes
1answer
206 views

Dropping then adding a table to a subscription with Identity option Not for Replication causes errors

We have a Transactional Replication environment that was initialised from a backup that replicates the data for several hundred tables. When a table is altered, say a new column added, I have created ...
7
votes
2answers
16k views

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

I am very new to Database Administration. I face a lot of problems while setting up mysql master-slave replication. I also face regular mysql replication troubleshooting issues. Can anybody helps ...
1
vote
2answers
264 views

Is it advisable to have MySQL Master/Slave running on the same physical server, on the same mysqld, sharing the same disk?

my Use-Case : The solution I am developing is very data oriented. I run a cron job every 3 hrs to read lots of records from a file, process them and store them in the database. I also need to ...
0
votes
1answer
1k views

MySQL Replication question

I have setup a master-slave replication between two MySQL servers using mysql Version 14.12 Distrib 5.0.51a, for debian-linux-gnu. Recently the replication errored out with this in the logs: ...
0
votes
0answers
134 views

Hello, I want to build up Postgresql 9.0 replication on Ubuntu 11.04 [closed]

I want to build up replication on postgresql 9.0 that too on Ubuntu 11.04. Please let me know through which method it is possible? I have tried many options including slony, streaming replication ...
1
vote
2answers
2k views

How can I check the status of transactional replication?

How can I check if there are commands waiting for being executed in the subscribers and find if there is any error occurring in my publication. I want to be able to do this programmatically so the ...
2
votes
1answer
682 views

mysql replication deadlock slave stopped

I've a master and slave and got the slave stopped with the following error log in slave. I want to fix this and get the two servers on synch and get going again. 111128 8:42:24 [Note] Slave I/O ...
2
votes
1answer
356 views

How to perform asynchronous cascade slave replication of PostgreSQL database?

This is a feasibility/architectural question (I am no database administrator). Let's imagine a PostgreSQL database running online (like those from Heroku for example). One would like to maintain a ...
3
votes
2answers
581 views

Can an article in Sql Server replication be based upon a query?

I am looking to replicate the results of a query, is that possible or do I need to rep the tables themselves?
4
votes
2answers
2k views

The distribution agent failed to create temporary files

I'm testing transactional replication between 4 databases, 2 in one machine(Virtual) and 2 in other(also virtual). None of my virtual machines is running an anti-virus. It's all working as expected, ...
3
votes
2answers
1k 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 ...
3
votes
1answer
3k views

MySQL Bug required remedy : [Warning] Invalid (old?) table or database name '#sql-'

We have a master & multiple slave replication in our production environment. At first, I found this error in the mysql error log on the master and later on the slave. As for all the replication, ...
1
vote
0answers
3k views

Transactional replication subscription not showing in SQL Server Management Studio [closed]

I tried to set up 3 SQL instances, one publisher 2 subscribers, to replicate data between them. I did it using the GUI wizard and all went fine in the Publisher: my publication appears under "Local ...
0
votes
2answers
828 views

In SQL Server 2008, is possible to one database subscribe 2 publications for the same database? (merge replication)

I'm trying to set up an high availability architecture using merge replication. I have 3 databases, and I'm trying to keep them all up to date with merge replication. So far I've manage to create one ...
1
vote
1answer
3k views

The process could not execute 'sp_replcmds' on 'S15415940'. Cannot execute as the database principal because the principal “dbo” does not exist

Can anyone show me the way to fix these error messages: The process could not execute 'sp_replcmds' on 'S15415940'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Cannot execute as the ...
2
votes
1answer
440 views

PostgreSQL archive_command on Windows

What is the best method for WAL log transfer on Windows? I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit. Servers do not have any shared SAN disk, they are on different hosts, ...
6
votes
4answers
867 views

How do I sync instance A to instance B without losing any of the data already on instance B?

Like I said in a comment below, I'm no DBA and I'm still in a learning process. Here's my scenario : I have an Oracle server running a couple schemas (let' call it Source). What I would like to do ...
3
votes
3answers
262 views

Is it possible to have 2 or more databases active, and synchronized between them?

edit I'm testing possible solutions for database redundancy and high availability,I tested mirroring it worked fine, but lacks scalability plus there will be a lot of work in one server. Now I ...
6
votes
1answer
160 views

Replication problems after server upgrade

In transactional replication - first 8000 rows of snapshot copies to subscriber snapshot then acts like it completed successfully. Publication table has 21 million rows. Snapshot says completed ...
3
votes
1answer
571 views

Configuring MySQL slave to use SSL

I am trying to set up a MySQL slave to use replication via SSL. The my.cnf file contains the following: server-id = 1012 master-host = host master-port = port master-user = user master-password = ...
1
vote
2answers
945 views

Will improper bin-log purging leads to deletion of mysql database

We had master to master and master to multiple slave environment in one of our client location. In one of the slave Db host we had disk space issue with bin-logs. At first i deleted the bin-log files ...
6
votes
1answer
621 views

How long can the log reader agent run for before a restart will do it some good?

As a developer who has for the first time successfully implemented a replication topology for our production database, I'm monitoring it very closely and fretting over potential problems. I'm pleased ...
4
votes
4answers
701 views

Can two servers access the same database files?

I'm designing an application and considering some options regarding the database system since I'm not familiar with Microsoft SQL Server. I would like to know if it's possible to have 2 servers ...
3
votes
1answer
600 views

Solution for deploying multiple instances of Django Server with Database replication

have written a Django application that reads / writes data into a postgres database, at the moment I have been deploying one of these devices per client. I am faced with having to deploy multiple ...
2
votes
1answer
265 views

Will mysql_secure_install script block master updates to slave?

I had setup two virtual mysql database servers in two oracle linux 6 vm's, which come with mysql server ver 5.1.47 Master named prod_master & slave named prod_slave1. I installed both the mysql ...
2
votes
1answer
552 views

How often do you back up the distribution database for transactional replication when sync with backup is set to true for the distribution database?

I'm trying to figure out how often to back up the distribution database when "sync with backup" is set to true. If I understand this correctly, sync with backup ensures the distribution database can ...
4
votes
2answers
2k views

Read-only copy of SQL Server database

We have main database, through out day we insert/update this DB through main application(windows). We have another web application which is suppose to just display content from main DB but instead we ...
4
votes
2answers
3k views

How to handle the My SQL DB Master to Master replication when there was a disk space outage

We had master to master replication with two node nodes A & B, both are in virtual environment. Initially there was an outage (diskspace issue) in node A and stopped replication. Application level ...
2
votes
4answers
3k views

Tons and tons of relay logs on a master

I have a master that has 298 relay bin files as recent as today, going back well 298 days. There is no relay-log definitions in the .cnf and mysql> show variables like '%relay%'; ...
1
vote
1answer
103 views

Backup / Restore Distributor

I have a database architecture with: => 1 distributor running on a dedicated instance of SQL Server 2005 => 2 publishers running each on a dedicated instance of SQL Server 2000 and SQL Server 2005 => ...
1
vote
1answer
221 views

Master port is disabled from Public IP, MySQL log is not getting refreshed

My MySQL Replication setup is over internet. Master is on Public IP. If I stop mysql service in master, immediately an error message is thrown in slave. And when I start the service, slave is ...
6
votes
3answers
12k views

Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql

I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log). I have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log). The DB on S1 was using one data file ...
4
votes
3answers
1k views

Are there any in-memory NoSQL databases?

Given that NoSQL databases are designed to support horizontal scalability by throwing in more servers, are there any that are designed to do entirely without persistent disk storage? I'm looking at ...