Tag: MySQL 8.0

Feed: Planet MySQL; Author: Lenz Grimmer; As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona Server for MySQL 8.0.26, the storage engine will still be included in the binary builds and packages but will be disabled by default. If you are upgrading from a previous version, the TokuDB Storage Engine plugin will fail with an error message at server startup if it ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C to be a replica of B, i.e: You can follow the next steps: Note: log_replica_updates should be enabled on the soon-to-be primary as it is a prerequisite for chain replication. Note: It is assumed that both replicas only stream from Server A and there are no ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The following is a list of all function differences between MariaDB 10.7 and MySQL 8.0. It is based on functions available in the MySQL 8.0.23 and the MariaDB 10.7.0 releases. For a more complete list of differences, see Incompatibilities and Feature Differences Between MariaDB 10.7 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 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 ST_HausdorffDistance ... 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.7.0, 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: Planet MySQL; Author: Frederic Descamps; We recently saw that .frm files have been somewhat of replaced for MyISAM tables in MySQL 8.0 (see this post). However, what are those files ? Can they be used for something else than MyISAM tables ? … Let’s try to answer those questions and get more familiar with the .sdi files. What does SDI stand for ? SDI acronym stands for Serialized Dictionary Information. As you may know already, MySQL 8.0 replaced the old way to store the metadata of tables, their structure, into the new transactional Data Dictionary (in InnoDB). Additionally, that ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Contents Comparison Table See Also The following is a comparison of variables that either appear only in MariaDB 10.6 or MySQL 8.0, or have different default settings in MariaDB 10.6, and MySQL 8.0. The stable releases MariaDB 10.6.4 and MySQL 8.0.11, with only default plugins enabled, were used for the comparison. Note that MySQL 8 is an 'evergreen' release, so features may be added or removed in later releases. The most notable differences are that MariaDB includes, by default, the Aria storage engine (resulting in extra memory allocation), Galera Cluster, and has ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL 8.0.26 has been released last week ! As usual, it’s highly advised to read the release notes to get informed about the changes and bug fixed. MySQL is Open Source and each release contains contributions from our great Community. Let me thanks all the contributors on behalf of the entire MySQL Team: Thank you ! MySQL 8.0.26 includes contributions from Venkatesh Prasad Venugopal, Zhai Weixiang, Miron Balcerzak, Marc Fletcher, Zheng Lai, Huqing Yan, Lee William, Brian Yue, Marcus Ekström, Adam, Cable, Garen Chan, Xiaoyu Wang, Marcelo Altmann and Facebook. Once again, thank you ... Read More

Feed: Planet MySQL; Author: Facebook Code Engineering; MySQL, an open source database developed by Oracle, powers some of Facebook’s most important workloads. We actively develop new features in MySQL to support our evolving requirements. These features change many different areas of MySQL, including client connectors, storage engine, optimizer, and replication. Each new major version of MySQL requires significant time and effort to migrate our workloads. The challenges  include: Porting our custom features to the new version Ensuring replication is compatible between the major versions Minimizing changes needed for existing application queries Fixing performance regressions that prevent the server from supporting ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL Server 8.0.26 and 5.7.35, new versions of the popular Open Source Database Management System, have been released in conjunction with the 8.0.26 Connector and Component products.  We are also pleased to announce the release of MySQL Cluster 8.0.26, the latest GA, along with 7.6.19, 7.5.23, 7.4.33. MySQL Cluster is the distributed, shared-nothing variant of MySQL.  These releases are recommended for use on production systems and are available in source and binary form for a number of platforms from our MySQL Community download pages at: https://dev.mysql.com/downloads/ Windows packages are available via the Installer for Windows or .ZIP ... Read More

Feed: Planet MySQL; Author: Dave Stokes; You may have noticed that MySQL 8.0.26 was released today (yea!)  and I recommend reading the release notes but here are some of the highlights.TLS version 1 and 1.1 are deprecated. Please use later versions such as 1.2 and 1.3 (you made need OpenSSL 1.1.1 or higher too).More information in the server log on client timeouts includes the timeout value, and client user and host when that information is availableInternal functions to copy values between columns are improved and test at about11% faster (YMMV)There are a lot of interesting bits of information in the release notes ... Read More