Showing entries 1 to 10 of 45
10 Older Entries »
Displaying posts with tag: Disaster Recovery (reset)
Automatic connection failover for Asynchronous Replication

Since MySQL 8.0.22 there is a mechanism in asynchronous replication that makes the receiver automatically try to re-establish an asynchronous replication connection to another sender, in case the current connection gets interrupted due to the failure of the current sender.

The post Automatic connection failover for Asynchronous Replication first appeared on dasini.net - Diary of a MySQL expert.

Webinar: The New Galera Manager Deploys Galera Cluster for MySQL on Amazon Web Services

There is NEW ERA for Galera Cluster monitoring and management and as we just recently released Galera Manager 1.0 into the wild for everyone to deploy their Galera Clusters within an Amazon Web Services (AWS) Elastic Compute Cloud (EC2) environment to achieve MySQL High Availability, Multi-Master MySQL, active-active clustering out of the box on Amazon and Disaster Recovery, all from the comfort of a web-based graphical user interface (GUI).

The Galera Manager is the new graphical user interface (GUI) tool for provisioning Galera Clusters on Amazon Web Services (AWS) Elastic Compute Cloud (EC2). It allows an administrator to easily create and add nodes, without manually having to configure each node. Perhaps more useful is that Galera Manager provides charts for monitoring the host and database metrics, to ensure the proper and efficient functioning of …

[Read more]
MySQL InnoDB Cluster Disaster Recovery contingency via a Group Replication Replica

Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.

If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc.

Reminder: InnoDB Cluster (Group Replication, Shell & Router) in version 8.0 has had serious improvements from 5.7. Please try it out.

So, given that, and given that we want to consider how best to fulfill the need, i.e. create a DR site for our InnoDB Cluster, let’s get started.

Basically I’ll be looking at the following scenario:

InnoDB Cluster Source site with a Group Replication Disaster Recovery Site.

Now, just before we get into the nitty-gritty, here’s the scope.

Life is already hard enough, so we want as much automated as possible, so, yes, InnoDB Cluster gets some of that done, but there are other parts we will still have …

[Read more]
Use Case: Geo-Scale Multi-Master MySQL with Disaster Recovery

How to build a multi-region, multi-master MySQL cloud database back-end capable of serving a global high volume cloud contact center

This global SaaS provider is a Cloud Contact Center solution provider (the leading Salesforce telephony solution), who needed to deliver up-to-date data to clients as quickly as possible. Its cloud-based call center software frees users to make every conversation personal; it supports the creation of exceptional customer experiences that help serve better and sell more. Its technology is 100% cloud-based and device-agnostic for telephony infrastructure.

What is the Challenge?

Active/Active (multi-master) MySQL clustering is needed when there is significant update load on geographically distributed applications. These require fast response times both for updates and reads, and they also need to share data on a global scale.

  • Regional distribution of data
  • Deliver …
[Read more]
Use Case: MySQL HA and Disaster Recovery

How to achieve MySQL high availability, data protection & disaster recovery

This MySQL high availability and disaster recovery use case is based on a customer of ours who is a government-regulated lottery service consisting of a number of games of chance. Its mission is to fuel imagination – and fund education for all citizens of their state as it uses the proceeds of its activities to do so. Through its games, it has provided billions of dollars in scholarship and other such education funding for several decades.

What is the Challenge?

As is common for gambling and betting organisations, our customer faced a number of challenges and needed to have a solid infrastructure in place in order to provide its services satisfactorily.

This includes:

  • Ensuring 24/7/365 availability of its online gaming platform
  • Handling thousands of transactions quickly and while ensuring zero downtime …
[Read more]
Use Case: MySQL High Availability, Zero Downtime Maintenance and Disaster Recovery for SaaS

Zero Downtime SaaS Provider — How to Easily Deploy MySQL Clusters in AWS and Recover from Multi-Zone AWS Outages

This is the second post in a series of blogs in which we cover a number of different Continuent Tungsten customer use cases that center around achieving continuous MySQL operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and global scaling – and how we help our customers achieve this.

This use case looks at a multi-year (since 2012) Continent customer who is a large Florida-based SaaS provider dealing with sensitive (HIPAA Compliant) medical data, which offers electronic health records, practice management, revenue cycle management and data analytics for thousands of doctors.

What is the Challenge?

Lack of high availability in AWS. The challenge they were facing came from using AWS, which allowed them to rapidly provision database and …

[Read more]
Tungsten Clustering Makes The 2020 DBTA Top Trending Products List

We’re delighted to be able to share that Tungsten Clustering – our flagship product – is named in the DBTA 2020 List of Trend Setting Products!

Congratulations to all the products and their teams that were named in the 2020 list.

We have been at the forefront of the market need since 2004 with our solutions for platform agnostic, highly available, globally scaling, clustered MySQL databases that are driving businesses to the cloud (whether hybrid or not) today; and our software solutions are the expression of that.

Tungsten Clustering allows enterprises running business-critical MySQL database applications to cost-effectively …

[Read more]
Geo-Scale MySQL for Continuous Global Operations & Fast Response Times

Geo-scale MySQL – or how to build a global, multi-region MySQL cloud back-end capable of serving several hundred million player accounts

This blog introduces a series of blogs we’ll be publishing over the next few months that discuss a number of different customer use cases that our solutions support and that centre around achieving continuous MySQL operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and global scaling.

This first use case looks at a customer of ours who are a global gaming company with several hundred million world-wide player accounts.

What is the challenge?

How to reliably, and fast, cater to hundreds of millions of game players around the world? The challenge here is to serve a game application for a geographically-distributed audience; in other words, a pretty unique challenge.

It requires fast, local response times …

[Read more]
Comparing Replication Technologies for MySQL Clustering: Part 1

Overview

Clustering provides high availability and disaster recovery, along with the ability to read-scale both locally and globally. Some clusters even provide active/active capabilities, which others have a single master.

Real time database replication is a must for clustering and other key business purposes, like reporting. There are a number of replication technologies available for MySQL, and some are even bundled into various solutions. When choosing a replication methodology, it is paramount to understand just how the data moves from source to target. In this blog post, we will examine how asynchronous, synchronous, and “semi-synchronous” replication behave when used for clustering. Also, we will explore how …

[Read more]
Read the White Paper: Tungsten Clustering for MySQL, MariaDB & Percona Server Databases

We’re happy to announce that our white paper ‘Tungsten Clustering – Benefits & Configurations’ for MySQL, MariaDB and Percona Server is available to read on our website.

Tungsten Clustering is a one-of-a-kind software solution that provides clustering, disaster recovery and high availability for MySQL, MariaDB & Percona Server databases.

It allows enterprises running business-critical database applications to cost-effectively achieve continuous operations on a global scale with:

  • Commercial-grade high availability (HA)
  • Geographically redundant disaster recovery (DR)
  • Global operations with geographically distributed multi-master

[Read more]
Showing entries 1 to 10 of 45
10 Older Entries »