Kubernetes Archives - The Distributed SQL Blog

Databases Distributed SQL Docker Ecosystem Integrations How To Kubernetes PostgreSQL

August 26, 2020

Using Envoy Proxy’s PostgreSQL & TCP Filters to Collect Yugabyte SQL Statistics

Layer 7 proxies like NGINX and HAProxy have been popular since the mid-2000s. The term “proxy” refers to their role as an intermediary for the traffic between an application client and an application server. The “layer 7” classification comes from the fact that these proxies take routing decisions based on URLs, IPs, TCP/UDP ports, cookies, or any information present in messages sent over a layer 7 (aka application layer) networking protocol like HTTP and gRPC.

…

Databases Distributed SQL Google Cloud Platform GraphQL How To Kubernetes Microsoft Azure PostgreSQL

August 24, 2020

by Jimmy Guerrero

Getting Started with Hasura GraphQL Remote JOINs on Multi-Cloud Distributed SQL

Remote Joins in Hasura GraphQL extend the concept of joining data across tables, to being able to join data across tables and remote data sources. In this blog post we are going to demonstrate this capability by configuring the following set up.

A 3 node YugabyteDB cluster running on GKE with a Hasura GraphQL Engine attached
A 3 node YugabyteDB cluster running on AKS with a Hasura GraphQL Engine attached
A Remote Schema and Remote Relationship configured
The ability to issue GraphQL queries that join data from two different databases,

…

Databases Distributed SQL Google Cloud Platform GraphQL How To Kubernetes

August 21, 2020

by Jimmy Guerrero

Deploying a Real-Time Location App with Hasura GraphQL Engine and Distributed SQL

Hasura is one of the leading vendors in the GraphQL ecosystem. They offer an open source engine that connects to your databases and microservices, and then auto-generates a production-ready GraphQL backend. GraphQL is a query language (more specifically a specification) for your API, and a server-side runtime for executing queries by using a type system you define for your data.

…

Distributed SQL Google Cloud Platform Kubernetes Spring

August 20, 2020

by Jimmy Guerrero

Run the REST Version of Spring PetClinic with Angular and Distributed SQL on GKE

Java developers know that Spring Data makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. When YugabyteDB is combined with Spring, Java developers are able to leverage their familiarity with PostgreSQL while gaining the added benefits of Distributed SQL. These “out-of-the-box” benefits include geo-data distribution, high performance, and horizontal scalability,

…

Community News Databases Distributed SQL Kubernetes Open Source

August 14, 2020

by Michelle Brinich

Staying Connected During COVID-19: Join Us at KubeCon + CloudNativeCon Europe 2020

We are excited to sponsor KubeCon + CloudNativeCon Europe 2020 and participate alongside other open source and cloud native communities coming together to drive cloud native computing forward. Although many people across the world remain physically distanced (us included), we believe that coming together as a community and maintaining a sense of connection are still very essential and important.

…

Databases Distributed SQL Google Cloud Platform How To Kubernetes

July 30, 2020

by Jimmy Guerrero

Distributed SQL Change Management with Liquibase and YugabyteDB on GKE

Liquibase is an open source and extensible change management project that supports a variety of databases including Snowflake, MySQL, and PostgreSQL via JDBC. Liquibase allows users to easily define changes in SQL, XML, JSON, and YAML. These changes are then managed in a version control system so the changes can be documented, ordered, and standardized. For more information on the features and benefits of Liquibase,

…

Databases Distributed SQL Google Cloud Platform How To Kubernetes

July 29, 2020

by Jimmy Guerrero

Getting Started with SQLPad and Distributed SQL on Google Kubernetes Engine

SQLPad is an MIT licensed web app written in React and Node.js for writing and running SQL queries and visualizing the results. SQLPad supports PostgreSQL, MySQL, SQL Server, Crate, Vertica, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, and many more via ODBC. Because YugabyteDB is PostgreSQL compatible, most third-party tools and apps will work “out of the box.” SQLPad is no exception here.

…

Databases Distributed SQL Google Cloud Platform How To Kubernetes

May 26, 2020

by Jimmy Guerrero

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE

In the last few years, Prometheus has gained huge popularity as a tool for monitoring distributed systems. It has a simple yet powerful data model and query language, however, it can often pose a bit of a challenge when it comes to high availability as well as for historical metric data storage. Adding more Prometheus replicas can be used to improve availability,

…

Databases Distributed SQL Google Cloud Platform How To Kubernetes Open Source PostgreSQL

May 20, 2020

by Jimmy Guerrero

Part 1: Deploying a Distributed SQL Backend for Apache Airflow on Google Cloud

Apache Airflow is a popular platform for programmatically authoring, scheduling, and monitoring workflows. Airflow has been deployed by companies like Adobe, Airbnb, Etsy, Instacart, and Square. The advantage of defining workflows as code is that they become more maintainable, versionable, testable, and collaborative. Airflow is used to author these workflows as directed acyclic graphs (DAGs) of tasks.

…