Databases in Amazon Lightsail
Last updated: March 15, 2019
You can create a MySQL or PostgreSQL managed database in Amazon Lightsail with a few steps. Lightsail makes database administration more efficient by managing your common maintenance and security tasks. Using the Lightsail console, you can:
Back up your database to a snapshot.
Create a new larger database from a snapshot.
Troubleshoot common issues with browser-based logs and metrics.
Recover data by using point-in-time backup and restore operations.
The efficient Lightsail experience enables you to build your application on a Lightsail instance and connect it to a Lightsail managed database. You can also create a standalone database, and connect analytics or querying tools for your company. Choose from standard or high availability database plans that include your pre-configured database, SSD-based storage, and data transfer allocation for a fixed, monthly price. You can also manage Lightsail databases using the AWS Command Line Interface (AWS CLI), API, or SDK.
Here's some articles to help you manage your database in Lightsail:
Configuring the data import mode for your database in Amazon Lightsail
Configuring the public mode for your database in Amazon Lightsail
Downloading an SSL certificate for your managed database in Amazon Lightsail
Modifying your managed database in Amazon Lightsail to use a specific certificate
Connecting to your MySQL database in Amazon Lightsail using SSL
Connecting to your PostgreSQL database in Amazon Lightsail using SSL
Importing data into your PostgreSQL database in Amazon Lightsail
Changing the preferred maintenance and backup windows for your database in Amazon Lightsail
Enabling the MySQL database general and slow query logs in Amazon Lightsail
Creating a database from a point-in-time backup in Amazon Lightsail