Skip to content

Docs List

melrose98 edited this page Dec 11, 2018 · 102 revisions

COCKROACHDB

GUIDES

Get Started

Install CockroachDB

Start a Local Cluster

From Binary
In Docker

Learn CockroachDB SQL

Build an App

Overview
Go
Python
Ruby
Java
Node.js
C++
C# (.NET)
Clojure
PHP
Rust

Explore Features

Data Replication

Fault Tolerance & Recovery

Automatic Rebalancing

Serializable Transactions

Cross-Cloud Migration

Follow-the-Workload

Orchestration

JSON Support

Third-Party Database Tools

Deploy

Production Checklist

Test Deployment

Manual Deployment

Overview
On-Premises
AWS
Azure
Digital Ocean
Google Cloud Platform GCE

Orchestrated Deployment

Overview
Kubernetes Single-Cluster Deployment
Kubernetes Multi-Cluster Deployment
Kubernetes Performance Deployment
Docker Swarm Deployment
Mesosphere DC/OS Deployment

Monitoring and Alerting

Overview
Use the Admin UI
Use the Prometheus and Alertmanager

Access Management

Manage Users
Privileges

Configure Replication Zones

Performance Benchmarking

Performance Tuning

Enterprise Features

Request an Enterprise License
Table Partitioning
Node Map
Role-Based Access Control
Encryption at Rest
Change Data Capture (Enterprise)

Migrate

Migration Overview

Migrate from Postgres

Migrate from MySQL

Migrate from CSV

Maintain

Upgrade to CockroachDB v2.1

Manage Long-Running Queries

Decommission Nodes

Import Data

  • [import-data.md]migration-overview.md로 연결되며 문서 내용 없음
  • (이는 원본 프로젝트 문서 및 웹페이지에서 동일)

Back up and Restore Data

Create a File Server for IMPORT/BACKUP

Rotate Security Certificates

Diagnostics Reporting

SQL Audit Logging (Experimental)

Troubleshoot

Overview

  • troubleshooting-overview.md

Common Errors

  • common-errors.md

Troubleshoot Cluster Setup

  • cluster-setup-troubleshooting.md

Troubleshoot Query Behavior

  • query-behavior-troubleshooting.md

Understand Debug Logs

  • debug-and-error-logs.md

Support Resources

  • support-resources.md

File an Issue

  • file-an-issue.md

Contribute

Contribute to CockroachDB

  • contribute-to-cockroachdb.md

Improve the Docs

  • improve-the-docs.md

REFERENCES

SQL

Supported Client Drivers

  • install-client-drivers.md

Client Connection Parameters

  • connection-parameters.md

SQL Feature Support

SQL Support Summary
  • sql-feature-support.md
Detailed SQL Standard Comparison
  • detailed-sql-support.md

SQL Statements

Overview
  • sql-statements.md
ADD COLUMN
  • add-column.md
ADD CONSTRAINT
  • add-constraint.md
ALTER COLUMN
  • alter-column.md
ALTER DATABASE
ALTER INDEX
  • alter-index.md
ALTER RANGE
  • alter-range.md
ALTER SEQUENCE
  • alter-sequence.md
ALTER TABLE
  • alter-table.md
ALTER TYPE
  • alter-type.md
ALTER USER
  • alter-user.md
EXPERIMENTAL_AUDIT
  • experimental-audit.md
ALTER VIEW
  • alter-view.md
BACKUP (Enterprise)
  • backup.md
BEGIN
  • begin-transaction.md
CANCEL JOB
  • cancel-job.md
CANCEL QUERY
  • cancel-query.md
CANCEL SESSION
  • cancel-session.md
COMMIT
CONFIGURE ZONE
  • configure-zone.md
CREATE CHANGEFEED (Enterprise)
  • create-changefeed.md
CREATE DATABASE
  • create-database.md
CREATE INDEX
  • create-index.md
CREATE ROLE (Enterprise)
  • create-role.md
CREATE SEQUENCE
  • create-sequence.md
CREATE STATISTICS (Experimental)
  • create-statistics.md
CREATE TABLE
  • create-table.md
CREATE TABLE AS
  • create-table-as.md
CREATE USER
  • create-user.md
CREATE VIEW
  • create-view.md
DELETE
  • delete.md
DROP COLUMN
  • drop-column.md
DROP CONSTRAINT
  • drop-constraint.md
DROP DATABASE
  • drop-database.md
DROP INDEX
  • drop-index.md
DROP ROLE (Enterprise)
  • drop-role.md
DROP SEQUENCE
  • drop-sequence.md
DROP TABLE
  • drop-table.md
DROP USER
  • drop-user.md
DROP VIEW
  • drop-view.md
EXPLAIN
  • explain.md
EXPLAIN ANALYZE
  • explain-analyze.md
EXPORT (Enterprise)
  • export.md
GRANT
  • grant.md
GRANT (Enterprise)
  • grant-roles.md
IMPORT
  • import.md
INSERT
  • insert.md
PARTITION BY (Enterprise)
  • partition-by.md
PAUSE JOB
  • pause-job.md
RENAME COLUMN
  • rename-column.md
RENAME DATABASE
  • rename-database.md
RENAME INDEX
  • rename-index.md
RENAME TABLE
  • rename-table.md
RENAME SEQUENCE
  • rename-sequence.md
RELEASE SAVEPOINT
  • release-savepoint.md
RESET
RESET CLUSTER SETTING
  • reset-cluster-setting.md
RESTORE (Enterprise)
  • restore.md
RESUME JOB
  • resume-job.md
REVOKE
  • revoke.md
REVOKE (Enterprise)
  • revoke-roles.md
ROLLBACK
  • rollback-transaction.md
SAVEPOINT
  • savepoint.md
SELECT
  • select-clause.md
SET
  • set-vars.md
SET CLUSTER SETTING
  • set-cluster-setting.md
SET TRANSACTION
  • set-transaction.md
SHOW
  • show-vars.md
SHOW BACKUP
  • show-backup.md
SHOW CLUSTER SETTING
  • show-cluster-setting.md
SHOW COLUMNS
  • show-columns.md
SHOW CONSTRAINTS
  • show-constraints.md
SHOW CREATE
  • show-create.md
SHOW DATABASES
  • show-databases.md
SHOW EXPERIMENTAL_RANGES
  • show-experimental-ranges.md
SHOW GRANTS
  • show-grants.md
SHOW INDEX
  • show-index.md
SHOW JOBS
  • show-jobs.md
SHOW QUERIES
  • show-queries.md
SHOW ROLES
  • show-roles.md
SHOW SCHEMAS
  • show-schemas.md
SHOW SESSIONS
  • show-sessions.md
SHOW STATISTICS (Experimental)
  • show-statistics.md
SHOW TABLES
  • show-tables.md
SHOW TRACE FOR SESSION
  • show-trace.md
SHOW USERS
  • show-users.md
SHOW ZONE CONFIGURATIONS
  • show-zone-configurations.md
SPLIT AT
  • split-at.md
TRUNCATE
  • truncate.md
UPDATE
  • update.md
UPSERT
  • upsert.md
VALIDATE CONSTRAINT
  • validate-constraint.md

Data Types

Overview
  • data-types.md
ARRAY
  • array.md
BOOL
  • bool.md
BYTES
  • bytes.md
COLLATE
  • collate.md
DATE
  • date.md
DECIMAL
  • decimal.md
FLOAT
  • float.md
INET
  • inet.md
INT
  • int.md
INTERVAL
  • interval.md
JSONB
  • jsonb.md
SERIAL
  • serial.md
STRING
  • string.md
TIME
  • time.md
TIMESTAMP
  • timestamp.md
UUID
  • uuid.md

Constraints

Overview
  • constraints.md
Check
  • check.md
Default Value
  • default-value.md
Foreign Key
  • foreign-key.md
Not Null
  • not-null.md
Primary Key
  • primary-key.md
Unique
  • unique.md

Functions and Operators

  • functions-and-operators.md

SQL Syntax

Keywords & Identifiers
  • keywords-and-identifiers.md
Constants
  • sql-constants.md
Selection Queries
  • selection-queries.md
Ordering Query Results
  • query-order.md
Limiting Query Results
  • limit-offset.md
Table Expressions
  • table-expressions.md
Common Table Expressions
  • common-table-expressions.md
Join Expressions
  • joins.md
Computed Columns
  • computed-columns.md
Scalar Expressions
  • scalar-expressions.md
Subqueries
  • subqueries.md
Name Resolution
  • sql-name-resolution.md
AS OF SYSTEM TIME
  • as-of-system-time.md
NULL Handling
  • null-handling.md
Full SQL Grammar
  • sql-grammar.md

Transactions

  • transactions.md

Views

  • views.md

Window Functions

  • window-functions.md

Performance Optimization

SQL Best Practices
  • performance-best-practices-overview.md
Indexes
  • indexes.md
Inverted Indexes
  • inverted-indexes.md
Column Families
  • column-families.md
Interleaved Tables
  • interleave-in-parent.md
Parallel Statement Execution
  • parallel-statement-execution.md
Cost-Based Optimizer
  • cost-based-optimizer.md

Information Schema

  • information-schema.md

Porting Applications

From PostgreSQL
  • porting-postgres.md

Experimental Features

  • experimental-features.md

CLI

Overview

cockroach start

  • start-a-node.md

cockroach init

  • initialize-a-cluster.md

cockroach cert

  • create-security-certificates.md
  • create-security-certificates-openssl.md

cockroach quit

  • stop-a-node.md

cockroach sql

  • use-the-built-in-sql-client.md

cockroach sqlfmt

cockroach user

  • create-and-manage-users.md *

cockroach node

  • view-node-details.md

cockroach dump

  • sql-dump.md

cockroach demo

  • cockroach-demo.md

cockroach debug zip

  • debug-zip.md

cockroach gen

  • generate-cockroachdb-resources.md

cockroach version

  • view-version-details.md

Cluster Settings

  • cluster-settings.md

Admin UI

Admin UI Overview

  • admin-ui-overview.md

Cluster Overview Page

  • admin-ui-cluster-overview-page.md

Overview Dashboard

  • admin-ui-overview-dashboard.md

Hardware Dashboard

  • admin-ui-hardware-dashboard.md

Runtime Dashboard

  • admin-ui-runtime-dashboard.md

SQL Dashboard

  • admin-ui-sql-dashboard.md

Storage Dashboard

  • admin-ui-storage-dashboard.md

Replication Dashboard

  • admin-ui-replication-dashboard.md

Databases Page

  • admin-ui-databases-page.md

Statements Page

  • admin-ui-statements-page.md

Jobs Page

  • admin-ui-jobs-page.md

Advanced Debugging Page

  • admin-ui-debug-pages.md

Custom Chart Debug Page

  • admin-ui-custom-chart-debug-page.md

CONCEPTS

Architecture

Overview

  • overview.md

SQL Layer

  • sql-layer.md

Transaction Layer

  • transaction-layer.md

Distribution Layer

  • distribution-layer.md

Replication Layer

  • replication-layer.md

Storage Layer

  • storage-layer.md

Features

Multi-Active Availability

  • multi-active-availability.md

Simplified Deployment

  • simplified-deployment.md

Strong Consistency

  • strong-consistency.md

SQL

  • sql.md

Distributed Transactions

  • distributed-transactions.md

Online Schema Changes

  • online-schema-changes.md

Automated Scaling & Repair

  • automated-scaling-and-repair.md

High Availability

  • high-availability.md

Open Source

  • open-source.md

Go Implementation

  • go-implementation.md

FAQS

Product FAQs

  • frequently-asked-questions.md

SQL FAQs

  • sql-faqs.md

Operational FAQs

  • operational-faqs.md

CockroachDB in Comparison

  • cockroachdb-in-comparison.md

RELEASES

v2.1.1

v2.1

v2.0.6

v2.0

v1.1.9

v1.1

All Production Releases

Testing Releases (Alphas & Betas)

Known Limitations

  • known-limitations.md

MANAGED COCKROACHDB

Get Started

Sign Up for the Service

  • managed-sign-up-for-a-cluster.md

Connect to Your Cluster

  • managed-connect-to-your-cluster.md

Learn CockroachDB SQL

Use the Admin UI

  • managed-use-the-admin-ui.md

Use Your Cluster

Migrate Data

Migration Overview

Migrate from Postgres

Migrate from MySQL

Migrate from CSV

Tune Performance

Manage Your Account

User Management

  • managed-user-management.md

Cluster Management

  • managed-cluster-management.md
Clone this wiki locally