# MySQL 5.7

Published articles for MySQL 5.7.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How We Migrated Millions of UGC Records to Aurora MySQL

DevFeed: [How We Migrated Millions of UGC Records to Aurora MySQL](<https://devfeed.tech/articles/how-we-migrated-millions-of-ugc-records-to-aurora-mysql-38727.md>)

Original publisher: [Read original article](<https://blog.developer.bazaarvoice.com/2025/08/25/how-we-migrated-millions-of-ugc-records-to-aurora-mysql/>)

Author: Kovi

Published: 2025-08-25T10:42:12Z

Content type: article

Language: en

Sources: [Bazaarvoice](<https://devfeed.tech/sources/bazaarvoice.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [reliability](<https://devfeed.tech/topics/reliability.md>), [resiliency](<https://devfeed.tech/topics/resiliency.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cost](<https://devfeed.tech/tags/cost.md>), [database](<https://devfeed.tech/tags/database.md>), [devops](<https://devfeed.tech/tags/devops.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [performance](<https://devfeed.tech/tags/performance.md>), [reliability](<https://devfeed.tech/tags/reliability.md>)

### AI overview

Bazaarvoice describes migrating millions of user-generated content records from Amazon RDS for MySQL to Amazon Aurora MySQL. The article explains the operational limits, performance and scaling challenges, and a two-phase modernization that first standardized on MySQL 8.0 before the Aurora migration.

### Source excerpt

Discover how Bazaarvoice migrated millions of UGC records from RDS MySQL to AWS Aurora - at scale and with minimal user impact. Learn about the technical challenges, strategies, and outcomes that enabled this ambitious transformation in reliability, performance, and cost efficiency Bazaarvoice ingests and serves millions of user-generated content (UGC) items--reviews, ratings, questions, answers, and [...]

## Rising costs of running legacy Amazon RDS systems

DevFeed: [Rising costs of running legacy Amazon RDS systems](<https://devfeed.tech/articles/rising-costs-of-running-legacy-amazon-rds-systems-27711.md>)

Original publisher: [Read original article](<https://gagor.pro/2024/04/rising-costs-of-running-legacy-amazon-rds-systems/>)

Author: Tom

Published: 2024-04-27T00:00:00Z

Content type: opinion

Language: en

Sources: [Tomasz Gągor](<https://devfeed.tech/sources/tomasz-gagor.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [legacy](<https://devfeed.tech/topics/legacy.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-rds-extended-support](<https://devfeed.tech/tags/aws-rds-extended-support.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-database-costs](<https://devfeed.tech/tags/cloud-database-costs.md>), [legacy](<https://devfeed.tech/tags/legacy.md>), [legacy-rds-costs](<https://devfeed.tech/tags/legacy-rds-costs.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [mysql-5-7-support](<https://devfeed.tech/tags/mysql-5-7-support.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-10-support](<https://devfeed.tech/tags/postgresql-10-support.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>)

### AI overview

The article examines the rising cost of maintaining legacy Amazon RDS instances running MySQL 5.7 and PostgreSQL 10 or earlier. It explains how RDS Extended Support lets customers continue using outdated versions with critical updates, while adding region- and resource-dependent charges and allowing up to three years to upgrade.

### Source excerpt

Understand the rising costs of maintaining legacy Amazon RDS systems and explore the new RDS Extended Support option for MySQL and PostgreSQL.

## Emulating Window Functions in MySQL 5.7

DevFeed: [Emulating Window Functions in MySQL 5.7](<https://devfeed.tech/articles/emulating-window-functions-in-mysql-5-7-28938.md>)

Original publisher: [Read original article](<https://blog.jooq.org/emulating-window-functions-in-mysql-5-7/>)

Author: lukaseder

Published: 2023-01-20T11:07:00Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [dense-rank](<https://devfeed.tech/tags/dense-rank.md>), [deprecated](<https://devfeed.tech/tags/deprecated.md>), [emulations](<https://devfeed.tech/tags/emulations.md>), [local-variables](<https://devfeed.tech/tags/local-variables.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [ordering](<https://devfeed.tech/tags/ordering.md>), [rank](<https://devfeed.tech/tags/rank.md>), [row-number](<https://devfeed.tech/tags/row-number.md>), [sql](<https://devfeed.tech/tags/sql.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

### AI overview

This tutorial explains how to emulate window functions in MySQL 5.7 using user variables. It warns that the technique depends on incidental evaluation order, can break when query execution changes, and is deprecated in MySQL 8.x.

### Source excerpt

One of MySQL 8's biggest improvements is the support of window functions. As I always said in conferences, there's SQL before window functions and SQL after window functions. Once you start using them, you'll use them everywhere. Some of you poor souls are unfortunate enough to be stuck on MySQL 5.7, either of your own ... Continue reading Emulating Window Functions in MySQL 5.7 ->