2.2. Launching from the Google (GCP) Marketplace

You can launch your instances in GCP via the Marketplace. Simply search for "Continuent" to view all the listings available. For the Clustering solution you will need to subscribe to "Tungsten Clustering for MySQL", and then clicking the "Get Started" button.

Once subscribed you can then start to configure your instance. When choosing the instance size there are a number of factors to take into account

  • Which topology are you deploying? For a standard 3-node cluster the minimum instance should be at least a c3-standard-4. For advanced topologies you shoud consider at least a c3-standard-8 (or the equivalent depending on the availability within the region your are deploying). Ideally, you should also consider ssd for the disk. The larger your anticipated workload, then the larger the instance should be, and should primarily be determined by your MySQL Database needs.

  • How large will your database be? By default the instance is launched with a 40Gb partition which should be suitable for most small to medium workloads. You should consider increasing this as required, based on your MySQL Database needs, taking into consideration that binary logging must be enabled and there will be an almost 1:1 relationship between binary logs and THL Logs.

Quantity of instances and their Location

  • Standard Clusters : You will need a minimum of 3-nodes, for any greater, there must be an odd number to maintain quorum, for example 3,5,7,9 etc. All nodes must be in the same region however they can, and probably should, be in different zones.

  • Composite Active/Passive & Composite Active/Active Clusters : These topologises consist of multiple clusters connected together, each cluster must conform to the same node count and rules for a standard cluster, and there must be a minimum of 2 clusters. Therefore for these topologies you will need a minimum of 6 nodes (3 per cluster). Each cluster may reside in a different region, allowing you to configure full geo-distribution.

  • For more details and to understand the different topologies, see Deployment: MySQL Topologies. Whilst the launch wizard on the launched VM will assist you to pre-configure either a Standard cluster, a Composite Active/Passive cluster or a Composite Active/Active cluster, users with advanced knowledge can adjust and configure the nodes to suit any required clustering topology available.

Based on your business rules, you will need to configure the appropriate network rules to allow you to access the host via your chosen terminal application, additionally you will need to allow communication between all nodes within the cluster, and to allow your applications to communicate with the proxy nodes. A full breakdown of the network requirements can be found here: Configuring Network and SSH Environment

After luanching your instances, you can now proceed to configure them, see Chapter 4, Configuring Instances through the Launch Wizard for instructions