Updated on 2023-11-21 GMT+08:00

Getting Started with Common Practices

After purchasing and connecting to a GeminiDB Cassandra DB instance, you can view common practices to better use it.

Table 1 Common practices

Practice

Description

Database rules

Basic Design

Describes basic design specifications of GeminiDB Cassandra.

Database Objects

Describes rules of using database objects.

Database Usage

Describes constraints of using databases.

Queries

Describes rules of querying GeminiDB Cassandra.

Instance modifications

Changing an Instance Name

Describes how to change the name of a GeminiDB Cassandra instance to identify different instances.

Resetting the Administrator Password

Describes how to change your administrator password. For security reasons, change it periodically.

Changing vCPUs and Memory of an Instance

Describes how to change the CPU or memory of your instance to suit your service requirements.

Data backup

Managing Automated Backups

Describes how GeminiDB Cassandra API automatically creates backups for a DB instance during a backup window and saves the backups based on the configured retention period.

Managing Manual Backups

Describes how to create manual backups for a DB instance. These backups can be used to restore data for improved reliability.

Setting a Cross-Region Backup Policy

Describes how to set a cross-region backup policy for a DB instance. Then for disaster recovery, you can restore backups to a new instance in another region.

Creating a Table-level Backup

Describes how to create a table-level backup for a DB instance. If a database or table is deleted, maliciously or accidentally, backups can help restore your data.

Data restoration

Restoring Data to a New Instance

Describes how to restore an existing automated or manual backup to a new instance. The restored data is the same as the backup data.

Restoring a Backup to a Specific Point in Time

Describes how to use an automated backup to restore instance data to a specified point in time.

Log management

Slow Query Logs

Describes how to view slow query logs of a GeminiDB Cassandra database. The unit of the execution time is ms. You can identify the SQL statements that take a long time to execute and tune them based on slow query logs.