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
1answer
40 views

How do I get the MySQL binary log coordinates from the binary files?

I'm attempting to set up replication for a large (120 GB) MySQL database and I messed up. I shut down the master, copied the data files, and restarted the master. Now I've set up the slave & ...
1
vote
1answer
48 views

Streaming replication and lag when performing VACUUM on master

My streaming replication standby server is showing a delay of a few minutes when vacuuming a large table on the master. What is the reason for the lag, and is there a way to reduce it? Both servers ...
2
votes
1answer
65 views

MySQL v5.1.73 - can the binlog_format betweem Master & slave be different?

We are in the process of testing MySQL replication before using it in production. The MySQL is being setup by Puppet in our case and I noticed that the binlog_format setting is different between ...
0
votes
2answers
32 views

EC2 and setting up MYSQL Replication

my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2. My question is I want to setup a new slave to MYSQL master, can I take a snapshot of ...
1
vote
1answer
30 views

MariaDB cluster and external data feed

I've just finished setting up the 3 nodes mariadb (galera) cluster (let's call the nodes node1, node2 and node3). In order to have the cluster up to date with currently working mariadb database (let's ...
1
vote
2answers
81 views

mysql master slave replication scenario

We are creating a new mysql slave, but for dump we are taking from a backup server which is a slave of current master. Now to enable replication we want to connect it with the master so should I take ...
0
votes
0answers
27 views

Replicating table level PostgreSQL 64bit windows

I need to replicate some tables on PostgreSQL 64bit for Windows (master -> slaves replication model) and I can't find any tool that can achieve that. Slony-I work very well for PostgreSQL 32bit for ...
2
votes
0answers
20 views

Transactional Replication breaks when schema is changed in Publisher

We have set up Transactional replication where in two Publishers feed into one Subscriber , now if try to change the schema of any one Publishers or both publishers, replication breaks. We have ...
0
votes
0answers
23 views

bdr_int_copy issues and confusion

I am hoping someone can clarify a few things for me. I am having issues getting my 2nd node to join the first node using bdr_init_copy In a nut shell here is my scenario on node 1, i create a couple ...
0
votes
1answer
23 views

How can I view when mysql mixed mode replication is logging a statement using row or statement format?

I have a couple of servers running in MIXED mode replication and I do maintenance regularly on them deleting a decent sized set of data. There is one table that had no primary key and is just used for ...
1
vote
1answer
71 views

MariaDB Multi-source Replication SQL_SLAVE_SKIP_COUNTER

When an error occurs on a slave while executing a statement from the master, it is sometimes useful to use SQL_SLAVE_SKIP_COUNTER variable to skip the execution of the query, like this: STOP SLAVE; ...
0
votes
2answers
39 views

mysql table replication on just some records?

I have a big database which contain a table with about 26 million records. Now i need to make some reports on it from a special period of time. So how to make a replication from that table from a ...
0
votes
0answers
23 views

migrating MYSQL 5.5 to percona xtradb cluster 5.6

if we have to migrate MYSQL 5.5 using statement based replication to percona xtradb 5.6 would that be possible. What we want to do is to make percona xtradb cluster a slave of our current MYSQL and ...
0
votes
1answer
48 views

SQL Server Replication - FTP Snapshot: Policy requires SSL

SQL Server 2014 on both Publisher & Subscriber. Publisher & Subscriber are across the internet. Replication is Transactional Replication Error messages: The process could not connect to ...
1
vote
1answer
36 views

Indexed view doesn't exist on the subscriber

I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber. The object I want to ...
0
votes
1answer
19 views

Unable to delete a SQL Server 2012 publication

I've set up a transactional replication for two databases, let's call them A & B. Replication for the database A worked just fine and I was able to delete it afterwards without any issues. ...
0
votes
2answers
25 views

Can data be replicated from a slave MySQL back to a master without the slave containing all the master data?

We have a PHP/Symfony 2 application using MySql as the database. The database contains a large amount of data. The application is deployed to a separate server(s) and an empty/clean version of the ...
0
votes
1answer
36 views

MySQL - Master to Slave setup question

i have now setup a Master => Slave setup, after hard fightning its now working and this is great. the next step is, how can tell the slave if i create a new table/stroed procured or function on my ...
1
vote
1answer
53 views

Distribution database(recovery pending)

Firstly I was trying to create a distribution database and I succeded at first but since I checked the box to configure SQL server Agent to start automatically, the last step of configuring ...
0
votes
0answers
34 views

Replicating from MySQL 5.1 master to 5.6 slave failing because 'INSERT … VALUES (NOW())' results in 'Error_code: 1062'

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...
0
votes
0answers
20 views

Are there any databases other than DB2 for z/OS that implement true data sharing?

Are there any database products for Linux/Unix/Windows that implement true independent member data sharing similar to what DB2 for z/OS implements? Specifically the individual members are each ...
1
vote
0answers
32 views

Replication Data Issue

After configuring replication all the data from tables has replicated from publisher to subscriber. Now my requirement is whenever I insert new record in publisher only that record should replicate ...
0
votes
2answers
52 views

is Master-Master replication ok for me?

I have two separated locations connected by a not too reliable VPN. I have a common system that depends on MYSQL that read/write tables. Will master-master replication keep both locations in sync? I ...
0
votes
1answer
79 views

Table partitioning in MYSQL Master Slave

I have to Partition a MYSQL table using Range partitioning. Table is 200M rows big and I have Master/Slave replication. What I want to do is to stop replication on slave, partition the table on ...
0
votes
0answers
15 views

Maintaining Data Window

My specification requires that a remote machine maintain a 'data window' that consists of a subset of rows from a table in a local database. This window can move depending on the current value of a ...
0
votes
0answers
23 views

SQL Server Replication: Central Subscriber : Loading data in the same table

I have configured a Transactional Replication from Oracle (11g) to SQL Server 2014. I have many clients with the same database and we want to have a Multi-Publisher and only one Subscriber. The ...
1
vote
0answers
49 views

BDR Replication issue

I am trying to setup 2-node BDR replication and i am getting the following error while running bdr_init_copy. /usr/pgsql-9.4/bin/bdr_init_copy -d "host=10.10.145.111 dbname=apimgtdb port=5432" ...
0
votes
1answer
41 views

Optimize slave .ibd tables, where slave has innodb_file_per_table and master does not

We are trying to reclaim file space on our replication server. The space we want to reduce are .ibd files on the slave. We have a simple Master -> Slave (read only) replication setup, for some reason, ...
0
votes
1answer
161 views

Permanent count of waiting tasks (2) in Activity monitor

Now I'm observing in Activity Monitor permanent count of waiting tasks: and at "Resource waits" tab I see next: so, my question is: How to find and resolve this wait tasks? I suspect that it ...
0
votes
0answers
49 views

Column based replication in mysql 5.6

I want to do column based replication which means: In my server, I have table T1 in which columns are A, B, C, D, E I want to replicate this table on different server in mysql 5.6 only, but with ...
1
vote
2answers
74 views

Master/Master/Slave Replication

Just trying to get some information on the best route to setup replication for this DB I've got. I'm using MySQL 5.1 I found this and it seems like the idea we have in mind. We're looking to have ...
0
votes
1answer
41 views

How can we configure the Streaming Replication(master-slave) on single SAN storage in PostgreSQL?

I want to configure the Streaming Replication in PostgreSQL.My data directories of Primary and Standby are in same SAN storage.Is it Possible to do replication.
1
vote
1answer
63 views

MySQL replicate-rewrite-db ALTER TABLE not rewritten

I have a production database called "master" that I want to replicate on another server under another name (call it "slave"). All worked fine until an ALTER TABLE statement was performed on the ...
0
votes
1answer
79 views

Non-Replicating commands from (master) Mysql 5.5.40 to (slave) MariaDB 10.0.19

CRUD replicates just fine. But we noticed that DB structure altering commands such as ALTER TABLE and/or adding/updating columns to a table and even creating new ones do not replicate to the slave at ...
1
vote
3answers
70 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
0
votes
0answers
41 views

MySQL: Replication is paused with both threads running, System Lock in ProcessList

I have just set up Master Slave replication from a MariaDB EC2 instance to a MySQL RDS instance. What can I do? The Seconds_Behind_Master are increasing, never decreasing. Slave_IO_State Waiting ...
0
votes
2answers
37 views

Master Master replication not working showing

error from master 1 Last_SQL_Error: Error 'Cannot add or update a child row: a foreign key constraint fails (stylanzo_live.report_viewed_product_index, CONSTRAINT ...
1
vote
1answer
299 views

Postgres 9.4, replication slots, doesn't work failover master

I've installed postgres master and slave nodes by this manual: At the master (10.0.0.1): sudo -u postgres initdb -D /data/postgres/main Change postgresql.conf: listen_addresses = '*' wal_level = ...
0
votes
0answers
12 views

After merge replication setup, tables at subscriber not getting any data from publisher

I have created a merge replication setup through Replication Wizard. After sync, it is observed that the subscriber DB gets created with the exact tables in publisher as intended, but on the ...
0
votes
2answers
74 views

sql server transactional - replication - the internal procedures often deadlock with user processes

Very often I have deadlocks on my subscription server, involving the replication internal stored procedures and user processes either ad hoc or procedure queries. For example: Deadlock of the ...
0
votes
1answer
67 views

Where to look for Agent history in Replication?

In SQL server 2008R2 replication configuration, "agent history cleanup distribution" job by default runs every 10 minutes and deletes any historical data older the 48hrs. If I increase the retention ...
0
votes
0answers
63 views

How to troubleshoot, find and fix query Percona 5.6 with error “SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1”

i'm running Magento CMS, and underneath there are 2 physical servers both with Percona Server version: 5.6.23-72.1-log Percona Server (GPL), Release 72.1, Revision 0503478 in Master/Slave ...
1
vote
1answer
185 views

MySQL 5.6 Slaves Fail to Reconnect to older MySQL server when it goes down for backups

I have an existing replication setup with Masters and Slaves running MySQL 5.0. A long existing script runs at night which restarts MySQL on the master with skip-networking, runs a backup, and then ...
0
votes
1answer
55 views

Replication Configuration

I had a SQL Server 2008 Express edition as a Default instance and I am having SQL Server 2012 Evolution and SQL Server 2014 Evolution are my named instances. When I was trying to configure ...
2
votes
2answers
79 views

migrate db's - best way to mirror or replicate a full database

I would like to mirror/replicate my databases to the cloud. The cloud is setup using VPN to my actual machine. I am a bit confused by the options I have and would like to get some light into it. My ...
0
votes
0answers
31 views

mysql sharding techniques

I have developed one website for social network and I have used mysql for data storage. Now a days, many tables become a very huge (2-3 tables has 30 million records & 3-4 table has 300k records) ...
0
votes
2answers
49 views

Run MySQL replication by schedule or on demand

I have a master-slave replication currently configured. I know this setup runs real time. Is it possible to sync only the databases on schedule (daily or weekly) or by demand? Thanks!
2
votes
0answers
222 views

Warm Standby PostgreSQL 9.4 error; FATAL: the database system is starting up [closed]

I want to setup a Master and a warm standby, so far here's what I have setup: Master postgresql.conf listen_addresses = '*' wal_level = archive archive_mode = on archive_command = 'copy "%p" ...
0
votes
0answers
55 views

Converting MySQL master-master replication to master-standby

I set up two mysql servers in a master-master configuration. This was working fine until recently when I encountered a duplicate-key problem. After doing some research and evaluating my needs, I ...
0
votes
1answer
124 views

Can SQL Server replication be used for Point-of-Sale (POS)?

We are looking for a solution that will synchronize the databases of our POS. The scenario says we have 3 POS with SQL Server Express installed on each machine. We want these databases to be in-sync ...