1

I have an existing MySQL database running on AWS Lightsail, I want to create a read replica for that one, how can I do it?

1

To my understanding this is not an option for the Lightsail managed databases. You can however create an RDS instance of MySQL and create a read replica there. To connect to this RDS instance you'll need to use VPC Peering.

Lightsail lets you connect to AWS resources, such as an Amazon RDS database, through virtual private cloud (VPC) peering. A VPC is a virtual network dedicated to your AWS account. Everything you create inside Lightsail is inside a VPC, and you can connect your Lightsail VPC to an Amazon VPC.

To create a MySQL Read Replica:

Using the AWS Management Console, you can easily add read replicas to existing DB Instances. Use the "Create Read Replica" option corresponding to your DB Instance in the AWS Management Console.

Connecting to it can be accomplished via the following method:

  1. In the Lightsail console, choose Account on the top navigation menu.

  2. Choose Account from the drop-down..

  3. Choose the Advanced tab.

  4. Choose Enable VPC peering under the AWS Region where you want to enable it.

References

Using Lightsail with other AWS Services
Lightsail - How to set up VPC Peering with other AWS Resources
Read Replicas

|improve this answer|||||
  • Wonderful. I will try this and let you know how it went – Shobi Oct 31 '19 at 12:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.