MySQL Grails

Grails-MySql

Integrate MySQL with Grails

This quickstart guide will help you to integrate your Grails application with MySQL service on App42 PaaS.


Glossary

Kontena – Kontena is a lightweight container that will run your apps and services in an isolated and secured manner. You can specify the power of the Kontena while setting up infra or creating services. One Kontena power specifies to 256 MB Memory and 128 MHz CPU.

Service – Services in the App42 PaaS are add-on components which are needed in an App. App42 PaaS supports multiple services like SQL databases, NoSQL databases and more.

Prerequisites

To get going with App42 PaaS, below are few prerequisites that will allow you to use AppHQ – App42 PaaS Management Console as well as Command Line Client.


Configure MySQL credentials into Grails App

Once you have setup the Grails environment and created the MySQL service, You need to configure the MySQL credentials in your created Grails application.


hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
}
// environment specific settings
environments {
    production {
        dataSource {
            dbCreate = "update" // one of 'create', 'create-drop','update'
            pooled = true
            driverClassName = "com.mysql.jdbc.Driver"
            username = "${username}"
            password = "${password}"
            url = "jdbc:mysql://{host}:${port}/${databaseName}?autoReconnect=true"
            dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
            properties {
                validationQuery="select 1"
                testWhileIdle=true
                timeBetweenEvictionRunsMillis=60000
            }
        }
    }
}

You can also use our Sample Apps and extend it to suit your needs. Here is the link to Grails-MySQL Sample App

Update Application

After doing all the modifications to your App, you need to update it on App42 PaaS to get the changes affected in your App running on App42 PaaS platform.

$ app42 update
Enter App Name: testGrails
1: Binary
2: Source
Choose Upload Type [Binary]: 2

Updating Application... OK

Operation is in progress, Please wait...-
App deployed successfully.