Documents Product Categories MariaDB 11 on Ubuntu Server 23.04 with Support by cloudimg

MariaDB 11 on Ubuntu Server 23.04 with Support by cloudimg

Jun 28, 2024
Ubuntu Server 23.04 – MariaDB 11 Version: 1.0.0 Created by: cloudimg Table of Contents 1.) Overview......................................................................................................................1 2.) Access & Security..........................................................................................................2 3.) System Requirements....................................................................................................2 4.) Connecting to the Instance...........................................................................................2 5.) On Startup....................................................................................................................2 6.) Filesystem Configuration..............................................................................................3 7.) Server Components......................................................................................................3 8.) Scripts and Log Files.....................................................................................................4 9.) Using System Components...........................................................................................4 1.) Overview This document is provided as a user guide for the Ubuntu Server 23.04 – MariaDB 11 product offering on the Alibaba Cloud Marketplace. Please reach out to support@cloudimg.co.uk if any issues are encountered following this user guide for the chosen product offering.2.)Access & Security Please update the security group of the target instance to allow the below ports and protocols for access and connectivity. Protocol Type Port Description SSH TCP 22 SSH connectivity Custom TCP TCP 3306 MySQL Database Listener Port for remote access 3.)System Requirements The minimum system requirements for the chosen product offering can be found below Minimum CPU Minimum RAM Required Disk Space 1 256 MB 20 GB 4.) Connecting to the Instance Once launched in the ECS Console, please connect to the instance via an SSH client using the root user with the key pair associated at launch. 5.) On Startup An OS package update script has been configured to run on boot to ensure the image is fully up to date at first use. You can disable this feature by removing the script from /stage/scripts/ and deleting the entry in crontab for the root user. Disable the OS update script from running on reboot rm -f /stage/scripts/initial_boot_update.sh crontab -e #DELETE THE BELOW LINE. SAVE AND EXIT THE FILE. @reboot /stage/scripts/initial_boot_update.sh6.) Filesystem Configuration Please see below for a screenshot of the server disk configuration and specific mount point mappings for software locations. Filesystem Size Used Avail Use% Mounted on udev 446M 0 446M 0% /dev tmpfs 95M 824K 94M 1% /run /dev/nvme0n1p3 38G 5.8G 30G 17% / tmpfs 472M 0 472M 0% /dev/shm tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 472M 0 472M 0% /sys/fs/cgroup /dev/nvme1n1 9.8G 158M 9.2G 2% /var/lib/mysql /dev/nvme0n1p2 2.0G 173M 1.7G 10% /boot /dev/loop0 56M 56M 0 100% /snap/core18/2128 /dev/loop3 56M 56M 0 100% /snap/core18/2409 /dev/loop2 68M 68M 0 100% /snap/lxd/22753 /dev/loop1 62M 62M 0 100% /snap/core20/1518 /dev/loop5 47M 47M 0 100% /snap/snapd/16292 /dev/loop4 47M 47M 0 100% /snap/snapd/16010 /dev/loop6 71M 71M 0 100% /snap/lxd/21029 tmpfs 95M 0 95M 0% /run/user/1002 Mount Point Description /boot Operating System Kernel files /var/lib/mysql MariaDB data directory 7.) Server Components Please see below for a list of installed server components and their respective installation paths. The below versions are subject to change on initial boot based on the initial_boot_update.sh script finding new versions of the software in the systems package repositories. Component Version Software HomeAliyun CLI 3 /usr/local/bin/aliyun MariaDB 11 11 /etc/mysql/mariadb.cnf 8.) Scripts and Log Files The below table provides a breakdown of any scripts & log files created to enhance the useability of the chosen offering. Script/Log Path Description Initial_boot_update.sh /stage/scripts Update the Operating System with the latest updates available. Initial_boot_update.log /stage/scripts Provides output for initial_boot_update.sh mariadb_root_password.log /stage/scripts MariaDB root database password file 9.) Using System Components Instructions can be found below for using each component of the server build mentioned in section 7 of this user guide document. Aliyun CLI Run – Once logged into the server, you may check the options available for the use of Aliyun CLI via the below command. aliyun –-help MariaDB The MariaDB Database service has been configured to start on boot, please use the below commands to start, stop and check the status of the service. #Check the MariaDB service is running service mariadb status#Stop the MariaDB service service mariadb stop #Start the MariaDB service service mariadb start You can access the MariaDB database server as the root user by referring to the instructions in the /stage/scripts/mariadb_root_password.log file. The root database user has been disabled for remote login as per best practise and therefore only a local login from the server command line will be allowed for the root user. mysql -u root -p #Enter the randomly generated password found in the /stage/scripts/mariadb_root_password.log file
To view the full page, please visit: MariaDB 11 on Ubuntu Server 23.04 with Support by cloudimg Product Userguide

MariaDB 11 on Ubuntu Server 23.04 with Support by cloudimg

This product has charges associated with it for the build, maintenance and support of the image.
Buy now