Author: MariaDB Knowledge Database

Feed: MariaDB Knowledge Base Article Feed. Author: . The most recent release of MariaDB 10.10 is:MariaDB 10.10.0 preview releases Download Now MariaDB 10.10 is a current development branch. See Plans for MariaDB 10.10. New Features & Improvements Replication Change defaults for CHANGE MASTER TO so that GTID-based replication is used by default if master supports it (MDEV-19801) Deprecate MASTER_USE_GTID=Current_Pos to favor new MASTER_DEMOTE_TO_SLAVE option (MDEV-20122) Optimizer Improve optimization of joins with many tables, including eq_ref tables (MDEV-28852) Table elimination does not work across derived tables (MDEV-26278) UCA14 Collation DDL Galera Implement a method to add IPs to allowlist for Galera Cluster ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The following is a list of all function differences between MariaDB 10.10 and MySQL 8.0. It is based on functions available in the MySQL 8.0.24 and the MariaDB 10.10.0 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.10 and MySQL 8.0 Present in MariaDB Only Dynamic Columns Galera General Geographic MySQL has removed the following functions in MySQL 8.0. JSON Sequences Window Functions Miscellaneous Present in MySQL Only GTID MariaDB and MySQL have differing GTID implementations. GTID_SUBSET GTID_SUBTRACT WAIT_FOR_EXECUTED_GTID_SET WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS Geographic MBRCOVEREDBY ST_BUFFER_STRATEGY ST_Collect ST_FrechetDistance ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . APT를 사용한 MariaDB 설치 Debian, Ubuntu, 그리고 다른 유사한 Linux 배포판에서는 apt, aptitude, Ubuntu Software Center, Synaptic Package Manager, 또는 다른 패키지 매니저를 사용하여 MariaDB의 저장소에서 관련 .deb 패키지를 설치할 수 있습니다. 이 페이지에서는 apt를 사용한 간단한 설치 단계를 안내합니다. APT 저장소에 MariaDB 추가하기 현재 다음 Linux 배포판에 대한 APT 저장소가 있습니다.: Debian 9 (Jessie) Debian 10 (Buster) Debian 11 (Bullseye) Debian Unstable (Sid) Ubuntu 18.04 LTS (Bionic) Ubuntu 20.04 LTS (Focal) Ubuntu 20.10 (Groovy) Ubuntu 21.04 (Hirsute) Ubuntu 21.10 (Impish) MariaDB 패키지 저장소 설치 MariaDB Package Repository apt를 사용하여 MariaDB를 설치할 ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB starting with 10.9The Hashicorp Key Management Plugin is used to implement encryption using keys stored in the Hashicorp Vault KMS. The current version of this plugin implements the following features: Authentication is done using the Hashicorp Vault's token authentication method; If additional client authentication is required, then the path to the CA authentication bundle file may be passed as a plugin parameter; The creation of the keys and their management is carried out using the Hashicorp Vault KMS and their tools; The plugin uses libcurl (https) as an interface to the ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.10 is an upcoming major development release. JIRA We manage our development plans in JIRA, so the definitive list will be there. This search shows what we currently plan for 10.10. It shows all tasks with the Fix-Version being 10.10. Not all these tasks will really end up in 10.10 but tasks with the "red" priorities have a much higher chance of being done in time for 10.10. Practically, you can think of these tasks as "features that will be in 10.10". Tasks with the "green" priorities probably won't be in ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Not all character sets and collations are supported across both MySQL and MariaDB. As of 10.8.3, MariaDB supports 40 character sets and 322 collations (armscii8_general_nopad_ci, armscii8_nopad_bin, ascbig5_chinese_nopad_ci, big5_nopad_bin, iicp1250_general_nopad_ci, cp1250_nopad_bin, cp1250_general_nopad_ci, cp1250_nopad_bin, cp1251_general_nopad_ci, cp1251_nopad_bin, cp1256_general_nopad_ci, cp1256_nopad_bin, cp1257_general_nopad_ci, cp1257_nopad_bin, cp850_general_nopad_ci, cp850_nopad_bin, cp852_general_nopad_ci, cp852_nopad_bin, cp866_general_nopad_ci, cp866_nopad_bin, cp932_japanese_nopad_ci, cp932_nopad_bin, dec8_nopad_bin, dec8_swedish_nopad_ci, eucjpms_japanese_nopad_ci, eucjpms_nopad_bin, eucjpms_japanese_nopad_ci, eucjpms_nopad_bin, euckr_korean_nopad_ci, euckr_nopad_bin, gb2312_chinese_nopad_ci, gb2312_nopad_bin, gbk_chinese_nopad_ci, gbk_nopad_bin, geostd8_general_nopad_ci, geostd8_nopad_bin, greek_general_nopad_ci, greek_nopad_bin, hebrew_general_nopad_ci, hebrew_nopad_bin, hp8_english_nopad_ci, hp8_nopad_bin, keybcs2_general_nopad_ci, keybcs2_nopad_bin, koi8r_general_nopad_ci, koi8r_nopad_bin, koi8u_general_nopad_ci, koi8u_nopad_bin, latin1_nopad_bin, latin1_swedish_nopad_ci, latin2_general_nopad_ci, latin2_nopad_bin, latin5_nopad_bin, latin5_turkish_ci, latin5_turkish_nopad_ci, latin7_general_nopad_ci, latin7_nopad_bin, macce_general_nopad_ci, macce_nopad_bin, macroman_general_nopad_ci, macroman_nopad_bin, sjis_japanese_nopad_ci, sjis_nopad_bin, swe7_nopad_bin, tis620_thai_nopad_ci, tis620_nopad_bin, ucs2_croatian_mysql561_ci, ucs2_general_mysql500_ci, ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Syntax create_synonym_db(db_name,synonym) # db_name (VARCHAR(64)) # synonym (VARCHAR(64)) Description create_synonym_db is a stored procedure available with the Sys Schema. Takes a source database name db_name and synonym name and creates a synonym database with views that point to all of the tables within the source database. Useful for example for creating a synonym for the performance_schema or information_schema databases. Returns an error if the source database doesn't exist, or the synonym already exists. Example SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Syntax sys.sys_get_config(name,default) Description sys_get_config is a stored function available with the Sys Schema. The function returns a configuration option value from the sys_config table. It takes two arguments; name, a configuration option name, and default, which is returned if the given option does not exist in the table. Both arguments are VARCHAR(128) and can be NULL. Returns NULL if name is NULL, or if the given option is not found and default is NULL. Examples SELECT sys.sys_get_config('ps_thread_trx_info.max_length',NULL); +----------------------------------------------------------+ | sys.sys_get_config('ps_thread_trx_info.max_length',NULL) | +----------------------------------------------------------+ | 65535 | +----------------------------------------------------------+ See Also Comments Content reproduced on ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The following is a list of all function differences between MariaDB 10.9 and MySQL 8.0. It is based on functions available in the MySQL 8.0.24 and the MariaDB 10.9.1 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.9 and MySQL 8.0 Present in MariaDB Only Dynamic Columns Galera General Geographic MySQL has removed the following functions in MySQL 8.0. JSON Sequences Window Functions Miscellaneous Present in MySQL Only GTID MariaDB and MySQL have differing GTID implementations. GTID_SUBSET GTID_SUBTRACT WAIT_FOR_EXECUTED_GTID_SET WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS Geographic MBRCOVEREDBY ST_BUFFER_STRATEGY ST_Collect ST_FrechetDistance ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The following is a list of all function differences between MariaDB 10.8 and MySQL 8.0. It is based on functions available in the MySQL 8.0.23 and the MariaDB 10.8.3 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.8 and MySQL 8.0 Present in MariaDB Only Dynamic Columns Galera General Geographic MySQL has removed the following functions in MySQL 8.0. JSON Sequences Window Functions Miscellaneous Present in MySQL Only GTID MariaDB and MySQL have differing GTID implementations. GTID_SUBSET GTID_SUBTRACT WAIT_FOR_EXECUTED_GTID_SET WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS Geographic MBRCOVEREDBY ST_BUFFER_STRATEGY ST_FrechetDistance ST_GeoHash ... Read More