Re: [google-cloud-sql-discuss] Cloud SQL connect to an android app

Hi,

When load testing it is important to have usage as close as possible to your real use. For this reason, I recommend creating a duplicate of your production environment (backend+frontend) and then a system to generate the same requests that your clients use. Make this slowly increase the number of requests, measuring errors and latency. Keep going until errors or latency becomes unacceptable; this will tell you the capacity of the environment you have created. Try this with different Cloud SQL instances sizes, and see which provides enough capacity for you.

I am not sure what you mean when you say "create REST API". If you mean making Cloud SQL instances via API: yes; see https://cloud.google.com/sql/docs/admin-api/v1beta4/instances/insert. If you mean does Cloud SQL have a REST API for creating records in the database: no. You must write your own front end that takes user requests and then calls to the database. You may find App Engine + Endpoints (https://cloud.google.com/endpoints/) helps this.

As an alternative you make like to look at Firebase (https://firebase.google.com/). This provides a database for designing Apps without requiring any front end work. It's database is less powerful than Cloud SQL but easier to use.

David

On Fri, Jul 8, 2016 at 10:55 PM, Ccs <chgchksg128@gmail.com> wrote:

Hi David, 

Thanks for the reply.

I am newbie in database.

How can I do a load testing?

Besides, create REST API is included in google cloud sql package?

On Saturday, 9 July 2016 00:55:09 UTC+8, David Newgas wrote:

Hi,

Do you have any questions about this?

If you are asking which package to use, it depends on what your usage is like. We recommend that you do load testing to determine whether a given configuration is sufficient for your needs.

David

On Fri, Jul 8, 2016 at 1:55 AM, Ccs <chgch...@gmail.com> wrote:

Good day,

I am creating an app with an access of 500,000 view per day.

I did with another services to store my MySQL database and then create rest API to connect.

Now I want to migrate to Google cloud SQL.

My data is about 1MB only and all text.

I am thinking if the cheapest package with 500,000 access of API is able to support.

Thanks

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e372249d-76b3-4a2d-a918-70060472652b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d2a2d489-79f3-443d-ac81-26afdab8cd09%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bY_w_w0y5XrfKZNQjO%2B_jx36yi4Ed%3DFWGOEv%2BL4zTEryQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.