Stack Overflow
Stack Overflow

Questions tagged [database-cluster]

Use database-cluster for questions related to running a group of databases as a cluster, which helps prevent the existence of a single point of failure in case a database server fails or is compromised.

References

70 questions
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
17
votes
1 answer

What's a good balance to decide when to partition a table in BigQuery?

We are using a public dataset to benchmark BigQuery. We took the same table and partitioned it by day, but it's not clear we are getting many benefits. What's a good balance? SELECT sum(score) FROM…
Felipe Hoffa
  • 54,922
  • 16
  • 151
  • 325
11
votes
2 answers

When to prefer master-slave and when to cluster?

I know there have been many articles written about database replication. Trust me, I spent some time reading those articles including this SO one that explaints the pros and cons of replication. This SO article goes in depth about replication and…
th3an0maly
  • 3,360
  • 8
  • 33
  • 54
8
votes
4 answers

Resources for Database Sharding and Partitioning

I'm working with a database schema that is running into scalability issues. One of the tables in the schema has grown to around 10 million rows, and I am exploring sharding and partitioning options to allow this schema to scale to much larger…
Peter Bratton
  • 6,302
  • 6
  • 39
  • 61
7
votes
2 answers

Cluster vs replication

I have an use case where I am looking to replicate a single database on multiple servers (for HA and scalability purposes), Would there be any disadvantage to run a 3 node replica instead of a 3 nodes cluster ?
romainrbr
  • 73
  • 1
  • 4
5
votes
4 answers

MySQL cluster error 1114 (HY000): The table 'users' is full

I have a MySQL cluster setup, There are 2 data nodes and 1 management node. We are now getting errors on our data nodes when doing inserts. ERROR 1114 (HY000): The table 'users' is full Please any help is appreciated, Is this a config issue, if so…
T-Wrecks
  • 143
  • 1
  • 2
  • 6
4
votes
1 answer

Add cluster to an existing table in oracle

Is it possible to add cluster to an existing table? For example... I have a table: CREATE TABLE table_name( t_id number PRIMARY KEY, t_name varchar2(50)); Cluster: CREATE CLUSTER my_cluster (c_id NUMBER) SIZE 100; Is there a command like:…
randomUser56789
  • 936
  • 2
  • 13
  • 32
4
votes
1 answer

pgpool-II for Postgres - Is it what I need?

I just stumbled upon pgpool-II in my search for clustering my Postgres DB (just getting ready to deploy a web app in a couple months). I still have the shakes from excitement, but I'm nervous, as each time I find something this excellent I am soon…
orokusaki
  • 55,146
  • 59
  • 179
  • 257
3
votes
2 answers

Galera replication ignore table

With normal Mysql replication we can ignore tables with: replicate_ignore_table I can't find any information on whether or not it's possible to do this with Galera cluster replication. I'd like to ignore a table that is not important so that no…
gijs007
  • 233
  • 1
  • 7
  • 19
3
votes
1 answer

Got error 4239 'Trigger with given name already exists' from NDBCLUSTER

We are running a MySQL Cluster Version: mysql> SELECT VERSION(); +------------------------------+ | VERSION() | +------------------------------+ | 5.6.15-ndb-7.3.4-cluster-gpl | +------------------------------+ Trying to create a…
gies0r
  • 4,723
  • 4
  • 39
  • 50
3
votes
5 answers

Is it true that MyISAM engine is more preferable than InnoDB when we are building clustered storage? Why if it is so?

I heard this today during interview for java developer. I had to list some advantages of MyISAM over InnoDB and why it's still being widely used. And they were waiting to hear from me the answer as the title of this question. As I understand from…
Roman
  • 64,384
  • 92
  • 238
  • 332
2
votes
1 answer

Assigning virtual IP in repmgr

I have a postgres cluster made using repmgr. This is the requirement of the application that they should not have to change the IP in the application when the database switchover occurs. Is there a way to use virtual IP with repmgr which outside…
makhshif afiniti
  • 55
  • 1
  • 8
2
votes
1 answer

PostgreSQL - Clustering never completes - long key?

I am having problems with clustering a table where the key consists of one char(23) field and two TimeStamp fields. The char(23) field contains Alpha-Numeric values. The clustering operation never finishes. I have let it run for 24 hours and it…
user731288
  • 21
  • 1
2
votes
1 answer

Where exactly the table-data stored using MySQL-cluster gets stored?

I am a new-bee to MySQL cluster and wanted to know where exactly the data is stored in MySQL-cluster and where can i see it without directly. As we can see the separate files for each tables in MySQL 5.x databases. I have to verify for the same in…
HarsH
  • 760
  • 3
  • 12
  • 27
2
votes
3 answers

Cassandra received an invalid gossip generation for peer

We have a basic 2 node Cassandra cluster. Both nodes run version 3.9 with minimal configurations to enable clustering. One of the nodes is sending wrong generation which causes the other node to show the warning WARN [GossipStage:1]…
Arslan Mehboob
  • 1,012
  • 1
  • 9
  • 21
1
2 3 4 5