App Engine and MySQL

I just wanted to ask if we can access an external MySQL server开发者_Python百科 from Google App Engine...

The only way to communicate with other hosts is by using UrlFetch that only provides HTTP and HTTPS requests.
So, you can't do it out of the box.

Anyway, if you really need to access an external MySQL server database, you should consider to expose it through a Web API (RESTful, Soap web-services for example). In this way your data would be available also via UrlFetch.

I am still in the learning phase of all this, but I am fairly certain you can do this now a few ways:

• Link Apps Scripts to App Engine and use the JDBC
• Link it to Google
• Cloud SQL Store your SQL database on Google Cloud Store
• Connect Apps Scripts via spreadsheet scripting

"Google Apps Script has the ability to make connections to databases via JDBC with the Jdbc Service. The current support extends to MySQL, Microsoft SQL Server and Oracle. Apps Script makes it easy to connect to databases hosted on Google Cloud SQL, but also works with other cloud hosting platforms and even local databases." https://developers.google.com/apps-script/jdbc

(edited for structure)

It is still not possible to native connect GAE to an external MySQL server the only exception is Googles Cloud SQL. We are using it in our production environment and like the experience. Stable and the performance is good.

GAEs own database scales well and we are using it in most situations, but in cases where we need to ask more complex questions or need aggregate functions, we use Googles Cloud SQl.

These answers are a bit outdated. Google App Engine instances can connect to external database servers.

The ability to connect externally requires that the account the App Engine is running under be a "paid account" a/k/a "billing enabled".

References:

-https://cloud.google.com/appengine/docs/php/using-third-party-databases

-https://cloud.google.com/appengine/docs/php/runtime#PHP_Functions_that_requires_billing_enabled