MariaDB 5.5

You can install MariaDB 5.5 on Ubuntu 14.04.x from the Ubuntu repo using 'sudo apt-get install mariadb-server'.

Experimental

This page has been imported from http://www.oscarmanual.org and has not yet been reviewed by OSCAR EMR.


On Ubuntu 14.04 MariaDB 5.5 optionally can replace MySQL 5.5 as a OSCAR 15 prerequisite


MariaDB 5.5 in Ubuntu 14.04 is available by this technique

peter@peter-XPS ~ $ sudo apt-get install software-properties-common
peter@peter-XPS ~ $ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --homedir /tmp/tmp.shWft5FJLZ --no-auto-check-trustdb --trust-model always --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
gpg: requesting key 1BB943DB from hkp server keyserver.ubuntu.com
gpg: key 1BB943DB: public key "MariaDB Package Signing Key <package-signing-key@mariadb.org>" imported
gpg: Total number processed: 1
gpg:               imported: 1
peter@peter-XPS ~ $ sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu trusty main'
peter@peter-XPS ~ $ sudo apt-get update
peter@peter-XPS ~ $ sudo apt-get install mariadb-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libmariadbclient18 libmysqlclient18 mariadb-client-5.5
  mariadb-client-core-5.5 mariadb-common mariadb-server-5.5
  mariadb-server-core-5.5 mysql-common
Suggested packages:
  tinyca mailx mariadb-test
Recommended packages:
  libhtml-template-perl
The following packages will be REMOVED:
  mysql-client-5.5 mysql-client-core-5.5 mysql-server-5.5
  mysql-server-core-5.5
The following NEW packages will be installed:
  libmariadbclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common
  mariadb-server mariadb-server-5.5 mariadb-server-core-5.5
The following packages will be upgraded:
  libmysqlclient18 mysql-common
2 upgraded, 7 newly installed, 4 to remove and 169 not upgraded.
Need to get 10.2 MB of archives.
After this operation, 19.7 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mysql-common all 5.5.50+maria-1~trusty [8,360 B]
Get:2 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-common all 5.5.50+maria-1~trusty [3,178 B]
Get:3 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main libmysqlclient18 amd64 5.5.50+maria-1~trusty [2,856 B]
Get:4 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main libmariadbclient18 amd64 5.5.50+maria-1~trusty [518 kB]
Get:5 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-client-core-5.5 amd64 5.5.50+maria-1~trusty [623 kB]
Get:6 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-server-core-5.5 amd64 5.5.50+maria-1~trusty [3,823 kB]
Get:7 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-client-5.5 amd64 5.5.50+maria-1~trusty [959 kB]
Get:8 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-server-5.5 amd64 5.5.50+maria-1~trusty [4,257 kB]
Get:9 http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/ trusty/main mariadb-server all 5.5.50+maria-1~trusty [2,890 B]
Fetched 10.2 MB in 1min 4s (158 kB/s)                                          
Preconfiguring packages ...
(Reading database ... 190644 files and directories currently installed.)
Removing mysql-server-5.5 (5.5.47-0ubuntu0.14.04.1) ...
mysql stop/waiting
Removing mysql-client-5.5 (5.5.47-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
(Reading database ... 190522 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.5.50+maria-1~trusty_all.deb ...
Unpacking mysql-common (5.5.50+maria-1~trusty) over (5.5.47-0ubuntu0.14.04.1) ...
Selecting previously unselected package mariadb-common.
Preparing to unpack .../mariadb-common_5.5.50+maria-1~trusty_all.deb ...
Unpacking mariadb-common (5.5.50+maria-1~trusty) ...
Preparing to unpack .../libmysqlclient18_5.5.50+maria-1~trusty_amd64.deb ...
Unpacking libmysqlclient18 (5.5.50+maria-1~trusty) over (5.5.47-0ubuntu0.14.04.1) ...
Selecting previously unselected package libmariadbclient18.
Preparing to unpack .../libmariadbclient18_5.5.50+maria-1~trusty_amd64.deb ...
Unpacking libmariadbclient18 (5.5.50+maria-1~trusty) ...
dpkg: mysql-client-core-5.5: dependency problems, but removing anyway as you requested:
 akonadi-backend-mysql depends on mysql-client-core-5.5 | mariadb-client-core-5.5 | mysql-client-core-5.6; however:
  Package mysql-client-core-5.5 is to be removed.
  Package mariadb-client-core-5.5 is not installed.
  Package mysql-client-core-5.6 is not installed.

(Reading database ... 190536 files and directories currently installed.)
Removing mysql-client-core-5.5 (5.5.47-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Selecting previously unselected package mariadb-client-core-5.5.
(Reading database ... 190529 files and directories currently installed.)
Preparing to unpack .../mariadb-client-core-5.5_5.5.50+maria-1~trusty_amd64.deb ...
Unpacking mariadb-client-core-5.5 (5.5.50+maria-1~trusty) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
dpkg: mysql-server-core-5.5: dependency problems, but removing anyway as you requested:
 akonadi-backend-mysql depends on mysql-server-core-5.5 | mariadb-server-core-5.5 | mysql-server-core-5.6; however:
  Package mysql-server-core-5.5 is to be removed.
  Package mariadb-server-core-5.5 is not installed.
  Package mysql-server-core-5.6 is not installed.

(Reading database ... 190535 files and directories currently installed.)
Removing mysql-server-core-5.5 (5.5.47-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Selecting previously unselected package mariadb-server-core-5.5.
(Reading database ... 190447 files and directories currently installed.)
Preparing to unpack .../mariadb-server-core-5.5_5.5.50+maria-1~trusty_amd64.deb ...
Unpacking mariadb-server-core-5.5 (5.5.50+maria-1~trusty) ...
Selecting previously unselected package mariadb-client-5.5.
Preparing to unpack .../mariadb-client-5.5_5.5.50+maria-1~trusty_amd64.deb ...
Unpacking mariadb-client-5.5 (5.5.50+maria-1~trusty) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up mysql-common (5.5.50+maria-1~trusty) ...
Installing new version of config file /etc/mysql/my.cnf ...
Setting up mariadb-common (5.5.50+maria-1~trusty) ...
Selecting previously unselected package mariadb-server-5.5.
(Reading database ... 190567 files and directories currently installed.)
Preparing to unpack .../mariadb-server-5.5_5.5.50+maria-1~trusty_amd64.deb ...
Unpacking mariadb-server-5.5 (5.5.50+maria-1~trusty) ...
Selecting previously unselected package mariadb-server.
Preparing to unpack .../mariadb-server_5.5.50+maria-1~trusty_all.deb ...
Unpacking mariadb-server (5.5.50+maria-1~trusty) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
ureadahead will be reprofiled on next reboot
Setting up libmysqlclient18 (5.5.50+maria-1~trusty) ...
Setting up libmariadbclient18 (5.5.50+maria-1~trusty) ...
Setting up mariadb-client-core-5.5 (5.5.50+maria-1~trusty) ...
Setting up mariadb-server-core-5.5 (5.5.50+maria-1~trusty) ...
Setting up mariadb-client-5.5 (5.5.50+maria-1~trusty) ...
Setting up mariadb-server-5.5 (5.5.50+maria-1~trusty) ...
Installing new version of config file /etc/apparmor.d/usr.sbin.mysqld ...
Installing new version of config file /etc/init.d/mysql ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
Installing new version of config file /etc/mysql/debian-start ...
160705 13:56:54 [Note] /usr/sbin/mysqld (mysqld 5.5.50-MariaDB-1~trusty) starting as process 17020 ...
160705 13:56:54 [Note] Plugin 'InnoDB' is disabled.
160705 13:56:54 [Note] Plugin 'FEEDBACK' is disabled.
mysql start/running, process 17090
Processing triggers for ureadahead (0.100.0-16) ...
Setting up mariadb-server (5.5.50+maria-1~trusty) ...
Processing triggers for libc-bin (2.19-0ubuntu6.7) ...