Speaker

Franck Pachot

Franck Pachot

Developer Advocate at Yugabyte

Lausanne, Switzerland

Developer Advocate for YugabyteDB, distributed SQL database using PostgreSQL query layer. Franck has a passion for learning and sharing in blog posts (blog.pachot.net), articles, conferences and tech communities (AWS Data Hero and Oracle ACE Director)

Area of Expertise

  • Information & Communications Technology

Topics

  • Distributed
  • SQL
  • Database
  • Cloud Native
  • AWS Databases
  • Oracle Database

YugabyteDB: Distributed PostgreSQL on Kubernetes

Unlike traditional SQL databases, with their monolithic architecture, YugabyteDB brings horizontal scalability and resilience to the table. Our demo on Amazon EKS will delve into the core motivations behind adopting this cloud-native DB: elasticity and resilience, all while remaining PostgreSQL compatible and open-source.

pg_hint_plan - hinting without surprises

I use pg_hint_plan to learn about the optimizer, to understand the query planner choices, and sometimes, workaround a problem in production. But hinting is not easy. Fixing the exact plan needs more than one hint. Here are some tips and examples to use pg_hint_plan without surprises.

Harness the Power of a Single Database for Microservices

This session will delve into the benefits of using Distributed SQL for microservices. We will discuss the challenges of managing multiple databases in a microservices environment, such as complexity, inefficiency, and cost. Our focus will be on YugabyteDB, an Open Source and PostgreSQL-compatible distributed SQL database, which offers a potential solution to these challenges. Modern SQL databases are multi-model, including relational, document, text search, timeseries and more and YugabyteDB is multi-API. Combined with horizontal scalability, Distributed SQL offers a single database solution for microservices.

Anatomy of a distributed SQL database (YugabyteDB)

Porting all the features of PostgreSQL to a distributed database that “scales” horizontally is a challenge. But also the opportunity to modernize the underlying technologies of the DB, which becomes “cloud-native”: consensus protocols, logical clocks, automatic sharding. And to replace B-Tree indexes with LSM Tree and SSTables, more suited to SSD and distributed storage.

YugabyteDB is open-source, and we will go into the details of the architecture, at the crossroads of PostgreSQL, Spanner, Cassandra, RocksDB… to better understand the reasons for a new database, and its underlying technology. We will discuss the advantages and the challenges of this unique architecture design: re-using the PostgreSQL query layer, plugged on top of a distributed storage and transaction layer

Franck Pachot

Developer Advocate at Yugabyte

Lausanne, Switzerland