Denis Magda dmagda

YugabyteDB Outage Demo

Use this demo to showcase how YugabyteDB handles failures.

Start Cluster

Create the custom network:

docker network create custom-network

Mock data generation with built-in database capabilities

Relational databases such as PostgreSQL can do much more than store and return your application records. Those databases usually come with comprehensive compute capabitilies.

In this short note, let's review the generate_series function of PostgreSQL, then can generate mock data of various complexity.

Create a sample table for time-series data:
```
create table sensor (
  id int,
```

BRIN vs B-tree: a little demo

If you're not familiar with BRIN, check these easy-to-follow articles: https://www.crunchydata.com/blog/postgres-indexing-when-does-brin-win https://medium.com/geekculture/postgres-brin-index-large-data-performance-with-minimal-storage-4db6b...

Start a postgres instance and connect to it with psql or your favorite tool. And then follow the steps below.

Create a table and fill in with dummy date:

Workshop: YugabyteDB Multi-Region Deploymnets

The gist includes exercises for the "Mastering Multi-Region Deployments With YugabyteDB" workshop. Attend the summit and follow the steps below to get a practical experience.

Workshop: YugabyteDB Multi-Region Deploymnets
- Prerequisite
1. Start Cluster With Default Configuration

Startup Scripts for YugabyteDB and PostgreSQL

Start a database instance within a few seconds on you machine.

PostgreSQL

Start in basic configuration:

docker network create custom-network

Table Partitioning in PostgreSQL and YugabyteDB

Setup Local Environment:
- Start PostgreSQL
- Start YugabyteDB
Create Sample Schema
Partition By Hash
Partition By List

	version: "3.6"

	services:
	yb-master:
	image: yugabytedb/yugabyte:latest
	container_name: yb-master-n1
	volumes:
	- yb-master-data-1:/mnt/master
	command: [ "/home/yugabyte/bin/yb-master",
	"--fs_data_dirs=/mnt/master",