Uncategorized

Use AWS CloudFormation to Create a MySQL Fabric Server Farm

You can use AWS CloudFormation to create a MySQL Fabric server farm easily and quickly.

AWS CloudFormation allows you to make and manage AWS resources.  You could also deploy and update these resources in a way that is both predictable and orderly.  You can create your own templates to help you run your applications easily, taking away the guess work when it comes to the order in which these requirements are run and how to make them work.

After deploying a CloudFormation template, you can change it so that everything works the way you want it.  This gives you a way to apply version control to your templates, in a manner that is very similar to versioning your software.  Everything — from your templates to the stack — is deployed using AWS Management Console, application programming interfaces or the AWS Command Line.  CloudFormation is available to AWS customers with no additional fees except for the charges you incur from using the AWS resources that you use for your applications.

But did you know that you could use AWS CloudFormation to create a MySQL Fabric server farm easily and quickly?  On top of being able to synchronize your development, quality assurance and production environments and giving you a way to implement a fast disaster recovery solution, CloudFormation is also perfect for MySQL Fabric.

Why is CloudFormation also perfect for MySQL Fabric?

Because CloudFormation can help you do away with the bootstrap steps that you need to go through when creating a distributed system.

Using CloudFormation, you will only be dealing with three questions when you are installing MySQL Fabric: the Access Key, the Key Pair Name and the Secret Key. A sample script is found here.

This template might just be a proof of concept and it may need a lot of work to ensure that the installations go error free, it does make it apparent that you can easily install MySQL Fabric farms without going through a lot of steps.  Looking at it another way, it means that you can easily take advantage of the many benefits and features of MySQL Fabric, such as:

  1. High availability, which is built of mature MySQL Replication technology that is used by the world’s biggest Web sites.  It also allows for server monitoring, automated failover, transparent failover, semi-synchronous replication and geographic redundancy.
  1. Sharding, which enables you to scale reads and writes easily and automatically.  You also get to use user defined shard keys – that your data is even distributed between the different shards.  MySQL Fabric also maps the shard key to the shard that contains the appropriate data.
  1. MySQL Fabric aware connectors, which allows MySQL Fabric to route queries and transactions based on the knowledge it already has about the server farm and the state of the servers.  It also allows you to automatically route transactions and queries to the correct shard. Moreover, the writes are sent to the master site rather than to the back up.

With MySQL Fabric, you also have system wide coordination from managing all the MySQL Servers running on the instance.  You have centralized schema that you could maintain or update across all shards as well.  It also needs no agents and no proxies, which simplifies its architecture.

Imagine getting all these with a few simple steps?  Call Four Cornerstone today if you want this functionality.  Our team of MySQL and Oracle experts can help you get your mind wrapped around MySQL Fabric and AWS CloudFormation.

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Live Chat | Emergency