Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: xtradb-cluster

Does this make my XtraDB Cluster hang?

By adminPosted on April 30, 2023

Question : After seeing the following in the error log on the second node: 121003 7:16:06 [Note] WSREP: Member 0 […]

MariaDB cluster and external data feed

By adminPosted on February 7, 2023

Question : I’ve just finished setting up the 3 nodes mariadb (galera) cluster (let’s call the nodes node1, node2 and […]

Percona Cluster Failed with Haproxy : Connection Limit Exceeded

By adminPosted on December 17, 2022

Question : We have 3 node PXC cluster setup on amazon ec2. Its been working fine for around 4-5 months. […]

Replicating into a Percona XtraDB Cluster

By adminPosted on May 5, 2022

Question : We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It […]

Split brain scenario – RAC and PXC

By adminPosted on February 11, 2022

Question : Even though split brain scenario occurs in both Oracle RAC and Percona’s XtraDB Cluster, a two node cluster […]

Percona Node fails to join: Operation not permitted

By adminPosted on October 24, 2021

Question : Joining a new Percona node fails with: 130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: […]

Percona XtraDB Cluster and MySQL Replication

By adminPosted on June 10, 2021

Question : I’ve setup a 3-node multi master replication with percona xtradb cluster, it works perfectly. Now I’ve tried to […]

Percona XtraDB Cluster and MySQL Replication

By adminPosted on May 24, 2021

Question : I’ve setup a 3-node multi master replication with percona xtradb cluster, it works perfectly. Now I’ve tried to […]

Suddenly a massive amount of binlog files

By adminPosted on May 21, 2021

Question : I’ve seen a sudden increase of binlog files, very large in number and size, in all three nodes […]

MariaDB cluster and external data feed

By adminPosted on April 1, 2021

Question : I’ve just finished setting up the 3 nodes mariadb (galera) cluster (let’s call the nodes node1, node2 and […]

  • 1
  • 2
  • 3

Recent Posts

  • Save performance with large update on Index with Included Column
  • Integrating large PostgreSQL table as partition for a new table
  • Is there a way to show a string instead if numeric column has specific value?
  • Optimize query with a subquery (index is not used)
  • Return a column per date in a range
  • Can an AlwaysOn Availability Group be used to mitigate downtime when there’s replication syncing issues on the primary server?
  • Inner join on array column in Postgres
  • Connection pooling – NodeJS or Database products?
  • Why is there a separate describe and explain statement in MySQL
  • How should deletions be handled in the database?
  • Securely remove columns (and traces thereof) from a SQL database
  • Postgresql join removal
  • SSMS Oracle import using OpenQuery over LinkedServer (Oracle Provider for OLEDB) – XML Parsing: unable to switch encoding
  • Problem using multiple JOINs
  • Oracle – Extract user DDL for migration
  • Restore Oracle Database excluding some tablespaces
  • How do I maintain high INSERT-performance on PostgreSQL
  • INTERSECT query rewrite as JOIN?
  • Using the result set of a select query as the input of another select
  • Is it wise to drop fixed-length columns to free up space?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding