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
1
vote
1answer
138 views
Reconfiguring MySQL slave when changing the hostname/IP of master
I have one master and one slave replicating great, but the master is about to have both it's hostname and IP changed. In master.info I see the current hostname for the master, if I shutdown the slave ...
2
votes
1answer
214 views
Do database servers need load balancing?
I am trying to build a 1TB database on MySQL which will need strong read performance. I intend to replicate my database to prevent downtime.
Do my database servers need load balancing to improve ...
3
votes
2answers
123 views
IBM DB2 v9.7 HADR TSA failure on the standby server
I have an environment here where I have 2 servers running DB2.
One is the primary and the other one is standby. They replicate with HADR and failover is made automatically by TSA.
What's the default ...
5
votes
1answer
303 views
PostgreSQL: Can I do pg_start_backup() on a live, running db under load?
Our established replication has broken ("requested WAL segment has already been removed" during downtime)
We cannot easily stop the master again.
Can we do
pg_start_backup(),
rsync ${PGDATA}/ ...
3
votes
2answers
332 views
Two way replication
I have a little problem...
I have this case:
2 server instances
2 Databases
1 Table (5 columns)
From server 1 I created publication to replicate all columns of tables I have in DB1.
From server ...
2
votes
1answer
214 views
Running pg_dump on a hot standby server?
Disclaimer: I admittedly haven't tried this yet, but I'm not sure I would know if it wasn't working correctly, so I wanted to ask.
I would like to run a nightly backup job (via pg_dumpall) from a hot ...
4
votes
1answer
171 views
What is actually happening when postgresql discovers the trigger file and promotes it self from slave to master?
I have a streaming replication setup between two postgres servers (master: server A, slave: server B). I'm wondering what's actually happening under the hood when I touch the trigger file and the ...
1
vote
1answer
176 views
MySql proxy to replication configuration
Is there any solution (say a proxy) that makes MySQL replication cluster behave like one database towards developers? And developers then don't need to worry about using master to write and slaves to ...
4
votes
1answer
338 views
How to restore replication after server crash
We had two databases on one SQL Server 2005 instance with transactional replication between them (3 tables as articles). This server acted both as publisher and distributor.
Then the RAID on the ...
1
vote
1answer
56 views
Server load discrepency in Slave with Master load being low and constant
We have MySQL Replication
Master/Slave Setup
db01 Master
db02 Slave (ReadOnly)
We are getting load discrepency on the Slave (db02), but the Master's (db01) server load is low. MySQL is the only ...
0
votes
1answer
51 views
My SQL Replication to an online database server
I have two MySQL Databases:
On a local machine (connected to internet via a static IP)
My SQL database on my webserver (JustHost, which I can access remotely)
I want a replicate my local database ...
4
votes
2answers
542 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
1answer
86 views
SQL Server 2008 with SP1 Updating to SP3
I am considering applying this Service Pack 3 in a SQL Server 2008 with SP1, however I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and ...
5
votes
2answers
284 views
considerations when using triggers on a replicated (target) database
Our SQL Sever 2008 application database is replicated from Server A to Server B (push replication). We use the copy, let's call it database_b, on Server B to create reports and run other queries so ...
0
votes
4answers
189 views
Recommendation for synchronizing SQL Server DBs
I have two databases, prod and dev. Each DB is about 500GB. At the end of each work day, the prod database gets several million new rows and several thousands of updates. After the data is loaded in ...
1
vote
1answer
62 views
MySQL Replication - replication issues; procedures registered on master not giving same result on slave in MySQL 5.5.20
I am not able to replicate procedures registered in the Master to the Slave in MySQL 5.5.20
The Procedure is registered on the Master and can be seen on Slave. However, results fetched using the same ...
1
vote
1answer
278 views
Should a MySQL replication slave be set to read only?
I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only?
The guide sets up replication for the ...
5
votes
3answers
6k 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 ...
2
votes
1answer
183 views
Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber
is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
1
vote
1answer
205 views
MySQL Replication Error, can't stop slave
When I run command SHOW SLAVE STATUS\G, I see
Slave_IO_Running : 'Yes'
Slave_SQL_Running : 'No'
What I've usually done to fix this is to run
STOP SLAVE;
SET GLOBAL sql_slave_skip_counter = 1;
...
1
vote
1answer
29 views
what are the implications of setting up a subscriber as a publisher?
We have application database (APP_DB) that creates a "live copy" of itself via transactional replication (push) to a database (COPY_DB) on a separate server. This COPY_DB is used for reporting and ...
1
vote
1answer
167 views
oracle streams - how to get last successfully applied scn for crashed apply?
I have a downstream Streams replication set up between Oracle 9i (source) and Oracle 11g (destination). The process is still in developlment stage, so the whole setup is not stable yet.
Sometimes my ...
2
votes
2answers
111 views
Teaching Slony replication to select slave nodes
There is a system with up to 256 nodes in db cluster. We need to replicate some data from one of them across to all others. But for every row to replicate there is a list of nodes where it must be ...
1
vote
2answers
475 views
Replication error on SQL Server 2008
I'm doing merge replication between two SQL Server 2008 machine. But, when I attempt to do any modification on subscriber system, I get the following error.
The merge process could not enumerate ...
2
votes
1answer
352 views
How to add another table to publisher and subscriber without reinitializing the subscriber?
Is there chance to add another table in SQL Server 2005 transactional replication without reinitializing subscriber.
Thanx.
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
1
vote
2answers
87 views
Controlling the order in which merge articles are applied by snapshot at initialization?
I have a replication scheme that was created several months ago. Since that time the schema has had a variety of changes. All existing subscriptions were updated as these changes were made as the ...
1
vote
1answer
180 views
MySQL Slave Relay Logging but not logging Binary Log
I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of ...
4
votes
3answers
3k views
How to change a MySQL previous slave to be a master and remove slave status information?
I have a master -> slave configuration where the master failed. I've been able to reset the old-slave to be a master and the old-master to slave from it. Fine.
What I can't seem to do is to remove ...
1
vote
1answer
455 views
How do I configure multi master replication on WAMP?
I want to configure mysql multi master replication, but I've not seen any comprehensive article or tutorial on how to do that on WAMP. I will be grateful if some will point me to a tutorial, or ...
3
votes
1answer
117 views
adding another table to existing MySQL replication scenario
I'm running a simple MySQL replication scenario MASTER âž™ BLACKHOLE âž™ SLAVE, replicating only a number of tables via replicate-do-table on BLACKHOLE and SLAVE.
Now I would like to add several more ...
1
vote
1answer
96 views
How Can I Isolate A Merge Replication Timeout
I am using merge replication in SQL 2012 with web sync.
When I create my subscription I am getting a timeout. The error message is not clear about cause of the timeout, but what I do know is if I ...
4
votes
1answer
414 views
Replicate MySQL 5.0 Master to 5.5 Slave?
We're planning out a series of server/software upgrades and were curious.
We have a RHEL5 install running MySQL 5.0 that we'd like to replicate to a new (virtualized) server running CentOS 6 and ...
0
votes
1answer
48 views
Two slaves using the same server-id
I have a MySQL master with two slaves. Due to poor configuration both slaves had the same server-id.
My questions are:
Is the slaves' data fully synced with the master or did they miss transactions ...
2
votes
1answer
69 views
Why Do Replication Deletes Require sysadmin Access
I am running merge replication with SQL 2012.
There seems to be a nasty consequence of the delete triggers added for replication in SQL 2012.
Inside the delete triggers are this,
select @xe_message ...
3
votes
1answer
152 views
What is the difference between 'two way transactional replication' and 'peer to peer replication'?
Can someone explain in detail the exact differences between 2 way transactional replication and peer to peer replication?
0
votes
2answers
128 views
Need advises for a new MySQL architecture
I need to deploy a MySQL-based application with the following requirements and would love to receive some guidance (any) as to how I could set things up:
Scale of deployment
5 servers with a ...
2
votes
1answer
92 views
Maatkit shows the MySQL replication error in one table, but won't fix it
We use MySQL 5.1 with a primary/secondary replication setup. I use mk-table-checksum from Maatkit to generate checksums on the master and perform consistency checks on the replica.
mk-table-checksum ...
1
vote
1answer
102 views
Locking And Blocking With Merge Replication
I am using merge replication in SQL 2012 with web sync.
When I insert records into the top tables in my filter hierarchy it causes a lot of locking on the tables, including the merge replication ...
2
votes
1answer
179 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 ...
2
votes
1answer
46 views
Created databases and inserted data on MySQL slaves in Master-Slave replication - how to fix?
I got MySQL Master-Slave replication running on 1 master with 2 slaves. SHOW MASTER STATUS / SHOW SLAVE STATUS says they are in sync, but databases have been created on the slaves and filled with data ...
3
votes
1answer
116 views
Restrict record to be update or deleted according to dates inside row for SQL Server 2005
I have transaction replication between two SQL Servers. For testing purposes I deleted a lot of records at the subscriber that still existed at the publisher.
I now know that if someone updates, ...
2
votes
2answers
229 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 ...
2
votes
1answer
701 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
1answer
172 views
Disk space recovery on Mongodb replicaset secondaries
Is it possible to recover disk space on replica set secondaries based on the results of a repairDatabase call performed on a primary? I can't seem to locate anything that would work short of bringing ...
0
votes
0answers
37 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
80 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
...
4
votes
3answers
519 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 ...
1
vote
1answer
128 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 ...
2
votes
2answers
738 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 ...
