Stack Overflow
Stack Overflow

Questions tagged [database-replication]

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.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
0 answers

Can I replicate a database to different regions for read AND write access & synchronize?

We plan to have users all over the world who will access our web application. But our database is located in US-West. We want the same database in Mumbai. We did create a read-replica, but it's pointless if we need to execute write scripts there…
AskYous
  • 4,332
  • 9
  • 46
  • 82
0
votes
1 answer

MySQL NDB Cluster and Master Master replication

I'm asking this to see whether I'm doing the things are correctly or to get advise what needs to be done. Thing is I'm trying to run both NDB clustering and Master Master replication to same database. In here What I'm trying to do is create a db…
chinthakaS
  • 125
  • 1
  • 2
  • 10
0
votes
1 answer

possible to setup multi master with multi slave with galera with mariadb?

recently, I learned how to use galera and setup master to master replication with mariadb but I am wondering if I can also use galera with some setting adjustment to have multi master and multi slave let's say right now I have two master, I want I…
Tsuna
  • 2,098
  • 6
  • 24
  • 46
0
votes
1 answer

mariadb, is this kind of increment offset reaction consider normal?

I posted a similar question a bit earlier but I was a bit confused because of the settings already set and by reading this http://mariadb.org/auto-increments-in-galera/ I totally understand and corrected the settings but from what I read the output…
Dora
  • 6,776
  • 14
  • 51
  • 99
0
votes
2 answers

Building an Web App on a Read and Write based server set

I've got a general curiosity question. Say I have 1 master server (for writes) and 5 slave servers (for read). Within my web application, would I initiate a connection to both the master and slave? Using the master connection only for sending…
michael
  • 3
  • 1
0
votes
1 answer

mariadb master to master replication auto increment settings

I have just made a maria db master to master replication and after few days, I realized following the tutorial now the auto increment is by 2 instead of 1 as normal. I am wondering, would it be save to set it back to 1? or it's the best to leave it…
Dora
  • 6,776
  • 14
  • 51
  • 99
0
votes
1 answer

Couchdb changes to Apache Kafka

I want to have all of the changes of a couchdb database in kafka at application run time as they arrive. Is there any reliable existing tool for that?
Mohsen
  • 4,000
  • 8
  • 42
  • 73
0
votes
1 answer

Does SQL Replication Fragment Indexes?

I have a SQL Server with replication. The database in question has indexes with an avg_fragment_size_in_pages of 60-90% according to dm_db_index_physical_stats. I would assume the answer is yes, but I'm looking for some confirmation as to whether a…
Xenoranger
  • 421
  • 5
  • 22
0
votes
0 answers

Mysql database syncing on will

We are using amazon rds for our ecommerce site. we are inserting/updating our products by using cron automation. We have around more than 5 millions of products. Whenever the automation starts the site goes to maintenance mode.Automation will take…
sarath s rajendran
  • 398
  • 4
  • 19
0
votes
1 answer

access master table from replica

I have two mariadb servers one is configured as master and the other as a replica of this master. I have created a database named params on master and it has a table with a couple of items in it. How can I see this table and access or modify it…
max
  • 2,627
  • 1
  • 24
  • 44
0
votes
1 answer

Adding symmetricds to slony slave in Postgres

Can we add triggers to the slave in postgres which is using slony for replication? These additional triggers (which will not be present in master) are needed for some additional work. Thanks
Gurpreet Singh
  • 90
  • 1
  • 7
0
votes
1 answer

Oracle-to-SQL Server replication: manipulate data during replication

I've "inherited" a working Oracle (10g) to SQL Server 2005 data replication using standard SQL Server snapshot and transactional replication. Everything works fine - as long as Oracle doesn't try to send a date that's outside the SQL Server DATETIME…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
0
votes
1 answer

Merge Replication could not drop object due to Foreign Key Constraint

Good Day Everyone. I am slightly confused here. (it doesn't take a lot to confuse me though) I have a merge replication and it started giving me this error: Could not drop object 'TableName' because it is referenced by a FOREIGN KEY constraint.…
Mardus Davel
  • 77
  • 8
0
votes
3 answers

Mongodb replication automatically

Is there any ways or methods to start mongodb replication directly when mongod service start? I don't want to enter to shell and ON the replication? Thanks!
Swe Zin Phyoe
  • 149
  • 1
  • 2
  • 11
0
votes
0 answers

Questions About Load Balancing ProstgreSQL 9.6

I have a question regarding streaming replication in Postgres. I have this one DB server that runs Postgres and it's heavy on both reads and writes(runs bulk inserts, large selects, minute to minute etc.). I'm trying to find a strategy to handle the…
user8256294
1 2 3
…
99 100