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

Tag: mysql-innodb-cluster

MySQL client goes down after using setPrimaryInstance() in InnoDB clustering, but the cluster remains up with all nodes functioning

By adminPosted on January 23, 2023

Question : So, I have a cluster of 3 nodes, each in a different data center located in the same […]

how the mysql server settings replicatd in innodb cluster

By adminPosted on December 30, 2022

Question : I just started learning about cluster so I don’t have much knowledge if question is not appropriate please […]

Cannot rejoin or add instance to MySQL InnoDB cluster

By adminPosted on October 31, 2022

Question : I have a MySQL InnoDB cluster running where I had added three nodes, one is having the Primary […]

check slave status innodb cluster

By adminPosted on October 9, 2022

Question : On InnoDB cluster, I have tried to execute command ‘show slave status’ to get status of a slave. […]

exitStateAction not working as expected on MySQL INNODB Cluster

By adminPosted on August 10, 2022

Question : I’m in the process of setting up and testing an Innodb Cluster. So far I have three nodes […]

Unable to add new instance on MySQL InnoDB cluster

By adminPosted on August 7, 2022

Question : I’m setting up new MySQL InnoDB cluster 8.0.16 consisting of three instances: srv-mysql-01 srv-mysql-02 srv-mysql-03 I run JS-script […]

MySQL client goes down after using setPrimaryInstance() in InnoDB clustering, but the cluster remains up with all nodes functioning

By adminPosted on August 1, 2022

Question : So, I have a cluster of 3 nodes, each in a different data center located in the same […]

Cannot rejoin or add instance to MySQL InnoDB cluster

By adminPosted on July 4, 2022

Question : I have a MySQL InnoDB cluster running where I had added three nodes, one is having the Primary […]

MySQL incorrectly saying serverID non unique when adding an instance to the InnoDB cluster

By adminPosted on June 21, 2022

Question : I Get the following error when adding the second instance to a MYSQL Innodb Cluster ERROR: Cannot add […]

MySQL hangs on SELECT from table with blob fields

By adminPosted on April 4, 2022

Question : I managed to create a mysql 8 InnoDB cluster with three nodes (VPS in one dedicated server, 25GB […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

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