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

SQL Transaction Replication Error Autofix

I understand that T-Rep includes a publisher, distributor and subscriber. Usually I find replication failing due to a Primary Key conflict or a row not found issue. I am planning to leverage the distribution databases and the publisher database to…
Alok Singh
  • 174
  • 3
  • 15
0
votes
1 answer

Is it possible to create an unsegmented table on one node in a K-1 safe cluster in Vertica?

Our project requirement is to have certain tables to be present on only one/two nodes out of the currently available 5 nodes. Is it possible to keep the tables on a specific node in a K-1 safe cluster?
NitheshKHP
  • 381
  • 1
  • 2
  • 13
0
votes
0 answers

data replication and master

I have a web based system in php that works locally in multiple places and in each place has a local database in mysqli. Also my system in every place connect remotely to another database that get all of information from specific tables of local…
zoro.cut
  • 31
  • 1
  • 1
  • 8
0
votes
1 answer

Query Not working in MySQL 5.6 - [MYSQL 5.1 (Master) to MYSQL 5.6 (Slave) Replication Error]

MYSQL 5.1 (Master) to MYSQL 5.6 (Slave) Replication Error Below Query not working in MYSQL 5.6 which is working fine with MYSQL 5.1 mysql> alter table MY_DATA add column test enum('0','1') default 0 after channel_id; ERROR 1067 (42000): Invalid…
Bhagwat Singh Adhikari
  • 1
  • 1
0
votes
1 answer

How do I make a vb.net project in visual studio that uses a sql server database, but make that database available offline when users are off site?

I have a program that helps salesmen design and price products. The pricing information for the program is held on the server in a SQL database and accessed with a dataset as normal. My program will therefore run if the user is connected to the…
Jolrath
  • 1
  • 1
0
votes
1 answer

Bucardo custom replication logic

I have a question regarding the Bucardo capabilities in Postgre SQL. Bucardo puts in sync tables between several databases. Imagine we have table Orders in DB1 and DB2. create table orders(order_id integer primary key, item_id integer, quantity…
MaterialGirl
  • 363
  • 2
  • 10
  • 22
0
votes
0 answers

ERROR >> undefined method 'new' for nil:NilClass

SCREENSHOT HEREI'm trying to perform Tungsten Replicator installation using tpm by typing: ./tools/tpm install alpha \ --install-directory=/opt/continuent \ --master=tungsten1 \ --members=tungsten1,tungsten2 \ --enable-heterogeneous-master=true…
Tony Kim
  • 1
  • 2
0
votes
1 answer

SQL Server Replication - Stored Procedure Execution

I've been trying to configure a simple publication to replicate stored procedure execution as per this post but no matter what I try every time I execute the SP on the Publisher db the updates get pushed row by row to the subscriber rather than…
Mark
  • 13
  • 3
0
votes
1 answer

Is mariaDB INSERT … ON DUPLICATE KEY UPDATE safe to use with Galera replication?

Is mariaDB INSERT … ON DUPLICATE KEY UPDATE safe to use with Galera replication? I have found that it is not safe with Row based replications + master master Why mysql INSERT ... ON DUPLICATE KEY UPDATE can break RBR replication on a master / master…
Bartosz Bilicki
  • 12,599
  • 13
  • 71
  • 113
0
votes
0 answers

How do i fix this MySQL function so that the “This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA” error is avoided?

I have this function RETURN ACOS(SIN(RADIANS(lat1))*SIN(RADIANS(lat2))+COS(RADIANS(lat1))*COS(RADIANS(lat2))*COS(RADIANS(lon2-lon1)))*6371; And i get the error This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA”. How do i fix this…
Chizuoka
  • 57
  • 1
  • 10
0
votes
2 answers

AWS RDS SQL Server - distributing queries to read-replicas

We are using AWS RDS SQL Server and need some help with solving the following problem - how to handle heavy read queries and prevent the report queries from blocking the rest of the operations. We were hoping RDS Multi-AZ would solve this problem…
DevOps One
  • 21
  • 4
0
votes
0 answers

mysql replication and GRANT that doesn't quite grant

I am trying to set up mysql replication. All's well, but I see an error 1045 for the slave: mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Connecting to master …
jma
  • 3,580
  • 6
  • 40
  • 60
0
votes
2 answers

MySQL Replication Duplicate Entry for Primary Key

160523 13:07:29 [ERROR] Slave SQL: Error 'Duplicate entry '914166' for key 'PRIMARY'' on query. Default database: 'zo_dev_20121216'. Query: 'UPDATE activity SET activity_type_id = 9, subject = 'Send departure email', date_due =…
Ravi
  • 2,472
  • 3
  • 20
  • 26
0
votes
1 answer

MySQL Cluster ERROR failed with Error 'Got error 240 'Unknown error code' from NDBCLUSTER' on query

In one of our environment mysql replication is failing intermittently. Below are the related mysql server logs. mysql> show slave status \G; *************************** 1. row *************************** Slave_IO_State: Waiting…
praitheesh
  • 41
  • 6
0
votes
0 answers

Replication on ubuntu 14.04

I'm working with a practice about repication, I'm trying to make it with an ubuntu and i'm struggled with the file my.cnf and now i can't start the service of mysql. Does anybody have any idea how can i fix it?
Felipe Ls
  • 21
  • 6
1 2 3
…
99
100