Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs
15 votes
Accepted

How to restart MariaDB Galera cluster?

MariaDB Galera Cluster: Solution 1: 1) I've changed safe_to_bootstrap parameter to 1 on one of the node in the file /var/lib/mysql/grastate.dat: safe_to_bootstrap: 1 2) After that I killed all mysql ...
Oleksandr's user avatar
  • 393
9 votes

How do I configure AWS Aurora to separate write/read operations

I just wanted to point out that AWS has updated and now have a cluster Read endpoint that does load balancing in case anyone runs into this from Google. https://aws.amazon.com/blogs/aws/new-reader-...
Tony's user avatar
  • 99
8 votes
Accepted

How to recover MariaDB Galera Cluster after full crash?

Pre-Recovery Settings: Ensure that the MYSQL_HOME path is being exported in the .profile. If the MySQL install is in a different location, then make that change to the MYSQL_HOME.(Example: MYSQL_HOME=...
Siero Sierikas's user avatar
7 votes
Accepted

Dba.getCluster: This function is not available through a session to a standalone instance (RuntimeError)

It seems the node from the one you are trying to use the command is not part of the Cluster. What you can do is to try to get the status from another node. If this is not possible, then try to ...
Adan's user avatar
  • 86
6 votes
Accepted

Is MySQL Cluster a right choice?

When evaluating clustered solutions you need to think about the read/write profile of your application and match that against available solutions. For a heavy read based profile of an application, ...
Lee Parayno's user avatar
5 votes
Accepted

Mysql Group replication vs Mysql Cluster

Group Replication vs Galera (aka PXC) Group Replication is only months old; Galera has been around for years. Once GR establishes its worth (which I think it will), the answer may be something like ...
Rick James's user avatar
  • 78.3k
4 votes

Mysql Group replication vs Mysql Cluster

you have these various options: A single node without replication: one master who handle the read/writes, if the master goes down you are dead. A single node with one or more replication nodes: ...
Ibrahim Albarki's user avatar
4 votes
Accepted

What happens to mysql synchronous replication when read replica can't respond?

MySQL does not support synchronous replication. There will always be a delay because changes are not written to the binary log until you commit a transaction, then the replica must download the binary ...
Bill Karwin's user avatar
3 votes

MySQL Solution to Sync 3 servers data

You are asking some good questions here but you are at an important crossroads and undoing an architectural mistake after implementing it is extremely difficult and costly. The first question you ...
Barrett Chambers's user avatar
2 votes
Accepted

MySQL Cluster: API node won't start successfully

Ok. The issue is related to SELinux. I put SELinux in permissive mode with setenforce 0 and restarted MySQL, and it connected fine - this gave it away pretty quickly. So I loaded audit2why and figured ...
Shane's user avatar
  • 93
2 votes

How to recover MariaDB Galera Cluster after full crash?

If you are in the position where your seqno is -1, and you need to bootstrap that node, you can recovery the correct seqno by running: # galera_recovery Which will output the correct seqno plus it ...
ctrlbrk's user avatar
  • 121
2 votes
Accepted

What steps to take to resize an existing MYSQL NDB Cluster?

Since your data nodes are up and running you can check the size of the virtual memory allocated to the data node. If this is bigger than 80-90% of your available memory you will experience issues like ...
Mikael Ronström's user avatar
1 vote
Accepted

Can't drop an NDB database because the storage engine is unavailable

I finally worked out a way to fix this. I did mysqldump on every database except information_schema, database-schema, and ndbinfo. Then I stopped mysql and renamed /var/lib/mysql. Copied all the dump ...
elyograg's user avatar
  • 103
1 vote

MySQL partition failed

You can't compare DATE with string or any other values, the best way to do it assuming the filed type you are using is date is using an embedded function in MySQL TO_DAYS, you need to change the than (...
Ahmad Abuhasna's user avatar
1 vote

What is the best solution for synchronous sync and load balancing an InnoDB database

NDB is the only solution you mention that supports horizontal scalability. That is, part of the data resides on each node, so the more nodes you have, the greater the write capacity. The others are ...
Bill Karwin's user avatar
1 vote
Accepted

Mysql Innodb Cluster Replication

After spending a couple of days. Finally, find the solution. The solution is You have to whitelist IP of a primary and secondary node's in the /etc/hosts file in the primary Node. And Paste this below ...
Karan's user avatar
  • 11
1 vote

Cannot rejoin or add instance to MySQL InnoDB cluster

This has been fixed in MySQL Shell 8.0.23: https://dev.mysql.com/doc/relnotes/mysql-shell/8.0/en/news-8-0-23.html An instance that belongs to an InnoDB Cluster is identified by its server UUID. If the ...
Miguel Araújo's user avatar
1 vote

Is there a way to set different destination order with mysql-router?

using different specific host order, rather than using metadata-cache in mysql-router config "destination" option on each mysql-router seems to do it. ie. destination=server1,server2,server3
Ken's user avatar
  • 21
1 vote

ProxySQL in PXC and failing all nodes

No, installing ProxySQL is not mandatory Do you mean all three nodes close down suddenly rather than close down gracefully? What version of Percona XtraDB Cluster are you using? If it is a version 5....
greenweeds's user avatar
1 vote
Accepted

How to delete previous incarnation in MySQL (/w Group Replication)

Solved by bringing down the entire cluster, as mentioned in a similar issue here. After the restart, bringing the GR cluster back up from scratch had no mentions of incarnations.
insideClaw's user avatar
1 vote

Deleted config.ini in MySQL cluster by mistake

The file on the FS is only marked as deleted, with the actual deletion happening once all open FDs to it are closed. This means that if you haven't restarted the management server (or any process ...
Matt Lord's user avatar
  • 1,291
1 vote
Accepted

MySQL Node not Connecting to Management Nodes in NDB Cluster

I would remove the [mysql_cluster] section in the my.cnf file entirely, as it's redundant and can only lead to confusion (you already have two different settings for ndb-connectstring there). So I ...
Matt Lord's user avatar
  • 1,291
1 vote
Accepted

Problem in MySQL cluster when using two clusters

I'm assuming from the diagram that this is not in fact MySQL Cluster (NDB) but rather the informal sense of the word "cluster." This should be fine as long as you don't intend to write to M2 or S2, ...
Michael - sqlbot's user avatar
1 vote

mysql cluster with innodb utilizing high memory

The main memory usage in an SQL node is for InnoDB's buffer pool. What is the value of innodb_buffer_pool_size? (Use SHOW VARIABLES LIKE 'innodb_buffer_pool_size';) How much RAM do you have? ...
Rick James's user avatar
  • 78.3k
1 vote

Mysql Alter Tables took 5 hours to add 1 column

In my experience with MySQL Cluster, I found pt-online-schema-change as a very handy tool for appling live schema changes. It works this way: it creates a new real table B (with temporary purposes) ...
nulll's user avatar
  • 151
1 vote

MySQL Cluster - How the Sharding works?

NDB may be the right solution for you. Or... Sharding is splitting up the data -- some rows go here; some go there. NDB does sharding, and it also does redundancy. That is, the rows that are going ...
Rick James's user avatar
  • 78.3k

Only top scored, non community-wiki answers of a minimum length are eligible