Service: MariaDB
The open source project MariaDB is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. This tutorial walks you through how to setup a MariaDB server in Open Source Cloud.
- If you have not already done so, sign up for an OSC account.
Create a service secret for the database root password.
rootpassword=guide
The root password to just serve as an example.
Click on the button "Create dbserver" in the web user interface. Then enter the following values in the create dbserver dialog.
Press the button Create and wait for the instance to be in status Running.
Obtain the IP and port on the service instance card.
In this case we have IP 172.232.131.169 and port 10504
To test a connection launch the mysql client with the following options:
% mysql -h 172.232.131.169 -P 10504 -p
Enter password: guide
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.5-10.11.8-MariaDB-log Alpine Linux
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.