Databases

YugabyteDB Community Fundamentals Training and Certification Recap
November 10, 2020
By
Community NewsDatabasesDistributed SQL

YugabyteDB Community Fundamentals Training and Certification Recap

We recently held our first ever free “YugabyteDB Fundamentals” community training and certification class. A special thanks to Karen Tamrazyan and all 6000+ the members of the Cloud Study Network for hosting us! If you weren’t able to make it, here’s what you missed…

Course Content

Over the span of 90 minutes we covered the following topics in depth:

  • Distributed SQL terms, definitions, and comparisons
  • YugabyteDB architecture and design principles
  • YSQL API development
  • Course review and exam prep

We also worked through a variety of hands-on exercises including:

  • Single and multi-node cluster installs on Mac,

…

Read more

Yugabyte Named a 2020 Gartner Cool Vendor in Data Management
November 2, 2020
By
Company NewsDatabasesDistributed SQL

Yugabyte Named a 2020 Gartner Cool Vendor in Data Management

We are incredibly proud to have recently been recognized by Gartner as a Cool Vendor in Data Management! [1]

The report recommends, “as a data and analytics leader focused on delivering cost-effective innovation, you should evaluate emerging technologies, focusing on those that provide new capabilities in familiar data management paradigms, without requiring sizable investments in new skills.“

We couldn’t agree more. This is why we built YugabyteDB with two APIs that implement the same wire protocol,

…

Read more

Monitoring YugabyteDB in Kubernetes with the Prometheus Operator and Grafana
October 27, 2020
By
DatabasesDistributed SQLKubernetes

Monitoring YugabyteDB in Kubernetes with the Prometheus Operator and Grafana

This blog post is written by guest author Bhavin Gandhi, Software Engineer at InfraCloud Technologies, Inc. InfraCloud helps startups, SMBs, and enterprises scale by adopting cloud-native technologies.

Using the Prometheus Operator has become a common choice when it comes to running Prometheus in a Kubernetes cluster. It can manage Prometheus and Alertmanager for us with the help of CRDs in Kubernetes. The kube-prometheus-stack Helm chart (formerly known as prometheus-operator) comes with Grafana,

…

Read more

Service Mesh Era: Building Modern Apps with YugabyteDB and Istio
October 21, 2020
By
DatabasesDistributed SQLHow ToKubernetes

Service Mesh Era: Building Modern Apps with YugabyteDB and Istio

Microservices architectures are becoming the de facto way developers are thinking about how their applications are constructed. But security remains a top concern for many organizations. Given the general trends of the proliferation of threats within the production network and the increased points of privileged access, it is increasingly necessary to adopt a zero-trust network security approach for microservices architectures.

One of the most common security approaches is to set up mTLS.

…

Read more

Distributed SQL Summit Recap: Mainframe Modernization
October 20, 2020
By
DatabasesDistributed SQLHow ToPostgreSQL

Distributed SQL Summit Recap: Mainframe Modernization

At the Distributed SQL Summit 2020, Brenesh Stanslas Flower Mary – Senior Architect, Wipro Digital, presented the talk “Monolith to Microservices.” In the talk he demonstrated how it is possible to take a large, intertwined mainframe monolith and break it down into microservices using a practical approach. The end-to-end approach he demonstrated made use of Wipro’s “moderniZ” platform which addresses the modernization (or transformation) of UIs, data, and services.

Challenges with Mainframes Today

Brenesh pointed out that although many organizations are well down the path of moving new (and some legacy applications) to the cloud or cloud-native technologies so they can take advantage of the cost savings,

…

Read more

Distributed SQL Tips and Tricks – Oct 16, 2020
October 16, 2020
By
DatabasesDistributed SQLHow ToPostgreSQL

Distributed SQL Tips and Tricks – Oct 16, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

How to use joins in UPDATE statements

Sometimes,

…

Read more

The Distributed Database Behind Twitter
October 15, 2020
By
Apache CassandraDistributed SQLHow It Works

The Distributed Database Behind Twitter

Twitter is one of the world’s favorite places for people and brands to connect online. Powering a global service that helps people share everything from breaking news and entertainment to sports, politics, and everyday interests takes infrastructure that can adapt and evolve over time.

In his talk at the 2020 Distributed SQL Summit, Mehrdad Nurolahzade, engineer on the real-time infrastructure team at Twitter, walks us through the distributed database behind Twitter,

…

Read more

Version Control for Distributed SQL with Flyway’s Maven Plugin
September 30, 2020
By
DatabasesDistributed SQL

Version Control for Distributed SQL with Flyway’s Maven Plugin

Flyway is an open source database version control and migration tool that stresses simplicity and convention over configuration. Changes to the database can be written in SQL (and in some database-specific dialects like PL/SQL and T-SQL) or Java. You interact with Flyway using a command-line client, howeer there are a variety of plugins that can be leveraged, including Maven, Gradle, Spring Boot, and more.

Supported databases include Oracle, SQL Server,

…

Read more

Getting Started with IntelliJ IDEA and Distributed SQL
September 29, 2020
By
DatabasesDistributed SQLHow ToPostgreSQL

Getting Started with IntelliJ IDEA and Distributed SQL

IntelliJ IDEA is a popular integrated development environment (IDE) written in Java for developing software. It is developed by JetBrains and is available as an ache 2 licensed community edition and in a proprietary commercial edition. IntelliJ supports a variety of datasources within their IDE. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” IntelliJ is no exception here.

In this blog post we’ll walk you though the following steps:

  • Install a 3 node YugabyteDB cluster on Google Kubernetes Platform
  • Install the Northwind sample database
  • Configure IntelliJ to work with YugabyteDB
  • Test out some basic IntelliJ database features with YugabyteD

Step 1: Install YugabyteDB on a GKE Cluster using Helm 3

In this section we are going to install YugabyteDB on the cluster.

…

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free