MariaDB MariaDB 10.2.5 RC now available

eva2000 · Apr 6, 2017

MariaDB 10.2 is the current development series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.

MariaDB 10.2.5 is a Release Candidate (RC) release.

For an overview of MariaDB 10.2 see the What is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

TokuDB updated to 5.6.35-80.0

PCRE updated to 8.40

MDEV-12160: ed25519 authentication plugin

MDEV-11842: Fix a 10.1.21 regression with failed INSERT, BEFORE INSERT triggers, and columns with no default value

MDEV-12075: Fix a 10.1.21 regression in the InnoDB data file extension code

MDEV-11027: better InnoDB crash recovery progress reporting

MDEV-11520: improvements to how InnoDB data files are extended

Improvements to InnoDB startup/shutdown to make it more robust

MDEV-11233: fix for FULLTEXT index crash

MDEV-9734: systemd compatible bintar files now available

MDEV-9658: RocksDB alpha storage engine added

This is an alpha version of this storage engine with limited functionality at this time

Currently, zlib and snappy compression is supported (only zlib on Windows)

RocksDB is not available for 32-bit platforms

AWS Key Management plugin added for Windows, CentOS, RHEL, and Fedora packages

Fixes for the following security vulnerabilities:

CVE-2017-3313

CVE-2017-3302

Notes
For a complete list of changes made in MariaDB 10.2.4, with links to detailed information on each push, see the changelog.
Click to expand...

The post MariaDB 10.2.5 RC now available appeared first on MariaDB.org.

Continue reading...

eva2000 · Apr 6, 2017

AWS Key Management plugin added for Windows, CentOS, RHEL, and Fedora packages

Click to expand...

interesting feature that apparently is available from MariaDB Enterprise 10.1.13 AWS Key Management Encryption Plugin

The AWS Key Management plugin uses the Amazon Web Services (AWS) Key Management Service (KMS) for encryption at rest.

The plugin uses AWS Key management service to generate and store AES keys on disk, in encrypted form. The plugin will decrypt them in memory, using the AWS KMS "Decrypt" API function, and MariaDB data will then be decrypted using AES and plaintext key.

The AWS KMS plugin is included in MariaDB Enterprise packages, on OSs where it can be built, starting with MariaDB Enterprise 10.1.13. For more information, consult the Amazon Web Services (AWS) Key Management Service (KMS) Encryption Plugin Setup Guide.
Click to expand...

eva2000 · Apr 9, 2017

More on MyRocks addition MyRocks available in MariaDB 10.2 Release Candidate 2 | MariaDB

Now, we’re releasing MariaDB Server 10.2.5, which is Release Candidate number 2. Although this is a Release Candidate, there is one significant new piece in it, namely MyRocks. MyRocks is a storage engine developed by Facebook using RocksDB as the backend. Some of the benefits of MyRocks are that it provides great compression, it’s write efficient and data loading is fast. The MyRocks site has more information about the benefits and you can learn more about MyRocks in MariaDB on our blog.

Since MyRocks originally was developed by Facebook, the focus was to make it especially suitable for their needs, i.e. their workloads and platforms. Under the lead of our developer Sergey Petrunia, MyRocks was now included in MariaDB. MyRocks in MariaDB is constantly being merged with upstream MyRocks from Facebook.

The goal was to make MyRocks available as a storage engine in MariaDB Server for every MariaDB user to consume on whatever platform they use (with some exceptions for 32-bit platforms and older Linuxes). With MyRocks now included in RC2 of 10.2 that goal has been accomplished. MyRocks is available in the MariaDB Server packages for most Linux distributions and is available for Windows users too.

- See more at: MyRocks available in MariaDB 10.2 Release Candidate 2 | MariaDB
Click to expand...

eva2000 · Apr 9, 2017

Code (Text):

mysqladmin  Ver 9.1 Distrib 10.2.5-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Server version          10.2.5-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 sec

Threads: 5  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 1.000

Code (Text):

mysql -t -e "SHOW PLUGINS;"
+-------------------------------+----------+--------------------+------------------------+---------+
| Name                          | Status   | Type               | Library                | License |
+-------------------------------+----------+--------------------+------------------------+---------+
| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
| partition                     | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| METADATA_LOCK_INFO            | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
| QUERY_CACHE_INFO              | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
| QUERY_RESPONSE_TIME           | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
| QUERY_RESPONSE_TIME_AUDIT     | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
+-------------------------------+----------+--------------------+------------------------+---------+

Code (Text):

mysql -t -e "SHOW ENGINES;"
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                                               | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                                            | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

Revenge · Apr 9, 2017

I don't see MyRocks there.

eva2000 · Apr 9, 2017

yeah not seeing it myself either - no ha_rocksdb.so found

Code (Text):

rpm -ql MariaDB-server | grep ha_
/usr/lib64/mysql/plugin/ha_archive.so
/usr/lib64/mysql/plugin/ha_blackhole.so
/usr/lib64/mysql/plugin/ha_federated.so
/usr/lib64/mysql/plugin/ha_federatedx.so
/usr/lib64/mysql/plugin/ha_mroonga.so
/usr/lib64/mysql/plugin/ha_sphinx.so
/usr/lib64/mysql/plugin/ha_spider.so

Might be source install only Building MyRocks in MariaDB ?

Revenge · May 8, 2017

I was reading some comments on their Jira, and it seems 10.2 will not ship with xtradb at all, but only with Oracle Innodb.

They even are working in a commit for configurations where they were using xtradb parameters: [MDEV-12472] InnoDB should accept XtraDB parameters, warning that they are ignored - JIRA

Did they give any explanation for this decision?

eva2000 · May 8, 2017

Revenge said: ↑

I was reading some comments on their Jira, and it seems 10.2 will not ship with xtradb at all, but only with Oracle Innodb.

They even are working in a commit for configurations where they were using xtradb parameters: [MDEV-12472] InnoDB should accept XtraDB parameters, warning that they are ignored - JIRA

Did they give any explanation for this decision?
Click to expand...

woah that's news to me. But seems Oracle MySQL 5.7 InnoDB plugin is more performant than Percona's XtraDB InnoDB so maybe why ?

MDEV-12472: InnoDB should accept XtraDB parameters, warning that they… · MariaDB/server@b297b31 · GitHub wow.. might be a surprise to some folks who do use Percona XtraDB InnoDB specific options !

there's Percona XtraDB InnoDB options will be gone in MariaDB 10.2.x then

-adaptive_hash_index_partitions
-additional_mem_pool_size
-api_bk_commit_interval
-api_disable_rowlock
-api_enable_binlog
-api_enable_mdl
-api_trx_level
-buffer_pool_populate
-cleaner_eviction_factor
-cleaner_flush_chunk_size
-cleaner_free_list_lwm
-cleaner_lru_chunk_size
-cleaner_lsn_age_factor
-cleaner_max_flush_time
-cleaner_max_lru_time
-corrupt_table_action
-empty_free_list_algorithm
-fake_changes
-file_io_threads
-foreground_preflush
-kill_idle_transaction
-locking_fake_changes
-log_arch_dir
-log_arch_expire_sec
-log_archive
-log_block_size
-log_checksum_algorithm
-max_bitmap_file_size
-max_changed_pages
-mirrored_log_groups
-priority_cleaner
-priority_io
-priority_master
-priority_purge
-sched_priority_cleaner
-sched_priority_io
-sched_priority_master
-sched_priority_purge
-show_locks_held
-show_verbose_locks
-stats_include_delete_marked
-track_changed_pages
-track_redo_log_now
-use_global_flush_log_at_trx_commit
-use_stacktrace
-use_sys_malloc
Click to expand...

Log in / Register

Forums

Get the most out of your Centmin Mod LEMP stack

MariaDB MariaDB 10.2.5 RC now available

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

Revenge Active Member

eva2000 Administrator Staff Member

Revenge Active Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Get the most out of your Centmin Mod LEMP stack

MariaDB MariaDB 10.2.5 RC now available

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

Revenge Active Member

eva2000 Administrator Staff Member

Revenge Active Member

eva2000 Administrator Staff Member

.