Distributed SQL
Tuning and Optimization
in YugabyteDB
BW
Builder Workshop
2022 Dec 07
2:00 PM - 4:30 PM CET
Level: Intermediate
As a distributed PostgreSQL-compatible database, YugabyteDB has a ton of similarities and a few differences when compared to open-source Postgres. YugabyteDB does behave and look like Postgres in runtime which allows you to reuse most optimization techniques you've already mastered with Postgres. At the same time, YugabyteDB is a distributed database that can store your data across multiple geographies and use thousands of CPUs distributed across hundreds of nodes which requires you to consider query tuning patterns specific to distributed systems.
During this workshop, you'll learn and receive hands-on experience with techniques, concepts, and toolsets used for performance optimization and query tuning in YugabyteDB. By following simple examples, you'll start with generic SQL optimization concepts and tactics, and then do a deep dive into advanced optimization techniques specific to YugabyteDB's distributed nature.
What you’ll learn and how you can apply it:
Wanted: Developers and Architects
What you'll need
Operating System
macOS 10.12+, Ubuntu 16.04+, Docker, or Minikube 1.18+
Chromium web browser
Safari, Chrome, Opera, or Microsoft Edge
Third party tools
Your favorite IDE, such as IntelliJ IDEAEclipse, or Visual Studio Code.
GitPod or Docker 20 or later, JDK 11 or later, Python 3.8 or later, Apache Maven 3.0 or later and Docker Compose 1.29 or later
YugabyteDB Managed sandbox (free) cluster
YugabyteDB public slack account
Duration: 150 minutes
Welcome!
Zoom Meeting Details | Wed Dec 07 @ 02:00 PM CET
Zoom Recording
Presentation
🦶Next Steps
🧰 Your YugabyteDB skill on LinkedIn
The answers you seek
YugabyteDB University courses are FREE, so enroll today!
You do not need to purchase a YugabyteDB software license for this course. YugabyteDB is open source software.
You can sign up for Yugabyte Cloud Free cluster without a credit card or payment method.
Yes!
Most of our courses require a YugabyteDB cluster, so an on-demand Yugabyte Cloud cluster is a great option.
If you get stuck, help is a literally a click away. In the Course Player header bar, select Discussions and post a question, concern, or even suggestion.
We also have a #training channel on YugabyteDB Public Slack.
Yes! We highly value your feedback and suggestions. Your review and rating helps pay it forward for our future students.
After you register, you will receive a calendar invitation. You will also receive an email reminding you to attend this builder workshop.
You will find the Zoom webinar details in the Course Player, in Welcome --> Zoom Details. In the table of contents, select this lesson and then select Start Zoom. That's it.
Franck will be your workshop guide
Franck Pachot
Developer Advocate