RDS MySQL

RDS MySQL on Reliance on Heaven releases technical dividends

On May 7, 2023, the prices of Alibaba Cloud Yaochi database RDS MySQL and RDS PostgreSQL all series of ARM architecture directories will be reduced by a maximum of 40%. Behind the adjustment of the product business strategy is the dividend release brought by the continuous software and hardware collaborative technology optimization

2023-05-30

Start free trial of RDS MySQL Serverless

RDS MySQL Serverless instance is a database launched by Alibaba Cloud for small and medium-sized enterprises or individual developers. It provides the real-time flexibility of CPU and memory, and the ability to charge computing resources on demand. It has the advantages of low resource consumption, simple use, flexibility and low price.

2023-05-12

RDS MySQL serverless evaluation

RDS MySQL Serverless can pay as you need, pay as you use, and dynamically match resources. It is very cost-effective if it is used in the short term. For example, it is convenient to buy the product temporarily to improve the performance dynamically if the database access has soared due to activities in a certain period of time

2023-05-14

Teach you how to migrate self built MySQL to RDS MySQL instance

Through this tutorial, you can learn to use DTS to migrate self built MySQL to RDS MySQL instance

2023-05-12

SQL Challenge, use RDS MySQL Serverless resources to tune SQL for free

Alibaba Cloud developer community and database team jointly held the "Alibaba Cloud Database SQL Challenge". Technical experts from Alibaba Cloud database team prepared three questions for developers from simple to deep. Come and see how good you are at writing SQL. In addition, we also provided developers with free RDS MySQL Serverless resources for three months, so that they can experience the convenience of cloud development while participating in the competition

2023-05-20

Can RDS MySQL prevent hacker intrusion?

RDS MySQL provides comprehensive and diversified security reinforcement functions in network communication, data storage, access control, security audit, instance disaster recovery and other dimensions. Hacker script intrusion can be completely intercepted by network communication security means, such as VPC, security group, white list, SSL encryption access and other schemes. At the same time, the TDE technology of data storage encryption can be enabled to prevent hackers from dragging databases through ciphertext data storage

What do you think is the most important characteristic of an excellent database?

1. An excellent database should have the following characteristics: reliability: ensure data security, prevent data loss or damage, and can be recovered. Scalability: It can handle a large amount of data and expand at any time to meet the growing business needs. Flexibility: It can support multiple data types and data structures. High performance: fast processing of a large number of data queries and inserts. Security: Protect the privacy and integrity of data through various security mechanisms. Ease of use: Simplify the tasks of data management and maintenance, and have friendly interfaces and operation methods. 2. RDS MySQL supports MySQL 5.5, 5.6, 5.7 and 8.0, has excellent performance and throughput, and provides a full range of solutions in disaster recovery, backup, recovery, monitoring, migration, etc. MySQL, based on MySQL and RDS, has more advanced functions, which can be used more flexibly for scenarios, and is relatively friendly in terms of price.

What do you know from reading "RDS MySQL from entry to advanced level"?

On the weekend, I read the book "RDS MySQL from Introduction to Advanced" in the community. Although it only has more than 60 pages, it is informative and step-by-step. It is a very practical popular science manual for developers who just access cloud database services. Let's talk about my understanding of RDS MySQL after reading this book. RDS MySQL encapsulates the deployment, operation and maintenance, elasticity, security and other features of MySQL, and provides a database instance externally. Compared with traditional self built databases, cloud database services are cost-effective, secure and reliable, enabling developers to focus on core business development. It has the following advantages. First of all, the availability and data reliability of AliCloud RDS services are as high as 99.9%. If a traditional self purchased server is used to build database services, developers need to be confident in building master-slave replication and self built RAID, which costs human and financial resources. The availability and reliability are far from cloud database services. Secondly, in terms of system security, Alibaba Cloud RDS has security protection functions such as anti DDos attacks and vulnerability repair. Traditional database services need to solve security problems such as vulnerabilities. In terms of database backup, RDS, by virtue of its "cloud" advantages, can achieve automatic backup without occupying local resources. Traditional database services need to back up themselves and regularly check whether the backup is available. In terms of system hosting, RDS does not have any hosting fees, while self built database services need to bear the cost of servers. In addition, RDS requires no operation and maintenance costs, while traditional database businesses also require full-time administrators to maintain. The last point is that RDS supports elastic capacity expansion and on-demand deployment, which can maximize the use of computing resources and effectively reduce the cost of enterprises. The flexibility of self built database services is not high. Due to the need to consider the peak situation, its utilization rate cannot reach 100% as the cloud database. Therefore, as a technical developer, it is necessary to understand RDS. This book mainly includes MySQL database infrastructure, SQL performance tuning, MySQL Group Replication and other core database technologies, which can help developers to start RDS MySQL database services in less time and improve their job competitiveness in enterprises~

Will RDS MySQL database report an error or update the same data if the primary key is inserted in conflict?

If a primary key conflict occurs when inserting data into the RDS MySQL database, the insertion operation will fail and an error will be returned. This is because the primary key is used to uniquely identify each row of data in each table. Therefore, data that already exists in the primary key cannot be inserted. Updating the same data is usually done using the UPDATE statement. If the primary key already exists, the INSERT operation will fail and the same data will not be updated. If you want to insert or update data, you can consider using INSERT INTO ON DUPLICATE KEY UPDATE statement, which will update data instead of inserting new data when a primary key conflict occurs, to ensure that the primary key remains unique.

Alibaba Cloud RDS MySQL prompts that DATEADD is not available. What related functions are available? thank you.

AliCloud RDS for MySQL is compatible with MySQL 5.5, MySQL 5.6, MySQL 5.7, and MySQL 8.0. It does not have the DATEADD function, but it also supports the DATE_ADD function supported by MySQL in the open source community

RDS MySQL from beginner to advanced

MySQL is the most mainstream open source database today. It has been recognized by a large number of users with its stability, security, flexibility, low cost and other advantages. It also has a wide audience in China. This manual focuses on the basic architecture of RDS MySQL database, SQL performance tuning, and advanced MySQL MGR features, so that you can have a preliminary understanding of MySQL database in a short time. At the same time, you will also have the opportunity to experience SQL diagnosis and tuning in the experimental environment, and easily access RDS MySQL database in seven days to complete technical growth and career breakthrough

Principle and Practice of MySQL Database for Enterprise Operation and Maintenance

MySQL is the world's most popular open source database, widely used in various application scenarios. This e-book is jointly produced by a number of after-sales technical service experts from Alibaba Cloud's expert service team to help you get started with enterprise operation and maintenance. Through this book, you can learn: database products/functions and O&M best practices, how to quickly connect to RDS MySQL, the intelligent elasticity of RDS MySQL in the promotion scenario, and troubleshooting of several common scenarios

Go deep into RDS MySQL practice

MySQL is the world's most popular open source database, widely used in various application scenarios. This e-book is jointly produced by Alibaba Cloud database engineers and a number of senior celebrities in the industry. It explains the application and practice of RDS MySQL in high concurrency scenarios such as Double 11 in detail, and helps you quickly understand the core technologies of RDS MySQL.

RDS MySQL Operation and Maintenance Manual

During database operation and maintenance, do you often find problems difficult to solve in MySQL? The Cloud Database Operation and Maintenance Practical Manual was jointly created by the AliCloud developer community and the AliCloud database team. It contains 25 strategies for solving common problems in data operation and maintenance, involving RDS MySQL, RDS PostgreSQL, Redis, and has interpretation of specific problems such as performance problems, patrol maintenance, and operation and maintenance practices. With one in hand, there is no need to worry about cloud data operation and maintenance problems!