MariaDB MariaDB 10.1.7 now available - upgrade for Centmin Mod LEMP stack

eva2000 · Sep 10, 2015

Download MariaDB 10.1.7

Release Notes Changelog What is MariaDB 10.1?

MariaDB APT and YUM Repository Configuration Generator

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.7. This is a Release Candidate (RC) release.

See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.1? page in the MariaDB Knowledge Base for general information about the MariaDB 10.1 series.

Thanks, and enjoy MariaDB!

Continue reading...

eva2000 · Sep 10, 2015

finally first RC release for MariaDB 10.1 branch What is MariaDB 10.1? - MariaDB Knowledge Base

Been looking forward to MariaDB 10.1 for it's Facebook WebScale MySQL patches [MDEV-6039] WebScaleSQL patches - JIRA + MySQL 5.7 backports
Code:
mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.1.7-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

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

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

pamamolf · Sep 10, 2015

Is there any release date for the final version?

eva2000 · Sep 10, 2015

haven't check TBH

testing 123.09beta01 test branch for mariadb 10.0 to 10.1.7 update

Code:

--------------------------------------------------------
Centmin Mod 1.2.3-eva2000.09 - http://centminmod.com
--------------------------------------------------------
                   Centmin Mod Menu                
--------------------------------------------------------
1).  Centmin Install
2).  Add Nginx vhost domain
3).  NSD setup domain name DNS
4).  Nginx Upgrade / Downgrade
5).  PHP Upgrade / Downgrade
6).  XCache Re-install
7).  APC Cache Re-install
8).  XCache Install
9).  APC Cache Install
10). Memcached Server Re-install
11). MariaDB 5.2/5.5 & 10.x Upgrade Sub-Menu
12). Zend OpCache Install/Re-install
13). Install ioping.sh vbtechsupport.com/1239/
14). SELinux disable
15). Install/Reinstall ImagicK PHP Extension
16). Change SSHD Port Number
17). Multi-thread compression: pigz,pbzip2,lbzip2...
18). Suhosin PHP Extension install
19). Install FFMPEG and FFMPEG PHP Extension
20). NSD Re-install
21). Update - Nginx + PHP-FPM + Siege
22). Add Wordpress Nginx vhost + WP Super Cache
23). Update Centmin Mod Code Base
24). Exit
--------------------------------------------------------
Enter option [ 1 - 24 ] 11
--------------------------------------------------------

Code:

--------------------------------------------------------
        MariaDB MySQL Upgrade Sub-Menu           
--------------------------------------------------------
1). MariaDB 5.2.x Branch Upgrade Only
2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
6). Back to Main menu
--------------------------------------------------------
Enter option [ 1 - 6 ] 4
--------------------------------------------------------
Place holder for now until MariaDB 10.1.x is ready to be added

Code:

--------------------------------------------------------
        MariaDB MySQL Upgrade Sub-Menu           
--------------------------------------------------------
1). MariaDB 5.2.x Branch Upgrade Only
2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
6). Back to Main menu
--------------------------------------------------------
Enter option [ 1 - 6 ] 5
--------------------------------------------------------

Code:

--------------------------------------------------------------------------------
This script's MariaDB 10.1.x upgrade process is still in beta testing stages.
So please test on a test server and not a live production server. But if you use
on live server or if MySQL databases already exist, please back them up before
running this upgrade script via mysqldump - instructions at:
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.

###############################################################
###        IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE        ###
###      OR RISK DATA LOSS DUE TO MARIADB 10.1 Changes      ###
###############################################################

For each DATABASENAME backup via mysqldump i.e.

  mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
--------------------------------------------------------------------------------

Have you backed up your databases ? [y/n] y

MariaDB 10.1.x no longer works with mydumper
MySQL backup tool. But still works with MariaDB 5.2.x
Do you want to continue with upgrade to MariaDB 10.1.x ? [y/n] y

Code:

*************************************************
MariaDB 10.1.x Repo setup...
*************************************************

Loaded plugins: fastestmirror, priorities
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
Cleaning repos: base epel extras mariadb rpmforge updates
Cleaning up everything
Cleaning up list of fastest mirrors
rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB

*************************************************
MariaDB 10.1.x check available packages
yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
*************************************************

Installed Packages
MariaDB-client.x86_64               10.0.17-1.el7.centos                @mariadb
MariaDB-common.x86_64               10.0.17-1.el7.centos                @mariadb
MariaDB-compat.x86_64               10.0.17-1.el7.centos                @mariadb
MariaDB-devel.x86_64                10.0.17-1.el7.centos                @mariadb
MariaDB-shared.x86_64               10.0.17-1.el7.centos                @mariadb
Available Packages
MariaDB-client.x86_64               10.1.7-1.el7.centos                 mariadb
MariaDB-common.x86_64               10.1.7-1.el7.centos                 mariadb
MariaDB-compat.x86_64               10.1.7-1.el7.centos                 mariadb
MariaDB-devel.x86_64                10.1.7-1.el7.centos                 mariadb
MariaDB-server.x86_64               10.1.7-1.el7.centos                 mariadb
MariaDB-shared.x86_64               10.1.7-1.el7.centos                 mariadb
mariadb-devel.x86_64                1:5.5.44-1.el7_1                    updates
mariadb-server.x86_64               1:5.5.44-1.el7_1                    updates

real    0m16.967s
user    0m5.146s
sys     0m0.559s

*************************************************
MariaDB 10.1.x YUM install...
yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
*************************************************

Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* base: centos.mirror.serversaustralia.com.au
* epel: fedora.mirror.serversaustralia.com.au
* extras: mirror.aarnet.edu.au
* rpmforge: mirror.ventraip.net.au
* updates: mirror.aarnet.edu.au
152 packages excluded due to repository priority protections
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.17-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.1.7-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.0.17-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.1.7-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.0.17-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.1.7-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.0.17-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.1.7-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.1.7-1.el7.centos will be installed
--> Processing Dependency: libjemalloc.so.1()(64bit) for package: MariaDB-server-10.1.7-1.el7.centos.x86_64
---> Package MariaDB-shared.x86_64 0:10.0.17-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.1.7-1.el7.centos will be an update
--> Running transaction check
---> Package jemalloc.x86_64 0:3.6.0-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package             Arch        Version                     Repository    Size
================================================================================
Installing:
MariaDB-server      x86_64      10.1.7-1.el7.centos         mariadb       96 M
Updating:
MariaDB-client      x86_64      10.1.7-1.el7.centos         mariadb       38 M
MariaDB-common      x86_64      10.1.7-1.el7.centos         mariadb       43 k
MariaDB-compat      x86_64      10.1.7-1.el7.centos         mariadb      1.4 M
MariaDB-devel       x86_64      10.1.7-1.el7.centos         mariadb      6.5 M
MariaDB-shared      x86_64      10.1.7-1.el7.centos         mariadb      1.3 M
Installing for dependencies:
jemalloc            x86_64      3.6.0-1.el7                 epel         105 k

Transaction Summary
================================================================================
Install  1 Package  (+1 Dependent package)
Upgrade  5 Packages

Total download size: 143 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
--------------------------------------------------------------------------------
Total                                              3.5 MB/s | 143 MB  00:41  
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Updating   : MariaDB-common-10.1.7-1.el7.centos.x86_64                   1/12
  Updating   : MariaDB-client-10.1.7-1.el7.centos.x86_64                   2/12
  Installing : jemalloc-3.6.0-1.el7.x86_64                                 3/12
  Installing : MariaDB-server-10.1.7-1.el7.centos.x86_64                   4/12
  Updating   : MariaDB-devel-10.1.7-1.el7.centos.x86_64                    5/12
  Updating   : MariaDB-compat-10.1.7-1.el7.centos.x86_64                   6/12
  Updating   : MariaDB-shared-10.1.7-1.el7.centos.x86_64                   7/12
  Cleanup    : MariaDB-devel-10.0.17-1.el7.centos.x86_64                   8/12
  Cleanup    : MariaDB-shared-10.0.17-1.el7.centos.x86_64                  9/12
  Cleanup    : MariaDB-compat-10.0.17-1.el7.centos.x86_64                 10/12
  Cleanup    : MariaDB-client-10.0.17-1.el7.centos.x86_64                 11/12
  Cleanup    : MariaDB-common-10.0.17-1.el7.centos.x86_64                 12/12
  Verifying  : MariaDB-server-10.1.7-1.el7.centos.x86_64                   1/12
  Verifying  : MariaDB-devel-10.1.7-1.el7.centos.x86_64                    2/12
  Verifying  : MariaDB-client-10.1.7-1.el7.centos.x86_64                   3/12
  Verifying  : MariaDB-common-10.1.7-1.el7.centos.x86_64                   4/12
  Verifying  : jemalloc-3.6.0-1.el7.x86_64                                 5/12
  Verifying  : MariaDB-compat-10.1.7-1.el7.centos.x86_64                   6/12
  Verifying  : MariaDB-shared-10.1.7-1.el7.centos.x86_64                   7/12
  Verifying  : MariaDB-common-10.0.17-1.el7.centos.x86_64                  8/12
  Verifying  : MariaDB-shared-10.0.17-1.el7.centos.x86_64                  9/12
  Verifying  : MariaDB-compat-10.0.17-1.el7.centos.x86_64                 10/12
  Verifying  : MariaDB-devel-10.0.17-1.el7.centos.x86_64                  11/12
  Verifying  : MariaDB-client-10.0.17-1.el7.centos.x86_64                 12/12

Installed:
  MariaDB-server.x86_64 0:10.1.7-1.el7.centos                                

Dependency Installed:
  jemalloc.x86_64 0:3.6.0-1.el7                                              

Updated:
  MariaDB-client.x86_64 0:10.1.7-1.el7.centos                                
  MariaDB-common.x86_64 0:10.1.7-1.el7.centos                                
  MariaDB-compat.x86_64 0:10.1.7-1.el7.centos                                
  MariaDB-devel.x86_64 0:10.1.7-1.el7.centos                                 
  MariaDB-shared.x86_64 0:10.1.7-1.el7.centos                                

Complete!

real    1m11.911s
user    0m31.329s
sys     0m3.876s

Code:

*************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
  for MariaDB 10.1.x my.cnf compatibility
*************************************************

systemctl start mysql.service
systemctl restart mysql.service
total 269M
-rw-rw----. 1 mysql mysql    0 Apr  3 02:00 multi-master.info
drwx--x--x. 2 mysql mysql 4.0K Apr  3 02:00 mysql
drwx------. 2 mysql mysql 4.0K Apr  3 02:00 performance_schema
-rw-r--r--. 1 mysql mysql   15 Apr  3 02:00 mysql_upgrade_info
-rw-r-----. 1 mysql mysql 1.8K Apr  3 02:00 centos7.localdomain.err
-rw-rw----. 1 mysql mysql 128K Apr  3 02:00 ib_logfile1.gz
-rw-rw----. 1 mysql mysql 128K Apr  3 02:00 ib_logfile0.gz
-rw-rw----. 1 mysql mysql 128M Apr  3 02:00 ib_logfile1
-rw-rw----. 1 mysql mysql   52 Sep  9 22:12 aria_log_control
-rw-rw----. 1 mysql mysql  16K Sep  9 22:12 aria_log.00000001
-rw-rw----  1 mysql mysql  872 Sep  9 22:12 ib_buffer_pool
-rw-rw----. 1 mysql mysql  12M Sep  9 22:14 ibdata1
-rw-rw----. 1 mysql mysql 128M Sep  9 22:14 ib_logfile0
-rw-rw----  1 mysql mysql  24K Sep  9 22:14 tc.log
srwxrwxrwx  1 mysql mysql    0 Sep  9 22:14 mysql.sock
-rw-rw----  1 mysql mysql    5 Sep  9 22:14 centos7.localdomain.pid

Code:

mysql_upgrade --verbose
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Phase 1/6: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Phase 2/6: Fixing views
Processing databases
information_schema
mysql
performance_schema
Phase 3/6: Running 'mysql_fix_privilege_tables'
Phase 4/6: Fixing table and database names
Processing databases
information_schema
mysql
performance_schema
Phase 5/6: Checking and upgrading tables
Processing databases
information_schema
performance_schema
Phase 6/6: Running 'FLUSH PRIVILEGES'
OK

Code:

------------------------------------------------
Installing MariaDB 10 plugins
------------------------------------------------
mysql -e "INSTALL SONAME 'metadata_lock_info';"
mysql -e "INSTALL SONAME 'query_cache_info';"
mysql -e "INSTALL SONAME 'query_response_time';"
mysql -t -e "SELECT * FROM mysql.plugin;"
+---------------------------+------------------------+
| name                      | dl                     |
+---------------------------+------------------------+
| METADATA_LOCK_INFO        | metadata_lock_info.so  |
| QUERY_CACHE_INFO          | query_cache_info.so    |
| QUERY_RESPONSE_TIME       | query_response_time.so |
| QUERY_RESPONSE_TIME_AUDIT | query_response_time.so |
+---------------------------+------------------------+

Code:

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     |
| XTRADB_READ_VIEW              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| XTRADB_INTERNAL_HASH_TABLES   | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| XTRADB_RSEG                   | ACTIVE   | INFORMATION SCHEMA | 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_CHANGED_PAGES          | 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     |
| CHANGED_PAGE_BITMAPS          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| 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:

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             | DEFAULT | MyISAM storage engine                                                                            | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
| InnoDB             | YES     | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
systemctl restart mysql.service


------------------------------------------------
MariaDB 10.1.x Upgrade completed
------------------------------------------------

Code:

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

Server version          10.1.7-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 6 min 47 sec

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

Once updated to MariaDB 10.1, you can use regular yum update to update minor versions within MariaDB 10.1.x branch

Code:

yum update MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared

pamamolf · Sep 17, 2015

MariaDB® Closes the Gap in Data Security with Open Source Database Encryption Contributed by Google | MariaDB

Cool news and it will be great to have an example of encrypting data on the database as it is not required changes on app code.....

eva2000 · Sep 17, 2015

it's in the official site docs Data at Rest Encryption - MariaDB Knowledge Base

pamamolf · Sep 18, 2015

No automated tricks for this using Centminmod?

eva2000 · Sep 18, 2015

pamamolf said: ↑

No automated tricks for this using Centminmod?
Click to expand...

all manual !

Log in / Register

Forums

Learn about Centmin Mod LEMP Stack today

MariaDB MariaDB 10.1.7 now available - upgrade for Centmin Mod LEMP stack

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

pamamolf Premium Member Premium Member

eva2000 Administrator Staff Member

pamamolf Premium Member Premium Member

eva2000 Administrator Staff Member

pamamolf Premium Member Premium Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Learn about Centmin Mod LEMP Stack today

MariaDB MariaDB 10.1.7 now available - upgrade for Centmin Mod LEMP stack

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

pamamolf Premium Member Premium Member

eva2000 Administrator Staff Member

pamamolf Premium Member Premium Member

eva2000 Administrator Staff Member

pamamolf Premium Member Premium Member

eva2000 Administrator Staff Member

.