gak bisa convert mysql to mariadb

[prandah]

Code: [Select]

[root@pegasus ~]# sh /script/mysql-to-mariadb
*** Change MySQL to MariaDB - begin ***
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
              : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5
              : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
              : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
              : kloxo-mr-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Update Services Branch List
- List for 'dns' branch
- List for 'dovecot' branch
- List for 'httpd' branch
- List for 'lighttpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch

Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
              : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5
              : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
              : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
              : kloxo-mr-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Setting up Remove Process
No Match for argument: mysql*.i386
Determining fastest mirrors
 * base: mirror.ash.fastserv.com
 * extras: mirror.ash.fastserv.com
 * kloxo-mr-epel: mirror.symnds.com
 * kloxo-mr-ius: mirror.symnds.com
 * updates: centos.mirror.nac.net
0 packages excluded due to repository protections
No Packages marked for removal
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Setting up Remove Process
No Match for argument: mysql*.i686
Loading mirror speeds from cached hostfile
 * base: mirror.ash.fastserv.com
 * extras: mirror.ash.fastserv.com
 * kloxo-mr-epel: mirror.symnds.com
 * kloxo-mr-ius: mirror.symnds.com
 * updates: centos.mirror.nac.net
0 packages excluded due to repository protections
No Packages marked for removal
[root@pegasus ~]# cat /etc/redhat-release
CentOS release 6.4 (Final)
[root@pegasus ~]#



[MRatWork]

File kloxo-mr.repo sudah diedit dan jalankan 'yum clean all'?.

[prandah]

sama mas :

Code: [Select]

[root@pegasus ~]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5 kloxo-mr-mariadb64
              : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
              : kloxo-mr-varnish-3.0 updates
Cleaning up Everything
[root@pegasus ~]# sh /script/mysql-to-mariadb
*** Change MySQL to MariaDB - begin ***
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
              : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5 kloxo-mr-mariadb64
              : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
              : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
              : kloxo-mr-varnish-3.0 updates
Cleaning up Everything
Update Services Branch List
- List for 'dns' branch
- List for 'dovecot' branch
- List for 'httpd' branch
- List for 'lighttpd' branch
- List for 'mysql' branch
- List for 'nginx' branch
- List for 'php' branch
- List for 'qmail' branch

Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
              : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5 kloxo-mr-mariadb64
              : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
              : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
              : kloxo-mr-varnish-3.0 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Setting up Remove Process
No Match for argument: mysql*.i386
Determining fastest mirrors
 * base: mirror.ash.fastserv.com
 * extras: mirror.ash.fastserv.com
 * kloxo-mr-epel: www.gtlib.gatech.edu
 * kloxo-mr-ius: mirror.symnds.com
 * updates: mirror.cs.vt.edu
0 packages excluded due to repository protections
No Packages marked for removal
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Setting up Remove Process
No Match for argument: mysql*.i686
Loading mirror speeds from cached hostfile
 * base: mirror.ash.fastserv.com
 * extras: mirror.ash.fastserv.com
 * kloxo-mr-epel: www.gtlib.gatech.edu
 * kloxo-mr-ius: mirror.symnds.com
 * updates: mirror.cs.vt.edu
0 packages excluded due to repository protections
No Packages marked for removal
[root@pegasus ~]#


[MRatWork]

Tunjukkan hasil 'sh /script/sysinfo' dan 'cat /etc/yum.repos.d/kloxo-mr.repo'

[prandah]

sysinfo :

Code: [Select]

[root@pegasus ~]# sh /script/sysinfo

A. Kloxo-MR: 6.5.0.f-2013080605

B. OS: CentOS release 6.4 (Final) x86_64

C. Apps:
   1. MySQL: mysql-5.5.29-1.el6.x86_64
   2. PHP: php53u-5.3.27-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.25-1.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.5.2-1.el6.x86_64
   6. Qmail: qmail-toaster-1.03-1.3.27.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.x86_64
   7. Dns: djbdns-1.05-17.3.mr.el6.x86_64

D. Php-type (for Httpd/proxy): php-fpm_event

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:         36140       1455      34684          0         75        737
   -/+ buffers/cache:        641      35498
   Swap:        18111          0      18111

[root@pegasus ~]#

kloxo-mr.repo

Code: [Select]

[root@pegasus ~]# cat /etc/yum.repos.d/kloxo-mr.repo
[kloxo-mr-release-neutral-noarch]
name=Kloxo-MR - release-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-neutral-arch]
name=Kloxo-MR - release-neutral-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-version-noarch]
name=Kloxo-MR - release-version-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-noarch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-version-arch]
name=Kloxo-MR - release-version-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-testing-neutral-noarch]
name=Kloxo-MR - testing-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-neutral-arch]
name=Kloxo-MR - testing-neutral-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-version-noarch]
name=Kloxo-MR - testing-version-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-noarch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-version-arch]
name=Kloxo-MR - testing-version-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-i386-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-srpms]
name=Kloxo-MR - srpms
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
enabled=0
gpgcheck=0

# ==================================

[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-6-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl* mariadb* bind*

# ==================================

[kloxo-mr-ius]
name=Kloxo-MR - IUS Community Packages for EL 6 - $basearch
baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/$basearch
mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el6&arch=$basearch
enabled=1
gpgcheck=0
exclude=php52* mysql5*

[kloxo-mr-ius-c5]
name=Kloxo-MR - IUS Community Packages for EL 5 (special) - $basearch
baseurl=http://dl.iuscommunity.org/pub/ius/archive/CentOS/5/$basearch
#mirrorlist=http://rpms.potissima.com/repo/mirrors/ius-centos-5-$basearch-mirrors.txt
enabled=1
gpgcheck=0
includepkgs=php52*

# ==================================

[kloxo-mr-epel]
name=Kloxo-MR - Extra Packages for EL 6 - $basearch
baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
enabled=1
gpgcheck=0

# ==================================

# for varnish
[kloxo-mr-varnish-3.0]
name=Kloxo-MR - Varnish 3.0 for EL 6 - $basearch
baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el6/$basearch
enabled=1
gpgcheck=0

# ==================================

# for hiawatha
[kloxo-mr-centosec]
name=Kloxo-MR - CentOS 6 Packages from CentOS.EC
baseurl=http://centos6.ecualinux.com/$basearch
enabled=1
gpgcheck=0
exclude=cairo*

# ==================================

# for nginx-stable
[kloxo-mr-nginx]
name=Kloxo-MR - nginx repo
baseurl=http://nginx.org/packages/centos/6/$basearch/
gpgcheck=0
enabled=0

# ==================================

# for mariadb
[kloxo-mr-mariadb32]
name=Kloxo-MR - mariadb32 repo
baseurl=http://yum.mariadb.org/5.5/centos6-x86
enabled=0
gpgcheck=0

# for mariadb
[kloxo-mr-mariadb64]
name=Kloxo-MR - mariadb64 repo
baseurl=http://yum.mariadb.org/5.5/centos6-amd64
enabled=1
gpgcheck=0

# ==================================

# for atrpms
[kloxo-mr-atrpms]
name=Kloxo-MR - Fedora Core 6 - $basearch - ATrpms
baseurl=http://dl.atrpms.net/el6-$basearch/atrpms/stable
gpgcheck=0
enable=0
[root@pegasus ~]#


[MRatWork]

Bisa jadi ada masalah di mariadb server sehingga rpm tidak tersedia.

Jika pakai Centos 6, sebaiknya pakai mariadb dari centalt dimana perlu ubah kloxo-mr.repo menjadi:

Code: [Select]

[kloxo-mr-release-neutral-noarch]
name=Kloxo-MR - release-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-neutral-arch]
name=Kloxo-MR - release-neutral-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-version-noarch]
name=Kloxo-MR - release-version-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-noarch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-version-arch]
name=Kloxo-MR - release-version-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-testing-neutral-noarch]
name=Kloxo-MR - testing-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-neutral-arch]
name=Kloxo-MR - testing-neutral-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-version-noarch]
name=Kloxo-MR - testing-version-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-noarch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-version-arch]
name=Kloxo-MR - testing-version-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-i386-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-srpms]
name=Kloxo-MR - srpms
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
enabled=0
gpgcheck=0

# ==================================

[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-6-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl* bind*

# ==================================

[kloxo-mr-ius]
name=Kloxo-MR - IUS Community Packages for EL 6 - $basearch
baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/$basearch
mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el6&arch=$basearch
enabled=1
gpgcheck=0
exclude=php52* mysql5*

[kloxo-mr-ius-c5]
name=Kloxo-MR - IUS Community Packages for EL 5 (special) - $basearch
baseurl=http://dl.iuscommunity.org/pub/ius/archive/CentOS/5/$basearch
#mirrorlist=http://rpms.potissima.com/repo/mirrors/ius-centos-5-$basearch-mirrors.txt
enabled=1
gpgcheck=0
includepkgs=php52*

# ==================================

[kloxo-mr-epel]
name=Kloxo-MR - Extra Packages for EL 6 - $basearch
baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
enabled=1
gpgcheck=0

# ==================================

# for varnish
[kloxo-mr-varnish-3.0]
name=Kloxo-MR - Varnish 3.0 for EL 6 - $basearch
baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el6/$basearch
enabled=1
gpgcheck=0

# ==================================

# for hiawatha
[kloxo-mr-centosec]
name=Kloxo-MR - CentOS 6 Packages from CentOS.EC
baseurl=http://centos6.ecualinux.com/$basearch
enabled=1
gpgcheck=0
exclude=cairo*

# ==================================

# for nginx-stable
[kloxo-mr-nginx]
name=Kloxo-MR - nginx repo
baseurl=http://nginx.org/packages/centos/6/$basearch/
gpgcheck=0
enabled=0

# ==================================

# for mariadb
[kloxo-mr-mariadb32]
name=Kloxo-MR - mariadb32 repo
baseurl=http://yum.mariadb.org/5.5/centos6-x86
enabled=0
gpgcheck=0

# for mariadb
[kloxo-mr-mariadb64]
name=Kloxo-MR - mariadb64 repo
baseurl=http://yum.mariadb.org/5.5/centos6-amd64
enabled=0
gpgcheck=0

# ==================================

# for atrpms
[kloxo-mr-atrpms]
name=Kloxo-MR - Fedora Core 6 - $basearch - ATrpms
baseurl=http://dl.atrpms.net/el6-$basearch/atrpms/stable
gpgcheck=0
enable=0
[root@pegasus ~]#
kemudian jalankan 'yum clean all; yum update' dimana kemudian terjadi update dari mysql ke mariadb dari centalt.

[agssbuzz]

Bisa jadi ada masalah di mariadb server sehingga rpm tidak tersedia.

Jika pakai Centos 6, sebaiknya pakai mariadb dari centalt dimana perlu ubah kloxo-mr.repo menjadi:

Code: [Select]

[kloxo-mr-release-neutral-noarch]
name=Kloxo-MR - release-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-neutral-arch]
name=Kloxo-MR - release-neutral-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-version-noarch]
name=Kloxo-MR - release-version-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-noarch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-release-version-arch]
name=Kloxo-MR - release-version-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[kloxo-mr-testing-neutral-noarch]
name=Kloxo-MR - testing-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-neutral-arch]
name=Kloxo-MR - testing-neutral-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-version-noarch]
name=Kloxo-MR - testing-version-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/noarch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-noarch-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-testing-version-arch]
name=Kloxo-MR - testing-version-$basearch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-i386-mirrors.txt
enabled=0
gpgcheck=0

[kloxo-mr-srpms]
name=Kloxo-MR - srpms
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
enabled=0
gpgcheck=0

# ==================================

[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
#mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-6-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl* bind*

# ==================================

[kloxo-mr-ius]
name=Kloxo-MR - IUS Community Packages for EL 6 - $basearch
baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/$basearch
mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el6&arch=$basearch
enabled=1
gpgcheck=0
exclude=php52* mysql5*

[kloxo-mr-ius-c5]
name=Kloxo-MR - IUS Community Packages for EL 5 (special) - $basearch
baseurl=http://dl.iuscommunity.org/pub/ius/archive/CentOS/5/$basearch
#mirrorlist=http://rpms.potissima.com/repo/mirrors/ius-centos-5-$basearch-mirrors.txt
enabled=1
gpgcheck=0
includepkgs=php52*

# ==================================

[kloxo-mr-epel]
name=Kloxo-MR - Extra Packages for EL 6 - $basearch
baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
enabled=1
gpgcheck=0

# ==================================

# for varnish
[kloxo-mr-varnish-3.0]
name=Kloxo-MR - Varnish 3.0 for EL 6 - $basearch
baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el6/$basearch
enabled=1
gpgcheck=0

# ==================================

# for hiawatha
[kloxo-mr-centosec]
name=Kloxo-MR - CentOS 6 Packages from CentOS.EC
baseurl=http://centos6.ecualinux.com/$basearch
enabled=1
gpgcheck=0
exclude=cairo*

# ==================================

# for nginx-stable
[kloxo-mr-nginx]
name=Kloxo-MR - nginx repo
baseurl=http://nginx.org/packages/centos/6/$basearch/
gpgcheck=0
enabled=0

# ==================================

# for mariadb
[kloxo-mr-mariadb32]
name=Kloxo-MR - mariadb32 repo
baseurl=http://yum.mariadb.org/5.5/centos6-x86
enabled=0
gpgcheck=0

# for mariadb
[kloxo-mr-mariadb64]
name=Kloxo-MR - mariadb64 repo
baseurl=http://yum.mariadb.org/5.5/centos6-amd64
enabled=0
gpgcheck=0

# ==================================

# for atrpms
[kloxo-mr-atrpms]
name=Kloxo-MR - Fedora Core 6 - $basearch - ATrpms
baseurl=http://dl.atrpms.net/el6-$basearch/atrpms/stable
gpgcheck=0
enable=0
[root@pegasus ~]#
kemudian jalankan 'yum clean all; yum update' dimana kemudian terjadi update dari mysql ke mariadb dari centalt.

Saya juga ada masalah pak ketika convert mysql ke mariadb.
Convert berhasil, namun panel kloxo nya mati gabisa di akses.[root@ks3099518 ~]# sh /script/cleanup

Code: [Select]

[root@ks3099518 ~]# sh /script/restart-services
Stopping httpd:                                           [  OK  ]
Starting httpd:                                            [  OK  ]
Stopping nginx:.                                           [  OK  ]
Starting nginx:                                             [  OK  ]
Stopping php-fpm:                                        [  OK  ]
Starting php-fpm:                                         [  OK  ]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
Stopping xinetd:                                           [  OK  ]
Starting xinetd:                                            [  OK  ]
Shutting down MySQL. SUCCESS!
Starting MySQL.. SUCCESS!
[root@ks3099518 ~]# service kloxo restart
Stopping kloxo-phpcgi:                                  [FAILED]
Starting kloxo-phpcgi:                                   [  OK  ]
Stopping kloxo-hiawatha:                               [  OK  ]
Starting kloxo-hiawatha:                                [  OK  ]
[root@ks3099518 ~]#Gak bisa cleanup juga.

[MRatWork]

Coba lihat di /etc/my.cnf jika ada 'skip-innodb' ubah jadi '#skip-innodb'.

Jika dalam /etc/my.cnf.d tidak ada file my.cnf. copykan /etc/my.cnf.rpmsave ke /etc/my.cnf.d/my.cnf.