Update existing MySQL database to Optimized Writes?

1

What are the options to update an existing database (one that predates Optimized Writes) to support Optimized Writes?

Our database is currently running MySQL 8.0.26. What sequence of steps would we need to perform? And is there an option that utilizes blue/green deployments?

2개 답변
1

We have a similar issue too. RDS (r6g, MySQL 8.0.31) created before Optimized Writes become available and currently during instance restart log shows: "The database is using the doublewrite buffer. RDS Optimized Writes is incompatible with the storage configuration. For more information, see the RDS Optimized Writes for MYSQL documentation." However, instance matches all conditions from the documentation and it's not possible to turn off innodb_doublewrite because it's not modifiable.

So it seems it's not possible to enable Optimized Writes for existing instance. Looks like the only way to create a new instance and move all the data (or do it with replication). Maybe it's also possible to make a snapshot and restore from it to a new instance, not yet checked.

osa
답변함 일 년 전
0

Optimized writes is automatically enabled when the following conditions are met.
Optimize Writes will be available when the following conditions are met

  • RDS for MySQL version 8.0.30 and higher.
  • Use the following DB instance classes
    • db.x2iedn
    • db.r6i
    • db.r6g
    • db.r6gd
    • db.r5b
  • You can only modify a database to turn on RDS Optimized Writes if the database was created with a DB engine version and DB instance class that support the feature. In this case, if RDS Optimized Writes is turned off for the database, you can turn it on by setting the rds.optimized_writes parameter to AUTO.
  • When you are restoring an RDS for MySQL database from a snapshot, you can only turn on RDS Optimized Writes for the database if all of the following conditions apply:
    • The snapshot was created from a database that supports RDS Optimized Writes.
    • The snapshot is restored to a database that supports RDS Optimized Writes.
    • The restored database is associated with a parameter group with the rds.optimized_writes parameter set to AUTO.

Doc: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-optimized-writes.html#rds-optimized-writes-limitations

And blue/green deployments can be used when upgrading minor MySQL versions.

profile picture
hayao-k
답변함 2년 전
  • This isn't correct.

    Applying this configuration to an existing RDS instance that predated the release of Optimized Writes does not automatically enable it on the instance. The above criteria only apply to new instances.

  • Thank you for your comment. You are correct and I have revised my response.

  • We have the similar issue after update an exist RDS from 5.7 to 8.0.35, Is there a way to enable optimized writes on an exist updated RDS?

  • Any updates on this? We got a similar issue on .36 in which the instance refuses to enable optimised writes - the notice is "The database is using the doublewrite buffer. RDS Optimized Writes is incompatible with the storage configuration. For more information, see the RDS Optimized Writes for MYSQL documentation."

    See https://repost.aws/questions/QUjRrTyExOTBydShz2FQBTWA/replication-lag-issue-during-and-after-upgrade-from-mysql5-7-to-mysql-8-0-36

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠