A distributed SQL database provides a service where you can query the global database without knowing where the rows are. You connect to any node, without having to know the cluster topology. …
In 2019 I made a “19 features you will miss if you leave Oracle Database” presentation, about the features that are used every day with Oracle, and that may not be available in other databases. Because, as a consultant, I’ve seen many enterprises thinking about moving to open-source databases, especially…
Originally published at https://blog.yugabyte.com on October 14, 2021.
A distributed SQL database reads from remote nodes, which increases the need for optimal data access. …
I have seen a people comparing YugabyteDB and PostgreSQL, and surprised by the different throughput when running a simple test on a from a single session. The purpose of a distributed database is to scale out. When running on a single node without the need for High-Availability-without-data-loss (this is a…
Originally published at https://dev.to on October 7, 2021.
When you create an index, you want the creation to be either:
- fast, blocking concurrent writes to get a stable version of the rows until the creation is completed, usually with a share lock on the table
- online, which means that it…
Originally published at https://dev.to on October 4, 2021.
I’ll write soon about the alternatives for multi-tenancy on YugabyteDB, as this is something a lot of users are asking for (for SaaS — Software as a Service). The solutions are a balance between isolation and scalability. Here I’m showing the maximum…
We have documented how to install YugabyteDB on the main cloud providers (https://docs.yugabyte.com/latest/deploy/public-clouds). And when I joined Yugabyte, many friends from the oracle community asked me about the Oracle Cloud (OCI).
In the Oracle Cloud there are 2 ways to run containers:
YugabyteDB on free cloud — no credit card — any region
You have an e-mail? You have a database. No credit card needed.
Just head up to https://cloud.yugabyte.com/sign-up and you can create one YugabyteDB on the free tier.
Choose the provider (currently AWS and GCP), the region, and be ready to connect your application and verify the level of compatibility with…
I’m running databases and knowing if the pressure is on CPU, RAM or I/O is crucial, and that’s not easy to infer from the metrics provided in CloudWatch or OS usual monitoring. Recent Linux kernels provide PSI (Pressure Stall Information) for that, so let’s enable it.
I have EC2 instances…
In a past post I detailed how the most common RDBMS can avoid the most expensive operation in an access by index, the lookup to the rows scattered in the table, with Index Only Scan. I mentioned the limitation with PostgreSQL where the ACID visibility of the row is not…
