Problem Instalation Moodle with MySQL Galera Cluster

Problem Instalation Moodle with MySQL Galera Cluster

ໂດຍ wini mk -
ຈຳນວນການຕອບກັບ: 8


"Unexpected id generated for the Admin account. Your database configuration or clustering setup may not be fully supported"

"Nonconsecutive id generated for the Admin account. Your database configuration or clustering setup may not be fully supported."

i have a problem during install Moodle with MySQL Galera Cluster... i dont know why.. please help me ເສົ້າ

ການຈັດອັນດັບສະເລ່ຍ: -
ໃນການຕອບກັບຫາ wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

ໂດຍ Howard Miller -
ຮູບພາບຂອງ Core developers ຮູບພາບຂອງ Documentation writers ຮູບພາບຂອງ Particularly helpful Moodlers ຮູບພາບຂອງ Peer reviewers ຮູບພາບຂອງ Plugin developers
https://blog.mariadb.org/auto-increments-in-galera/ ??
ການຈັດອັນດັບສະເລ່ຍ:Useful (1)
ໃນການຕອບກັບຫາ Howard Miller

Re: Problem Instalation Moodle with MySQL Galera Cluster

ໂດຍ wini mk -
do you have another way?
ການຈັດອັນດັບສະເລ່ຍ: -
ໃນການຕອບກັບຫາ wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

ໂດຍ Jeff White -
Make your Moodle instance on a standard mysql db then import it to Galera. That is how we got our Galera cluster working and Moodle has been very happy in its new home.
ການຈັດອັນດັບສະເລ່ຍ:Useful (2)
ໃນການຕອບກັບຫາ Jeff White

Re: Problem Instalation Moodle with MySQL Galera Cluster

ໂດຍ wini mk -

can you tell me step by step how did you do it..

ການຈັດອັນດັບສະເລ່ຍ: -
ໃນການຕອບກັບຫາ wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

ໂດຍ Jeff White -

Simply build the instance a moodle install on a test/dev environment, mysqldump the db, import the db. Galera will load the rest with assigning out the unique fields when loading the tables.


https://docs.moodle.org/38/en/Moodle_migration#Backup_the_Moodle_database_on_the_old_server

ການຈັດອັນດັບສະເລ່ຍ: -