Background
MySQL is a widely used database management system. The maximum number of connections in the database directly impacts system performance and stability. If the maximum number of connections in MySQL is improperly set, the database may be unable to handle a large number of concurrent requests, therefore, the normal operation of the business is affected.
To improve database service reliability and stability, a fault experiment on the maximum number of connection is required. Through experiments, the system can be verified to see if it can operate normally under improper maximum connection settings, allowing for quick and effective fault resolution.
Note: For MySQL instance creation and connection, see the following documents.
Experiment Implementation
Step 1: Experiment Preparation
A MySQL instance available for experiment
A CVM instance (used only for connecting database example. You can use other means of connection.)
Step 2: Experiment Orchestration
1. Check parameter configuration max_connections for number of connections in MySQL instance first, and pay attention to the initial value.
3. Click Skip and create a blank experiment. Fill in the experiment information and add a ready MySQL instance.
4. Click Add Now, and select Network Resources.
5. Select Set maximum connections, and then click Next.
6. Configure fault action parameters, and click Confirm.
7. After action parameter configuration, click Next. Configure Guardrail Policy and Monitoring Metrics considering actual situations, and click Submit to complete experiment creation.
Step 3: Experiment Execution
1. Go to experiment details, and click Go to the action group for execution.
2. Click Execute to start an experiment.
3. Click the Action Card, and check details of action execution.
4. Check instance execution logs and confirm a successful execution.
5. Check the effects after the execution of the failure action, check max_connections parameter of MySQL instance, and you will find that a change has taken place.
6. Execute a recovery action, and check the execution logs of the recovery action.
7. Check the result after recovery. Check max_connections parameter of MySQL instance, and you will find that the parameter has been reset to the initial value.