Cloud SQL instances can be built in any zone within a region. An instance’s specification, such as RAM size and number of CPU cores, is defined by its instance type.
Cloud SQL supports MySQL versions 5.5 and 5.6 and PostgreSQL version 9.5.
Cloud SQL instances are made accessible by mapping Cloud IPs to them.
When an instance is first created, admin credentials are automatically generated by the API. The credentials are only displayed at create time, since the admin password is not stored by the API, so cannot be retrieved later.
A new password can be generated at any time, using the “Reset admin password” action. This generates a new admin password and updates the instance with it.
For convenience, Cloud SQL instances created from snapshots inherit the admin password from the snapshot, rather than generating a new one each time.
Creating a snapshot of a Cloud SQL instance takes an instant and consistent copy of the databases stored on it. Snapshots can be created manually at any time and also automatically by specifying a schedule. New instances perform daily scheduled snapshots by default.
The snapshot itself is instantaneous, but the copy process can take anything from 30 seconds to several minutes depending on the size of the databases and the load on your instance.
During the copy process, the snapshot is held on the instance so the instance cannot be destroyed until the copy is completed.
New Cloud SQL instances can be built using a snapshot as a starting point, essentially cloning an instance. Instances created from snapshots inherit the admin password from the snapshot.
Cloud SQL snapshots can be deleted from the images container in Orbit at any time using Brightbox Manager or the CLI.
Minor version updates to the database engine are automatically applied during a weekly one hour maintenance window.
The maintenance window can be set to any hour during the week but defaults to Sunday morning between 06:00am and 07:00am UTC.
During any updates, service can be interrupted for short periods of time if the instance needs to be restarted.
Minor version updates are from the upstream vendor, and will usually only contain bug and security patches.
The Cloud SQL MySQL engine supports versions 5.5 and 5.6. You can specify which version at create time. The latest minor version is used at create time and any new point releases from then on will be installed in the weekly maintenance window.
Snapshots are compatible between point releases but not between minor versions. So you cannot snapshot a MySQL 5.5 instance and create a 5.6 instance from the snapshot. To upgrade minor versions, create a new instance and use the standard mysql tools to take and reload a database dump.
The snapshot process depends on crash recoverable storage engines, such as InnoDB. MySQL’s MyISAM engine is not a crash recoverable storage engine so snapshots of MyISAM tables may result in incomplete or corrupt data.
If you need to use MyISAM tables, then you can minimise the risk of corrupted tables in snapshots by flushing and locking them prior to making a snapshot. They only need to be locked for a few seconds at the start of the snapshot, and not during the copy process.
The Cloud SQL PostgreSQL engine supports version 9.5. You can specify which version at create time. The latest minor version is used at create time and any new point releases from then on will be installed in the weekly maintenance window.
The following PostgreSQL extensions are available for use and can be activated
using the standard
CREATE EXTENSION command.
Cloud SQL instance specifications are set at create time by setting a Cloud SQL type. There are several Cloud SQL types available and are listed on the pricing page, in the Brightbox Manager GUI and in the CLI. A type specifies the combined RAM, disk size and number of cpu cores of the Cloud SQL instance.
To change the type of an instance, you should snapshot it and create a new instance of the desired type from the snapshot.
When downgrading, you must ensure that the snapshot data size is not larger than the capacity of the smaller instance type.
Cloud SQL instances are billed by the hour, starting from when it is first created until it is destroyed. Data between the instance and the Internet is billed per gigabyte at the standard Internet data rates. Data between the instance internally from within the same region is free.
Snapshot storage is billed per gigabyte at the Orbit storage rate.
Last updated: 20 Jul 2018 at 10:51 UTC