Stack Overflow
Stack Overflow

Questions tagged [mysql-cluster]

MySQL NDB Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability.

MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster scales horizontally on commodity hardware with auto-sharding (partitioning) to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces. ("Cluster" is an overloaded term; this topic is NDB Cluster.)

201 questions
1
vote
0 answers

MySQL cluster dump with logfile

Here's a problem I'm having in MySQL cluster and hoping one of you has an answer since it seems like something pretty obvious. I'm producing dumpfiles of our MySQL cluster databases which of course include the CREATE LOGFILE GROUP / CREATE…
Arkandel
  • 339
  • 2
  • 10
1
vote
1 answer

Permission granted mysql user cannot access the particular database Caused by: java.sql.SQLException: Access denied for user

I used grant all on mydb.* TO user1@"localhost" identified by "user1" And getting following error when access the mysql from a separate physical box. This is a mysql cluster(Mysql server version 5.1.56). And connector jar is…
Subash Chaturanga
  • 814
  • 2
  • 10
  • 20
1
vote
0 answers

PHP-MySQLi not returning error when using a CALL and a SELECT result was returned before the error

Don't know if someone can help but for some reason when using call stored procedure that has a select before a dynamic SQL syntax error PHP doesn't report an error. If calling the stored procedure in workbench the error shows. Basic setup…
user180442
  • 31
  • 2
1
vote
1 answer

MySQL distributed database with mysql access to each node

I have task to implement particular database structure: Multiple mysql servers with data using the same schema. Each server can see and edit only his particular part of data. And One master server with his own data that can run queries using data…
genpj
  • 11
  • 2
1
vote
2 answers

What's the ad-hoc query, in RDBMS?

A doc about MySQL Cluster says: Many new applications need the back-end database to meet the above challenges, while still: Preserving transactional integrity with ACID compliance; Enabling deep insight by running complex, ad-hoc queries against…
lovespring
  • 19,051
  • 42
  • 103
  • 153
1
vote
1 answer

Should I increase MaxBufferedEpochs in MySQL Cluster - (Disconnecting node because it has exceeded MaxBufferedEpochs)

I am using MySQL cluster to handle the parallel processing of a large data stream which occasionally requires big joins (millions of rows) and update/deletes/inserts of multiple (1000s) of rows at a time. It appears to be handling this quite…
Joe Green
  • 364
  • 1
  • 11
1
vote
4 answers

Mysql-cluster issue

I am trying to create a table in mysql Cluster. When I type this I had this error: /usr/local/mysql/mysqlc/bin/mysql -h 127.0.0.1 -P 1186 -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Someone has…
user3435212
  • 21
  • 4
1
vote
1 answer

Run Mysql-CLuster

I am trying to test mysql-cluster but I have to run it. I succeeded installation and configuration but the last step of running doesn't work. I have a major error, when I run /home/sonia/mysqlc/bin/mysqld --defaults-file=conf/my.cnf & I get this…
user3435212
  • 21
  • 4
1
vote
1 answer

How to configure hibernate jpa to work with mysql ndb(cluster)

I want to use Hibernate JPA with MySql NDB cluster. Does Hibernate-JPA support MySql NDB? I found this document on using OpenJPA/ClusterJPA with NDB: http://dev.mysql.com/doc/ndbapi/en/mccj-using-jpa.html. Could someone point me to a doc similar to…
Rama Palaniappan
  • 365
  • 1
  • 3
  • 12
0
votes
0 answers

CRITICAL SQL cluster issue - VM's cannot migrate between the nodes

How I discovered that my clusters had issues, I have two SQL servers VMs, if you went into them, one of their drives would show up but without any statistics, how big it is, or anything. When I went to computer management, I saw the drive was in RAW…
Gift
  • 97
  • 1
  • 12
0
votes
0 answers

trying to configure mysql-innodb-cluster but have Pods pending error

I am trying to configure mysql-innodb-cluster using helm. Here is command : helm install mycluster mysql-operator/mysql-innodbcluster -n mysql-cluster. I already have made rook-ceph storageclass. But pods are still pending. I really don't know how…
박지환
  • 1
0
votes
0 answers

Cannot connect to MySQL database after implementing NDB Cluster

I'm trying to shift from a single instance of a mysql database to using a cluster for redundancy purposes, following the steps I found from here, I thought this was the solution I needed, but I'm getting an error now that I can't seem to find a…
Shawn Mccausland
  • 1
  • 1
0
votes
1 answer

MySQL trigger throws ERROR 1442, even though its updating a table different to the one calling the trigger

I'm in the process of trying to optimise my querys, part of which is storing a value like "number of comments" in its own column instead of having to use COUNT() each time. To do this, I plan to create a couple of triggers in the "comments" table.…
OldYogurtPot
  • 1
  • 1
0
votes
0 answers

Deployment of mysql-operator fails with “unsupported mode prw”

I have a working microk8s but the deployment of mysql-operator installed according to the official documentation(using manifest files) is failing. My microk8s is installed on 3 lxd containers based on ubuntu 22.04 images. The host is a laptop…
goremo
  • 43
  • 7
0
votes
0 answers

I am unable to alter table engine while importing SQL dump file in clustered environment it generates error

I am importing the SQL dump file in MySQL NDB Clustering Environment All the tables are imported successfully on node1. but they are not clustered on node 2. For this execute the following command: Alter Table su_contribution…
NAEEM AKRAM
  • 1
1 2 3
…
13 14