We’re excited to announce that we are adding support for vector storage and search into MySQL and PlanetScale. Soon, you’ll be able to use PlanetScale as a vector database for all of your AI needs without needing to adopt a second tool. You can sign up to be notified of release at planetscale.com/ai. What are vectors? A vector is a one-dimensional array of real number values: [1, 1] is a vector, as is [1.5, 8.889, 9.234]. Each element represents an attribute or a dimension, and the position of that element in the array represents a “point.” In three-dimensional space, a vector of [2, 3, 5] would have 2 as the x-coordinate, 3 as the y-coordinate and 5 as the z-coordinate. In real-world applications of artificial intelligence, vectors are in significantly higher dimensionality — well above 1,000! Modern databases are already very good at storing lists of numbers. Storing vectors as a raw datatype is not interesting, like points on a globe or …

This post was originally published in 2011 and was updated in October 2023.

I see this message on our forums, and I think it’s a great question: “Which version of Percona Server is currently recommended?” It’s really the same question as “Which version of MySQL is currently recommended?” In this blog, we cover everything you need to know about how to choose the right version of MySQL for your needs, as well as key information on the latest versions, 5.7 and 8.0.

Understanding MySQL Versions

MySQL versions play a pivotal role in database management, as each MySQL version represents a distinct release, encompassing enhancements, bug fixes, and new features that affect the performance, security, and functionality of the database and applications. Staying informed about MySQL version updates is vital for anyone tasked with managing databases, as it directly impacts the efficiency and reliability of data …

This article will explore how to connect to Oracle in Delphi using the Devart ODAC library. We'll cover the installation of Devart ODAC, provide concrete examples of its usage, and even compare it to FireDAC.

The post How to Connect to Oracle in Delphi with Devart ODAC appeared first on Devart Blog.

As a DBA, one of the very frequent tasks is to stop/start MySQL service for batching or some other activities. Before stopping MySQL, we may need to check if there are any active connections; if there are, we may need to kill all those. Generally, we use pt-kill to kill the application connections or prepare kill statements using the select queries.

Example commands:

pt-kill --host=192.168.11.11 --user=percona -p --sentinel /tmp/pt-kill.sentinel2 --pid /tmp/pt-kill.pid  --victims all --match-command 'Query' --ignore-user 'pmm|rdsadmin|system_user|percona' --busy-time 10 --verbose --print --kill 

select concat('kill ',id,';') from information_schema.processlist where user='app_user';

MySQL has a variable called offline_mode to set the server into maintenance mode. When you set this, it immediately disconnects all the client connections that don’t …

Discover the best practices for creating secure MySQL backups and uploading them to FTP or popular free file hosting services like Fex.net, Fastupload.io, MEGA, Google Drive, and Easyupload.io. Protect your data with our comprehensive guide.

The post How to Upload MySQL Backup Files to FTP or Free File Hosting Services appeared first on Devart Blog.

We will provide step-by-step instructions on installing MyDAC, demonstrate its usage with practical examples, and compare it with FireDAC to highlight its advantages.

The post How to Connect to MySQL in Delphi with MyDAC: A Comprehensive Guide appeared first on Devart Blog.

MySQL HeatWave Lakehouse is now available on AWS, enabling AWS customers to run transaction processing, real-time analytics across data warehouses and data lakes, and machine learning in one cloud database service. They can replace five AWS services with one, reducing complexity and obtaining the best price-performance in the industry for analytics.

Learn how to copy a MySQL instance to another server or to the cloud.

To copy a MySQL server to another server or to the cloud, there are several ways.

We can distinguish between two different types of copy:

• physical copy
• logical copy

The physical copy is often the fastest. However, it requires some tools to ensure that you have a consistent online backup. For example, you can use MySQL Enterprise Backup (MEB).

Alternatively, it’s possible to use the CLONE plug-in to provision a new instance with existing data from a source server. This is my preferred approach.

Finally, the last physical solution is the use of a file system snapshot, but this requires the right infrastructure and even more care to have a consistent …

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first. Let’s review the best practices we usually follow in Managed Services before using your MySQL server in production and stage env, even for home play purposes.

Memory

Our usual recommendation is to use specific memory parameters, which we suggest to ensure optimal performance.

• To prevent out-of-memory (OOM) episodes, the OOM Score has to be set to -800.
• vm.swappiness = 1
• Disable Transparent Huge Pages
• Install and enable jemalloc. Let’s briefly go through each setting to understand why adjustments are needed. Afterward, we will see how to configure these …