Experiment: Experiencing MariaDB

1555 already completed

Experiment Content:

Start Your Experiment View Experiment Manual
Firefox and Chrome Browser are recommended

Duration：10 mins

1. View the system environment
2. Install MariaDB
3. Test MariaDB

Experiment Resources:

Hardware：LinuxONE
OS：Redhat 7.6
DB：MariaDB 5.5.60

Medal Status

Lighten Medals

Latest Activites

zhoufc

has completed the experiment and received a blue medal

chenjian

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

syyjcyao

has completed the experiment and received a blue medal

syyjcyao

has completed the experiment and received a blue medal

yanqingc

has completed the experiment and received a blue medal

yanqingc

has completed the experiment and received a blue medal

Challenges: Install and Use MariaDB

517 already completed

Challenge Background:

A company is interested in the virtualization of LinuxONE, and wants to integrate some edge businesses onto LinuxONE. These edge businesses run on CentOS and use MariaDB as their database.

Start Your Challenge

Challenge Goal:

1. Install MariaDB on ClefOS (CentOS on Z) by means of yum (where yum source has been installed)
2. Create a database "testdb"
3. Create a sheet "customers" in the database - (customer_id INT PRIMARY KEY, first_name TEXT, last_name TEXT);
4. Insert a data entry into the sheet, e.g. 1,'Tom', 'Wang'

Challenge Rules:

1. Once the challenge starts, the system will start timing for 30min.
2. Click the "Submit Results" button on the upper left corner after the challenge task is completed.
3. The system evaluates your performance automatically and gives your challenge results and score.
4. Your score is ranked according to your time taken to challenge. The shorter your time is, the higher your rank is.

Medal Status

Lighten Medals

Challenge Ranking List

Rank	Nickname	Time
	gzibm004	6s
	yangdmsh	6s
	warrenxzy	11s
4	JingBh	11s
5	wanghaif	20s

Discovery:Experiencing MariaDB

56 already completed

Experiment Content:

Duration：10 mins

Start Your Discovery
redeem 100 points for your discovery

1. View the system environment
2. Install MariaDB
3. Test MariaDB

Experiment Resources:

Hardware：LinuxONE
OS：Redhat 7.6
DB：MariaDB 5.5.60

Tips

1. Discovery provides longer time for your experience;you are home free
2. Data will be cleared after the end of discovery
3. It is needed to finish the experiment and challenge first to start your discovery

返回顶部

Please start your discovery after you finish the challenge.

Please start your discovery after you finish the experiment.

Experiment Manual

The following content is displayed on the same screen for your experiment so that you can make any necessary reference in experiment. Start your experiment now!

View environmental information, confirm the hardware platform and operating system version(Duration: 5 mins)
Excuting an order
1.1 uname -m

_{Tips: Type the above command in the operation area on the right side of the window and press Enter to execute
Click（）to automatically insert commands in the operation area, which is faster}

Confirm that the hardware platform is s390x, s390x means that the system is based on IBM Z or LinuxONE hardware platform.
1.2 cat /etc/redhat-release
Confirm that the operating system version is Red Hat 7.6
Install MariaDB(Duration: 5 mins)
Excuting an order:
2.1 # yum list mariadb-server
View MariaDB installation package and installation status

2.2 #yum -y install mariadb-server
Start to install MariaDB package

2.3 # systemctl start mariadb
Start MariaDB database service

2.4 # systemctl status mariadb
Check the MariaDB service status and see the green font of active (running) indicating that the service has started successfully
Test MariaDB(Duration: 5 mins)
Excuting an order:
3.1 # mysql --version
View database software version

3.2 # mysql -u root
Connect to the database server

The following step commands must end with a semicolon（;）
MariaDB [(none)]>
3.3 create database testdb;
Create a test database named testdb

MariaDB [(none)]>
3.4 use testdb;
Select the testdb database just created

MariaDB [testdb]>
3.5 create table customers (customer_id INT PRIMARY KEY, first_name TEXT, last_name TEXT);
Create a table named customers in the testdb database, and specify the column name (customer_id / first_name / lastname) and data type (INT PRIMARY KEY / TEXT) in the table

MariaDB [testdb]>
3.6 show tables;
View the table just created

MariaDB [testdb]>
3.7 insert into customers values (1,'Tom', 'Wang');
Insert a row of test data into the customer table

MariaDB [testdb]>
3.8 select * from customers;
View the test data just inserted into the customer table

MariaDB [testdb]>
3.9 exit;
Exit the database server