xsbr

Galera SST mysqldump - mysql log

Nov 21st, 2011
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.79 KB | None | 0 0
  1. 111121 12:13:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data
  2. 111121 12:13:14 [Note] Plugin 'FEDERATED' is disabled.
  3. 111121 12:13:14 InnoDB: The InnoDB memory heap is disabled
  4. 111121 12:13:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  5. 111121 12:13:14 InnoDB: Compressed tables use zlib 1.2.3
  6. 111121 12:13:14 InnoDB: Using Linux native AIO
  7. 111121 12:13:15 InnoDB: Initializing buffer pool, size = 1.0G
  8. 111121 12:13:15 InnoDB: Completed initialization of buffer pool
  9. 111121 12:13:15 InnoDB: highest supported file format is Barracuda.
  10. 111121 12:13:15 InnoDB: Waiting for the background threads to start
  11. 111121 12:13:16 InnoDB: 1.1.8 started; log sequence number 1595645
  12. 111121 12:13:16 [Note] Recovering after a crash using /var/lib/mysql/logs/mysql-bin
  13. 111121 12:13:16 [Note] Starting crash recovery...
  14. 111121 12:13:16 [Note] Crash recovery finished.
  15. 111121 12:13:16 [Note] Event Scheduler: Loaded 0 events
  16. 111121 12:13:16 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
  17. 111121 12:13:16 [Note] WSREP: wsrep_load(): Galera 21.1.0(r86) by Codership Oy <info@codership.com> loaded succesfully.
  18. 111121 12:13:16 [Note] WSREP: Reusing existing '/var/lib/mysql/data//galera.cache'.
  19. 111121 12:13:16 [Note] WSREP: Passing config to GCS: gcache.dir = /var/lib/mysql/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql/data//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; 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; replicator.commit_order = 3
  20. 111121 12:13:16 [Note] /usr/sbin/mysqld: ready for connections.
  21. Version: '5.5.15-wsrep_21.2-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) wsrep patch: 21.21.2.r3595
  22. 111121 12:13:22 [Note] WSREP: Stop replication
  23. 111121 12:13:24 [Note] WSREP: Start replication
  24. 111121 12:13:24 [Note] WSREP: Found saved state: 63a3602a-1445-11e1-0800-a2059aac0e84:0
  25. 111121 12:13:24 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1
  26. 111121 12:13:24 [Note] WSREP: Setting initial position to 63a3602a-1445-11e1-0800-a2059aac0e84:0
  27. 111121 12:13:24 [Note] WSREP: protonet asio version 0
  28. 111121 12:13:24 [Note] WSREP: backend: asio
  29. 111121 12:13:24 [Note] WSREP: GMCast version 0
  30. 111121 12:13:24 [Note] WSREP: (f9b92af4-144a-11e1-0800-d120b33b673e, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  31. 111121 12:13:24 [Note] WSREP: (f9b92af4-144a-11e1-0800-d120b33b673e, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  32. 111121 12:13:24 [Note] WSREP: EVS version 0
  33. 111121 12:13:24 [Note] WSREP: PC version 0
  34. 111121 12:13:24 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer ''
  35. 111121 12:13:24 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,f9b92af4-144a-11e1-0800-d120b33b673e,1) memb {
  36. f9b92af4-144a-11e1-0800-d120b33b673e,
  37. } joined {
  38. } left {
  39. } partitioned {
  40. })
  41. 111121 12:13:25 [Note] WSREP: gcomm: connected
  42. 111121 12:13:25 [Note] WSREP: Changing maximum message size 0 -> 64500, result: 32636
  43. 111121 12:13:25 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  44. 111121 12:13:25 [Note] WSREP: Opened channel 'my_wsrep_cluster'
  45. 111121 12:13:25 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 0, memb_num = 1
  46. 111121 12:13:25 [Note] WSREP: STATE_EXCHANGE: sent state UUID: fa06296c-144a-11e1-0800-409afc9fee99
  47. 111121 12:13:25 [Note] WSREP: STATE EXCHANGE: sent state msg: fa06296c-144a-11e1-0800-409afc9fee99
  48. 111121 12:13:25 [Note] WSREP: STATE EXCHANGE: got state msg: fa06296c-144a-11e1-0800-409afc9fee99 from 0 (server1234)
  49. 111121 12:13:25 [Note] WSREP: Quorum results:
  50. version = 1,
  51. component = PRIMARY,
  52. conf_id = 0,
  53. members = 1/1 (joined/total),
  54. act_id = 0,
  55. last_appl. = -1,
  56. protocols = 0/1/1 (gcs/repl/appl),
  57. group UUID = 63a3602a-1445-11e1-0800-a2059aac0e84
  58. 111121 12:13:25 [Note] WSREP: Flow-control interval: [8, 16]
  59. 111121 12:13:25 [Note] WSREP: Restored state OPEN -> JOINED (0)
  60. 111121 12:13:25 [Note] WSREP: Member 0 (server1234) synced with group.
  61. 111121 12:13:25 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
  62. 111121 12:13:25 [Note] WSREP: New cluster view: group UUID: 63a3602a-1445-11e1-0800-a2059aac0e84, conf# 1: Primary, number of nodes: 1, my index: 0, first seqno: 1, protocol version 1
  63. 111121 12:13:25 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  64. 111121 12:13:25 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1
  65. 111121 12:13:25 [Note] WSREP: Synchronized with group, ready for connections
  66. 111121 12:13:25 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  67.  
  68.  
Add Comment
Please, Sign In to add comment