Problem Instalation Moodle with MySQL Galera Cluster

Problem Instalation Moodle with MySQL Galera Cluster

by wini mk -
Number of replies: 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 sad

Average of ratings: -
In reply to wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
https://blog.mariadb.org/auto-increments-in-galera/ ??
Average of ratings: Useful (1)
In reply to Howard Miller

Re: Problem Instalation Moodle with MySQL Galera Cluster

by wini mk -

I've tried it and the results are the same

Average of ratings: -
In reply to Howard Miller

Re: Problem Instalation Moodle with MySQL Galera Cluster

by wini mk -
do you have another way?
Average of ratings: -
In reply to wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Sorry - I've never used Galera. That was just the outcome of a search.
Average of ratings: -
In reply to wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

by 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.
Average of ratings: Useful (2)
In reply to Jeff White

Re: Problem Instalation Moodle with MySQL Galera Cluster

by wini mk -

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

Average of ratings: -
In reply to wini mk

Re: Problem Instalation Moodle with MySQL Galera Cluster

by 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

Average of ratings: -
In reply to Jeff White

Re: Problem Instalation Moodle with MySQL Galera Cluster

by wini mk -

ok i'll try it.. thank you for your suggestion

Average of ratings: -