gh-ost Based Online Schema Migration for MySQL

Introduce gh-ost based online schema migration and how to perform an online schema migration without downtime in Bytebase.

20-Person Start-Up, 30+ SaaS Services, and $1,183 Monthly Bill

A breakdown of the 30+ SaaS services that we use daily at Bytebase, a 20-person 18-month tech startup, and how much they cost us monthly.

How to Configure ClickHouse SSL Connection

Configure ClickHouse SSL connection and test it by using self-signed CA.

Dev, SRE, Operations, DevOps - What’s the Difference?

Explain and address the confusion between Developer (Dev), Site Reliability Engineer (SRE), (Operations) Ops and DevOps.

Restoring a MySQL Database to a Point in Time

This article describes how Point-in-Time-Recovery (PITR) works in Bytebase and the steps to restore a database using this feature.

How to install MySQL Shell on Your Mac

Learn how to install MySQL Shell on your macOS.

Introducing Schema Review Policy for MySQL

This post introduces a new feature - schema review policy, which help DBAs and application developers compose better schema change statements.

The Database as Code Landscape

The idea of codifying database schema changes (aka schema migration) is not new. While we are observing an accelerated trend of embracing Database as Code (DaC) across the industry. In this blog, we will review the state-of-the-art in the Database as Code landscape and share our own insight into the current and future trends in this space.

DBA, Database and Developer - The Decameron

This is the first of the DDD series, consisting of 10 stories of DBA & Database & developer.

Introducing bb - a Bytebase CLI tool to manage database operations

This article describes how to install and run Bytebase CLI bb

Get Database Change Notification via Webhook

For better collaboration, DBAs and developers need to be notified when there is any update of the database changes. With Bytebase, you can configure webhooks at a project-level so that Bytebase can post database change notifications to the webhook endpoint.

How to use Bytebase with Better Uptime

We use Better Uptime as a way to monitor our websites. With a feature called heartbeats, it is also an easy-to-use tool to monitor Bytebase automatic backup.

Database Migration: SQLite to PostgreSQL

This article describes the story of Bytebase migrating its storage from SQLite to PostgreSQL and the challenges on the way.

How Bytebase uses Render

We recently moved most of our hosted service to render.com and also leverage its unique capability to improve our dev workflow. I was responsible for this task.

How to build a highly-available service in the Cloud?

This article describes how sharding can help building a highly-available services in the Cloud based on author's years of experience at Google Cloud.

What is Database Schema Drift?

Database schema drift is the case where the actual schema in the live database is different from the source of truth. It's also one of the most frequent root cause of the database related outages.

GitLab Upgrade from 13 to 14

GitLab upgrade from 13 to 14

Announcing our $3M Seed Round

We are excited to announce that we've raised a $3M seed round, led by Matrix Partners China with participation from Dongxu Huang, co-Founder/CTO of PingCAP (the company behind TiDB).

Run ClickHouse with Docker and Connect Using MySQL Client

Run ClickHouse with Docker, and connect using MySQL client.

Database Version Control, State-based or Migration-based?

We dive the rationale behind the industry divergence between state-based and migration-based approach. In the end, we also show how Bytebase can help to get the best of both worlds.

Database as Code - the Good, the Bad and the Ugly

Database-as-Code has many benefits in today's DevOps world. However, there exists several missing bricks preventing its wider adoption. We touch many points around Database-as-Code and also explain why Bytebase could help the transition.

SQL Primary Key - UUID or Auto Increment Integer / Serial?

Pros and Cons between choosing UUID or auto increment integer / serial for SQL database.

Announcing Bytebase. Open source, web-based, zero-config, dependency-free database schema change and version control tool for Developer and DBA

Bytebase is a tool for database schema change and version control, its main audience are Developers and DBAs. We want to make Bytebase the industry benchmark solution for managing database schema change.