Creating a DB Instance Running the MariaDB Database Engine
The basic building block of Amazon RDS is the DB instance. The DB instance is where you create your MariaDB databases.
You must complete the tasks in the Setting Up for Amazon RDS section before you can create or connect to a DB instance.
AWS Management Console
To launch a MariaDB DB instance
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the top right corner of the AWS Management Console, choose the region in which you want to create the DB instance.
In the navigation pane, choose DB Instances.
Choose Launch DB Instance to start the Launch DB Instance Wizard.
The wizard opens on the Select Engine page.
In the Launch DB Instance Wizard window, choose Select for the MariaDB DB engine.
The next step asks if you plan to use the DB instance you are creating for production. If you are, choose Yes. If you choose Yes, the failover option Multi-AZ and the Provisioned IOPS storage option are preselected in the following step. Choose Next when you are finished.
On the Specify DB Details page, specify your DB instance information. The following table shows settings for an example DB instance. Choose Next when you are finished.
For This Parameter Do This:
Choose the default, general-public-license, to use the GNU General Public License, version 2 for MariaDB. MariaDB has only one license model.
DB Engine Version
Choose the version of MariaDB that you want to work with.
DB Instance Class
Choose a DB instance class that defines the processing and memory requirements for the DB instance. For more information about all the DB instance class options, see DB Instance Class.
Determine if you want to create a standby replica of your DB instance in another Availability Zone for failover support. For more information about multiple Availability Zones, see Regions and Availability Zones.
You usually choose Yes for production instances to enable instance failover and maintain high availability.
Select the storage type you want to use. For more information about storage, see Storage for Amazon RDS.
Type a value to allocate storage for your database (in gigabytes). In some cases, allocating a higher amount of storage for your DB instance than the size of your database can improve I/O performance. For more information about storage allocation, see Amazon RDS Storage Types.
DB Instance Identifier
Type a name for the DB instance that is unique for your account in the region you selected. You might choose to add some intelligence to the name such as including the region and DB engine you selected, for example
Type a name using 1-16 alphanumeric characters that you will use as the master user name to log on to your DB instance. You'll use this user name to log on to your database on the DB instance for the first time.
Master Password and Confirm Password
Type a password that contains from 8 to 41 printable ASCII characters (excluding /,", and @) for your master user password. You'll use this password when you use the user name to log on to your database. Type the password again for Confirm Password.
On the Configure Advanced Settings page, provide additional information that RDS needs to launch the MariaDB DB instance. The table shows settings for an example DB instance. Specify your DB instance information, then choose Next Step.
For This Parameter Do This:
Choose the name of the Amazon Virtual Private Cloud (Amazon VPC) that will host your MariaDB DB instance. For more information about VPC, see Amazon Virtual Private Cloud (VPCs) and Amazon RDS.
Determine if you want to specify a particular Availability Zone. If you selected Yes for the Multi-AZ Deployment parameter on the previous page, you will not have any options here. For more information about Availability Zones, see Regions and Availability Zones.
VPC Security Groups
Choose the VPC security group you want to use with this DB instance. For more information about VPC security groups, see Security Groups for Your VPC in the Amazon Virtual Private Cloud User Guide.
Type a name for your default database that is 1 to 64 alphanumeric characters. If you don't provide a name, Amazon RDS won't automatically create a database on the DB instance you are creating.
To create additional databases, connect to the DB instance and use the SQL command CREATE DATABASE. For more information about connecting to the DB instance, see Connecting to a DB Instance Running the MariaDB Database Engine.
Specify the port that applications and utilities will use to access the database. MariaDB installations default to port 3306. The firewalls at some companies block connections to the default MariaDB port. If your company firewall blocks the default port, choose another port for the new DB instance.
You cannot change the port once you create the DB instance, so it is very important that you determine the correct port to use to access the DB instance.
DB Parameter Group
Select a DB Parameter Group, which is used to manage your DB engine configuration. Each MariaDB version has a default parameter group you can use, or you can create your own parameter group. For DB engine configurations that you frequently use or to increase your database engine uptime, you can create your own DB parameter group. For more information about parameter groups, see Working with DB Parameter Groups.
Select an Option Group, which is used to enable and configure DB engine features. Each MariaDB version has a default option group you can use, or you can create your own option group. For more information about option groups, see Working with Option Groups.
Copy Tags To Snapshots
Choose this option to have any DB instance tags copied to a DB snapshot when you create a snapshot. For more information, see Tagging Amazon RDS Resources.
Yesif you want to enable encryption at rest for this DB instance. For more information, see Encrypting Amazon RDS Resources.
Backup Retention Period
Set the number of days you want automatic backups of your database to be retained. For testing purposes, you can set this value to 1.
Specify the period of time during which your DB instance is backed up. During the backup window, storage I/O may be suspended while your data is being backed up and you may experience elevated latency. This I/O suspension typically lasts for the duration of the snapshot. This period of I/O suspension is shorter for Multi-AZ DB deployments, since the backup is taken from the standby, but latency can occur during the backup process. For more information, see Working With Backups.
Enable Enhanced Monitoring
Choose Yes to enable gathering metrics in real time for the operating system that your DB instance runs on. For more information, see Enhanced Monitoring.
Only available if Enable Enhanced Monitoring is set to
Yes. Set the interval, in seconds, between when metrics are collected for your DB instance.
Auto Minor Version Upgrade
Choose Yes to enable your DB instance to receive minor DB engine version upgrades automatically when they become available.
Choose the weekly time range during which system maintenance can occur. For more information about the maintenance window, see Adjusting the Preferred DB Instance Maintenance Window.
In addition, Federated Storage Engine is currently not supported by Amazon RDS for MariaDB.
The Point-In-Time Restore and snapshot restore features of Amazon RDS for MariaDB require a crash recoverable storage engine, and these two features are supported only for the XtraDB storage engine. Although MariaDB supports multiple storage engines with varying capabilities, not all of them are optimized for crash recovery and data durability.
Choose Launch DB Instance to create your MariaDB DB instance.
On the final page of the wizard, choose Close.
On the Amazon RDS console, the new DB instance appears in the list of DB instances. The DB instance will have a status of creating until the DB instance is created and ready for use. When the state changes to available, you can connect to the DB instance. Depending on the DB instance class and store allocated, it can take several minutes for the new instance to be available.
To create a MariaDB DB instance, use the AWS CLI create-db-instance command. The following parameters are required:
The following command creates a MariaDB instance named mydbinstance.
For Linux, OS X, or Unix:
aws rds create-db-instance \ --db-instance-identifier
aws rds create-db-instance ^ --db-instance-identifier
This command should produce output similar to the following:
DBINSTANCE mydbinstance db.m1.small mariadb 20 sa creating 3 **** n 10.0.17 SECGROUP default active PARAMGRP default.mariadb10.0 in-sync
To create a MariaDB DB instance, call the Amazon RDS API CreateDBInstance action. The following parameters are required:
https://rds.us-west-2.amazonaws.com/ ?Action=CreateDBInstance &AllocatedStorage=20 &BackupRetentionPeriod=3 &DBInstanceClass=db.m1.small &DBInstanceIdentifier=mydbinstance &DBName=mydatabase &DBSecurityGroups.member.1=mysecuritygroup &DBSubnetGroup=mydbsubnetgroup &Engine=mariadb &MasterUserPassword=<masteruserpassword> &MasterUsername=<masteruser> &Version=2013-09-09 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140213/us-west-2/rds/aws4_request &X-Amz-Date=20140213T162136Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=8052a76dfb18469393c5f0182cdab0ebc224a9c7c5c949155376c1c250fc7ec3