Author: MariaDB Knowledge Database

Feed: MariaDB Knowledge Base Article Feed. Author: . MyRocks supports several compression algorithms. Supported Compression Algorithms Supported compression algorithms can be checked like so: show variables like 'rocksdb%compress%'; +-------------------------------------+------------------------------------+ | Variable_name | Value | +-------------------------------------+------------------------------------+ | rocksdb_supported_compression_types | Snappy,Zlib,LZ4,LZ4HC,ZSTDNotFinal | +-------------------------------------+------------------------------------+ Another way to make the check is to look into #rocksdb/LOG file in the data directory. It should have lines like: 2019/04/12-14:08:23.869919 7f839188b540 Compression algorithms supported: 2019/04/12-14:08:23.869920 7f839188b540 kZSTDNotFinalCompression supported: 1 2019/04/12-14:08:23.869922 7f839188b540 kZSTD supported: 1 2019/04/12-14:08:23.869923 7f839188b540 kXpressCompression supported: 0 2019/04/12-14:08:23.869924 7f839188b540 kLZ4HCCompression supported: 1 2019/04/12-14:08:23.869924 7f839188b540 kLZ4Compression supported: 1 2019/04/12-14:08:23.869925 7f839188b540 kBZip2Compression supported: 0 2019/04/12-14:08:23.869926 7f839188b540 kZlibCompression ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.3 is the current major stable version. The first stable release was in May 2018, and it will be supported until May 2023. For details on upgrading from MariaDB 10.2, see Upgrading from MariaDB 10.2 to 10.3. MariaDB Server 10.3 is included in MariaDB TX 3.0. Watch the webinar recording to learn more about the new features included in this release. The following lists the major new features in MariaDB 10.3: Implemented Features Syntax / General Features System-versioned tables (also known as AS OF) (MDEV-12894) Table Value Constructors (MDEV-12172) — GSoC ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . With MariaDB Kubernetes Operator you can deploy MariaDB Platform on a Kubernetes Cluster, using one of several cluster topologies. When creating a cluster, you can set the specific topology you want to use with the cluster.topology parameter. The topology determines: Optimizations: Whether to optimize MariaDB Platform for Transactional or Analytical workloads Default Containers: The number of containers created by default Load-balancing: Whether the cluster uses MariaDB MaxScale to load-balance between containers Replication: Whether MariaDB Server containers deploy as master/slave or multi-master replication clusters Transactional Processing Topologies In cases where you need MariaDB ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This article does not apply to the thread pool implementation on Windows. On Windows, MariaDB uses a native thread pool created with the CreateThreadpool APl, which has its own methods to distribute threads between CPUs. On Unix, the thread pool implementation uses objects called thread groups to divide up client connections into many independent sets of threads. The thread_pool_size system variable defines the number of thread groups on a system. Generally speaking, the goal of the thread group implementation is to have one running thread on each CPU on the system at ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This tutorial is a quick overview of what the MaxScale REST API offers, how it can be used to inspect the state of MaxScale and how to use it to modify the runtime configuration of MaxScale. The tutorial uses the curl command line client to demonstrate how the API is used. Configuration and Hardening The MaxScale REST API listens on port 8989 on the local host. The admin_port and admin_host parameters control which port and address the REST API listens on. Note that for security reasons the API only listens for local ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This filter adds routing hints to a service. The filter has no parameters. Note: If a query has more than one comment only the first comment is processed. Always place any MaxScale related comments first before any other comments that might appear in the query. The client connection will need to have comments enabled. For example the mysql command line client has comments disabled by default and they need to be enabled by passing the -c option. Most, if not all, connectors keep all comments intact in executed queries. For comment types, ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.4MariaDB 10.4 introduces a number of changes to the authentication process, intended to make things easier and more intuitive. Overview There are four main changes relating to authentication: The default authentication method is now the unix_socket plugin, which allows the use of operating system credentials when connecting to MariaDB via the local Unix socket file. Remember, the best way to keep your password safe is not to have one! It is possible to use more than one method to authenticate, for example migrating users to the more secure ed25519 ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Security-Enhanced Linux (SELinux) is a Linux kernel module that provides a framework for configuring mandatory access control (MAC) system for many resources on the system. It is enabled by default on some Linux distributions, including RHEL, CentOS, Fedora, and other similar Linux distribution. SELinux prevents programs from accessing files, directories or ports unless it is configured to access those resources. Verifying Whether SELinix Is Enabled To verify whether SELinux is enabled, execute the getenforce command. For example: getenforce Changing SELinux's Mode Sometimes it can be helpful to permanently set SELinux to permissive ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.1Since MariaDB 10.1, the MySQL-wsrep patch has been merged into MariaDB Server. Therefore, in MariaDB 10.1 and above, the functionality of MariaDB Galera Cluster can be obtained by installing the standard MariaDB Server packages and the Galera wsrep provider library package. Beginning in MariaDB 10.1, Galera Cluster ships with the MariaDB Server. Upgrading a Galera Cluster node is very similar to upgrading a server from MariaDB 10.2 to MariaDB 10.3. For more information on that process as well as incompatibilities between versions, see the Upgrade Guide. In order to ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . BACKUP LOCK blocks a table from DDL statements. This is mainly to be used by tools like mariabackup that needs to ensure that there are no DDL's on a table while the table files are opened. For example for an Aria table stores data in 3 files with extensions .frm, .MAI and .MAD. Normal read/write operations can continue as normal. Syntax To lock table: BACKUP LOCK table_name To unlock table: BACKUP UNLOCK BACKUP LOCK [database.]table_name; - Open all files related to a table (for example, t.frm, t.MAI and t.MYD) BACKUP UNLOCK; - ... Read More