mysql - 如何将我的 Amazon Elastic Beanstalk MySQL RDS 实例升级到 5.6？

Question

AWS 提供了有关如何使用只读副本将 MySQL 5.5 实例升级到 MySQL 5.6 的指南。然而，它的最后一步是将您的应用程序指向新数据库，但 EBS 没有提供通过 Web 控制台将您的应用程序指向不同数据库的机制。升级基于 EBS 的 RDS 实例的推荐路径是什么？

Answer 1

我通常建议用户在 Beanstalk 之外提供数据库，这个问题就是其中之一。

还有

For a production environment, you may want to launch a databaseinstance outside of your environment and configure your application toconnect to it outside of the functionality provided by ElasticBeanstalk.

AWS RDS 确实支持从 5.5 升级到 5.6。

MySQL 5.5 to MySQL 5.6

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html

但在您当前的设置中。

1. 创建 RDS 数据库的快照。
2. 根据该快照在 Beanstalk 之外配置 RDS 数据库
3. 配置新的 Elastic Beanstalk 环境并设置这些环境属性。

In the Environment Properties section, define the variables that your application reads to construct a connection string. For compatibility with environments that have an integrated RDS DB instance, use the following:

RDS_HOSTNAME – The hostname of the DB instance.

Amazon RDS console label – Endpoint is the hostname.

RDS_PORT – The port on which the DB instance accepts connections. The default value varies between DB engines.

. Amazon RDS console label – Port

RDS_DB_NAME – The database name, ebdb.

Amazon RDS console label – DB Name

RDS_USERNAME – The user name that you configured for your database.

Amazon RDS console label – Username

RDS_PASSWORD – The password that you configured for your database.

https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/AWSHowTo.RDS.html