tencent cloud

Feedback

Alarm Upgrade

Last updated: 2021-08-12 11:00:35

    Background

    TDSQL for MySQL upgraded the monitoring items for server and component services on April 1, 2021 by replacing the legacy alarm policy type and modifying hundreds of monitoring and alarm metrics. You can configure alarm policies of the TDSQL for MySQL type in the Cloud Monitor console.
    The legacy TDSQL policy type was deactivated on July 29, 2021. You cannot configure new alarm policies in this type any more, and your previously configured TDSQL alarm polices will be gradually transferred to the new policy type.
    Comparison of the legacy and new alarm policy types:
    Policy Type
    Metric Coverage
    Support and Maintenance
    Tencent Distributed SQL
    8 metrics
    This policy type was deactivated on July 29, 2021 and cannot be configured subsequently. All legacy alarm policies will be transferred to the new policy type.
    Cloud Database - TDSQL MySQL - Instance
    37 metrics
    This policy type was released on April 1, 2021 with ongoing maintenance available.
    Note:
    The new TDSQL for MySQL policy type has covered all metrics of the legacy TDSQL policy type. For more information, please see Comparison Table of New and Legacy Metrics.
    For the new alarm policies, please see New Metric Description.

    Alarm Policy Migration

    After the legacy TDSQL policy type is deactivated, the system will automatically transfer previously configured alarm policies to the new TDSQL for MySQL policy type on the backend.
    Note:
    Alarms may not be automatically transferred to the new alarm policy type by the system for certain instances or users. If this is the case for you, we will notify you through Message Center, email, or SMS. Then, please follow the manual transfer steps below to manually transfer the alarms.

    Manual transfer steps

    1. Sort out exiting alarm metrics and policies.
    1. Log in to the Cloud Monitor console, select Alarm Configuration > Alarm Policy on the left sidebar, and click Advanced Filter.
    2. On the pop-up page, select the alarm policy type corresponding to Tencent Distributed SQL in Policy Type, query alarm policies in this category, and download the previously configured alarm policies of the original Tencent Distributed SQL policy type.
    
    
    3. Configure new alarm policies.
    1. On the Alarm Policy page, click Create.
    2. On the Create Alarm Policy page, select Cloud Database - TDSQL MySQL - Instance for Policy Type and configure alarms according to the policies downloaded in step 1. For the alarm configuration method, please see Creating Alarm Policy.
    3. Verify whether the TDSQL for MySQL alarm policies are enabled and can successfully trigger alarms. Set a minimum trigger threshold in Metric alarm on the Create Alarm Policy page, choose to set a recipient or recipient group, and select the notification channel (email or SMS) to test a policy. For example, you can configure an alarm policy for the CPU utilization metric that triggers an alarm once per minute when the threshold is greater than or equal to 1% for one statistical period of one minute.
    4. After the new policy type is verified, delete the alarm policies previously configured under the original TDSQL (legacy) policy type. On the Alarm Policy page, filter alarm policies by the "Tencent Distributed SQL" policy type and delete the filtered policies according to the policy list downloaded in step 1. If you encounter any issues during the transfer, please submit a ticket for assistance.
    Comparison Table of New and Legacy Metrics
    Legacy Policy Type
    Metric/Event Alarm
    Legacy Metric/Event Alarm Name
    New Policy Type
    New Metric/Event Alarm Name
    Tencent Distributed SQL
    Metric alarm
    CPU utilization
    Cloud Database - TDSQL MySQL - Instance
    Maximum CPU utilization of source node
    Metric alarm
    Storage space utilization
    Cloud Database - TDSQL MySQL - Instance
    Maximum data disk utilization of source node
    Metric alarm
    Slow queries
    Cloud Database - TDSQL MySQL - Instance
    Total slow queries of source nodes
    Metric alarm
    Active connections
    Cloud Database - TDSQL MySQL - Instance
    Total active threads
    Metric alarm
    Cache hit rate
    Cloud Database - TDSQL MySQL - Instance
    Minimum cache hit rate of source node
    Metric alarm
    Database connections
    Cloud Database - TDSQL MySQL - Instance
    Total client connections
    Metric alarm
    Replica lag
    Cloud Database - TDSQL MySQL - Instance
    Secondary node delay
    Metric alarm
    Primary-Secondary switch
    Cloud Database - TDSQL MySQL - Instance
    Primary-Secondary switches

    New Metric Description

    Policy Type
    Metric/Event Alarm
    Metric/Event Alarm Name
    Cloud Database - TDSQL MySQL
    Metric alarm
    CPU utilization
    Metric alarm
    Total UPDATE requests of source nodes
    Metric alarm
    Total open connections
    Metric alarm
    Total maximum connections
    Metric alarm
    SQL Throughput
    Metric alarm
    SQL Error Throughput
    Metric alarm
    SQL Success Throughput
    Metric alarm
    Requests consuming less than 5 ms
    Metric alarm
    Requests consuming 5–20 ms
    Metric alarm
    Requests consuming 21–30 ms
    Metric alarm
    Requests consuming more than 30 ms
    Metric alarm
    Minimum remaining binlog disk space in all shards
    Metric alarm
    Total binlog disk space of source nodes
    Metric alarm
    Maximum database connection utilization
    Metric alarm
    Total available data disk space of source nodes
    Metric alarm
    Total DELETE requests of source nodes
    Metric alarm
    Maximum IO utilization of source node
    Metric alarm
    Total logical reads from InnoDB disk
    Metric alarm
    Total pages read into InnoDB buffer pool by read-ahead thread
    Metric alarm
    Total logical reads from InnoDB buffer pool
    Metric alarm
    Total rows deleted from InnoDB tables on source nodes
    Metric alarm
    Total rows inserted to InnoDB tables on source nodes
    Metric alarm
    Total rows read from InnoDB tables
    Metric alarm
    Total rows updated in InnoDB tables on source nodes
    Metric alarm
    Total INSERT requests of source nodes
    Metric alarm
    Total available cache of source nodes
    Metric alarm
    Total REPLACE_SELECT requests of source nodes
    Metric alarm
    Total REPLACE requests of source nodes
    Metric alarm
    Total requests of source and replica nodes
    Metric alarm
    Total SELECT requests
    
    Contact Us

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

    Technical Support

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

    7x24 Phone Support