Questions tagged [distributed-database]

Anything related to distributed databases and the techniques and the tools used to manage them. A distributed database is a database whose information is not stored in a single physical location, but it is spread over various devices, often placed far apart.

Anything related to distributed databases and the techniques and the tools used to manage them. A distributed database is a database whose information is not stored in a single physical location, but it is spread over various devices, often placed far apart.

188 questions
0
votes
1 answer

Rolling upgrades in YugaByte DB - is it possible?

Does YugaByte DB have the ability to support rolling upgrades for the system?
Ricardo Adam
  • 115
  • 5
0
votes
1 answer

What can I control with keyspace?

Can I control the amount of CPU, memory and IO resources per keyspace in yugabyte DB?
0
votes
2 answers

Can I write a program to see if a table exists in YugaByte's YCQL (Cassandra) api?

Is there a programmatic way to check if a table exists in YugaByte's YCQL (Cassandra) api? For example, in Postgres one can do something like: How to check if a table exists in a given schema SELECT EXISTS ( SELECT 1 FROM …
0
votes
1 answer

How to use docker in distributed systems

Hello i have the following problem: I have .NET Core WebApi and a Distributed Database(RethinkDB) that i want to scale using Docker containers. The database can be both sharded and replicated ( i am not interested in replication though). My problem…
0
votes
1 answer

How to model "dimension" tables in TiDB?

I would like to designate certain tables as replicated to all TiKV stores such that they are always available to join with locally (thereby reducing expensive distributed joins at the TiDB level). This would allow the TiKV coprocessor to join…
0
votes
0 answers

Writes to geographically distributed database

If we have a database system replicated in geographically separate locations... and we want to allow writes on each of them. What is the best way to do that? For example: A site like expedia.com allows customers around the world to book any…
0
votes
2 answers

Need help in understanding Akka

I am working on creating a distributed database system using Akka. I have the code for a database system that works on a single machine but want to make it distributed. But I have difficulty in understanding and approach to creating. Here's what my…
vinayawsm
  • 845
  • 9
  • 28
0
votes
1 answer

Distributed C++ game server which use database

My C++ turn-based game server (which uses database) does not stand against current average amount of clients (players), so I want to expand it to multiple (more then one) amount of computers and databases where all clients still will remain within…
Slaus
  • 2,086
  • 4
  • 26
  • 41
0
votes
1 answer

TiDB CREATE FUNCTION returns error

I was running these codes in TiDB: CREATE FUNCTION `FN_UP_TRADEDAY`( endDay int(11), upDays int(11), marketx varchar(20) ) RETURNS int(11) READS SQL DATA BEGIN declare beginDay int(11); declare days int(11) default upDays-1; select day into…
Coco
  • 29
  • 4
0
votes
1 answer

Aerospike: Read records from a particular node using secondary index

I want to read records from Aerospike DB using Secondary index. Could you please if its possible to read records using secondary index from a particular node ( rather than from all nodes --- Default Behavior ) I am looking to do this operation…
Tarun
  • 3,162
  • 3
  • 29
  • 45
0
votes
1 answer

The machine that Syncer is in is broken and the directory of the `syncer.meta` file is lost when using TiDB

Syncer GTID synchronously updates syncer.meta. If the machine that Syncer is in goes down, the directory of syncer.meta is lost. And I did not find the record information of GTID in TiDB. How to deal with this?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

How to determine the right TiDB and TiDB-Ansible version?

TiDB provides so many different versions and the documentation also mentions different versions for users to install. How to avoid choosing the wrong TiDB version and TiDB-Ansible version? What's the difference between various TiDB master versions?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
0 answers

Are all distributed database designed to process data in parallel?

I am learning about the characteristics of distributed database and I came across this website that describes some of the advantages of distributed…
Stanleyrr
  • 858
  • 3
  • 12
  • 31
0
votes
1 answer

`ERROR 9001 (HY000): PD server timeoutstart timestamp may fall behind safepoint` in TiDB

When I was testing TiDB, I bumped into the 9001 error. I didn't figure out the cause. How to deal with it?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

How to check the health status of the whole TiDB cluster?

I've deployed the TiDB cluster for a test. I want to check whether the instances have all been started successfully, but I do not have a command line cluster management tool. In this case, how to check the health status of the TiDB cluster?
Lilian Lee
  • 190
  • 1
  • 12