Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # this is read by the standalone daemon and embedded servers
- [server]
- # this is only for the mysqld standalone daemon
- [mysqld]
- #
- # * Galera-related settings
- #
- [galera]
- # Mandatory settings
- wsrep_on=ON
- wsrep_provider="/usr/lib/galera/libgalera_smm.so"
- wsrep_cluster_address="gcomm://10.2.0.4,10.2.0.5"
- binlog_format=row
- default_storage_engine=InnoDB
- innodb_autoinc_lock_mode=2
- innodb_locks_unsafe_for_binlog=1
- query_cache_size=0
- query_cache_type=0
- wsrep-sst-method=rsync
- #wsrep_sst_auth=sst_user:sst_passwd
- #
- # Allow server to accept connections on all interfaces.
- #
- bind-address=0.0.0.0
- #
- # Optional setting
- #wsrep_slave_threads=1
- #innodb_flush_log_at_trx_commit=0
- # this is only for embedded server
- [embedded]
- # This group is only read by MariaDB servers, not by MySQL.
- # If you use the same .cnf file for MySQL and MariaDB,
- # you can put MariaDB-only options here
- [mariadb]
- # This group is only read by MariaDB-10.1 servers.
- # If you use the same .cnf file for MariaDB of different versions,
- # use this group for options that older servers don't understand
- [mariadb-10.1]
- $ docker rm -f some-mariadb
- $ rm -rf /mnt/resource/data/*
- $ docker run
- --name some-mariadb
- -v /mnt/resource/mysql.conf.d:/etc/mysql/conf.d
- -v /mnt/resource/data:/var/lib/mysql
- -e MYSQL_ROOT_PASSWORD=my-secret-pw
- -e MYSQL_USER=sst_user
- -e MYSQL_PASSWORD=sst_passwd
- -d
- -p 3306:3306
- -p 4567:4567/udp
- -p 4567-4568:4567-4568
- -p 4444:4444
- mariadb:10.1
- --wsrep-new-cluster
- --wsrep_node_address=10.2.0.4
- $ rm -rf /mnt/resource/data/*
- $ docker rm -f some-mariadb
- # Create a mysql folder so the Docker container won't initialize the db again
- $ mkdir -p /mnt/resource/data/mysql
- $ docker run
- --name some-mariadb
- -v /mnt/resource/mysql.conf.d:/etc/mysql/conf.d
- -v /mnt/resource/data:/var/lib/mysql
- -d
- -p 3306:3306
- -p 4567:4567/udp
- -p 4567-4568:4567-4568
- -p 4444:4444
- mariadb:10.1
- --wsrep_node_address=10.2.0.5
- 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
- 2016-01-23 23:57:52 140131133560576 [Warning] WSREP: RBR event 1 Query apply warning: 1, 1536
- 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