# Connect instances that use LAMP packaged by Bitnami to an Aurora database
**This blueprint packaged by Bitnami is being deprecated**
Blueprints packaged by Bitnami will no longer receive updates after May 19, 2026. Starting November 19, 2026, you will no longer be able to create new instances with this blueprint. When creating new instances, we recommend using the equivalent Lightsail blueprint if available. Existing instances using blueprints packaged by Bitnami will continue to run without any disruption. [Learn more](amazon-lightsail-faq-bitnami-blueprints.md)
If you have an existing instance that uses a blueprint packaged by Bitnami and want to migrate to a Lightsail-packaged blueprint, see [Migrate to Lightsail blueprints](migrate-from-bitnami-to-lightsail-blueprints.md).
**This tutorial applies to instances that use LAMP packaged by Bitnami only**
If your instance uses the LAMP blueprint packaged by Lightsail, see [LAMP](amazon-lightsail-lamp-lightsail.md) instead.
Application data for posts, pages, and users is stored on a MariaDB database that is running on your LAMP instance in Amazon Lightsail. If your instance fails, your data may become unrecoverable. To prevent this scenario, you should transfer your application data to a MySQL managed database.
Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud. It combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases. Aurora is offered as part of the Amazon Relational Database Service (Amazon RDS). Amazon RDS is a managed database service that makes it easier to set up, operate, and scale a relational database in the cloud. For more information, see the [Amazon Relational Database Service User Guide](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/) and the [Amazon Aurora User Guide for Aurora](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/).
In this tutorial, we show you how to connect your application database from a LAMP instance in Lightsail to an Aurora managed database in Amazon RDS.
**Contents**
+ [Step 1: Complete the prerequisites](#connect-lamp-to-aurora-prerequisites)
+ [Step 2: Configure the security group for your Aurora database](#configure-security-group)
+ [Step 3: Connect to your Aurora database from your Lightsail instance](#connect-to-aurora-database-from-lamp-instance)
+ [Step 4: Transfer the MariaDB database from your LAMP instance to your Aurora database](#transfer-database-from-lamp-to-aurora)
+ [Step 5: Configure your application to connect to your Aurora managed database](#connect-application-to-database)
## Step 1: Complete the prerequisites
Complete the following prerequisites before you begin:
1. Create a LAMP instance in Lightsail, and configure your application on it. The instance should be in a running state before you continue. For more information, see [Launch and configure a LAMP instance in Lightsail](amazon-lightsail-quick-start-guide-lamp-bitnami.md).
1. Turn on VPC peering in your Lightsail account. For more information, see [Set up Amazon VPC peering to work with AWS resources outside of Lightsail](lightsail-how-to-set-up-vpc-peering-with-aws-resources.md).
1. Create an Aurora managed database in Amazon RDS. The database should be located in the same AWS Region as your LAMP instance. It should also be in a running state before you continue. For more information, see [Getting started with Amazon Aurora](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_GettingStartedAurora.html) in the *Amazon Aurora User Guide for Aurora*.
## Step 2: Configure the security group for your Aurora database
An AWS security group acts as a virtual firewall for your AWS resources. It controls the incoming and outgoing traffic that can connect to your Aurora database in Amazon RDS. For more information about security groups, see [Control traffic to resources using security groups in the Amazon Virtual Private Cloud User Guide](https://docs.aws.amazon.com/vpc/latest/userguide/VPC_SecurityGroups.html).
Complete the following procedure to configure the security group to so that your LAMP instance can establish a connection to your Aurora database.
1. Sign in to the [Amazon RDS console](https://console.aws.amazon.com/rds/).
1. Choose **Databases** in the navigation pane.
1. Choose the **Writer instance** of the Aurora database that your LAMP instance will connect to.
1. Choose the **Connectivity & security tab**.
1. In the **Endpoint & port** section, make a note of the **Endpoint name** and **Port** of the **Writer instance**. You will need these later when configuring your Lightsail instance to connect to the database.
1. In the **Security** section, choose the active VPC security group link. You will be redirected to your database’s security group.
1. Make sure that the security group for your Aurora database is selected.
1. Choose the **Inbound rules** tab.
1. Choose **Edit inbound rules**.
1. In the **Edit inbound rules** page, choose **Add rule**.
1. Complete one of the following steps:
+ If you are using the default MySQL port 3306, select **MySQL/Aurora** in the **Type** dropdown menu.
+ If you are using a custom port for your database, select **Custom TCP** in the **Type** dropdown menu and enter the port number in the **Port Range** text box.
1. In the **Source** text box, add the private IP address of your LAMP instance. You must enter the IP addresses in CIDR notation, which means that you must append `/32`. For example, to allow `192.0.2.0`, enter `192.0.2.0/32`.
1. Choose **Save rules**.
## Step 3: Connect to your Aurora database from your Lightsail instance
Complete the following procedure to confirm that you can connect to your Aurora database from your Lightsail instance.
1. Sign in to the [Lightsail console](https://lightsail.aws.amazon.com/).
1. In the left navigation pane, choose **Instances**.
1. Choose the browser-based SSH client icon for your LAMP instance to connect to it using SSH.
1. After you're connected to your instance, enter the following command to connect to your Aurora database. In the command, replace {{DatabaseEndpoint}} with the endpoint address of your Aurora database, and replace {{Port}} with the port of your database. Replace {{MyUserName}} with the name of the user that you entered when creating the database.
```
mysql -h {{DatabaseEndpoint}} -P {{Port}} -u {{MyUserName}} -p
```
You should see a response similar to the following example, which confirms that your instance can access and connect to your Aurora database.
If you don’t see this response, or you get an error message, then you might need to configure the security group of your database to allow the private IP address of your Lightsail instance to connect to it. For more information, see the [Configure the security group for your Aurora database](#configure-security-group) section of this guide.
## Step 4: Transfer the MariaDB database from your LAMP instance to your Aurora database
Now that you’ve confirmed you can connect to your database from your instance, you should migrate the data from your LAMP instance database to your Aurora database. For more information, see [Migrating data to an Amazon Aurora MySQL DB cluster](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.html) in the *Amazon Aurora User Guide for Aurora*.
## Step 5: Configure your application to connect to your Aurora managed database
After transferring your application data to your Aurora database, you should configure the application running on your LAMP instance to connect to your Aurora database. Connect to your LAMP instance using SSH, and access the application’s database configuration file. In the configuration file, define the endpoint address of your Aurora database, the database user name, and password. Following is an example configuration file.
