mysql 切换 rds_如何从最小的应用程序影响“从MySQL切换到Amazon RDS”？

Amazon RDS是纯MySQL,由您的应用程序访问与其他MySQL数据库相同的方式; RDS的Web服务接口纯粹用于创建,删除和修改DB实例,而不是DB数据.从他们的

FAQ：

Q: How do I access my running DB

Instance?

Once your DB Instance is available,

you can retrieve its

endpoint via the DescribeDBInstance

API. Using this endpoint you can

construct the connection string

required to connect directly with your

DB Instance using your favorite

database tool or programming language.

In order to allow network requests to

your running DB Instance, you will

need to authorize access. For a

detailed explanation of how to

construct your connection string and

get started, please refer to our

Getting Started Guide.

This是您需要的入门指南的一部分 – 它说明了如何获取新实例的主机名,以便您可以连接到该实例,授权实例从客户端进行访问,然后使用MySQL命令行客户端进行连接(举个例子)：

$rds-describe-db-instances --headers

$rds-authorize-db-security-group-ingress default --cidr-ip 192.0.2.0/30 --headers

$mysql -h myinstance.crwjauxgijdf.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -p