BMS-HOSxP Community
HOSxP => MySQL => ข้อความที่เริ่มโดย: Aquilani ที่ สิงหาคม 07, 2012, 09:31:18 AM
-
warning: Percona-XtraDB-Cluster-client-5.5.24-23.6.341.rhel6.i686.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ########################################### [100%]
1:Percona-XtraDB-Cluster-########################################## [ 13%]
2:Percona-XtraDB-Cluster-########################################## [ 25%]
3:Percona-XtraDB-Cluster-########################################## [ 38%]
4:Percona-XtraDB-Cluster-########################################## [ 50%]
5:Percona-XtraDB-Cluster-########################################## [ 63%]
6:Percona-XtraDB-Cluster-########################################## [ 75%]
7:Percona-XtraDB-Cluster-########################################## [ 88%]
8:Percona-XtraDB-Cluster-########################################## [100%]
120807 9:21:23 [Note] Flashcache bypass: disabled
120807 9:21:23 [Note] Flashcache setup error is : ioctl failed
120807 9:21:23 [Note] WSREP: Read nil XID from storage engines, skipping position init
120807 9:21:23 [Note] WSREP: wsrep_load(): loading provider library 'none'
120807 9:21:23 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
120807 9:21:23 [ERROR] Aborting
120807 9:21:23 [Note] WSREP: Service disconnected.
120807 9:21:24 [Note] WSREP: Some threads may fail to exit.
120807 9:21:24 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/sbin/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
Percona XtraDB Cluster is distributed with several useful UDFs from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details
[root@myhostname ~]# service mysql restart
MySQL (Percona Server) PID file could not be found! [FAILED]
Starting MySQL (Percona Server).The server quit without upd[FAILED]D file (/var/lib/mysql/myhostname.mydomain.pid).
#################my.cnf 4G#######################
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=tis620
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 820M
max_allowed_packet = 128M
table_cache = 1500
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 512M
thread_cache_size = 8
query_cache_size= 386M
thread_concurrency = 8
default-character-set=tis620
skip-name-resolve
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
innodb_file_per_table
innodb_data_home_dir = /var/lib/mysql/
#interactive_timeout = 600
#wait_timeout = 1200
innodb_data_file_path = ibdata1:100M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
############################# mysql 5.1.X
#innodb_log_arch_dir = /var/lib/mysql/
#############################
innodb_buffer_pool_size = 2456M
innodb_additional_mem_pool_size = 24M
innodb_log_file_size = 256M
innodb_log_buffer_size = 2M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 0
[mysqldump]
quick
max_allowed_packet = 16M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-
ทำ server แบบ cluster หรือ server mysql ธรรมดาครับเห็นติดตั้ง Percona-XtraDB-Cluster
-
Server Mysql ครับก่อนหน้านี่ติดตั้ง MySql percona 5.5.25 ก็ start mysql ไม่ได้เช่นกันครับ error แบบเดียวกัน
CentOS 6.2 ครับ ปิด selinux กับ firewall ละต้องตรวจสอบที่ไหนอีกครับ ???
-
โหลดคู่มืออ่านแล้วทำตามนะครับใช้ percona อันแรกถูกแล้วนะครับไม่ต้อง cluster
http://hosxp.net/index.php?option=com_smf&Itemid=28&topic=26019.0
-
percona 5.5.25a
http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.25a-27.1/RPM/rhel6/
-
ลองเอาของผมไปติดตั้งดูเพราะผมติดตั้งจริงและใช้ได้จริงไม่มีปัญหาใด ๆ
-
ลบกวนขอ my.cnf 4G สำหรับ Percona หน่อยครับ
Lifegoon_2006@hotmail.com
-
ลองเปลี่ยนค่าใน my.cnf ดูนะครับ ไม่รู้แก้ได้หรือยัง
warning: Percona-XtraDB-Cluster-client-5.5.24-23.6.341.rhel6.i686.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ########################################### [100%]
1:Percona-XtraDB-Cluster-########################################## [ 13%]
2:Percona-XtraDB-Cluster-########################################## [ 25%]
3:Percona-XtraDB-Cluster-########################################## [ 38%]
4:Percona-XtraDB-Cluster-########################################## [ 50%]
5:Percona-XtraDB-Cluster-########################################## [ 63%]
6:Percona-XtraDB-Cluster-########################################## [ 75%]
7:Percona-XtraDB-Cluster-########################################## [ 88%]
8:Percona-XtraDB-Cluster-########################################## [100%]
120807 9:21:23 [Note] Flashcache bypass: disabled
120807 9:21:23 [Note] Flashcache setup error is : ioctl failed
120807 9:21:23 [Note] WSREP: Read nil XID from storage engines, skipping position init
120807 9:21:23 [Note] WSREP: wsrep_load(): loading provider library 'none'
120807 9:21:23 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
120807 9:21:23 [ERROR] Aborting
120807 9:21:23 [Note] WSREP: Service disconnected.
120807 9:21:24 [Note] WSREP: Some threads may fail to exit.
120807 9:21:24 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/sbin/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
Percona XtraDB Cluster is distributed with several useful UDFs from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details
[root@myhostname ~]# service mysql restart
MySQL (Percona Server) PID file could not be found! [FAILED]
Starting MySQL (Percona Server).The server quit without upd[FAILED]D file (/var/lib/mysql/myhostname.mydomain.pid).
#################my.cnf 4G#######################
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=tis620
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 820M
max_allowed_packet = 128M
table_cache = 1500
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 512M
thread_cache_size = 8
query_cache_size= 386M
thread_concurrency = 8
default-character-set=tis620
skip-name-resolve
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
innodb_file_per_table
innodb_data_home_dir = /var/lib/mysql/
#interactive_timeout = 600
#wait_timeout = 1200
innodb_data_file_path = ibdata1:100M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
############################# mysql 5.1.X
#innodb_log_arch_dir = /var/lib/mysql/
#############################
innodb_buffer_pool_size = 2456M
innodb_additional_mem_pool_size = 24M
innodb_log_file_size = 256M
innodb_log_buffer_size = 2M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 0
[mysqldump]
quick
max_allowed_packet = 16M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-
เอา my.cnf มาฝาก ของผมใช้ได้ทั้ง 2G,4G,8G ครับเลือกใช้เอา !!!!
-
แจ้งผล Start Mysql ได้แล้วครับ ต่อไปน่าจะเกิดปัญหาที่ภาษารึป่าวครับ