I have little experience with CloudFoundry. They are so kind to sponsor the GR8Conf website deployed through their service. To configure SQL, it seems to me that a simple solution is to use the CloudFoundry plugin and type
cloudFoundry.db.schemaName = "myName"
in the config / CloudFoundry.groovy file.
In your config / DataSource.groovy file, you should:
production {
dataSource {
driverClassName = 'com.mysql.jdbc.Driver'
dbCreate = "update"
url = "jdbc: mysql: // localhost / myName" // or url = "jdbc: mysql: // $ {System.getProperty (" dbHostName "," localhost ")} / myName"
dialect = 'org.hibernate.dialect.MySQLDialect'
username = "myName_user"
password = "myName_password"
}
}
(I got some of this information from: http://www.cloudfoundry.com/getting_started.html )
I do not think you need to provide additional SQL scripts. What you defined in your BootStrap will happen through deployment.
For the price, I have no ideas. I suggest you write their support to ask.
On the other hand: www.gr8conf.org website is not yet running on EC2, but I did not understand how to back up my database from EC2 to S3, and this is very important, because when the EC2 instance ends, everything in it lost if backup is not performed. / Søren
sbglasius
source share