Posts by MariaDB Knowledge Database
Author: MariaDB Knowledge Database
Changes and Improvements in MariaDB 10.10
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
Function Differences Between MariaDB 10.10 and MySQL 8.0
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
MariaDB 설치 (.deb 다운로드)
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
Hashicorp Key Management Plugin
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
Plans for MariaDB 10.10
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
Incompatibilities and Feature Differences Between MariaDB 10.8 and MySQL 8.0
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
create_synonym_db
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
sys_get_config
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
Function Differences Between MariaDB 10.9 and MySQL 8.0
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
Function Differences Between MariaDB 10.8 and MySQL 8.0
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
Recent Comments