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

How to configure openfire to connect mysql cluster

I want the high availability of database for my Openfire server. Hence, I have successfully created a mysql cluster. But I am not able to configure Openfire to use that mysql cluster. I have searched about it but not able to find much except using…
Pragya
  • 155
  • 1
  • 12
1
vote
1 answer

unable to start mysql cluster SQL-node

I want to create my own MySQL cluster for test sake. I have 2 machines, first one contains management node,ndbd node and SQL-node, and second one configured just as ndbd node. I installed a centos(minimal version) and tried to install cluster using…
Majid D.
  • 11
  • 3
1
vote
0 answers

MySQL Cluster: The table is full

I have understanding wih MySQL Cluster. I have one table: 38 fields total 22 fields are described as 22 indexes (field type: int) Other fields double and bigint values The table doesn't have defined Primary Key My Environment (10 nodes): data…
vladimir-user5480135
  • 49
  • 4
1
vote
2 answers

MySQL Cluster - mysql api nodes are failing to start

I am trying to start mysqld(API) nodes as a part of my mysql cluster setup and now it is always failing to start with below error - Command used to start mysql API is - mysqld & Error that I am getting - 2015-12-14 11:58:26 0 [Warning] TIMESTAMP…
Paresh
  • 1,140
  • 2
  • 12
  • 29
1
vote
0 answers

MySQL Cluster NDB API Events Node Failure

After sifting through the NDB API Events documentation and class comments, I came across this comment in NdbEventOperation.hpp: /* * Known Issues: * - If a node failure has occured not all events will be recieved * anymore. Drop…
wizurd
  • 3,541
  • 3
  • 33
  • 50
1
vote
0 answers

MySQL clustering: Query execution sequence

I want to know if MySQL clustering execution is sequential or concurrent in all active nodes?
sanoop
  • 92
  • 7
1
vote
2 answers

mysql cluster 7.4, crluster definition error

I installed MySQL Cluster 7.4 and then I tried to define and start a new cluster. But after pressing create and start cluster the following error happened: Command [u'net','start','N49'] returned non-zero exit status 2. How to solve this error on…
Saeed Afshari
  • 939
  • 1
  • 9
  • 17
1
vote
1 answer

ndbcluster tables gone invisible after mysql cluster restart

I did create a local mysql cluster few days back and started converting some of my existing innodb tables to ndb storage engines in order to check cluster's functioning. This process was working find and I was able to see those ndb tables on other…
Harsh Pandit
  • 101
  • 1
  • 5
1
vote
1 answer

MySQL Clustering issues in Windows platform

i have 2 windows machines 1) 192.168.168.01 2) 192.168.168.02 I want to use these two for configure clustering, mySQL version: mysql-cluster-gpl-noinstall-7.1.3-win32 here is my config.ini: [ndbd default] NoOfReplicas=1 …
sanoop
  • 92
  • 7
1
vote
1 answer

SQL Node not connected in a mysql cluster

I am trying to deploy a mysql cluster (4 machines) with 1 node manager, 1 sql node, and 2 data nodes. I am following these tutorials which are complimentary (first part, second part, third part, fourth part) from the official mysql website. However…
Othmane
  • 1,094
  • 2
  • 17
  • 33
1
vote
0 answers

How do I access Mysql Cluster Node ID for Mysql trigger or query use?

I'm trying to write a Trigger (BEFORE INSERT), and I need to find the cluster id or node id so I can set up a proper calculated id. Is there a way to retrieve this NodeId or the cluster's id in a query or trigger? I already checked documentation…
Space-time Code-monkey
  • 21
  • 4
1
vote
0 answers

Global MySQL DB Architecture hosted in different locations

I am working on an application (Java + MySQL) which will be hosted(application + db) in different servers across the glob. The same application and db will be hosted in Asia, Europe, Australia and North America. For faster access, the application…
Gourav
  • 813
  • 2
  • 10
  • 23
1
vote
0 answers

How to add option correctly in `sudo /usr/local/mysql/bin/mysqld --defaults-file="/etc/my.cnf" start`

To avoid [ERROR] Can't read from messagefile '/usr/share/mysql/errmsg.sys' I need [ERROR] Can't read from messagefile '/usr/share/mysql/errmsg.sys'. But sudo /usr/local/mysql/bin/mysqld --defaults-file="/etc/my.cnf" gives me [ERROR] Fatal error:…
wwood
  • 489
  • 6
  • 19
1
vote
1 answer

"could not get table metadata" "Got error 157 'Unknown error code' from NDBCLUSTER"

I'm developping a java web application and I use MySQL Cluster for Database I get this error when I try to instal the application in a Jboss server .... org.hibernate.exception.GenericJDBCException: could not get table metadata:…
Salmane El Alaoui
  • 63
  • 1
  • 8
1
vote
1 answer

Synchronous vs Asynchronous Clustering

I was reading the mariaDD knowledge base on Galera Cluster and i came across this: The basic difference between synchronous and asynchronous replication is that "synchronous" guarantees that if changes happened on one node of the cluster, they…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
1 2 3
…
13 14