[MariaDB]: Installation on Amazon EC2 machine
[srinivas@dbversity.com ~]$ sudo yum install mariadb-server mariadb
Loaded plugins: amazon-id, rhui-lb
Package 1:mariadb-5.5.41-2.el7_0.x86_64 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package mariadb-server.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: libaio.so.1()(64bit) for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Running transaction check
—> Package libaio.x86_64 0:0.3.109-12.el7 will be installed
—> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
—> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
–> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
–> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
—> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
–> Running transaction check
—> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
–> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Running transaction check
—> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
–> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
–> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
—> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
–> Running transaction check
—> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
—> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
–> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
mariadb-server x86_64 1:5.5.41-2.el7_0 rhui-REGION-rhel-server-releases 11 M
Installing for dependencies:
libaio x86_64 0.3.109-12.el7 rhui-REGION-rhel-server-releases 24 k
perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 rhui-REGION-rhel-server-releases 32 k
perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 rhui-REGION-rhel-server-releases 57 k
perl-DBD-MySQL x86_64 4.023-5.el7 rhui-REGION-rhel-server-releases 140 k
perl-DBI x86_64 1.627-4.el7 rhui-REGION-rhel-server-releases 802 k
perl-Data-Dumper x86_64 2.145-3.el7 rhui-REGION-rhel-server-releases 47 k
perl-IO-Compress noarch 2.061-2.el7 rhui-REGION-rhel-server-releases 260 k
perl-Net-Daemon noarch 0.48-5.el7 rhui-REGION-rhel-server-releases 51 k
perl-PlRPC noarch 0.2020-14.el7 rhui-REGION-rhel-server-releases 36 k
Transaction Summary
========================================================================================================================================================================
Install 1 Package (+9 Dependent packages)
Total download size: 12 M
Installed size: 59 M
Is this ok [y/d/N]: y
Downloading packages:
(1/10): libaio-0.3.109-12.el7.x86_64.rpm | 24 kB 00:00:00
(2/10): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00
(3/10): mariadb-server-5.5.41-2.el7_0.x86_64.rpm | 11 MB 00:00:00
(4/10): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00
(5/10): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm | 140 kB 00:00:00
(6/10): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00
(7/10): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00
(8/10): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00
(9/10): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00
(10/10): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00
————————————————————————————————————————————————————————
Total 12 MB/s | 12 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : perl-Data-Dumper-2.145-3.el7.x86_64 1/10
Installing : libaio-0.3.109-12.el7.x86_64 2/10
Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 3/10
Installing : perl-Net-Daemon-0.48-5.el7.noarch 4/10
Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 5/10
Installing : perl-IO-Compress-2.061-2.el7.noarch 6/10
Installing : perl-PlRPC-0.2020-14.el7.noarch 7/10
Installing : perl-DBI-1.627-4.el7.x86_64 8/10
Installing : perl-DBD-MySQL-4.023-5.el7.x86_64 9/10
Installing : 1:mariadb-server-5.5.41-2.el7_0.x86_64 10/10
Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 1/10
Verifying : perl-Net-Daemon-0.48-5.el7.noarch 2/10
Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 3/10
Verifying : 1:mariadb-server-5.5.41-2.el7_0.x86_64 4/10
Verifying : perl-PlRPC-0.2020-14.el7.noarch 5/10
Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 6/10
Verifying : libaio-0.3.109-12.el7.x86_64 7/10
Verifying : perl-DBI-1.627-4.el7.x86_64 8/10
Verifying : perl-IO-Compress-2.061-2.el7.noarch 9/10
Verifying : perl-DBD-MySQL-4.023-5.el7.x86_64 10/10
Installed:
mariadb-server.x86_64 1:5.5.41-2.el7_0
Dependency Installed:
libaio.x86_64 0:0.3.109-12.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-5.el7
perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7
perl-PlRPC.noarch 0:0.2020-14.el7
Complete!
[srinivas@dbversity.com ~]$
[srinivas@dbversity.com ~]$ rpm -qa|grep -i maria
mariadb-5.5.41-2.el7_0.x86_64
mariadb-server-5.5.41-2.el7_0.x86_64
mariadb-libs-5.5.41-2.el7_0.x86_64
mariadb-devel-5.5.41-2.el7_0.x86_64
[srinivas@dbversity.com ~]$
[srinivas@dbversity.com ~]$ sudo systemctl start mariadb.service
[srinivas@dbversity.com ~]$
[srinivas@dbversity.com ~]$
[srinivas@dbversity.com ~]$ sudo systemctl status mariadb.service
mariadb.service – MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
Active: active (running) since Wed 2015-04-01 16:38:30 EDT; 34s ago
Process: 11384 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 11305 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 11383 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─11383 /bin/sh /usr/bin/mysqld_safe –basedir=/usr
└─11541 /usr/libexec/mysqld –basedir=/usr –datadir=/var/lib/mysql –plugin-dir=/usr/lib64/mysql/plugin –log-error=/var/log/mariadb/mariadb.log –pid-fi…
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mariadb-prepare-db-dir[11305]: You can find additional information about the MySQL part at:
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mariadb-prepare-db-dir[11305]: http://dev.mysql.com
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mariadb-prepare-db-dir[11305]: Support MariaDB development by buying support/new features from MariaDB
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mariadb-prepare-db-dir[11305]: Corporation Ab. You can contact us about this at sales@mariadb.com.
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mariadb-prepare-db-dir[11305]: Alternatively consider joining our community based development effort:
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mariadb-prepare-db-dir[11305]: http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mysqld_safe[11383]: 150401 16:38:28 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.
Apr 01 16:38:28 dbversity.com.us-west-2.compute.internal mysqld_safe[11383]: 150401 16:38:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 01 16:38:30 dbversity.com.us-west-2.compute.internal systemd[1]: Started MariaDB database server.
Apr 01 16:38:52 dbversity.com.us-west-2.compute.internal systemd[1]: Started MariaDB database server.
[srinivas@dbversity.com ~]$
[srinivas@dbversity.com ~]$ mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.41-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>