Enabling a Read-Only Analysis Instance
ダウンロード
フォーカスモード
フォントサイズ
A read-only analysis instance is a columnar analytical read-only instance provided by TDSQL Boundless. It is designed to load data from the primary instance (read/write instance) on demand into an independent columnar read-only analytical engine, handle OLAP-type query workloads, and remain isolated from the transactional workloads of the primary instance. This document describes how to enable a read-only analysis instance under a primary instance.
Scenarios
When the primary instance handles core transactional (OLTP) workloads and the business also needs to execute complex analytical, aggregation, or reporting queries, you can enable a read-only analysis instance under the primary instance. After it is enabled, analytical queries are handled by an independent columnar engine. This avoids resource contention with transactional workloads and improves overall business stability and query performance.
Prerequisites
The TDSQL Boundless primary instance has been created. For details, see Creating a Provisioned Resource Instance.
The primary instance is in the Running state.
Binlog is enabled on the primary instance. For details, see Managing Binlog.
Use Limits
Currently, you can create a read-only analysis instance only within an existing instance. You cannot create one simultaneously when creating a new instance.
The region of the read-only analysis instance must be the same as that of the primary instance. Cross-region deployment is not supported.
The billing mode of the read-only analysis instance is linked to that of the primary instance.
Primary Instance Billing Mode | Optional Billing Mode for Read-Only Analysis Instance |
Yearly/monthly subscription | Yearly/monthly subscription, pay-as-you-go |
Pay-as-you-go | Pay-as-you-go |
Limitations
A read-only analysis instance uses independent computing and storage resources and is billed separately from the primary instance. Before enabling it, evaluate the analytical workload and budget of your business. For detailed billing rules, see Pricing Details.
Steps
Step 1: Go to the Read-Only Analysis Instance Purchase Page
1. Log in to the TDSQL Boundless console. In the Instance List, click the Instance ID of the target primary instance to go to the Instance Details page.
2. On the Instance Information tab, locate the Column Storage Information section and click Enable on the right side of Read-Only Analysis Engine. The system opens the purchase page for the TDSQL Boundless read-only analysis instance.
Step 2: Select Basic Configurations
On the Select Basic Configuration step of the purchase page, complete the selection of basic configuration items by referring to the following table.
Configuration Item | Description |
Billing Mode | Select the billing mode for the read-only analysis instance. Options include yearly/monthly subscription or pay-as-you-go. The specific available options are linked to the billing mode of the primary instance. For details, see Limits. |
Region | Select the region for the read-only analysis instance. Currently, it can only be deployed in the same region as the TDSQL Boundless read/write instance. |
Version | Select the kernel version for the read-only analysis instance. |
AZ | Select the AZ for the read-only analysis instance. It can be deployed in the same AZ as or a different AZ from the TDSQL Boundless instance. In cross-AZ access scenarios, leveraging the cross-AZ capability of VPC, the network latency is less than or equal to 100 ms. For specific available AZs, refer to the actual purchase page. |
Step 3: Select Specifications
In the specification configuration area, select the instance specification and disk capacity by referring to the following table.
Configuration Item | Description |
Instance Specifications | Select the instance specification for the read-only analysis instance. Different instance specifications provide different performance experiences. Since data analysis or complex SQL execution consumes significant computing resources, the instance specifications for the columnar read-only analysis engine are relatively large. Additionally, in high-concurrency data write scenarios, the columnar read-only analysis engine also consumes certain resources to ensure master-replica data consistency. Select the specification based on your actual business requirements. |
Disk Capacity | Since the read-only analysis instance does not currently use the shared storage of the TDSQL Boundless instance, you need to purchase disk space separately to store columnar data. Therefore, the disk space here needs to be selected separately and billed separately. The minimum hard disk specification is 100 GB, and the maximum hard disk specification is related to the selected instance specification. For details, refer to the actual purchase page. |
Number of Nodes | A read-only analysis instance supports a maximum of 6 nodes. |
Data Load Mode | Refers to the method by which the read-only analysis instance loads data from the corresponding TDSQL Boundless instance. All objects (default value): All data objects in the read-write instance are loaded into the read-only analysis instance. Objects that are not supported are skipped directly. Partial objects: Only selected objects are loaded into the read-only analysis instance. After you select partial objects, you must select the specific objects to load below. No objects: No objects are loaded. Only an empty read-only analysis instance is created. You must configure it later. |
After confirming that everything is correct, click Next: Set Network and Database.
Step 4: Configure Network and Database
On the Configure Network and Database step, complete the network and database configuration by referring to the following table.
Configuration Item | Description |
Network | The default VPC is the same as that of the read/write instance, and the subnet is an optional subnet in the specified AZ. It also supports being in a different VPC network from the read/write instance. |
Custom Port | Customize the access port for the read-only analysis instance. The default value is 3306. The valid range is 1024 to 65535. |
Tag | Optional. Adds Tags to the read-only analysis instance for resource categorization and management. Click Add to add multiple sets of Tags. Click Delete to remove added Tags. |
Instance Name | Select an instance naming method: Name It Later: Name the instance after it is created. Name It Now: Enter the instance name directly during the purchase phase. |
After confirming that everything is correct, click Next: Confirm Configuration.
Step 5: Confirm Configuration Information and Pay
On the Confirm Configuration Information step, verify all selected configuration items and the configuration cost. After confirming that everything is correct, click Buy Now. After the purchase is completed, return to the Instance List. When the status of the read-only analysis instance is displayed as running, it indicates that the instance has been successfully enabled and can normally handle analytical queries.
フィードバック