In this second post on real-time data replication from MySQL, MariaDB or Percona Server we’re looking at PostgreSQL replication, for example with one practical application using a POD style deployment with MySQL.
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.
This blog provides basic information about business-critical application to database connections; my team focuses on MySQL, MariaDB, and Percona Server for MySQL on Linux/Unix that’s infrastructure-agnostic (on-prem, VM, hybrid-cloud, cloud, multi-cloud, etc.).
Learn how and where the Connector communicates, and about the different SSL configurations possible.
This blog discusses some best practices for using multiple filesystems on MySQL database servers and how to achieve the best performance with them, while avoiding some of the possible pitfalls.
An overview of a Tungsten topology that doesn’t get much attention: the Cluster-Slave, which is an easy way to get data resiliency and integration, with features that make it ideal for big data analytics, reporting, and backups.
Watch this 30min training video on how to get started with Tungsten Replicator AMI and how to avail of it on Amazon Marketplace; including a step-by-step demonstration.
Version 6+ of Tungsten Clustering comes with a host of improvements for your Multi-Site Multi-Master topology (MSMM); this is partly why it has a new name: Composite Master-Master (CMM). Probably the most notable improvement is that the Managers are more aware. What does that mean?
The Tungsten Connector is an intelligent MySQL proxy that provides key high-availability and read-scaling features. This includes the ability to route MySQL queries by inspecting them in-flight.
Make It Smarter: Tuning MySQL Client Request Routing for Tungsten Connector
Over the past few days we have been working with a number of customers on the best way to handle Triggers within their MySQL environment when combined with Tungsten Replicator. This new blog dives head first into the minefield of Triggers and Replication.
