Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Let's take a look at Percona Everest 1.0.0 RC

06/13/2024 | Percona
Hi, the Percona Everest 1.0.0-rc1 release was published on GitHub. Percona Everest is the first open source cloud-native platform for provisioning and managing PostgreSQL, MongoDB and MySQL database clusters. I want to tell you how to install it so you can try it out. RC builds aren’t meant for the general public; we don’t support upgrading from RC to stable versions. This means that this is only for testing and familiarizing yourself with the features.

Learn More »

Why is My Java Application Freezing Under Heavy I/O Load?

06/10/2024 | Continuent

The Question

Recently, a customer asked us:

Why would heavy disk IO cause the Tungsten Manager and not MySQL to be starved of resources?

For example, we saw the following in the Manager log file tmsvc.log:

2019/06/03 00:50:30 | Pinging the JVM took 29 seconds to respond. 2019/06/03 00:50:30 | Pinging the JVM took 25 seconds to respond. 2019/06/03 00:50:30 | Pinging the JVM took 21 seconds to respond. 2019/06/03 00:50:30 | Pinging the JVM

Learn More »

Configuring the Tungsten Connector for PCI Compliance

06/06/2024 | Continuent

Summary

It is always a good idea to be mindful of open ports on your hosts, since they can be used by bad actors to gain access to your systems.

For this reason, it is often desirable to prevent outside connections to the port whenever possible to prevent intrusions.

For security purposes (and possibly PCI compliance), the Tungsten Connector proxy has the ability to bind to localhost/127.0.0.1 instead of listening on all available IP addresses via 0.0.0.0.

The Quest

Learn More »

2024 Continuent Tungsten Subscription Pricing

06/03/2024 | Continuent

Continuent Tungsten Subscription Pricing

Annual Software Subscriptions

Continuent offers its Tungsten Clustering solution (for MySQL HA/DR/Geo-Scale) via an annual subscription based on the number of database nodes in the deployment. A simple 3-node cluster starts at about $16,000 per year, but due to non-linear pricing (see below), the per node cost comes down significantly when the deployment size grows and we also have special pricing for smaller startups and also competitive u

Learn More »

Take a Clone it will last longer

06/01/2024 | Percona
So cloning is a great subject. I mean we clone sheep, we can clone human organs in time we might be able to clone humans, but thats a topic for scientist and philosophers. What is MySQL Replicaion: The MySQL clone plugin can be used to replicate data from a MySQL server to another MySQL server, and it supports replication. The cloning process creates a physical snapshot of the data, including tables, schemas, tablespaces, and data dictionary metadata.

Learn More »

Why MySQL Replication Is Fast

05/31/2024 | Hack MySQL

Replication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema and binary logs to see why.

Learn More »

Why MySQL Replication Is Fast

05/31/2024 | Hack MySQL

Replication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema binary logs to see why.

Learn More »

Why MySQL Replication Is Fast

05/31/2024 | Hack MySQL

Replication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema binary logs to see why.

Learn More »

Simplifying database orchestration anywhere with Terraform and ClusterControl

05/28/2024 | Severalnines

Infrastructure as Code (IaC) has become key to modern software development. Terraform – one of the most popular IaC tools – won the hearts of DevOps teams by offering a vast ecosystem of providers that allow it to interact with various cloud platforms, services, and APIs.

Terraform hosts a wide range of providers for deploying databases. However, most of these providers offer managed services that limit you to an environment or make you give up control of your infrastructure and the datab

Learn More »

Understanding THL, Events and Storage: Part 1

05/24/2024 | Continuent

When Tungsten Replicator extracts data, the information that has been extracted is written down into the Tungsten History Log, or THL. These files are in a specific format, and they are used to store all of the extracted information in a way that can easily be used to recreate and generate data in a target.

Each transaction from the source is written into the THL as an event, so within a single THL file there will be one or more events stored. For each event, we record information abo

Learn More »

Pages