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-03-29, 05:58:52

Author Topic: [ISSUE] Mysql 5.5+ and MariaDB  (Read 22924 times)

0 Members and 1 Guest are viewing this topic.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
[ISSUE] Mysql 5.5+ and MariaDB
« on: 2013-03-02, 14:29:57 »
Centos using Mysql version 5.5 as 'default'. In latest version of 5.5, no permit 'skip-innodb' inside '/etc/my.cnf'.

Sadly, fresh install of Kloxo-MR always add 'skip-innodb' for reason minimize memory usage. Latest upload of Kloxo-MR fixed this issue for fresh install.

Fix for this situation:
1. Update your Kloxo-MR

2. Repair login issue
Code: [Select]
# disable 'skip-innodb'
sed -i  's/skip-innodb/#skip-innodb/' /etc/my.cnf

# reset mysql root password
sh /script/reset-mysql-root-password YOURNEWPASSWORD

# reset kloxo database password
sh /script/resetpassword master YOURNEWPASSWORD

# run cleanup
sh /script/cleanup

# restart services
sh /script/restart-services

MariaDB also no permit for 'skip-innodb'. At this moment, MariaDB not work perfectly on Kloxo-MR because need adjustment sql command on php code.

Kloxo-MR running well with MariaDB now. Need update latest version and running 'sh /script/mysql-to-mariadb'.
« Last Edit: 2014-04-29, 14:17:26 by MRatWork »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ibuxxi

  • Senior Member
  • *
  • Posts: 322
  • Karma: +0/-0
    • View Profile
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #1 on: 2013-03-02, 15:27:17 »
i work
sed 's/skip-innodb/#skip-innodb/' > /etc/my.cnf

and my my.cnf is emty
« Last Edit: 1970-01-01, 01:00:00 by Guest »
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: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #2 on: 2013-03-02, 15:42:50 »
Sorry. Find out '/etc/my.cnf.rpmnew' or '/etc/my.cnf.save' and copy to '/etc/my.cnf'.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline zenkul

  • Global Moderator
  • Master
  • *****
  • Posts: 383
  • Karma: +3/-0
    • View Profile
    • home & decor
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #3 on: 2013-03-02, 23:42:46 »
mariadb + aria storage engine
is it database backup/restore mechanism like myisam ?
just copy/paste (replace) database at folder var/lib/mysql
« Last Edit: 1970-01-01, 01:00:00 by Guest »
easy, secure and speed up web panel ===> Kloxo-MR

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #4 on: 2013-03-03, 02:06:32 »
Is it save to upgrade to MariaDB now ? Will this take a lot of downtime to convert ?

Can I upgrade to latest Kloxo when not using MariaDB ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #5 on: 2013-03-03, 02:10:18 »
For update to MariaDB must be using 'sh /script/mysql-to-mariadb'. If not, still using MySQL.

Not intensive testing but aria look like faster than myisam.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #6 on: 2013-03-03, 02:14:17 »
It's not working:

Code: [Select]
Version: '5.5.30-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp
^C
[root@nowosci mysql]# sh /script/mysql-to-mariadb
*** Change MySQL to MariaDB - end ***
- Fix Service List
- No MySQL or MariaDB installed

 - Note: remove 'skip-innodb' from '/etc/my.cnf' and '/etc/my.cnf.d/my.cnf'

*** Change MySQL to MariaDB - end ***

Code: [Select]
[root@nowosci /]# rpm -qi mysql-server
Name        : mysql-server                 Relocations: (not relocatable)
Version     : 5.5.30                            Vendor: (none)
Release     : 15.el5.art                    Build Date: pi? 01 lut 2013 18:12:18 CET
Install Date: pon 04 lut 2013 15:51:10 CET      Build Host: archelon
Group       : Applications/Databases        Source RPM: mysql-5.5.30-15.el5.art.src.rpm
Size        : 46872240                         License: GPLv2 with exceptions
Signature   : DSA/SHA1, pi? 01 lut 2013 19:00:14 CET, Key ID 32a951145ebd2744
URL         : http://www.mysql.com
Summary     : Serwer MySQL i zwi?zane z nim pliki.
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. This package contains
the MySQL server and some accompanying files and directories.

Code: [Select]
[root@nowosci /]# cat /etc/my.cnf
[mysqld]
#skip-networking
#bind-address = 0.0.0.0
#server-id=1
#log-bin = mysql-bin
#skip-name-resolve
#skip-grant-tables
datadir=/var/lib/mysql
tmpdir=/dev/shm
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#skip-federated
old_passwords=1
skip-external-locking
query_cache_limit=64M
query_cache_size=256M
query_cache_type=1
max_connections=1000
max_user_connections=50
max_connect_errors=100
#wait_timeout=600
thread_cache_size=8
key_buffer=3172M
innodb_buffer_pool_size = 3172M
innodb_thread_concurrency = 16
innodb_log_file_size=64M
innodb_log_buffer_size = 16M
innodb_lock_wait_timeout = 100
innodb_flush_log_at_trx_commit = 2
innodb_support_xa=0
innodb_additional_mem_pool_size = 32M
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_max_dirty_pages_pct = 90
innodb_file_per_table
innodb_use_native_aio=0
sync_binlog=0
join_buffer=4M
max_allowed_packet=16M
table_open_cache=1024
table_cache=32k
sort_buffer_size=4M
read_buffer_size=4M
read_rnd_buffer_size=4M
max_connect_errors=100
tmp_table_size=32M
max_heap_table_size=2M
long_query_time=2
thread_concurrency=8
myisam_sort_buffer_size=64M
max_write_lock_count = 1
default-storage-engine=MyISAM

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
plugin-load=archive=ha_archive.so;blackhole=ha_blackhole.so

[mysqldump]
quick
max_allowed_packet=16M
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #7 on: 2013-03-03, 02:24:22 »
I am not testing mysql from other than 'standard' repo (centos, centalt and ius).
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #8 on: 2013-03-03, 02:25:59 »
Try install directly with 'yum install MariaDB-server MariaDB-client'.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: [ISSUE] Mysql 5.5+ and MariaDB
« Reply #9 on: 2013-04-18, 21:59:26 »
It was because MariaDB repo was disabled. Working fine now.
« Last Edit: 1970-01-01, 01:00:00 by Guest »

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine

Page created in 0.027 seconds with 21 queries.

web stats analysis