Real-Time MySQL Analytics — How to Replicate Data in Real-Time from MySQL, MariaDB or Percona Server to Vertica
Real-Time MySQL Analytics: In this first in a series of blog posts on real-time data replication from MySQL, MariaDB or Percona Server to high-performance data analytics engines (and how to do so easily and cost-effectively with the Tungsten Replicator AMI), we’re focussing on Vertica replication.
Alternative to Amazon AWS Aurora MySQL - Tungsten Clustering for MySQL High Availability (HA), Disaster Recovery (DR) and Geographic Distribution
This is the first blog in our ‘High Noon’ comparison series in which we look at the alternative solutions for MySQL high availability, disaster recovery and geographic-distribution. We focus on highly available, geo-scale, multi-region MySQL for business critical applications as directly compared to Amazon Aurora. Tungsten Clustering makes it easy to deploy and manage highly available MySQL clusters with any version of MySQL, MariaDB, and Percona Server for MySQL on-premises, in the cloud, hybrid-cloud or multi-cloud.
Online MySQL Schema Changes: An Example Procedure
Performing MySQL schema changes often requires downtime for applications. In this blog, we cover two ways we can perform MySQL schema changes without risking downtime or other MySQL data problems. In this real-life customer example, we perform a schema change to modify the column data type from varchar(20) to varchar(50) on approx. 35 tables from 3GB to 10GB in size. Two of the tables are partitioned, and one of them is about 100GB combining all partitions for that table.
Alternative MySQL and MariaDB Clustering Solutions: 'High Noon' Competitor Comparisons
Why do Continuent customers say year after year that Tungsten Clustering is a better MySQL HA/DR/Geo-Scale clustering and replication technology - in the cloud, on-prem, hybrid-cloud, multi-cloud - compared to alternatives such as Amazon Aurora for MySQL, Galera Cluster and host of others? We have put together a comprehensive comparison so you can learn about the pros and cons of various MySQL solutions for business-critical and mission-critical apps - and make an informed decision about what’s best for your needs and environment!
Easy MySQL HA Cluster Deployment with AWS CloudFormation
Read this blog to get a high-level introduction to AWS CloudFormation Templates, and a walkthrough on how to launch our CloudFormation template for the Tungsten Cluster AMI to run highly available MySQL database clusters in the AWS cloud.
What is MySQL Data Replication versus Clustering?
What is the difference between MySQL replication and MySQL clustering? While clustering involves a layer of replication, the capabilities, benefits, and reasons for using clustering versus replication are very different. At Continuent, we offer both clustering and replication for your MySQL, MariaDB, and Percona MySQL - in the cloud, on-prem, hybrid-cloud and multi-cloud, with no application changes or downtime necessary.
3, 2, 1… MySQL Backup is Fun!
“We don’t take backups, we use replication instead.” If you happen to agree with this statement, I urge you to continue reading. But even if you think you have a good backup plan, I still urge you to continue reading. Taking backups is usually not one of the most exciting parts of the job, but it might be the part that saves your company from a catastrophe. So, let’s make a plan!
Free-14 Day Trial of the Tungsten Replicator (AMI) on the AWS Marketplace
Give the latest Tungsten Replicator (AMI) a test drive with its 14-day free trial on the AWS marketplace!
Try the Latest Version of Tungsten Cluster (AMI) on the AWS Marketplace from as little as $0.70 per node / per hour
We’ve just recently brought our Tungsten Cluster (AMI) up to the current release level of our flagship product, Tungsten Cluster, and would like to invite users to give it a test drive!
Complete Solution for Continuous MySQL Operations: Multi-Site, Hybrid-Cloud, Multi-Cloud MySQL
Disaster Recovery for Continuous MySQL Operations does not have to be hard, but it does have to be WAN: Multi-Site, Hybrid-Cloud, Multi-Cloud. This blog discusses Business Continuity, Disaster Recovery, or “DR,” and an overlooked clustering feature that makes continuous database operations easy, affordable, and manageable.
From Servers in Hong Kong to Geographic MySQL Database Replication With Continuent Tungsten
ProductIP has been a Continuent customer since November 2014 and is sharing its Continuent experience here: from initially setting up their infrastructure in Hong Kong to running a geographically distributed MySQL database replication and clustering environment with Continuent Tungsten, read about their journey with us in this guest post.
MySQL Disaster Recovery Done Right! (Part I)
There are a number of MySQL HA solutions around. But there are surprisingly few MySQL DR solutions. And there is only one solution that Does MySQL DR Right!