Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.
2
votes
2answers
67 views
why is the slave machine faster for reading than master in database replication
In the master/slave database replication, all writes go to the master machine. All reads go to the slave machine. The master machine replicates data to the slave.
When the master replicates data to ...
6
votes
4answers
14k views
SQL Server Update Trigger, Get Only modified fields
I am aware of COLUMNS_UPDATED, well I need some quick shortcut (if anyone has made, I am already making one, but if anyone can save my time, I will appriciate it)
I need basicaly an XML of only ...
5
votes
4answers
5k views
Is it possible to do N-master => 1-slave replication with MySQL?
I want to make a dedicated SLAVE machine for data replication of three database on three different servers. In other words, I want to do Multiple Master => SIngle Slave replication.
Is there any way ...
7
votes
2answers
906 views
MySQL Replication
Shall I use MySQL replication to synchronize a local database and a remote database? If so, how do I setup both master and slave? Are there any other methods available to do this?
2
votes
2answers
930 views
MySQL replication be bi-directional
We have successfully set up a Master-Slave replication as described in MySQL literature.
However, I'm curious if anyone has set up a bidirectional replication. For example, if one has a Drupal or ...
0
votes
3answers
2k views
How to code PHP MySQL class for master and slave setup?
I have never used a master/slave setup for my mysql databases so please forgive if I make no sense here.
I am curious, let's say I want to have a master DB and 3 slave DB's. Would I need to write ...
27
votes
7answers
36k views
How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
Mysql Server1 is running as MASTER.
Mysql Server2 is running as SLAVE.
Now DB replication is happening from MASTER to SLAVE.
Server2 is removed from network and re-connect it back after 1 day. After ...
3
votes
2answers
3k views
Rails 3 and mysql master-slave replications
Want to set up mysql master-slave replications in rails app.
Are there plugins/db adapters available for Rails 3? Does the Masochism plugin work properly with rails 3?
1
vote
8answers
495 views
Can I set up a filtered, star-pattern database replication?
We have a client that needs to set up N local databases, each one containing one site's data, and then have a master corporate database containing the union of all N databases. Changes in an ...
3
votes
3answers
1k views
Consolidate data from many different databases into one with minimum latency
I have 12 databases totaling roughly 1.0TB, each on a different physical server running SQL 2005 Enterprise - all with the same exact schema. I need to offload this data into a separate single ...
1
vote
0answers
203 views
Rubyrep with Postgres-> PG::ERROR: Connection is closed when trying to scan
I setup the rubyrep config file with the server information. No extra options. I tested if i could connect to both databases externally with PGAdmin.
When I try it out I see the connection spike on ...
4
votes
1answer
1k views
What is syncobj in SQL Server
I run this script to search particular text in sys.columns and I get a lot of "dbo.syncobj_0x3934443438443332" this kind of result.
SELECT c.name, s.name + '.' + o.name
FROM sys.columns c
INNER JOIN ...
2
votes
2answers
186 views
Data structure design for database replication support
I'm developing a small ad-hoc replication framework (for a reatil company), which replicates only certain records of certain tables (about 200) depending on specific domain-level logic.
In order to ...
2
votes
1answer
301 views
offline limited multi-master in Postgres
Site A will be generating a set of records. Nightly they will backup their database and ftp it to Site B. Site B will not be modifying those records at all, but will be adding more records and other ...
2
votes
2answers
276 views
mysql replication - master to slave
I have successfully set up a master to slave environment and it is definitely working fine.
The only problem I have is that selecting count from a table, they are not the same BUT selecting after 5 ...
