tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TDSQL-C for MySQL
    Documentation
    Download PDF

    Loading Data into the Read-Only Analysis Engine

    Last updated: 2024-12-13 17:50:12
    Download PDF
      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: all objects, partial objects, and no objects. The three different data loading methods correspond to different loading schemes.
      1. All objects data loading method
      In all objects 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.
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy