Blogs by: Jimmy Guerrero

Distributed SQL Change Management with Liquibase and YugabyteDB on GKE
July 30, 2020
By
DatabasesDistributed SQLGoogle Cloud PlatformHow ToKubernetes

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, check out their documentation site.

…

Read more

Getting Started with SQLPad and Distributed SQL on Google Kubernetes Engine
July 29, 2020
By
DatabasesDistributed SQLGoogle Cloud PlatformHow ToKubernetes

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.

In this blog post we’ll show you how to:

  • Install a 3 node YugabyteDB cluster on Google Kubernetes Engine
  • Build the sample Northwind database
  • Build and configure SQLPad
  • Start the required SQLPad processes
  • Launch the SQLPad UI and issue a test query to validate the deployment

New to distributed SQL or YugabyteDB?

…

Read more

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – July 24, 2020
July 24, 2020
By
DatabasesDistributed SQLHow ToPostgreSQL

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – July 24, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs. First things first, for those of you who might be new to either distributed SQL or YugabyteDB.

What is Distributed SQL?

Distributed SQL databases are becoming popular with organizations interested in moving data infrastructure to the cloud or cloud native environments. This is often motivated by the desire to reduce TCO or move away from the horizontal scaling limitations of monolithic RDBMS like Oracle,

…

Read more

Getting Started with Longhorn Distributed Block Storage and Cloud Native Distributed SQL
July 21, 2020
By
DatabasesDistributed SQLHow ToKubernetes

Getting Started with Longhorn Distributed Block Storage and Cloud Native Distributed SQL

Editor’s note: This post was originally published on the Rancher blog, and has been cross-posted here and updated as of July 21, 2020 to account for new versions of software available.

Longhorn is cloud native distributed block storage for Kubernetes that is easy to deploy and upgrade, 100 percent open source, and persistent. Longhorn’s built-in incremental snapshot and backup features keep volume data safe, while its intuitive UI makes scheduling backups of persistent volumes easy to manage.

…

Read more

GraphQL & Distributed SQL Tips and Tricks – July 10, 2020
July 10, 2020
By
Community NewsDistributed SQLGraphQLHow ToPostgreSQL

GraphQL & Distributed SQL Tips and Tricks – July 10, 2020

Welcome to this week’s tips and tricks blog where we explore topics related to combining GraphQL and YugabyteDB to develop scalable APIs and services. We’ll also review upcoming events, new documentation, and blogs that have been published since the last tips and tricks post.

This next section is for those of you who might be new to either GraphQL or distributed SQL.

What’s GraphQL?

GraphQL is a query language (more specifically a specification) for your API,

…

Read more

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE
May 26, 2020
By
DatabasesDistributed SQLGoogle Cloud PlatformHow ToKubernetes

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, but otherwise, Prometheus does not offer continuous availability. For example, if one of the Prometheus replicas crashes,

…

Read more

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility
May 14, 2020
By
Compare and contrastPostgreSQLYugabyteDB

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

This post explores the compatibility of YugabyteDB with Oracle and PostgreSQL by examining 15 different Oracle features and their PostgreSQL equivalents highlighted in Roland Takacs’ blog post “Oracle vs PostgreSQL: First Glance.” As a PostgreSQL-compatible distributed SQL database, YugabyteDB offers a broad range of SQL features, making it an interesting choice for those looking to migrate from Oracle to a modern tech stack.

Read more

Getting Started with YugabyteDB on Azure Kubernetes Service
May 11, 2020
By
How ToKubernetesMicrosoft AzureYugabyteDB

Getting Started with YugabyteDB on Azure Kubernetes Service

Microsoft’s Azure Kubernetes Service (AKS) offers a highly available, secure, and fully managed Kubernetes service for developers looking to host their applications on containers in the cloud. AKS features elastic provisioning, an integrated developer experience for rapid application development, enterprise security features, and the most available regions of any cloud provider.

YugabyteDB is a natural fit for AKS because it was designed to support cloud native environments since its initial design.

…

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