This document introduces how to load data into the read-only analysis engine for data analysis and queries by users.
Note:
Currently, only databases, tables, and views can be loaded into the read-only analysis engine.
Prerequisites
You have prepared a cluster in the provisioned resource instance mode. See Creating Cluster. The cluster is in the running status.
Directions
The read-only analysis engine currently supports multiple data loading methods. Detailed operation methods are as follows.
Method 1: Loading Data During Creation of a Read-Only Analysis Engine
During creation of a read-only analysis engine instance, you can select a data loading method. Currently, there are three options: Full load, Partial objects, and No objects. The three different data loading methods correspond to different loading schemes.
1. The data loading method is full load.
In the full load mode, all database tables of the TDSQL-C for MySQL cluster will be automatically synchronized to the read-only analysis engine. Since some database table objects may not meet the loading conditions, these unsupported objects will be automatically ignored and not loaded into the read-only analysis engine.
2. Partial objects data loading method.
If the data loading method is selected as partial objects, you need to specify the objects to be loaded into the analysis engine during creation of a read-only analysis engine instance. If there are objects that do not meet the loading conditions, they will be ignored. If a table referenced by a view has not been loaded into the read-only analysis engine, an error will be reported that the table does not exist when the view is loaded.
3. No objects data loading method.
If the data loading method is selected as no objects, it means that no objects will be loaded during creation of a read-only analysis engine instance. Users need to manually specify the objects to be loaded when the instance is running. See Method 2: Manual Loading. Method 2: Manual Loading
If the no objects method is selected during creation of a read-only analysis engine instance, or if you need to modify the object information loaded into the read-only analysis engine, you can use the following method.
Loading Objects in the Console
1. Log in to the TDSQL-C MySQL console and click the target cluster in the cluster list on the left to enter the cluster management page. 2. On the cluster details page, locate the read-only analysis engine instance for which you need to modify the loaded objects, and then click Details to enter the details page of the read-only analysis engine instance.
3. Click Modify Object. In the object modification dialog box, check or uncheck the objects to be loaded into the read-only analysis engine.