Using Cloud SQL for MySQL
For a variety of applications, Cloud SQL for MySQL provides enterprises with the dependable performance, scalability, and dependability they want. Businesses like Nest and Chess.com are already using Cloud SQL for MySQL to power smart home devices and manage complicated game data. This robust foundation for data-driven solutions drives innovation and improves user experiences. Organizations are trying to use AI for their business objectives while utilizing the database that already supports their apps due to the increasing need for AI capabilities.
Google recently announced a number of new capabilities for Cloud SQL for MySQL, which is now available in preview and helps businesses use AI to power their databases and applications, in an effort to help them change their businesses. In order to aid you in creating cutting-edge generative AI apps and AI-assisted tools that streamline database administration and boost performance with Gemini, Google cloud now provide integrated support for vector embedding search. Now let’s explore these recent additions!
Create generative AI apps with Vector Search and connect them to MySQL Cloud
Now that vector embeddings can be stored and searched for similarity in SQL for MySQL, you may include generative AI into your current applications. With the MySQL engine, it now offers approximate-nearest-neighbor (ANN) and K-nearest-neighbor (KNN) search between embeddings.
Integrating LangChain to produce vector embeddings
Artificial intelligence systems can interact with your data more meaningfully if it is embedded as vectors. Complexities are preserved while information is maintained effectively when embedded as vectors. This allows AI programmes to compare distinct facts in an organized manner in order to identify commonalities.
A well-liked open-source framework for creating applications with large language models (LLMs) is called LangChain. In order to facilitate the data processing required to create vector embeddings and link it to your MySQL instance, the Cloud SQL team developed the Vector LangChain package. A vector storage, document loader, and chat message history are provided by the integration.
Google cloud offer an end-to-end example that shows how to create embeddings of data, like chat histories or huge documents, store the embeddings in MySQL, and search them, as well as a guide on using vector embeddings in MySQL with LangChain.
Use Vector Search to power generative AI applications
Once your embedded data is saved on Cloud SQL for MySQL, you can calculate the vector distance between two embeddings to see how similar they are to one another. The computation of vector distances grows computationally costly and ultimately unfeasible as dimensions and data volume rise. When calculating the absolute distance is not an option, approximate-nearest-neighbor (ANN) search is used to find related vectors in a scalable, accurate manner.
Furthermore, Cloud SQL now uses Google’s ScaNN framework to power built-in ANN search of vector embeddings in MySQL as well as storage. Building generative AI applications becomes simpler as a result of the removal of the requirement for a separate vector-store database when using Cloud SQL for MySQL for data management.
Gemini for MySQL database management, debugging, and optimization
Gemini can now be accessed at any point along the database trip. With Gemini in Databases, you can handle your database fleet’s whole lifespan, from migration to establishing the proper security and compliance measures to debugging performance problems. With a collection of MySQL-specific features, Cloud SQL for MySQL enables you to track and evaluate database-specific performance and identify issues before they have an influence on your applications.
Use Index Advisor to improve query efficiency
AI-recommended indexes can help you optimize your MySQL workloads as well. Within the Query Insights dashboard, Index Advisor finds queries that add to database inefficiencies and suggests new indexes to make them more efficient. Index Advisor assists in detecting suboptimal queries and helping you detect performance problems before they have a detrimental effect on your company.
Index Advisor analyses your workload and suggests columns to add indexes to, along with an estimate of the index storage size and performance impact, to help you expedite your slow queries. It provides the precise queries required to build the suggested index, making the optimisation process more easier. Enable Index Advisor’s flag and check your query insights to get started.
Troubleshoot and avoid performance problems with Active Queries
Real-time analysis of the ongoing queries on your instance is now available through the Query Insights panel. It offers a detailed analysis of the most popular queries that are presently executing on your database, along with an overview of the status of every connection. This report contains metrics, like the number of locked rows and transaction length, that are helpful in identifying expensive transactions. Active Query’s analysis helps you save time and effort troubleshooting by making clear which queries are running and how much they are costing.
You can end connections or inquiries as necessary in addition to performing active query analysis. The task of locating costly transactions and ending them in one easy move is streamlined by a centralised dashboard. With the query management capabilities that Active Queries brought, you can quickly pinpoint the cause of performance problems and see a high-level overview of your instance’s traffic to foresee future issues.
Use MySQL Recommender to track and enhance database health
Keeping your MySQL instance’s parameters and flags at their ideal levels can be difficult, as there are many options to choose from. The challenge increases when there is a fluctuation in database traffic, leading to ever-changing database requirements. MySQL Recommender suggests adjusting configuration settings to boost security, safeguard data, and enhance speed. When appropriate, it also offers an explanation of its suggestion and other ways to maintain the instance’s health.
MySQL Recommender functions as a Gemini-powered MySQL expert by keeping an eye on numerous database health indicators and settings. It will identify, for instance, when you have a lot of open tables, are about to surpass the maximum number of open connections, or are executing a lot of joins without indexes. By keeping an eye on and preserving instance health, MySQL Recommender assists users in identifying and avoiding database problems.
Once you enable Gemini in Databases, the Recommender will be turned on automatically, allowing you to start fine-tuning your MySQL settings.
Cloud SQL for MySQL Pricing
The cost of Cloud SQL for MySQL is contingent upon the dedicated-core or shared-core instance type that you select, as well as whether or not high availability is enabled. This is an explanation:
- Shared-core instances: Their cost is determined by the type of instance (machine configuration) and their duration (seconds). The Google Cloud SQL documentation [cloud sql mysql cost] has the pricing information.
- Dedicated-core instances: These are an option if you require additional authority and control. The cost of them is determined by how many virtual CPUs and memory they contain.
- High Availability (HA): In addition to the base instance pricing, there is an additional HA pricing for instances (regional instances) configured for HA.
For Cloud SQL, Google also provides a free tier so you may give it a try before committing to a subscription plan. Furthermore, new clients receive a $300 credit line for Cloud SQL.
Cloud SQL for MySQL supports automated and on demand backups
Cloud SQL for MySQL enables both scheduled and spontaneous database backups. This allows you more leeway in developing a solid backup plan. Below is a brief summary of each:
Automated backups
- Scheduled at a predetermined time slot by Google Cloud (usually with low impact on workload).
- Multiple backups can be kept for rollback reasons by configuring the retention time, which ranges from one day to a year.
- Ideal for automatically preserving backups on a regular basis.
On-demand backups
- Manually started anytime you require a quick database backup.
- Helpful for backing up data before important procedures or system modifications.
- Remain until you manually remove them or your instance is terminated.
- Excellent for making extra backups outside of the planned time frame.
Recall that while automated backups adhere to the specified retention policy, on-demand backups are your responsibility to manage and remove.
