Deploy a Single Server with MariaDB Enterprise Server 10.2 on SLES 12
These instructions detail the deployment of MariaDB Enterprise Server 10.2 on SUSE Linux Enterprise Server 12 in a Single Standalone Server configuration.
These instructions detail how to deploy a single-node row database, which is suited for a transactional or OLTP workload that does not require high availability (HA). This deployment type is generally for non-production use cases, such as for development and testing.
MariaDB Platform Components
These instructions detail the deployment of the following MariaDB Platform components:
MariaDB Enterprise Server Components
These instructions detail the deployment of the following MariaDB Enterprise Server components:
MariaDB Corporation provides a ZYpp package repository for SUSE Linux Enterprise Server 12.
Install via ZYpp (SLES)
Retrieve your Customer Download Token at https://customers.mariadb.com/downloads/token/ and substitute for
customer_download_tokenin the following directions.
Configure the ZYpp package repository.
To configure ZYpp package repositories:
$ sudo zypper install wget $ wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup $ echo "99e768b24ae430b37dec7cb69cdd625396630dba18f5e1588ee24d3d8bb97064 mariadb_es_repo_setup" \ | sha256sum -c - $ chmod +x mariadb_es_repo_setup $ sudo ./mariadb_es_repo_setup --token="customer_download_token" --apply \ --mariadb-server-version="10.2"
Install MariaDB Enterprise Server and package dependencies:
$ sudo zypper install MariaDB-server MariaDB-backup
Installation only loads MariaDB Enterprise Server to the system. MariaDB Enterprise Server requires configuration before the database server is ready for use.
MariaDB Enterprise Server can be configured in the following ways:
If a system variable supports dynamic changes, then it can be set on-the-fly using the SET statement.
MariaDB's packages include several bundled configuration files. It is also possible to create custom configuration files.
On RHEL, CentOS, and SLES, MariaDB's packages bundle the following configuration files:
And on RHEL, CentOS, and SLES, custom configuration files from the following directories are read by default:
Useful system variables and options for MariaDB Enterprise Server include:
Sets the path to the data directory. MariaDB Enterprise Server writes data files to this directory, including tablespaces, logs, and schemas. Change it to use a non-standard location or to start the Server on a different data directory for testing.
Sets the local TCP/IP address on which MariaDB Enterprise Server listens for incoming connections. When testing on a local system, bind the address to the local host at
127.0.0.1to prevent network access.
Sets the port MariaDB Enterprise Server listens on. Use this system variable to use a non-standard port or when running multiple Servers on the same host for testing.
Sets the maximum number of simultaneous connections MariaDB Enterprise Server allows.
Sets how MariaDB Enterprise Server handles threads for client connections.
Sets the file name for the error log.
Sets the amount of memory InnoDB reserves for the Buffer Pool.
Sets the size for each Redo Log file and innodb_log_files_in_group sets the number of Redo Log files used by InnoDB.
Sets the maximum number of I/O operations per second that InnoDB can use.
Choose a configuration file in which to configure your system variables and options.
It not recommended to make custom changes to one of the bundled configuration files. Instead, it is recommended to create a custom configuration file in one of the included directories. Configuration files in included directories are read in alphabetical order. If you want your custom configuration file to override the bundled configuration files, then it is a good idea to prefix the custom configuration file's name with a string that will be sorted last, such as
On RHEL, CentOS, and SLES, a good custom configuration file would be:
Set your system variables and options in the configuration file.
They need to be set in a group that will be read by mysqld, such as
[mariadb] log_error = mariadbd.err innodb_buffer_pool_size = 1G
Starting the Server
MariaDB Enterprise Server includes configuration to start, stop, restart, enable/disable on boot, and check the status of the Server using the operating system default process management system.
SUSE Linux Enterprise Server 12 uses systemd. You can manage the Server process using the
Enable during startup
Disable during startup
When MariaDB Enterprise Server is up and running on your system, you should test that it is working and there weren't any issues during startup.
Connect to the server using MariaDB Client using the
$ sudo mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 38 Server version: 10.2.38-12-MariaDB-Enterprise MariaDB Enterprise Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>