Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.53 KB | None | 0 0
  1. # this is read by the standalone daemon and embedded servers
  2. [server]
  3.  
  4. # this is only for the mysqld standalone daemon
  5. [mysqld]
  6.  
  7. #
  8. # * Galera-related settings
  9. #
  10. [galera]
  11. # Mandatory settings
  12. wsrep_on=ON
  13. wsrep_provider="/usr/lib/galera/libgalera_smm.so"
  14. wsrep_cluster_address="gcomm://10.2.0.4,10.2.0.5"
  15. binlog_format=row
  16. default_storage_engine=InnoDB
  17. innodb_autoinc_lock_mode=2
  18. innodb_locks_unsafe_for_binlog=1
  19. query_cache_size=0
  20. query_cache_type=0
  21. wsrep-sst-method=rsync
  22. #wsrep_sst_auth=sst_user:sst_passwd
  23.  
  24. #
  25. # Allow server to accept connections on all interfaces.
  26. #
  27. bind-address=0.0.0.0
  28. #
  29. # Optional setting
  30. #wsrep_slave_threads=1
  31. #innodb_flush_log_at_trx_commit=0
  32.  
  33. # this is only for embedded server
  34. [embedded]
  35.  
  36. # This group is only read by MariaDB servers, not by MySQL.
  37. # If you use the same .cnf file for MySQL and MariaDB,
  38. # you can put MariaDB-only options here
  39. [mariadb]
  40.  
  41. # This group is only read by MariaDB-10.1 servers.
  42. # If you use the same .cnf file for MariaDB of different versions,
  43. # use this group for options that older servers don't understand
  44. [mariadb-10.1]
  45.  
  46. $ docker rm -f some-mariadb
  47. $ rm -rf /mnt/resource/data/*
  48. $ docker run
  49. --name some-mariadb
  50. -v /mnt/resource/mysql.conf.d:/etc/mysql/conf.d
  51. -v /mnt/resource/data:/var/lib/mysql
  52. -e MYSQL_ROOT_PASSWORD=my-secret-pw
  53. -e MYSQL_USER=sst_user
  54. -e MYSQL_PASSWORD=sst_passwd
  55. -d
  56. -p 3306:3306
  57. -p 4567:4567/udp
  58. -p 4567-4568:4567-4568
  59. -p 4444:4444
  60. mariadb:10.1
  61. --wsrep-new-cluster
  62. --wsrep_node_address=10.2.0.4
  63.  
  64. $ rm -rf /mnt/resource/data/*
  65. $ docker rm -f some-mariadb
  66. # Create a mysql folder so the Docker container won't initialize the db again
  67. $ mkdir -p /mnt/resource/data/mysql
  68. $ docker run
  69. --name some-mariadb
  70. -v /mnt/resource/mysql.conf.d:/etc/mysql/conf.d
  71. -v /mnt/resource/data:/var/lib/mysql
  72. -d
  73. -p 3306:3306
  74. -p 4567:4567/udp
  75. -p 4567-4568:4567-4568
  76. -p 4444:4444
  77. mariadb:10.1
  78. --wsrep_node_address=10.2.0.5
  79.  
  80. 2016-01-23 23:57:52 140131133560576 [ERROR] Slave SQL: Error 'Column 'Time_zone_id' cannot be null' on query. Default database: 'mysql'. Query: 'INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Etc/GMT', @time_zone_id)', Internal MariaDB error code: 1048
  81. 2016-01-23 23:57:52 140131133560576 [Warning] WSREP: RBR event 1 Query apply warning: 1, 1536
  82. 2016-01-23 23:57:52 140131133560576 [Warning] WSREP: Ignoring error for TO isolated action: source: 09357a0e-c22d-11e5-963a-0a6f9b6b61c4 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 5 trx_id: -1 seqnos (l: 1147, g: 1536, s: 1535, d: 1535, ts: 73713003335315)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement