- Home
- Tag: MariaDB
Posts tagged MariaDB
Tag: MariaDB
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
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
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
MariaDB performance tuning and MySQL performance tuning

One of the most popular database servers is MariaDB, which was forked from the MySQL project in 2009. MariaDB is a robust database, and like all complex systems it needs tuning to run at its best. History of MySQL and MariaDB In the world of technology, MySQL is among the most popular open-source databases. In the past, MySQL was an independent company that provided both open-source and commercial databases. MySQL was acquired by Sun Microsystems, and Sun was then acquired by Oracle several years later. As a result of Oracle’s acquisition of Sun, the original MySQL developers forked a project ... Read More
Amazon RDS for MariaDB now supports M6i and R6i instances with new instance sizes up to 128 vCPUs and 1,024 GiB RAM.
Feed: Recent Announcements. Amazon Relational Database Service (Amazon RDS) for MariaDB, version 10.4 and higher, now supports M6i and R6i instances. M6i instances are the 6th generation of Amazon EC2 x86-based General Purpose compute instances, designed to provide a balance of compute, memory, storage, and network resources. R6i instances are the 6th generation of Amazon EC2 memory optimized instances, designed for memory-intensive workloads. Both M6i and R6i instances are built on the AWS Nitro System, a combination of dedicated hardware and lightweight hypervisor, which delivers practically all of the compute and memory resources of the host hardware to your instances ... Read More
MariaDB Docker Environment Variables
Feed: MariaDB Knowledge Base Article Feed. Author: . When you start the %%IMAGE%% image, you can adjust the initialization of the MariaDB instance by passing one or more environment variables on the docker run command line. Do note that none of the variables below will have any effect if you start the container with a data directory that already contains a database: any pre-existing database will always be left untouched on container startup. From tag 10.2.38, 10.3.29, 10.4.19, 10.5.10 onwards, and all 10.6 and later tags, the MARIADB_* equivalent variables are provided. MARIADB_* variants will always be used in preference ... Read More
Recent Comments