Alauda Database Service for MySQL-MGR

Install

TOC

Installing Alauda Container Platform Data Services Essentials

Optional Installation

The plugin serves as a foundational component for Alauda Data Services web console. It is not necessary to install it if the web console is not required.

Prerequisites

  1. Download Alauda Container Platform Data Services Essentials installation package that matches the platform.
  2. Use the platform's application publishing capability to publish Alauda Container Platform Data Services Essentials to the global cluster.

Procedure

Web Console
  1. In the left navigation bar, go to Marketplace > Cluster Plugins.
  2. Select the global cluster.
  3. Click the action button next to Alauda Container Platform Data Services Essentials plugin > Install.

Installing Alauda Container Platform Data Services RDS Framework

Optional Installation

The plugin serves as a foundational component for Alauda Data Services web console. It is not necessary to install it if the web console is not required.

Prerequisites

  1. Download Alauda Container Platform Data Services RDS Framework installation package that matches the platform.
  2. Use the platform's application publishing capability to publish Alauda Container Platform Data Services RDS Framework to any cluster where Data Services view are desired.

Procedure

Web Console
  1. Log in to the platform and navigate to the Administrator page.
  2. In the left navigation bar, select Marketplace -> OperatorHub to enter the OperatorHub page.
  3. Find Alauda Container Platform Data Services RDS Framework, click Install to access the installation page.

Configuration Parameters:

ParameterRecommended Configuration
ChannelThe default Channel is stable.
VersionSelect the desired version to install.
Installation ModeCluster: All namespaces under the cluster share one Operator for creating and managing instances, resulting in lower resource usage.
Installation LocationChoose the Recommended: If none exists, it will be created automatically.
Upgrade StrategyManual: When a new version is available in the OperatorHub, manual confirmation is required to upgrade the Operator to the latest version.
  1. On the Install Operator page, select Default Configuration, then click Install to complete the installation of Alauda Container Platform Data Services RDS Framework.

Installing Alauda Container Platform Data Services Query Analytics

Optional Installation

The plugin serves as a foundational component for query analytics capabilities. It is not necessary to install it if query performance monitoring and analysis are not required.

Prerequisites

  1. Install the ClickHouse plugin from the Operator Hub in the Marketplace first.
  2. Download Alauda Container Platform Data Services Query Analytics installation package that matches the platform.
  3. Use the platform's application publishing capability to publish Alauda Container Platform Data Services Query Analytics to any cluster where Application Services graphical capabilities are desired.

Procedure

Web Console
  1. Log in to the platform and navigate to the Platform Management page.
  2. In the left navigation bar, select Marketplace -> Operator Hub to enter the Operator Hub page.
  3. Find Alauda Container Platform Data Services Query Analytics, click Install to access the installation page.

Configuration Parameters:

ParameterRecommended Configuration
ChannelThe default Channel is stable.
VersionSelect the desired version to install.
Installation ModeCluster: All namespaces under the cluster share one Operator for creating and managing instances, resulting in lower resource usage.
Installation LocationChoose the Recommended: If none exists, it will be created automatically.
Upgrade StrategyManual: When a new version is available in the Operator Hub, manual confirmation is required to upgrade the Operator to the latest version.
  1. On the Install Operator page, select Default Configuration, then click Install to complete the installation of Alauda Container Platform Data Services Query Analytics.

Installing Alauda Container Platform Data Services Query Analytics

Optional Installation

The plugin serves as a foundational component for query analytics capabilities. It is not necessary to install it if query performance monitoring and analysis are not required.

Prerequisites

  1. Download Alauda Container Platform Data Services Query Analytics installation package that matches the platform.
  2. Use the platform's application publishing capability to publish Alauda Container Platform Data Services Query Analytics to any cluster where Application Services graphical capabilities are desired.

Procedure

Web Console
  1. Log in to the platform and navigate to the Platform Management page.
  2. In the left navigation bar, select Marketplace -> Operator Hub to enter the Operator Hub page.
  3. Find Alauda Container Platform Data Services Query Analytics, click Install to access the installation page.

Configuration Parameters:

ParameterRecommended Configuration
ChannelThe default Channel is stable.
VersionSelect the desired version to install.
Installation ModeCluster: All namespaces under the cluster share one Operator for creating and managing instances, resulting in lower resource usage.
Installation LocationChoose the Recommended: If none exists, it will be created automatically.
Upgrade StrategyManual: When a new version is available in the Operator Hub, manual confirmation is required to upgrade the Operator to the latest version.
  1. On the Install Operator page, select Default Configuration, then click Install to complete the installation of Alauda Container Platform Data Services Query Analytics.
Storage Configuration

The Query Analytics plugin defaults to hostPath storage at /cpaas/ck. If this path doesn't exist (commonly changed to /var/cpaas), follow these steps:

  1. Edit the QueryAnalyticsInstaller (qai) resource
  2. Configure slowSQL.storageClassName with your system's storage class Example configuration:
kind: QueryAnalyticsInstaller
metadata:
  name: qai
  resourceVersion: "4145608"
spec:
  slowSQL:
    GRPCPort: "9922"
    HTTPPort: "9911"
    clickhouse:
      clickhouseImage: 192.168.128.24/middleware/clickhouse-server:v24.8.3.59-64c1f43f
      resources:
        limits:
          cpu: "1"
          memory: 2Gi
        requests:
          cpu: "1"
          memory: 2Gi
    dataCleanCorn: 0 0 18 * * ?
    dataKeepDays: "15"
    name: pxc-ck
    namespace: cpaas-system
    server:
      image: 192.168.128.24/middleware/slowsql:2926e899
    storageClassName: mid-topolvmsc
  1. Delete existing pods and PVCs for changes to apply:
kubectl -n cpaas-system delete pvc -l clickhouse.altinity.com/cluster=slowsql-cluster &
kubectl -n cpaas-system delete pod -l clickhouse.altinity.com/cluster=slowsql-cluster

Installing Alauda Database for MySQL-MGR

Prerequisites

  1. Download the plugin installation package that matches the platform.
  2. Use the platform's application publishing capability to publish the plugin to any cluster where Alauda Database for MySQL-MGR capabilities are desired.

Procedure

Web Console
  1. Log in to the platform and navigate to the Administrator page.
  2. In the left navigation bar, select Marketplace -> OperatorHub to enter the OperatorHub page.
  3. Find Alauda Database Service for MySQL, click Install to access the installation page.

Configuration Parameters:

ParameterRecommended Configuration
ChannelThe default Channel is alpha.
VersionSelect the desired version to install.
Installation ModeCluster: All namespaces under the cluster share one Operator for creating and managing instances, resulting in lower resource usage.
Installation LocationChoose the Recommended: If none exists, it will be created automatically.
Upgrade StrategyManual: When a new version is available in the OperatorHub, manual confirmation is required to upgrade the Operator to the latest version.
  1. On the Install Operator page, select Default Configuration, then click Install to complete the installation.