- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Release of New Upgrade Mechanism for Kernel Minor Version
- Announcement on Optimization of Instance Storage Capacity, IOPS, and I/O Bandwidth
- Announcement on Some APIs with CAM Authentication Integrated
- Announcement on Sales Suspension of Some General Specifications
- Announcement on Some APIs Integrated with CAM Authentication
- Announcement on Some APIs with CAM Authentication Integrated
- Announcement on Change of Part of Parameters
- Announcement on Update of Database Audit Feature
- Announcement on Authentication of a Newly Added API Interface of Database Audit
- Announcement on Change of Public Network Linkage
- TDSQL-C for MySQL Audit Service Update
- Announcement on Supplementary Charge for Clusters with Pay-as-You-Go Storage Billing Mode
- Announcement on New APIs Integrated with CAM Permissions
- Announcement on the Release of New Version of Database Proxy
- Emergency Fix for Certain Monitoring Metrics
- Monitoring Metric Optimization
- Change to Database Audit Resource ID
- Ops Change
- Storage Price Adjustment Notification
- Beginner's Guide
- Product Introduction
- Kernel Features
- Kernel Overview
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Columns Syntax
- Correlated Subquery Result Cache
- Global Index
- Binlog Write Optimization
- Large Transaction Binlog Optimization
- Binlog Purging Performance Optimization
- Optimization of Plan Caching Point Query
- Auto-Increment Column Persistence
- Invisible Index
- Computation Pushdown
- Parallel Initialization of InnoDB Buffer Pool
- Security Features
- Stability Feature
- Purchase Guide
- Getting Started
- Database Audit
- Serverless Service
- Operation Guide
- Switching Cluster Page View in Console
- Database Connection
- Instance Management
- Configuration Adjustment
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Overview
- Use Limits
- Database Proxy Kernel Features
- Managing Database Proxy
- Enabling Database Proxy
- Setting Database Proxy Address
- Modifying or Deleting Connection Addresses
- Viewing and Changing the Access Policy
- Rebalancing the Load
- Transaction Split Feature
- Access Mode
- Adjusting Database Proxy Configuration
- Switching Database Proxy Network
- Viewing Database Proxy Monitoring Data
- Disabling Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Operation Log
- Data Migration
- Parallel Query
- Database Security and Encryption
- Monitoring and Alarms
- Basic SQL Operations
- Connecting to TDSQL-C for MySQL Through SCF
- Tag
- Practical Tutorial
- Classified Protection Practice for Database Audit of TDSQL-C for MySQL
- Upgrading Database Version from MySQL 5.7 to 8.0 Through DTS
- Usage Instructions for TDSQL-C MySQL
- New Version of Console
- Implementing Multiple RO Groups with Multiple Database Proxy Connection Addresses
- Strengths of Database Proxy
- Selecting Billing Mode for Storage Space
- Creating Remote Disaster Recovery by DTS
- Creating VPC for Cluster
- Data Rollback
- Solution to High CPU Utilization
- How to Authorize Sub-Users to View Monitoring Data
- White Paper
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Billing APIs
- Instance APIs
- CloseClusterPasswordComplexity
- CopyClusterPasswordComplexity
- DescribeClusterDetail
- DescribeClusterPasswordComplexity
- ModifyClusterPasswordComplexity
- OpenClusterPasswordComplexity
- UpgradeClusterVersion
- UpgradeInstance
- SetRenewFlag
- OfflineCluster
- ModifyMaintainPeriodConfig
- IsolateInstance
- IsolateCluster
- DescribeMaintainPeriod
- DescribeInstanceSpecs
- DescribeClusters
- CreateClusters
- AddInstances
- OfflineInstance
- DescribeInstanceDetail
- DescribeClusterInstanceGrps
- DescribeInstances
- ActivateInstance
- ModifyInstanceName
- ModifyClusterName
- SearchClusterTables
- SearchClusterDatabases
- RestartInstance
- Multi-AZ APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- CloseWan
- CreateClusterDatabase
- DeleteClusterDatabase
- DescribeClusterDetailDatabases
- ModifyClusterDatabase
- OpenWan
- SwitchClusterVpc
- OpenReadOnlyInstanceExclusiveAccess
- OpenClusterReadOnlyInstanceGroupAccess
- ModifyDBInstanceSecurityGroups
- DescribeProjectSecurityGroups
- DescribeDBSecurityGroups
- SwitchProxyVpc
- DescribeFlow
- DescribeZones
- ModifyVipVport
- Data Types
- Error Codes
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
- Glossary
- Contact Us
- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Release of New Upgrade Mechanism for Kernel Minor Version
- Announcement on Optimization of Instance Storage Capacity, IOPS, and I/O Bandwidth
- Announcement on Some APIs with CAM Authentication Integrated
- Announcement on Sales Suspension of Some General Specifications
- Announcement on Some APIs Integrated with CAM Authentication
- Announcement on Some APIs with CAM Authentication Integrated
- Announcement on Change of Part of Parameters
- Announcement on Update of Database Audit Feature
- Announcement on Authentication of a Newly Added API Interface of Database Audit
- Announcement on Change of Public Network Linkage
- TDSQL-C for MySQL Audit Service Update
- Announcement on Supplementary Charge for Clusters with Pay-as-You-Go Storage Billing Mode
- Announcement on New APIs Integrated with CAM Permissions
- Announcement on the Release of New Version of Database Proxy
- Emergency Fix for Certain Monitoring Metrics
- Monitoring Metric Optimization
- Change to Database Audit Resource ID
- Ops Change
- Storage Price Adjustment Notification
- Beginner's Guide
- Product Introduction
- Kernel Features
- Kernel Overview
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Columns Syntax
- Correlated Subquery Result Cache
- Global Index
- Binlog Write Optimization
- Large Transaction Binlog Optimization
- Binlog Purging Performance Optimization
- Optimization of Plan Caching Point Query
- Auto-Increment Column Persistence
- Invisible Index
- Computation Pushdown
- Parallel Initialization of InnoDB Buffer Pool
- Security Features
- Stability Feature
- Purchase Guide
- Getting Started
- Database Audit
- Serverless Service
- Operation Guide
- Switching Cluster Page View in Console
- Database Connection
- Instance Management
- Configuration Adjustment
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Overview
- Use Limits
- Database Proxy Kernel Features
- Managing Database Proxy
- Enabling Database Proxy
- Setting Database Proxy Address
- Modifying or Deleting Connection Addresses
- Viewing and Changing the Access Policy
- Rebalancing the Load
- Transaction Split Feature
- Access Mode
- Adjusting Database Proxy Configuration
- Switching Database Proxy Network
- Viewing Database Proxy Monitoring Data
- Disabling Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Operation Log
- Data Migration
- Parallel Query
- Database Security and Encryption
- Monitoring and Alarms
- Basic SQL Operations
- Connecting to TDSQL-C for MySQL Through SCF
- Tag
- Practical Tutorial
- Classified Protection Practice for Database Audit of TDSQL-C for MySQL
- Upgrading Database Version from MySQL 5.7 to 8.0 Through DTS
- Usage Instructions for TDSQL-C MySQL
- New Version of Console
- Implementing Multiple RO Groups with Multiple Database Proxy Connection Addresses
- Strengths of Database Proxy
- Selecting Billing Mode for Storage Space
- Creating Remote Disaster Recovery by DTS
- Creating VPC for Cluster
- Data Rollback
- Solution to High CPU Utilization
- How to Authorize Sub-Users to View Monitoring Data
- White Paper
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Billing APIs
- Instance APIs
- CloseClusterPasswordComplexity
- CopyClusterPasswordComplexity
- DescribeClusterDetail
- DescribeClusterPasswordComplexity
- ModifyClusterPasswordComplexity
- OpenClusterPasswordComplexity
- UpgradeClusterVersion
- UpgradeInstance
- SetRenewFlag
- OfflineCluster
- ModifyMaintainPeriodConfig
- IsolateInstance
- IsolateCluster
- DescribeMaintainPeriod
- DescribeInstanceSpecs
- DescribeClusters
- CreateClusters
- AddInstances
- OfflineInstance
- DescribeInstanceDetail
- DescribeClusterInstanceGrps
- DescribeInstances
- ActivateInstance
- ModifyInstanceName
- ModifyClusterName
- SearchClusterTables
- SearchClusterDatabases
- RestartInstance
- Multi-AZ APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- CloseWan
- CreateClusterDatabase
- DeleteClusterDatabase
- DescribeClusterDetailDatabases
- ModifyClusterDatabase
- OpenWan
- SwitchClusterVpc
- OpenReadOnlyInstanceExclusiveAccess
- OpenClusterReadOnlyInstanceGroupAccess
- ModifyDBInstanceSecurityGroups
- DescribeProjectSecurityGroups
- DescribeDBSecurityGroups
- SwitchProxyVpc
- DescribeFlow
- DescribeZones
- ModifyVipVport
- Data Types
- Error Codes
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
- Glossary
- Contact Us
You can adjust the specification and node count of the database proxy in the console.
Prerequisite
Notes
The database proxy will be automatically upgraded to the latest version during configuration adjustment if its version is old.
If the selected database proxy does not reside in the same availability zone with the primary instance, a potential decline in write performance may be observed during the connection via the database proxy.
If the required number of proxy nodes exceed the purchase limit upon calculation, it is advisable to choose a higher specification proxy.
When the proxy specification is 2 cores and 4000MB of memory, the recommended number of proxies is 1/8th (rounded up) of the sum of the CPU core numbers of the main instance and the read-only instance.
When the proxy specification is 4 cores and 8000MB of memory, the recommended number of proxies is 1/16th (rounded up) of the sum of the CPU core numbers of the main instance and the read-only instance.
When the proxy specification is 8 cores and 16000MB of memory, the recommended number of proxies is 1/32 (rounded up) of the sum of the CPU core numbers of the main instance and the read-only instance.
Impact Description
Changing different configuration items has different impacts, certain modifications will not result in connection interruptions, while others may cause such disruptions. The specific changeable items and their corresponding impacts are detailed in the following table.
Scenario One: Changed Proxy Specification and Unchanged Availability Zone and Node Count
Proxy Specification | Availability Zone | Number of Nodes | Switch Time | Impact |
Upgrade or downgrade | Unchanged | Unchanged | During the maintenance period | There may be momentary interruptions. Please ensure your operations are equipped with a reconnection mechanism. |
| | | | Upon completion of the upgrade |
Scenario Two: Changed Node Count and Unchanged Proxy Specification and Availability Zone
Proxy Specification | Availability Zone | Number of Nodes | Load Balancing Method | Switch Time | Impact |
Unchanged | Unchanged | Raised | Automatic | During the maintenance period | There may be momentary interruptions. Please ensure your operations are equipped with a reconnection mechanism. |
| | | | | Upon completion of the upgrade |
| | | Manual | During the maintenance period | It will not result in intermittent interruptions. |
| | | | | Upon completion of the upgrade |
| | Reduced | Automatic | During the maintenance period | Momentary interruptions may occur. Please ensure your operations are equipped with a reconnection mechanism. |
| | | | | Upon completion of the upgrade |
| | | | Manual | During the maintenance period |
| | | | | Upon completion of the upgrade |
Scenario Three: Unchanged Proxy Specification and Availability Zone and Node Count Combination Changed
Proxy Specification | Availability Zone | Number of Nodes | Load Balancing Method | Switch Time | Impact |
Unchanged | Raised | Raised | Automatic | During the maintenance period | There may be momentary interruptions. Please ensure your operations are equipped with a reconnection mechanism. |
| | | | | Upon completion of the upgrade |
| | | Manual | During the maintenance period | It will not result in intermittent interruptions. |
| | | | | Upon completion of the upgrade |
| | Reduced | Automatic | During the maintenance period | Momentary interruptions may occur. Please ensure your business is equipped with a reconnection mechanism. |
| | | | | Upon completion of the upgrade |
| | | | Manual | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | Reduced | Raised | Automatic | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | | | Manual | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | | Reduced | Automatic | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | | | Manual | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | Changed | Raised | Automatic | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | | | Manual | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | | Reduced | Automatic | During the maintenance period |
| | | | | Upon completion of the upgrade |
| | | | Manual | During the maintenance period |
| | | | | Upon completion of the upgrade |
Directions
1. Log in to the TDSQL-C for MySQL console. In the cluster list, select the cluster with the proxy enabled, click on the cluster ID, and proceed to the cluster management page.
2. Navigate to the Cluster Management page > Cluster Details > Database Proxy, and click Details, or directly select the Database Proxy tab on the Cluster Management page to access the Database Proxy Management page.
3. On the Overview tab on the Database Proxy tab, Click Adjust Configuration after Basic Information > Number of Nodes. The output content is in markdown format.
4. In the pop-up window, modify the relevant configurations of the database proxy (proxy specification, availability zone, and number of nodes) as needed, then click Confirm.
5. In Basic Info on the Database Proxy tab, after the task status changes from Upgrading to Running/Waiting to upgrade, the configuration adjustment is completed.
Note:
If you select Upon upgrade completion, after the configuration is adjusted, the system will automatically switch to the new configuration.
If you select During maintenance time, after the configuration is adjusted, the system will switch the configuration during the specified maintenance time period.
If you select During maintenance time but need to switch the configuration earlier due to your business requirements, after the configuration is adjusted, you can go to Database Proxy > Overview > Basic Info > Status/Task and click Execute now next to Running/Waiting to upgrade.
If the CLB resettings are performed manually after configuration adjustment, once the configuration adjustment is complete, one can manually perform CLB resettings under the corresponding Overview > Connection Address on the database proxy page.
Yes
No
Was this page helpful?