MariaDB Server is one of the most popular open-source relational databases. It’s made by the original developers of MySQL and is guaranteed to stay open source. It is part of most cloud offerings and the default in most Linux distributions.
To verify the installation, follow the below instructions
Step 1. Connect to SSH:
Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
In the navigation pane, choose Instances.
Select the instance and choose Connect.
Choose SSH Client
Copy the SSH command and paste it into the terminal.
ssh ec2-user@publicIP -i [Path of key pair file]
If it shows an access denied message run the following command, then run the above command again to connect via ssh.
chmod 400 [Path of key pair file]
Once launched in the Amazon EC2 Service, please connect to the instance via an SSH client using the ec2-user with the key pair associated at launch. Once connected as the ec2-user user, you will be able to sudo to the root user
Step 2. Verify the installation
Follow the steps to verify the MariaDB installation
1. When you log in with ssh
2. Type the below command to check the version
You will see the responses as shown below.
After installation, you can open an interactive MariaDB session as below command: sudo mariadb -u root
To monitor and assess application functions:-
a. Navigate to your Amazon EC2 console and verify that you're in the correct region.
b. Choose Instances and select your launched instance.
c. Select the server to display your metadata page and choose the Status checks tab at the bottom of the page to review if your status checks passed or failed.
For information about how to use the application, please visit: https://www.tutorialspoint.com/mariadb/index.htm
For detailed information about managing and requesting increased service please visit: https://docs.aws.amazon.com/general/latest/gr/aws_service_limits.html