Status request for RDS mysql service

[Athanasios Antoniou]

Hi everyone,

I have been (unsuccessfully) trying to deploy an RDS mysql service using the job template in cf-services-release repository. I'd like to ask whether the RDS service is currently working, and if so, could you provide a sample manifest of a working RDS service?

Thanks,

Nassos Antoniou

Software Engineer - GiMiScale B.V.

[James Bayer]

Nassos,

Can you confirm your use case? You want to have a big RDS MySQL server instance used in a multi-tenant way with many smaller MySQL database instances?

We are no longer using the MySQL RDS service at Pivotal since we have partnered with ClearDB to provide MySQL Services that are hosted at run.pivotal.io. It was working for us for awhile, so the code may be usable, but is not being actively used by us.

The best place to look at what values are required for a manifest is probably here in the spec file for the rds_mysql_gateway:

https://github.com/cloudfoundry/cf-services-release/blob/master/jobs/rds_mysql_gateway/spec

specifically the mysql_gateway.yml.erb file:

https://github.com/cloudfoundry/cf-services-release/blob/master/jobs/rds_mysql_gateway/templates/mysql_gateway.yml.erb

If I hear about an example manifest, then I try to share it.

To unsubscribe from this group and stop receiving emails from it, send an email to vcap-dev+u...@cloudfoundry.org.

--

Thank you,

James Bayer

[Athanasios Antoniou]

Thanks for your response James.

Indeed, I want to setup a multi-tenant RDS MySQL, which will host DBs of different CF users. 

The difficulty I'm facing with the mysql_gateway job template, is understanding how to specify the endpoint to the external service, in our case to the RDS DB. Also, I'm not sure what the role of the mysql_node_external job template is. 

Thanks,

Nassos Antoniou

[Sarah Chandler]

Hi Nassos, 

We've attached a deployment manifest for the configuration of the MySql gateway that you're attempting to use (with sensitive information redacted). Note that we're using the rds_mysql_gateway job with the mysql_node_external job. As James said, we haven't deployed the MySQL service in some time, so this configuration has not been recently tested.

Thanks,

Sarah Chandler and Matt Royal

[Athanasios Antoniou]

Thanks Sarah and Matt!

I have used the deployment manifest you have provided, and the service is working fine.

Kind Regards,

Nassos

[James Bayer]

nassos one idea that I'd humbly submit to you is to consider creating a section and page the cf-wiki [1] that described what you had to do to use the rds service and include the sample manifest. pivotal is not actively using it anymore so if the community doesn't collect the lessons learned somewhere useful, the next person will have to get lucky enough to find this mailing list thread and may still not know what other things you had to do to get it going.

[1] https://github.com/cloudfoundry-community/cf-docs-contrib/wiki

[Athanasios Antoniou]

Sorry for the late reply James,

I will document my rds mysql configuration and post a link to this discussion.

[Kinjal Doshi]

Hi Nassos,

I am trying to achieve something similar. It would be great if you could please share the process you used for provisioning MySQL on AWS via RDS for Cloud Foundry v2. 

Regards,

Kinjal