获取数据库资讯 💡

了解我们的产品更新和有关数据库的实时消息。

📕 What is Write-ahead logs (WAL)?

A type of logs used by storage engine to guarantee transaction ACID. For performance reason, whenever a transaction commits, the storage engine does not changes the data file directly, instead it persists the change by appending it to a log file and then signals the commit success. This process is called write-ahead because the actual change to the data file is batched at a later time, the storage engine just writes ahead to a log file to guarantee that the transaction data persists. If the database crashes in between, the recovery process will redo the changes recorded in the write-ahead logs to apply to the data file, that's why it's also known as redo logs. Another usage for WAL is for change-data-capture (CDC) since it already records all the data changes. e.g. PostgreSQL uses WAL for logical replication.

Safer and faster database change and version control for DBAs and Developers

Bytebase is an open source, web-based database schema change and version control tool for teams. It offers a web-based collaboration workspace to help DBAs and Developers manage the lifecycle of application database schemas.

mysql postgresql clickhouse tidb snowflake gitlab

Features

SQL 审核

专为 DBA 与应用开发者进行 Schema 变更协作而设计的审核工作流程,内置可配置的 SQL 质量规则。

Database-as-Code

可与版本控制系统(VCS)集成以托管 Schema 变更文件。每当新的变更文件提交后,会自动触发变更流水线。

流水线部署

针对多租户(M)、多环境(N)的情况,支持在单个变更流水线中实现 M*N 的矩阵式变更。

SQL 编辑器

一个易于使用的查询界面用于查看数据库记录。

变更历史

通过相邻版本间的比对,来展示每次变更产生的差异。

异常中心

定期扫描所有托管实例和数据库,并为用户提供整体视图以查看所有异常情况。

Drift 检测

定期扫描所有托管实例和数据库,并为用户提供整体视图以查看所有异常情况。

备份与恢复

支持数据库级别的定时自动、手动备份。可按开发、生产等不同环境制定差异化备份策略。

基于角色的访问控制

提供两类角色集。Owner, DBA, Developer 用于全局平台管理。Owner, Developer 用于应用开发者在各自项目内管理。