Tag Info

Hot answers tagged

3

Having done this type of project before, here's some of the practical gotchas to look out for: "2. This master then does one-way slave propagation to up to 200 read-only servers via VPN." Think carefully about the network traffic required here. In the simplest terms, if the insert/update/delete load on the database takes up 1/200th of a network cable's ...


2

To initialize a Transactional subscription from a backup you actually end up creating the publication first, enabling it to initialize subscriptions from a backup, then take a backup, and then initialize subscriptions with the backup. Changes that occur after taking the backup and before initializing the subscription(s) will be stored in the distribution ...


2

Oracle Golden Gate has always supported replication between Oracle and SQL Server. For a project I recently confirmed that Golden Gate for Oracle 10 is still available if you push a bit. If you are using an Oracle version that is out of support then you need to update for a number of reasons. Synchronization with Azure is detailed here.


2

Yes, it is very possible. As the Documentation says, you should have a minimum of three nodes in a Percona XtraDB Cluster. You only need one node out of the three nodes. Make sure all nodes in the PXC have unique server_ids. Make sure the Master you are replicating from has a unique server_id from the PXC nodes Make sure the master and every PXC node is ...


1

This currently isn't practical. Writes may not be done on a downstream replica, whether it replays WAL via streaming or archives. However, the logical decoding feature in PostgreSQL 9.4 sets the foundations for making this sort of thing possible. You could have a logical decoding plugin that reads the change-stream from the master server, then writes audit ...


1

I would say your basic process is quite straight forward. 1) Ensure that slave1 has got log-bin and log-slave-updates enabled (this will require a restart if not) 2) Take a copy of Slave1 and set up Slave2 as a slave of Slave1. You now have Master -> Slave1 -> Slave2 3) Once you are happy that Slave2 is performing as expected, set GLOBAL ...


1

There are cases in Merge Replication when parent and child rows can be processed out of order on synchronization resulting in constraint violations and conflicts. To understand how and why this can occur and how it may apply to your specific scenario, I recommend reading through: How to understand Merge Replication article processing order Merge Article ...


1

I have personally had experience with Transactional Replication. In my case, I configured the Distributor at the Report Server, and then created the Publication on Live server to be controlled from the Report Server. The Subscription from the Report Server worked perfectly. With this configuration, I was successfully able to replicate data from the Live ...


1

You are likely using the Express Edition. Note that Express Edition can only act as a Subscriber. Try using Standard Edition or above to Configure Distribution and Publishing.


1

DISCLAIMER : Not a Neo4j expert IMHO I would yes because the architecture link you gave sounds a lot like Percona XtraDB Cluster. The underlying replication scheme is driven by Galera. In essence, all nodes check with one another before doing transaction commits or rollbacks. This also means that you can run inserts, updates, and deletes on any node in ...


1

The Snapshot Agent process account used to connect to the Distributor must be db_owner in the distribution database and have read, write, and modify permissions on the snapshot share. The account used to connect to the Publisher must be db_owner in the publication database. The Log Reader Agent process account used to connect to the Distributor must be ...


1

Correct, skipping skips the transaction not the statement and that is why it is better to investigate the failure than blindly skipping. You're best placed to use pt-table-checksum and pt-table-sync to resolve drift after a skip since you will likely have diverged.


1

A smaller shell script can help the cause assuming you have catered all the differences between master/slave.. provided you have login path created if not use -uroot -ppass otherwise. Moreover you may need to check output log and need to correct the out of sync tables manually. c=mysql --login-path=lgp --protocol=TCP -NBe "show status like ...


1

Assuming you have corrected the slave drift, you can just "start slave" again, but You may need to skip some transactions, if they have been manually applied to the slave- you can do that with SET GLOBAL sql_slave_skip_counter You probably have other differences between the master and the slave, because of the operations you mentioned or because of the ...


1

If the binlog file number reaches its maximum value, it appears the server will throw an error. However, the maximum value is not 999999 as it would appear ... it's 2,147,483,647. From the source file sql/log.h (MySQL 5.6 source tree): #define MAX_LOG_UNIQUE_FN_EXT 0x7FFFFFFF Other relevant files are sql/binlog.cc and sql/log.cc. The code that ...



Only top voted, non community-wiki answers of a minimum length are eligible