MariaDB 5.2.7 MySQL Server Released

MariaDB 5.2.7 MySQL has been released. Already updated my custom Centmin Nginx installation script with MariaDB 5.2.7.

The MariaDB 5.2.7 change log is pretty long so summary:

  1. Faster Internal Temporary Tables
  2. HeidiSQL GUI client now included in Windows MSI package
  3. Red Hat Enterprise Linux (RHEL) 5 RPMs
  4. Other fixes and enhancements

Download MariaDB 5.2.7 MySQL server fromĀ http://downloads.askmonty.org/mariadb/5.2.7.

 

mysqladmin  Ver 9.0 Distrib 5.2.7-MariaDB, for unknown-linux-gnu on x86_64
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc,
2009 Monty Program Ab
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
 
Server version          5.2.7-MariaDB-mariadb101
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 9 min 52 sec
 
Threads: 1  Questions: 1  Slow queries: 0  Opens: 15  Flush tables: 1
Open tables: 8  Queries per second avg: 0.1
+--------------------------------+----------+--------------------+---------+---------+
| 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     |
| MyISAM                         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| partition                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| ARCHIVE                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| BLACKHOLE                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| CSV                            | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| FEDERATED                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| MEMORY                         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| Maria                          | ACTIVE   | DAEMON             | NULL    | GPL     |
| Aria                           | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| MRG_MYISAM                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| PBXT                           | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
| PBXT_STATISTICS                | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| InnoDB                         | DISABLED | STORAGE ENGINE     | NULL    | GPL     |
| INNODB_RSEG                    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_BUFFER_POOL_PAGES       | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_BUFFER_POOL_PAGES_INDEX | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_BUFFER_POOL_PAGES_BLOB  | 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_TABLE_STATS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_INDEX_STATS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| XTRADB_ADMIN_COMMAND           | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_SYS_TABLES              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_SYS_INDEXES             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_SYS_STATS               | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
| XTRADB_ENHANCEMENTS            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
+--------------------------------+----------+--------------------+---------+---------+

 

 


Previous:
Next:



MaxCDN Site Acceleration

Get Cost Effective Content Delivery
Unbeatable speed, stats, & price
http://www.maxcdn.com



7 Comments

  1. Hi George, I have already installed MariaDB 5.2.6 on my server, what do I have to upgrade to version 5.2.7?.

    I installed MariaDB using Centminv1.2.0-eva2000

  2. For now you’ll have to manually upgrade MariaDB using the usual RPM -Uvh upgrade method for mysql rpms. Later I plan to add an upgrade process to my modified version of Centmin to make upgrades easier.

  3. When I try to update the package-server-5.2.7 MariaDB-101.el5.x86_64.rpm, appear this error and not update. The other packages were updated without problems.

    root@webserver# rpm -Uvh http://xxxxxxxxxx/MariaDB-server-5.2.7-101.el5.x86_64.rpm
    Retrieving http://xxxxxxxxxxxxx/MariaDB-server-5.2.7-101.el5.x86_64.rpm
    warning: /var/tmp/rpm-xfer.tHDGQ8: Header V3 DSA signature: NOKEY, key ID 1bb943db
    Preparing… ########################################### [100%]
    file /usr/lib64/mysql/plugin/ha_example.a from install of MariaDB-server-5.2.7-101.el5.x86_64 conflicts with file from package MySQL-devel-5.1.56-0.glibc23.x86_64
    file /usr/lib64/mysql/plugin/ha_example.la from install of MariaDB-server-5.2.7-101.el5.x86_64 conflicts with file from package MySQL-devel-5.1.56-0.glibc23.x86_64

  4. No, I’m wrong in the previous message, that if they appear:

    [root@database ~]# rpm -Uvh http://xxxxxxxxxxx/MariaDB-server-5.2.7-101.el5.x86_64.rpmRetrieving http://xxxxxxxxxxx/MariaDB-server-5.2.7-101.el5.x86_64.rpm
    warning: /var/tmp/rpm-xfer.55uzj7: Header V3 DSA signature: NOKEY, key ID 1bb943db
    Preparing… ########################################### [100%]

    ******************************************************************
    A MySQL or MariaDB server package (MariaDB-server-5.2.6-101.el5) is installed.

    The current MariaDB server package is provided by a different
    vendor (MariaDB (http://mariadb.com/)) than OurDelta – http://ourdelta.org/. Some files may be installed
    to different locations, including log files and the service
    startup script in /etc/init.d/.

    A manual upgrade is required.

    – Ensure that you have a complete, working backup of your data and my.cnf
    files
    – Shut down the MySQL server cleanly
    – Remove the existing MySQL packages. Usually this command will
    list the packages you should remove:
    rpm -qa | grep -i ‘^mysql-‘

    You may choose to use ‘rpm –nodeps -ev ‘ to remove
    the package which contains the mysqlclient shared library. The
    library will be reinstalled by the MariaDB-shared package.
    – Install the new MariaDB packages supplied by OurDelta – http://ourdelta.org/
    – Ensure that the MariaDB server is started
    – Run the ‘mysql_upgrade’ program

    This is a brief description of the upgrade process. Important details
    can be found in the MariaDB manual, in the Upgrading section.
    ******************************************************************
    error: %pre(MariaDB-server-5.2.7-101.el5.x86_64) scriptlet failed, exit status 1
    error: install: %pre scriptlet failed (2), skipping MariaDB-server-5.2.7-101.el5

  5. Backup your databases then just remove old MariaDB-server-5.2.6-101.el5 and install new one.

    rpm -e MariaDB-server-5.2.6-101.el5.x86_64
    rpm -i MariaDB-server-5.2.7-101.el5.x86_64

  6. Hi George, I installed 5.2.7 MariaDB on a new server with CentOS, but not be available Innodb Storage Engine:

    MariaDB [(none)]> 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 |
    | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | FEDERATED | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | Maria | ACTIVE | DAEMON | NULL | GPL |
    | Aria | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | PBXT | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | PBXT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_RSEG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_BUFFER_POOL_PAGES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_BUFFER_POOL_PAGES_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_BUFFER_POOL_PAGES_BLOB | 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_TABLE_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_INDEX_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | XTRADB_ADMIN_COMMAND | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | INNODB_SYS_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    | XTRADB_ENHANCEMENTS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
    +——————————–+——–+——————–+———+———+
    33 rows in set (0.00 sec)

    How I can enable Innodb Storage Engine?

  7. r.goz default /etc/my.cnf has innodb disabled via skip-innodb command. You need to remove or comment out that line and restart mysql for InnoDB storage engine to be enabled. Note as per explanation at http://vbtechsupport.com/675/, for InnoDB performance, you need to meet the increased hardware and resource requirements for using InnoDB storage engine based database tables and need appropriate InnoDB tuned optimal performance settings. The InnoDB settings included in my script are generic basic settings for starters but may not suit your InnoDB usage requirements and you’ll need to understand these changes and requirements. There’s no free support for InnoDB tuning in my modified centmin.sh script.

Leave a Comment