MariaDB¶
[Update: May 23, 2019]
The following is information dependent RDBMS when “MariaDB” has been selected.
Overview¶
The following available functions are dependent on RDBMS.
Administration interface | CLI and WEB UI (phpMyAdmin) |
---|---|
Connection port number (CLI) | Port number 3306 (default value). It is possible to change it to an arbitrary port number. |
Connection port number (WEB UI) | Port number 443 |
In addition to the MariaDB standard installation extension, we have introduced the fol-lowing extensions to enable the "TokuDB" database engine appropriate for large amounts of data such as big data analysis. You can select and use the TokuDB engine as needed.
- TokuDB
- TokuDB_trx
- TokuDB_lock_waits
- TokuDB_locks
- TokuDB_file_map
- TokuDB_fractal_tree_info
- TokuDB_fractal_tree_block_map
- TokuDB_background_job_status
Connection to a database appliance using the mysql command¶
MySQL Command is used when connecting from the system you are using to the data-base appliance where MariaDB is active.
- To use the MySQL command line tool, it is necessary to conduct installation according to the pre-connection environment.
mysql -h [IPアドレス] -P [設定したポート番号*] -u [ユーザ名] -D [接続するデータベース名*] -p
*Can be omitted
Connection example¶
The following is an example of connection to a database appliance (MariaDB) with 192.168.1.100 via the mysql command. Here, the database port number (3306) is the default, and sakura is registered as the user
Connection as a user
$ mysql -h 192.168.1.100 -P 3306 -u sakura -D sakura -p
Enter password:[パスワードを入力してください]
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 60
Server version: 10.1.17-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ’help;’ or ’\h’ for help. Type ’\c’ to clear the current input statement.
MariaDB [sakura]>
Reference¶
- For information on MariaDB, see https://mariadb.com/ja.
- For information on phpMyAdmin, see https://www.phpmyadmin.net/.
- Please note that we will not take responsibility for information on external websites.
- The amount of log information output to the Log screen is determined by MariaDB de-fault settings (log_warnings=2) which cannot be changed. Unless a serious error has occurred most likely nothing will appear on the screen.
- Equipped with Oracle Database compatibility (MariaDB 10.3 and later).
- Supports the same data type and stored procedure for PL/SQL (MariaDB 10.3 and lat-er).