Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

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.

Important

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

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the top right corner of the AWS Management Console, choose the region in which you want to create the DB instance.

  3. In the navigation pane, choose DB Instances.

  4. Choose Launch DB Instance to start the Launch DB Instance Wizard.

    The wizard opens on the Select Engine page.

    
								Select Engine
  5. In the Launch DB Instance Wizard window, choose Select for the MariaDB DB engine.

  6. 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.

  7. 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:

    License Model

    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.

    Multi-AZ Deployment

    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.

    Note

    You usually choose Yes for production instances to enable instance failover and maintain high availability.

    Storage Type

    Select the storage type you want to use. For more information about storage, see Storage for Amazon RDS.

    Allocated Storage

    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 east1-mariadb-instance1.

    Master Username

    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.

    
						Specify DB Details
  8. 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:

    VPC

    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.

    Availability Zone

    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.

    Database Name

    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.

    Database Port

    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.

    Important

    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.

    Option Group

    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.

    Enable Encryption

    Select Yes if 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.

    Backup Window

    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.

    Granularity

    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.

    Maintenance Window

    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.

    
								Configure Advanced Settings

    In addition, Federated Storage Engine is currently not supported by Amazon RDS for MariaDB.

    Note

    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.

  9. Choose Launch DB Instance to create your MariaDB DB instance.

  10. On the final page of the wizard, choose Close.

  11. 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.

    
						My DB instances list

CLI

To create a MariaDB DB instance, use the AWS CLI create-db-instance command. The following parameters are required:

  • --db-instance-identifier

  • --db-instance-class

  • --engine

The following command creates a MariaDB instance named mydbinstance.

For Linux, OS X, or Unix:

Copy
aws rds create-db-instance \ --db-instance-identifier mydbinstance \ --db-instance-class db.m1.small \ --engine mariadb \ --allocated-storage 20 \ --master-username masteruser \ --master-user-password masteruserpassword \ --backup-retention-period 3

For Windows:

Copy
aws rds create-db-instance ^ --db-instance-identifier mydbinstance ^ --db-instance-class db.m1.small ^ --engine mariadb ^ --allocated-storage 20 ^ --master-username masteruser ^ --master-user-password masteruserpassword ^ --backup-retention-period 3

This command should produce output similar to the following:

Copy
DBINSTANCE mydbinstance db.m1.small mariadb 20 sa creating 3 **** n 10.0.17 SECGROUP default active PARAMGRP default.mariadb10.0 in-sync

API

To create a MariaDB DB instance, call the Amazon RDS API CreateDBInstance action. The following parameters are required:

  • DBInstanceIdentifier = mydbinstance

  • DBInstanceClass = db.m1.small

  • Engine = mariadb

Example

Copy
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

Related Topics