Barracuda to Antelope

Barracuda to Antelope

by Albert Ramsbottom -
Number of replies: 4

Anyone know this is a must?

Or can I ignore it on small installations?

Cheers

Albert

Average of ratings: -
In reply to Albert Ramsbottom

Re: Barracuda to Antelope

by Sergio Rabellino -
Picture of Particularly helpful Moodlers Picture of Plugin developers

AFAIK, Barracuda format it's a must, the differences about these 2 row formats it's explained here:

https://dev.mysql.com/doc/refman/5.6/en/innodb-file-format.html

If you don't convert your tables, the primary risk it's about the clipping of the values in some fields, which cannot store long variable-length data.

BTW the correct conversion direction is "Antelope to Barracuda..." and in the admin/moodleadmin directory you should find all the cli tools needed to check/fix your database engine/format.

Average of ratings:Useful (1)
In reply to Albert Ramsbottom

Re: Barracuda to Antelope

by Usman Asar -
Picture of Plugin developers Picture of Testers

As per moodle's requirements, its a recommended option and not required. Will come handy when restoring/backing up large courses.  Almost 80% cases wont even need it, but it annoys me to see amber colored warnings on moodle environment, therefore I convert them.

Average of ratings:Useful (1)
In reply to Usman Asar

Re: Barracuda to Antelope

by Albert Ramsbottom -

OK thanks

Does anyone know at what stage this was required as you are probably aware I am doing a march from 1.9.18 > 1.9.19 > 2.2.11 > 2.3.11 >2.7 > 2.9

big grin

Albert

In reply to Albert Ramsbottom

Re: Barracuda to Antelope

by Usman Asar -
Picture of Plugin developers Picture of Testers

My 2.7 started showing up on version update, so expect 2.7 onwards as 2.7 remains LTS version, so development work will be done on it until 2017 May I think, rest are only security maintained.

Average of ratings:Useful (1)