We are pleased to announce the general availability of Vitess 17! Major Themes in Vitess 17 # In this release of Vitess, several significant enhancements have been introduced to improve the compatibility, performance, and usability of the system. GA Announcements # The VTTablet settings connection pool feature, introduced in v15, is now enabled by default in this release. This feature simplifies the management and configuration of system settings, providing users with a more streamlined and convenient experience.

When trying to understand queries in the slow log, an interesting metric to look at is rows examined.  Also, when trying to understand CPU spikes on a MySQL instance, the InnoDB Metric dml_reads and the global status Innodb_rows_read are interesting to check.  In a similar way, when trying to gather information about which queries are loading the system, SUM_ROWS_EXAMINED from the

In Percona Managed Services, one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups.

It is a good practice to compress the backups to save costs on storage and to encrypt the backups so those can’t be used if the files are compromised as long as you keep your encryption keys safe!

Percona XtraBackup supports both compression and encryption of the backups. When the data is too big (tens of TB and more), the backups can take several hours or even days to complete. In order to speed up the backup process along with the compression and encryption, we can use multiple threads. We can specify the number of threads to be used for each operation (copy, compression, …

MySQL Heatwave Lakehouse  empowers  users to  query hundreds of terabytes of data in the object store using standard MySQL syntax and queries. It is the only fully managed cloud database service that combines transactions, analytics and machine learning services into one MySQL database delivering real-time, secure analytics without the complexity, latency and cost of ETL […]

In the article, you will learn how to migrate data from Oracle to a MySQL table using dbForge Studio for MySQL and ODBC driver.

The post How to Migrate Data from Oracle to MySQL: Step-by-Step Guide appeared first on Devart Blog.

There are several different ways to store dates and times in MySQL, and knowing which one to use requires understanding what you'll be storing and how MySQL handles each type. There are five column types that you can use to store temporal data in MySQL. They are: DATE DATETIME TIMESTAMP YEAR TIME Each column type stores slightly different data, has different minimum and maximum values, and requires different amounts of storage. In the table below, you'll see each column type and their various attributes.| Column | Data | Bytes | Min | Max | |-----------|-------------|-------|---------------------|---------------------| | DATE | Date only | 3 | 1000-01-01 | 9999-12-31 | | DATETIME | Date + time | 8 | 1000-01-01 00:00:00 | 9999-12-31 23:59:59 | | TIMESTAMP | Date + time | 4 | 1970-01-01 00:00:00 | 2038-01-19 03:14:17 | | YEAR | Year only | 1 | 1901 | 2155 | | TIME | Time only | 3 | -838:59:59 | 838:59:59 |

Dates, years, and times Based on this …

Storing datetime and timestamp data in MySQL correctly.

Course Dates

Public course: EMEA timezone 26th of September. USA timezone 27th of September.

Company dedicated training or consulting session, request for dates for your company via email to: sales@galeracluster.com

Course Duration

1 day.  The breakdown is 3 hours, with a half hour lunch break, and another 3 hours per day. There will be bio-breaks. The total contact time with the trainer is 6 hours over a span of 1 day.

Requirements

• You need to be able to use Zoom the platform we will be using
• You will need to have access to an SSH client. Being in a Microsoft Windows environment is OK, but you need to have SSH to access the remote servers that we provide you access to.
• Some basic understanding of Linux (e.g. package management) as well as MySQL
…

In previous posts, we talked about how we can use MySQL Shell to dump and load databases and how we can dump data to and from Oracle Cloud Infrastructure (OCI) buckets. In this post, we are going to show how you can use MySQL Shell to dump data from a MySQL RDS database to an S3 bucket and then load that […]

Using MySQL Shell, we can dump databases to and from various cloud providers.In this post, we will discuss how you can dump data from a MySQL database in AWS to an S3 bucket and then load that data into an instance of MySQL HeatWave in OCI using just two commands.