Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [percona-xtradb-cluster]

Percona XtraDB Cluster is a high availability and high scalability solution for MySQL users.

Percona XtraDB Cluster is a high availability and high scalability solution for MySQL users. XtraDB Cluster integrates Percona Server with the Galera library of high availability solutions in a single product package. XtraDB Cluster enables users to save money through:

  • Less downtime and higher availability
  • Reduced investment in high availability architectures
  • Lower DBA training and education costs
  • No investment in third-party,high availability solutions

Percona XtraDB Cluster features include:

  • Synchronous replication
  • Multi-master replication support
  • Parallel replication Automatic node provisioning

The focus for Percona XtraDB Cluster is data consistency at a significantly lower total cost than existing high availability solutions. XtraDB Cluster may be especially useful if your organization currently:

Uses MySQL replication to ensure high availability Needs a high availability solution for MySQL deployed in the cloud Is looking for a new, novel way to address previously impossible high availability challenges.

40 questions
1
vote
1 answer

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our Percona data with a second data center so that we…
user209180
  • 87
  • 1
  • 2
  • 6
1
vote
1 answer

Percona on EC2 ephemeral storage (part of XtraDB cluster)

We have a MySQL DB of roughly 100GB and want to move it into EC2. EBS volumes seem fairly slow for running MySQL databases (even with provisioned IOPS) and although we could use RAID10 to improve this (or Amazon RDS) I was really hoping to make use…
cates
  • 11
  • 1
1
vote
1 answer

Percona on 2nd node will not start

I have setup two Vagrant VMs to simulate Percona XtraDB Cluster for our development needs. The first VM comes online just fine, and everything works. However, when I try to start Percona on the 2nd VM we get errors when requesting state…
user169871
1
vote
1 answer

syncing specific tables between two already-replicating MySQL clusters

I have a circularly replicating MySQL cluster, and a newer cluster of Percona XtraDB instances that we're in the process of moving to. During the move, we're running some projects on the old cluster and other projects on the new cluster. I'd like to…
ceejayoz
  • 32,469
  • 7
  • 81
  • 105
1
vote
2 answers

Percona-Cluster: backup and restore procedure

I'm trying to restore a full backup taken from one node of a three-node percona cluster (percona cluster 5.5, galera 2.1, wsrep sst method is rsync, innodb tables only). Backup was taken like this: rm -rf /tmp/backup/mysqldb innobackupex…
Hank
  • 379
  • 3
  • 15
1
vote
1 answer

Trouble setting up a Percona XtraDB cluster on 2 servers

I'm trying to set up a Percona XtraDB cluster on two machines.. but i'm having a terrible time in getting the second machine up and running. I have used this article as a reference, and while it seems to be almost working, there's probably something…
GoldieNZ
  • 25
  • 1
  • 4
1
vote
3 answers

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with their pros and cons? The Percona XtraDB Cluster, Does…
Raj
  • 247
  • 2
  • 9
0
votes
4 answers

mysql (Perconadb) Galera/Xtrabackup cluster join fails with "Invalid Argument"

I have a MySQL Galera cluster, using Perconadb and Xtrabackup. The nodes can start stand-alone, or can join the cluster if only an IST is required. However, if an SST is required, then this runs to completion and then fails. The logs show that,…
Steve Shipway
  • 742
  • 5
  • 17
0
votes
1 answer

Initial Xtradb Cluster setup -- each node comes up isolated

I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103. When I follow the instructions on Percona's site just as written, after bootstrapping the…
user396356
  • 1
  • 2
0
votes
1 answer

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database. I would like to perform 'hot backups' simply using mysqldump on one of the nodes that doesn't serve the application by…
rgvcorley
  • 133
  • 6
0
votes
2 answers

Percona mysql-server on ubuntu 16.04

Issue: Can't install Percona mysql server. Platform: Ubuntu 16.04 x64 Server is an Openvz container. Memory: 1.5GB installation method apt-get install percona-xtradb-cluster-server-5.6 Source: cat /etc/apt/sources.list deb…
fatninja
  • 1
  • 1
  • 2
0
votes
0 answers

Do I need binlogs with a Percona xtradb cluster?

If I am running an XtraDB cluster, with no replication, do I need binlogs? They're enabled and chewing up disk space. I'm aware I can restrict their number using max_binlog_files, but I'm not sure if I need them at all in a clustered environment. If…
Edward Hibbert
  • 31
  • 4
0
votes
0 answers

What is an efficient means to serve a dynamic website globally, in terms of latency?

We're using Amazon's AWS infrastructure. At one time, we did have a load-balanced setup across geographic regions, and our database cluster was divided between those regions. To reduce costs for the time being, and to solve some clustering issues we…
Ian Atkin
  • 183
  • 8
0
votes
1 answer

Galera cluster implementation questions

I've just successfully created my first Galera cluster using MariaDB 10.0.20 between three servers. I have a few questions regarding my implementation: 1. what will happen if one server becomes isolated from the other servers but still has clients…
gijs007
  • 107
  • 1
  • 4
  • 17
0
votes
1 answer

How to hold specific package version?

I have Percona XtraDB Cluster 5.6 installed on my Ubuntu server. Recently, when i tried to update my system using apt i see some new version of percona, but with an older version. The following packages will be upgraded: percona-xtrabackup…
Spin0us
  • 123
  • 4
1
2
3