Blog

Try the Latest Version of Tungsten Cluster (AMI) on the AWS Marketplace from as little as $0.70 per node / per hour

Tungsten Cluster (AMI): Run highly available MySQL database clusters in the AWS cloud from as little as $0.70 per node / per hour

If you’re looking for an easy-to-use and cost-efficient MySQL HA, DR and geo-clustering solution, our AMI has got you covered!

The Continuent Tungsten Cluster (AMI) is a complete, fully-integrated, fully-tested MySQL HA, DR and geo-clustering solution on the AWS Marketplace for business-critical MySQL, MariaDB, & Percona Server applications.

It includes all of the features and benefits provided by our flagship product, Tungsten Cluster; and makes it easy to create MySQL database clusters in the AWS cloud, across multiple zones and regions, while keeping the data available even when systems fail. It provides full clustering support, including:

  • Intelligent Proxy with advanced load balancing.
  • Very fast, automatic local failover for HA, and rapid, automated global failover for DR.
  • Zero downtime maintenance.
  • Active/Active, multi-site deployments.

And all from as little as $0.70 per node / per hour (including AWS usage fees). Note that a minimum of 3 nodes is required, which would be a single cluster configuration. Multiple clusters can also be configured, see further details below.

Tungsten Cluster (AMI) is composed of three core components as well as our Tungsten MySQL monitoring and management GUI.

The following is also included:

  • MySQL Community Edition v5.7 or MySQL Community Edition v8.0 pre-configured with all the required prerequisites to run a Tungsten Cluster.
    Note: Tungsten Cluster supports all MySQL variants and versions (including MariaDB and Percona Server). You can replace the pre-configured MySQL version with your preferred choice.
  • HAProxy and Apache pre-configured for Tungsten Dashboard.
  • Access to Continuent Support for FREE for the first 14-Days following subscription.
  • Free Trials available by contacting sales@continuent.com.

Together, they handle all of the messaging and control of your Tungsten MySQL clusters in a seamlessly-orchestrated fashion.

How To Avail Of The Tungsten Cluster (AMI)

The AMI is available to launch manually via the Amazon Marketplace, or via Cloudformation Templates as per the instructions that follow below.

Possible configurations are:

  • Single Cluster - Minimum 3 nodes
  • Multiple Clusters - Minimum 2 Clusters, Minimum 3 nodes per cluster

Multiple Clusters can be configured either in an Active/Passive or Active/Active configuration. Each node will have one Primary Node for Read/Write and 2 or more Replica nodes for Read-Only.

By default, the AMI will launch with a 40Gb partition assigned to /opt. The software and associated logs will be generated here, therefore you should review the required storage space for this partition based on your activity levels. You should account for, at least, the same amount of space used by your binary logs within the retention period of your source database.

Cloudformation Approach

First you will need to subscribe to the AMI via the Marketplace, and then follow the URL below that matches the topology that you wish to deploy:

Complete the simple, single template form providing all the information required and then launch the clusters.

Cloudformation will handle the launch of the nodes required based on the topology chosen. It will also configure the various security gateways and VPC’s required, providing a complete stack ready to use.

Manual Approach

You will need to launch a minimum of 3 hosts for each cluster that you want to configure.

Upon launch, connect to one host as the ec2-user using your preferred choice of Terminal application.

Issue the following command `sudo su - tungsten` and the launch and setup wizard will automatically commence.

Follow on screen prompts to configure. The launch wizard will store the configuration in the local MySQL instance on each of the nodes within the cluster.

To complete the installation across the entire cluster, continue to connect to each node in turn. The launch script will retrieve the locally stored configuration and proceed to complete the installation.

Once all nodes have been installed, load the environment by typing `source /opt/continuent/share/env.sh` and then issue `startall` on each node.

Providing you configure the network security accordingly, you will be able to connect to the Dashboard by using the Public DNS/IP of any of the hosts in your choice of internet browser, and when prompted entering the user name ‘tungsten’ and the password you supplied during node configuration.

After launching the clusters via either method, Applications can then connect to the Cluster by using any standard JDBC call connecting to any host on the Connector Port supplied (Default 3306). For more information on the Connectors, review the online documentation: https://docs.continuent.com/tungsten-clustering-6.1/connector.html

To access the Dashboard, simply connect to the public IP/Hostname of any node in the cluster in your choice of browser.

Feedback

We’d love to hear your feedback on our AMIs, so please do comment below or contact us here.

About the Author

Continuent Team

Continuent, the MySQL Availability Company, since 2004 has provided solutions for continuous operations enabling business-critical MySQL applications to run on a global scale with zero downtime. Continuent provides geo-distributed MySQL high availability on-premises, in hybrid-cloud, and in multi-cloud environments.

Continuent customers are leading SaaS, e-commerce, financial services, gaming and telco companies who rely on MySQL and Continuent to cost-effectively safeguard billions of dollars in annual revenue.

Continuent’s database experts offer the industry's best 24/7 MySQL support services to ensure continuous client operations.

Add new comment