ผมติดตั้งเองครับไม่ได้ใช้ โปรแกรม MySQL Cluster Manager เพิ่งทดสอบเสร็จครับ ........ข้อมูลทั้ง 3 เครื่อง เท่ากัน แต่ระยะยาวยังไม่รู้จะเป็นแบบไหน ครับ
ติดตั้งเอง นะรัน mysql ได้
แต่ ใช้ MySQL Cluster Manager ไม่สามารถรันได้
อยากลองดู MySQL Cluster Manager ว่า ข้อมูลจะเป็นอย่างไร
เห็นมี tool ถ้าใช้ดีก็จะนำมาใช้จริง
อ.บอย ลง MySQL เอง
แต่ อ.ชัยพร แนะนำว่าจะต้องเป็น Galera Cluster ด้วย
ลองเปลี่ยนเป็น Galera Cluster ครับ
รอดูผลงาน อ.บอย
ผมนั่งแก้ ไป 4 บรรทัดแล้ว Error หายไป เหลือ Plunin Innodb
130313 04:22:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130313 04:22:14 mysqld_safe WSREP: Running position recovery with --log_error=
130313 04:22:15 mysqld_safe WSREP: Failed to recover position:
130313 4:22:15 [Note] WSREP: Read nil XID from storage engines, skipping position init
130313 4:22:15 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
130313 4:22:15 [Note] WSREP: wsrep_load(): Galera 2.3(r143) by Codership Oy <info@codership.com> loaded succesfully.
sh: /sbin/ifconfig: Permission denied
130313 4:22:15 [ERROR] WSREP: Failed to read output of: '/sbin/ifconfig | grep -E '^[[:space:]]+inet addr:' | grep -m1 -v 'inet addr:127' | sed 's/:/ /' | awk '{ print $3 }''
130313 4:22:15 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
130313 4:22:15 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
130313 4:22:15 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
130313 4:22:15 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'.
130313 4:22:15 [Note] WSREP: Passing config to GCS: base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
130313 4:22:15 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
130313 4:22:15 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
130313 4:22:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130313 4:22:15 InnoDB: The InnoDB memory heap is disabled
130313 4:22:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130313 4:22:15 InnoDB: Compressed tables use zlib 1.2.3
130313 4:22:15 InnoDB: Using Linux native AIO
130313 4:22:15 InnoDB: Initializing buffer pool, size = 7.7G
130313 4:22:15 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /var/lib/mysql/ibdata1 is of a different size
InnoDB: 1152 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 6400 pages, max 0 (relevant if non-zero) pages!
130313 4:22:15 InnoDB: Could not open or create data files.
130313 4:22:15 InnoDB: If you tried to add new data files, and it failed here,
130313 4:22:15 InnoDB: you should now edit innodb_data_file_path in my.cnf back
130313 4:22:15 InnoDB: to what it was, and remove the new ibdata files InnoDB created
130313 4:22:15 InnoDB: in this failed attempt. InnoDB only wrote those files full of
130313 4:22:15 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
130313 4:22:15 InnoDB: remove old data files which contain your precious data!
130313 4:22:15 [ERROR] Plugin 'InnoDB' init function returned error.
130313 4:22:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130313 4:22:15 [ERROR] Unknown/unsupported storage engine: InnoDB
130313 4:22:15 [ERROR] Aborting
130313 4:22:15 [Note] WSREP: Service disconnected.
130313 4:22:16 [Note] WSREP: Some threads may fail to exit.
130313 4:22:16 [Note] /usr/sbin/mysqld: Shutdown complete
130313 04:22:16 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
หัวข้อ: MySQL Cluster Manager พร้อมให้ทดสอบกันแล้วครับ (อ่าน 123438 ครั้ง)