MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Releases => Topic started by: MRatWork on 2013-03-02, 14:29:57

Title: [ISSUE] Mysql 5.5+ and MariaDB
Post by: MRatWork 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'.

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: ibuxxi on 2013-03-02, 15:27:17

i work
sed 's/skip-innodb/#skip-innodb/' > /etc/my.cnf

and my my.cnf is emty

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: MRatWork 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'.

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: zenkul 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

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: Spacedust 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 ?

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: MRatWork 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.

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: Spacedust 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


Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: MRatWork on 2013-03-03, 02:24:22

I am not testing mysql from other than 'standard' repo (centos, centalt and ius).

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: MRatWork on 2013-03-03, 02:25:59

Try install directly with 'yum install MariaDB-server MariaDB-client'.

Title: Re: [ISSUE] Mysql 5.5+ and MariaDB
Post by: Spacedust on 2013-04-18, 21:59:26

It was because MariaDB repo was disabled. Working fine now.