Tuesday, November 22, 2011

Cloud SQL limited preview

Dear Cloud SQL Limited Previewers

This is a friendly reminder that Cloud SQL is currently in limited preview: that means we are offering it on a limited basis to selected developers so that they can preview its capabilities and allow us to improve the service, and it is currently offered without performance or availability guarantees.

Cloud SQL is not currently recommended for mission-critical or high-intensity production applications.

While evaluating Cloud SQL we would ask you to bear in mind the following:
  • All your data is multiply geographically replicated, but we do not currently offer an automated backup service. Backups can be taken manually through the Google Cloud SQL dashboard (under 'Actions').

  • Synchronous replication also has an impact on write performance compared to non-replicated local disk. This especially affects bulk data imports. There are useful tips on optimising bulk imports here:
    http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html

  • Also bear in mind that many queries also involve writing to disk, for example those involving 'order by' clauses, and that these will also be slowed by replication. There are useful tips on optimising such queries here:
    http://dev.mysql.com/doc/refman/5.5/en/order-by-optimization.html

Let me know if you have any questions

thanks

J

--
Joe Faith | Product Manager | Google Cloud SQL

No comments:

Post a Comment