CODEWITHSUNDEEP
mysqlgoogle-app-enginegoogle-compute-engine
Roshan N
Roshan N

Reputation: 11

compute engine sql shared with app engine

what is the best method of sharing SQL server running on my compute engine (debian) with app engine?

I've tried creating a firewall policy to allow all connection from tcp:3306 but it's not working. The port still seems to remain blocked. I don't feel comfortable opening up this port anyways so maybe there are alternative ways to do this that is more secure?

so its actually two questions why am i unable to open port 3306 and what is a better way of allowing SQL connection from app engine to compute engine :)

Upvotes: 1

Views: 194

Answers (1)

David
David

Reputation: 9731

There are several options open to you:

  1. You could use Google Cloud SQL, which has specific ACL options for App Engine.

  2. You can open the port... you must ensure:

    I recommend you test this from your own workstation as well as from App Engine. This uses the socket API from Google App Engine, and so requires you have billing enabled.

  3. Or you could switch to using the App Engine Datastore. This has the advantage that it will scale much better than MySQL, and does not have a single point of failure.

Upvotes: 2

Related Questions