Report this

What is the reason for this report?

IPDB vs BigchainDB vs HBASE vs OrbitDB vs MySQL vs MariaDB vs Cassandra vs MongoDB vs PostgreSQL vs Oracle vs Redis vs CockRoachDB

Posted on May 16, 2021

It seems a big title, but I’d like a discussion about decentralized databases solutions

Is there out there a decentralized + high auto scalable + high speed + secure solution

also if someone have some numbers (because when I search I only find “high-speed”) but could do 10, 100, 1000 or 10 000 read+write per seconds ???

To develop decentralized Apps for a multi tools platform (POS, address-book, accounting, inventory, etc)

There is tons of stuff when I search on the web.

Is someone tested some of these?

Terms like noSQL, serverless, nodes, clusters, docker

Right now I’m using MariaDB 10.3 with RocksDB engine (in my view way better than innoDB) but for long term and with growing number of simultaneous users, what could be best?

sometimes load is low, sometimes average, sometimes high, but having to pay a big server to reach the high seems a waist of unused and paid resources…

what I mean by that : pay a server with 16 or 32 gig ram + 500mb or 3Tb… x CPU… but sometimes 100 users, other times 1000 users, you see my point, why pay for 10 000 users all the time?

when I try to search on auto-scaling, pay as you need, it’s really hard, in pricing sections of databases solutions; we have to choose a fix amount or ram, cpu disk pace…

Is there any solution with auto mode (will take more CPU/RAM when needed), take space as needed and be billed only for the use instead of paying for fix amount?

what about peer to peer (like blockchain) solutions ? which is usable and strong for long term ?



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi there,

Indeed, this is a great and broad discussion!

When selecting a database, it’s important to consider your specific use-case and requirements for scalability, speed, and security, along with your application’s architecture.

As you’ve mentioned, each database system has its own set of features and compromises.

For a setup that requires decentralized features, BigchainDB and IPDB are blockchain-based and provide robust security and transparency, suitable for applications needing an immutable ledger. While they offer unique advantages, they may not match the speed and scalability of more traditional databases.

For auto-scalability and flexible resource management, DigitalOcean’s Managed Databases for MySQL or PostgreSQL allow you to scale resources according to demand and bill you only for the resources utilized, avoiding the cost of over-provisioning.

Databases like Cassandra, HBase, and CockroachDB are engineered for high throughput and are effective in distributed environments.

On the other side, Redis offers remarkable speed as an in-memory data store and can often be used alongside your OLTP database.

Peer-to-peer options like OrbitDB offer decentralized alternatives, though they may not have the same level of maturity as their centralized counterparts when it comes to community and tooling support.

Ultimately, benchmarking databases with your specific workload will guide you to the most suitable choice. If no single database fits all your needs, you can always use a combination of different database systems like Redis + Postgres for example.

Best,

Bobby

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.