Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-04-26, 06:13:42
« previous next »
Pages: [1] 2   Go Down

Author Topic: mysql replace to mariadb  (Read 8519 times)

0 Members and 1 Guest are viewing this topic.

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
mysql replace to mariadb
« on: 2013-02-22, 18:01:55 »
Heya,

i have a dedi server 8gb centos5.9 (cpanel+litespeed-)8cpu, and 100 splogs with 25000posts per DB
is kloxo-mr ready for productive use

how to mysql replace to mariadb ?

what is best setting for big wp blogs to speed without issue

works kloxo-mr +centos6.3 64bit   without issue ?


thanks
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql replace to mariadb
« Reply #1 on: 2013-02-22, 19:54:59 »
Kloxo-MR not final release until now because backup-restore issue not already fixed (old issue from Kloxo Official).

Some people already use Kloxo-MR candidate release for their production server (including my all servers).

It's ok replace mysql to mariadb with little tricks.

This forum using nginx-proxy with php 5.3, php-fpm and mysql.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #2 on: 2013-02-22, 20:13:59 »
hello

#It's ok replace mysql to mariadb with little tricks.
what are the ticks ?

Kloxo-MR candidate release  = Kloxo-MR 6.5.0.c.2013022002   ?

in kloxo backup not work ?

thanks
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #3 on: 2013-02-22, 23:24:38 »
anyone tips ?
Quote from: "ibuxxi"
hello

#It's ok replace mysql to mariadb with little tricks.
what are the ticks ?

Kloxo-MR candidate release  = Kloxo-MR 6.5.0.c.2013022002   ?

in kloxo backup not work ?

thanks
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql replace to mariadb
« Reply #4 on: 2013-02-22, 23:34:31 »
No. Backup already running well (better than Kloxo because no issue as 'could_not_zip') but certain data (stats and mailing list) not backuped (problem since Kloxo).
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #5 on: 2013-02-22, 23:43:58 »
what are the ticks  :?:

Quote
#It's ok replace mysql to mariadb with little tricks.
what are the ticks ?

Kloxo-MR candidate release = Kloxo-MR 6.5.0.c.2013022002 ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql replace to mariadb
« Reply #6 on: 2013-02-22, 23:52:57 »
try:

Code: [Select]
yum replace mysql --replace-with=mariadb
service mysql stop
chkconfig mysql off
mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
chkconfig mysql on
service mysql restart

This trick possible not needed for next Kloxo-MR upload.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #7 on: 2013-02-23, 00:35:12 »
i test on vps centos 5.9 but only

Code: [Select]
yum replace mysql --replace-with=mariadb
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * addons: mirror.us.leaseweb.net
 * base: mirror.us.leaseweb.net
 * extras: mirror.us.leaseweb.net
 * kloxo-mr-epel: mirror.symnds.com
 * kloxo-mr-ius: mirror.symnds.com
 * updates: mirror.us.leaseweb.net
Excluding Packages from Kloxo-MR - centalt - i386
Finished
Excluding Packages from Kloxo-MR - release-version-i386
Finished
Excluding Packages from Kloxo-MR - release-version-noarch
Finished
0 packages excluded due to repository protections
Replacing packages takes time, please be patient...
Error: No Package Matching mariadb



Quote from: "MRatWork"
try:

Code: [Select]
yum replace mysql --replace-with=mariadb
service mysql stop
chkconfig mysql off
mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
chkconfig mysql on
service mysql restart

This trick possible not needed for next Kloxo-MR upload.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql replace to mariadb
« Reply #8 on: 2013-02-23, 00:37:35 »
MariaDB repo not include in kloxo-mr.repo at this moment.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #9 on: 2013-02-23, 00:56:47 »
i have a MariaDB.repo but only

Code: [Select]
yum replace mysql --replace-with=mariadb
Loaded plugins: fastestmirror, priorities, protectbase, replace
Repository mariadb is listed more than once in the configuration
Loading mirror speeds from cached hostfile
 * addons: mirror.us.leaseweb.net
 * base: mirror.us.leaseweb.net
 * extras: mirror.us.leaseweb.net
 * kloxo-mr-epel: mirror.us.leaseweb.net
 * kloxo-mr-ius: mirror.symnds.com
 * updates: mirror.us.leaseweb.net
kloxo-mr-centalt                                                                                                         |  951 B     00:00    
kloxo-mr-centosec                                                                                                        | 2.3 kB     00:00    
kloxo-mr-epel                                                                                                            | 3.7 kB     00:00    
kloxo-mr-ius                                                                                                             | 2.2 kB     00:00    
kloxo-mr-nginx                                                                                                           | 1.2 kB     00:00    
kloxo-mr-release-neutral-arch                                                                                            | 1.9 kB     00:00    
kloxo-mr-release-neutral-noarch                                                                                          | 1.9 kB     00:00    
kloxo-mr-release-version-arch                                                                                            | 1.9 kB     00:00    
kloxo-mr-release-version-noarch                                                                                          | 1.9 kB     00:00    
kloxo-mr-varnish-3.0                                                                                                     |  951 B     00:00    
Excluding Packages from Kloxo-MR - centalt - i386                                                                                              
Finished                                                                                                                                        
Excluding Packages from Kloxo-MR - release-version-i386                                                                                        
Finished                                                                                                                                        
Excluding Packages from Kloxo-MR - release-version-noarch                                                                                      
Finished                                                                                                                                        
0 packages excluded due to repository protections                                                                                              
Replacing packages takes time, please be patient...                                                                                            
Error: No Package Matching mariadb    

Quote from: "MRatWork"
MariaDB repo not include in kloxo-mr.repo at this moment.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline zenkul

  • Global Moderator
  • Master
  • *****
  • Posts: 383
  • Karma: +3/-0
    • View Profile
    • home & decor
Re: mysql replace to mariadb
« Reply #10 on: 2013-02-23, 01:13:34 »
MariaDB repo : https://downloads.mariadb.org/mariadb/repositories/
/etc/yum.repos.d/MariaDB.repo
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
easy, secure and speed up web panel ===> Kloxo-MR

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #11 on: 2013-02-23, 03:40:43 »
i have install the mariadb repo but not work

Quote
[root@happy2 yum.repos.d]# yum replace mysql --replace-with=mariadb
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * addons: centos.mirror.constant.com
 * base: centos.mirror.constant.com
 * extras: centos.mirror.constant.com
 * kloxo-mr-epel: mirror.symnds.com
 * kloxo-mr-ius: mirror.symnds.com
 * updates: centos.mirror.constant.com
Excluding Packages from Kloxo-MR - centalt - i386
Finished
Excluding Packages from Kloxo-MR - release-version-i386
Finished
Excluding Packages from Kloxo-MR - release-version-noarch
Finished
0 packages excluded due to repository protections
Replacing packages takes time, please be patient...
Error: No Package Matching mariadb

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline zenkul

  • Global Moderator
  • Master
  • *****
  • Posts: 383
  • Karma: +3/-0
    • View Profile
    • home & decor
Re: mysql replace to mariadb
« Reply #12 on: 2013-02-23, 08:39:16 »
i see, and i am the same stuck
waiting development progress : including mariadb package in to kloxo-mr
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
easy, secure and speed up web panel ===> Kloxo-MR

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #13 on: 2013-02-23, 13:18:37 »
how is the file in kloxo to enable normal mysql update/installation
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: mysql replace to mariadb
« Reply #14 on: 2013-02-23, 15:04:43 »
savage replace mysql to mariadb

yum install MariaDB-server MariaDB-shared perl-Time-HiRes
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
KVM VPS | Centos 6.8 (32) 2GB | Kloxo-MR 7.0.0.b-2016* | hiawatha | php56 | php-fpm-event | mariadb
Pages: [1] 2   Go Up
« previous next »
 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.032 seconds with 21 queries.

web stats analysis