Questions tagged [replication]

The use of redundant resources to improve reliability, fault-tolerance, or performance.

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

It could be data replication if the same data is stored on multiple storage devices, or computation replication if the same computing task is executed many times.

A computational task is typically replicated in space, i.e. executed on separate devices, or it could be replicated in time, if it is executed repeatedly on a single device.

The access to a replicated entity is typically uniform with access to a single, non-replicated entity. The replication itself should be transparent to an external user. Also, in a failure scenario, a failover of replicas is hidden as much as possible.

More info on Wikipedia

3869 questions
323
votes
12 answers

I get a "An attempt was made to load a program with an incorrect format" error on a SQL Server replication project

The exact error is as follows Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an…
baldy
  • 5,524
  • 4
  • 22
  • 19
86
votes
9 answers

Scaling solutions for MySQL (Replication, Clustering)

At the startup I'm working at we are now considering scaling solutions for our database. Things get somewhat confusing (for me at least) with MySQL, which has the MySQL cluster, replication and MySQL cluster replication (from ver. 5.1.6), which is…
Eran Galperin
  • 86,251
  • 24
  • 115
  • 132
82
votes
6 answers

How can I slow down a MySQL dump as to not affect current load on the server?

While doing a MySQL dump is easy enough, I have a live dedicated MySQL server that I am wanting to setup replication on. To do this, I need dumps of the databases to import to my replication slave. The issue comes when I do the dumps, MySQL goes…
z33k3r
  • 831
  • 1
  • 7
  • 5
57
votes
2 answers

How to delete replication slot in postgres 9.4

I have replication slot which I want to delete but when I do delete I got an error that I can't delete from view. Any ideas? postgres=# SELECT * FROM pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | active | xmin…
Igor Barinov
  • 21,820
  • 10
  • 28
  • 33
54
votes
6 answers

INSERT ... ON DUPLICATE KEY UPDATE with WHERE?

I'm doing a INSERT ... ON DUPLICATE KEY UPDATE but I need the update part to be conditional, only doing the update if some extra condition has changed. However, WHERE is not allowed on this UPDATE. Is there any workaround for this? I can't do…
Andreas Wederbrand
  • 38,065
  • 11
  • 68
  • 78
44
votes
8 answers

How to check the replication delay in PostgreSQL?

I would like to measure time between insert data into master-table and slave-table using streaming replication in PostgreSQL 9.3. For this I create table test_time with 2 fields id(serial), t(text). After that added a…
Alf162
  • 443
  • 1
  • 4
  • 7
43
votes
9 answers

Could not obtain information about Windows NT group user

I am creating a SQL Server Replication using a script. When I try to execute The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about Windows NT…
Raj More
  • 47,048
  • 33
  • 131
  • 198
42
votes
6 answers

How to split read-only and read-write transactions with JPA and Hibernate

I have a quite heavy java webapp that serves thousands of requests/sec and it uses a master Postgresql db which replicates itself to one secondary (read-only) database using streaming (asynchronous) replication. So, I separate the request from…
Sachin Verma
  • 3,712
  • 10
  • 41
  • 74
42
votes
5 answers

Method to replicate sqlite database across multiple servers

I'm developing an application that works distributed, and I have a SQLite database that must be shared between distributed servers. If I'm in serverA, and change sqlite row, this change must be in the other servers instantly, but if a server were…
39
votes
8 answers

Updating AUTO_INCREMENT value of all tables in a MySQL database

It is possbile set/reset the AUTO_INCREMENT value of a MySQL table via ALTER TABLE some_table AUTO_INCREMENT = 1000 However I need to set the AUTO_INCREMENTupon its existing value (to fix M-M replication), something like: ALTER TABLE some_table SET…
pars
  • 3,700
  • 7
  • 38
  • 57
37
votes
5 answers

How to add a new node to my Elasticsearch cluster

My cluster has a yellow health as it has only one single node, so the replicas remain unasigned simply because no other node is available to contain them. So I want to create/add another node so Elasticsearch can begin allocating replica’s to it.…
Avión
  • 7,963
  • 11
  • 64
  • 105
36
votes
2 answers

How do i run a query in MYSQL without writing it to the binary log

I want to run an import of a large file into MySQL. However, I don't want it written to the binary log, because the import will take a long time, and cause the slaves to fall far behind. I would rather run it seperately on the slaves, after the…
Kibbee
  • 65,369
  • 27
  • 142
  • 182
34
votes
4 answers

Delete all the contents from a kubernetes node

How to delete all the contents from a kubernetes node? Contents include deployments, replica sets etc. I tried to delete deplyoments seperately. But kubernetes recreates all the pods again. Is there there any ways to delete all the replica sets…
Mufeed
  • 3,018
  • 4
  • 20
  • 29
33
votes
3 answers

What are the implications of R + W > N for Cassandra clusters?

This introduction to Cassandra Replication and Consistency (slides 14-15) boldly asserts: R+W>N guarantees overlap of read and write quorums. Please imagine this inequality has huge fangs, dripping with the blood of innocent, enterprise…
Leftium
  • 16,497
  • 6
  • 64
  • 99
32
votes
12 answers

A timeout occured after 30000ms selecting a server using CompositeServerSelector

I try to deploy my Mongo database in Mongolabs, everything works fine, and I create a new database. Please see my connectionstring. public DbHelper() { MongoClientSettings settings = new MongoClientSettings() { …
Ragesh P Raju
  • 3,879
  • 14
  • 101
  • 136
1
2 3
99 100