La mise en production de Rivendell ne se limite pas à installer un package sur une machine. De nombreuses questions se posent lors de la préparation de son installation. C’était justement le sujet d’une réunion avec l’équipe de Divergence FM au début du mois. Le support préparé pour cette discussion a donné naissance à une présentation de quelques 40 slides.
Several of the Tryphon applications are in production with postgresql databases. AudioBank is in this case. Mostly because Tim is persuaded that MySql sucks :-p
In my laptop, only MySql is running. So to retrieve production data, I need to migrate it.
Dump only data from the wanted postgresql database :
pg_dump -d -a --column-inserts <database> > data.sql
Remove postgresql specific instructions :
sed -i -e '/^SET / d' -e '/^SELECT pg_catalog/ d' data.sql
If needed, change quotes used for postgresql reserved keywords (in column names for example) :
sed -i -e 's/"key"/`key`/' -e 's/"type"/`type`/' \ -e 's/"version"/`version`/' -e 's/"password"/`password`/' data.sql
Create a fresh structure of your mysql database (with rake db:migrate for example) and insert the data :
mysql database < data.sql
Our Autres(M)Ondes mobile studio integrates for a while a NAS server dedicated to rivendell mysql and files. The first steps to set up a such server are described into the Rivendell wiki page Setting up a dedicated Rivendell MySQL and audio store server.
Tryphon