MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Releases => Topic started 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
# 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'.
-
i work
sed 's/skip-innodb/#skip-innodb/' > /etc/my.cnf
and my my.cnf is emty
-
Sorry. Find out '/etc/my.cnf.rpmnew' or '/etc/my.cnf.save' and copy to '/etc/my.cnf'.
-
mariadb + aria storage engine
is it database backup/restore mechanism like myisam ?
just copy/paste (replace) database at folder var/lib/mysql
-
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 ?
-
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.
-
It's not working:
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 ***
[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.
[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
-
I am not testing mysql from other than 'standard' repo (centos, centalt and ius).
-
Try install directly with 'yum install MariaDB-server MariaDB-client'.
-
It was because MariaDB repo was disabled. Working fine now.