{"id":532,"date":"2014-12-23T15:51:14","date_gmt":"2014-12-23T13:51:14","guid":{"rendered":"http:\/\/misto.ch\/?p=532"},"modified":"2014-12-23T15:51:14","modified_gmt":"2014-12-23T13:51:14","slug":"add-database-to-your-paas","status":"publish","type":"post","link":"https:\/\/misto.ch\/de\/2014\/12\/23\/add-database-to-your-paas\/","title":{"rendered":"Add a Database to your own PaaS"},"content":{"rendered":"

This is the second part of our series on how to be your own PaaS provider using Dokku and RunAbove. The first part covered the basic installation<\/a> and enabled us to deploy simple Play applications. In this part, we’ll deploy a more interesting application that uses a database.
\n<\/p>\n

Adding support for databases and other additional services is handled by Dokku plugins<\/a>. Our goal is to add a MariaDB database instance and to deploy a Play application that uses it. So first we need to install one of the MariaDB plug-ins<\/a>.<\/p>\n

\n% ssh admin@ownpaas.tk\ncd \/var\/lib\/dokku\/plugins\nsudo git clone --recursive https:\/\/github.com\/Kloadut\/dokku-md-plugin mariadb\ncd mariadb\/dockerfiles\nsudo git checkout master\nsudo dokku plugins-install\n<\/pre>\n
Everything is well if the last command finishes with no output. You can verify that the plugin got installed by running dokku help:<\/p>\n
\nadmin@my-own-paas:~$ dokku help\n...\n    mariadb:console <app>     Open mysql-console to MariaDB container\n    mariadb:create <app>      Create a MariaDB container\n    mariadb:delete <app>      Delete specified MariaDB container\n    mariadb:dump <app> <file> Dump default db database into file\n    mariadb:dumpraw <app>     Dump default db database to std out \n    mariadb:info <app>        Display database informations\n    mariadb:link <app> <db>   Link an app to a MariaDB database\n    mariadb:logs <app>        Display last logs from MariaDB container\n<\/pre>\n
So let’s create a database! <\/p>\n
\nadmin@my-own-paas:~$ dokku mariadb:create computers\n\n-----> MariaDB container created: mariadb\/computers\n\n       Host: 172.17.42.1\n       Port: 49154\n       User: 'root'\n       Password: 'XXX'\n       Database: 'db'\n<\/pre>\n
You don’t have to write the configuration down, we will later inject them into our application container as environment variables. First, create a new application and do the usual dance to deploy it:<\/p>\n
\n% activator new computer-database computer-database-scala\n% cd computer-database\/\n% git init && git add . && git commit -m "init"\n% git remote add dokku dokku@ownpaas.tk:computer-database\n% git push dokku HEAD \n...\n=====> Application deployed:\n       http:\/\/computer-database.ownpaas.tk\n<\/pre>\n
Don’t try to access the application, it won’t work. Why?<\/p>\n
\nadmin@my-own-paas:~$ dokku apps\n=== My Apps\ncomputer-database\nplay-scala\nadmin@my-own-paas:~$ dokku logs computer-database\nPicked up JAVA_TOOL_OPTIONS:  -Djava.rmi.server.useCodebaseOnly=true\n@6ki18l5gj: Database 'default' needs evolution!\n...\n[warn] play - Run with -DapplyEvolutions.default=true if you want to run them automatically (be careful)\n<\/pre>\n
Not only does it need evolution, we also need to configure it to use our MariaDB instead of the H2 in-memory database it is currently configured to use. We can pass the evolutions-option using an environment variable:<\/p>\n
\nadmin@my-own-paas:~$ dokku config:set computer-database "JAVA_OPTS=-DapplyEvolutions.default=true"\n<\/pre>\n
Now, let’s link the application container to the database container:<\/p>\n
\nadmin@my-own-paas:~$ dokku mariadb:link computer-database computers\n...\n-----> Setting config vars and restarting computer-database\n       DB_HOST:     172.17.42.1$\n       DB_PASSWORD: 18BZYCAANmepCbPD$\n       DB_NAME:     db$\n       DB_PORT:     49154$\n       DB_USER:     root\n...\n-----> computer-database linked to mariadb\/computers database\n<\/pre>\n
We can use those environment variables in the application configuration, so edit conf\/application.conf and change the database section to this:<\/p>\n
\ndb.default.driver=com.mysql.jdbc.Driver\ndb.default.url="jdbc:mysql:\/\/"${DB_HOST}":"${DB_PORT}"\/"${DB_NAME}\ndb.default.user=${DB_USER}\ndb.default.password=${DB_PASSWORD}\n<\/pre>\n
Also don’t forget to update the build configuration to add the JDBC MySQL connector:<\/p>\n
\nlibraryDependencies ++= Seq(\n  ...\n  "mysql" % "mysql-connector-java" % "5.1.30"\n)\n<\/pre>\n
Ideally, we would be done now, but the SQL script in the evolutions aren’t valid for MySQL\/MariaDB, so we need to patch the sample application. I’ve prepared a patch that you can apply to your application (based on this fork<\/a>):<\/p>\n
\n% curl http:\/\/misto.ch\/wp-content\/mysql-compatible-evolutions.patch | git apply -\n<\/pre>\n
Add and commit to the repository to deploy:<\/p>\n
\n% git commit -a -m "db config"\n% git push dokku HEAD\n<\/pre>\n
Now it’s time to visit your application! This concludes this series. Let me know in the comments if you have any suggestions for further articles, providers to evaluate or things to deploy.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is the second part of our series on how to be your own PaaS provider using Dokku and RunAbove. The first part covered the basic installation and enabled us to deploy simple Play applications. In this part, we’ll deploy a more interesting application that uses a database. Adding support for databases and other additional […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,27],"tags":[29,35,36,38],"class_list":["post-532","post","type-post","status-publish","format-standard","hentry","category-infoq","category-scala","tag-database","tag-paas","tag-play","tag-scala"],"_links":{"self":[{"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/posts\/532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/comments?post=532"}],"version-history":[{"count":0,"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/posts\/532\/revisions"}],"wp:attachment":[{"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/media?parent=532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/categories?post=532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/misto.ch\/de\/wp-json\/wp\/v2\/tags?post=532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}