The latest from the MySQL community

Amazon instance profiles are used to pass IAM roles to an EC2 instance. This IAM role can be queried using EC2 instance metadata to access an S3 bucket. Please check Amazon’s Official Documentation for more information.

Today we are happy to announce that starting with Percona XtraBackup 8.0.31-24, xbcloud can read instance metadata and fetch credentials from an instance profile, utilizing it to authenticate against an S3 bucket. Xbcloud is a tool part of Percona XtraBackup and allows you to upload and download backups to Amazon S3 storage.

How it works

Configure your EC2 instance …

Summary of the preFOSDEM MySQL Days 2023

I discovered a dependency for MySQL Workbench on AlmaLinux 8 installation. I neglected to fully cover it when I documented the installation in a VM of AlmaLinux 9. I go back later and update that entry but for now you need the following dependencies:

proj-6.3.2-4.el8.x86_64.rpm
proj-datumgrid-1.8-6.3.2.4.el8.noarch.rpm
proj-devel-6.3.2-4.el8.x86_64.rpm

Install like this:

sudo dnf install -y *.rpm

Log file:

Last metadata expiration check: 3:01:53 ago on Fri 10 Feb 2023 03:37:49 AM UTC.
Dependencies resolved.
==========================================================================================
 Package                Architecture   Version                 Repository            Size
==========================================================================================
Installing:
 proj                   x86_64         6.3.2-4.el8             @commandline         2.0 M
 proj-datumgrid         noarch …

Note

PlanetScale now supports PostgreSQL.

Choosing a data store is one of the most important decisions you'll make when building software applications. The good and bad news though, is that there is an abundance of options. Depending on the type of application you're building, you may opt for a relational database like MySQL or Postgres, a non-relational database like MongoDB or CouchDB, a graph database like Neo4j, or one of the many other alternatives that each bring their own benefits and drawbacks.

It is a difficult choice and sometimes you realize that the database you initially went with no longer serves the needs of your application and you have to make the choice to migrate.

In this blog post, we'll take a look at how you can migrate your database schema from PostgreSQL to MySQL. MySQL and PostgreSQL …

Learn how to migrate from Postgres to MySQL Postgres vs MySQL incompatibilities and more.

MySQL HeatWave Best Practices Series: Data load to HeatWave with MySQL Autopilot   In the first blog of the best practices series, we discussed the best practices for schema design. In this blog, we go into details of best practices of loading data to HeatWave. This is the first criteria of running queries in HeatWave […]

MySQL HeatWave Best Practices Series: Data load to HeatWave with MySQL Autopilot

In 2023, FOSDEM returned as an in-person conference after being virtual for 2 years. With this comeback, the MySQL Team once again hosted the very popular preFOSDEM MySQL Days, a side event we have been doing since 2018. It was a blast ! It was great to see so many friends of MySQL in person. […]

After having cancelled 2 editions of the preFOSDEM MySQL Days because of the pandemic, we were finally back last week in Brussels for 2 wonderful days dedicated to the Dolphin database developed by Oracle. During this event and for the first time, we, the MySQL Team, decided to reward some members of the MySQL Community […]

The winners of the MySQL Rockstar 2022 Awards