2
votes
1answer
44 views

Need scalable database solution for very big automated data entry database

I've been working on MySQL database in simple web applications for a long time and i now have a project which should maintain about 1,000 up to 10,000 query per minute (it is some logging database ...
0
votes
0answers
5 views

What is the preferred mode of replication for a MySQL Cluster?

Reading about MySQL Cluster, I'd like to know about what are the preferred models of replication. I understand that it supports asynchronous replication out of the box, but I'm not sure of how it ...
0
votes
2answers
168 views

Experience with Scalearc sharding?

Does anyone have experience with Scalearc sharding and it's ability to scale ? Does Scalearc needs to have the whole data in memory or does it behave well with disk storage ? I'm thinking to big ...
0
votes
1answer
28 views

Cannot start MySQL Cluster Management Service

Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid= on command line. This is what EventViewer is saying
0
votes
0answers
110 views

calculate Transaction per Second on mysql ndbcluster

what is the formula to calculate the TPS of mysql ndbcluster? for example i have 5 clients to submit 200 queries each client.
0
votes
1answer
146 views

Redo Logs Mysql Cluster

The mysql cluster has 4 directories namely D8 D9 D10 D11 for redo logfiles. But while inserting into table only one redo directory is used. I ran following command to get redo information "all dump ...
1
vote
0answers
113 views

Error in alter table reorganize partition for MySQL Cluster

My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition. Some parameters of ...
1
vote
1answer
104 views

Data usage increases initially when reorganize partition mysql cluster

In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes. But before ...
1
vote
2answers
181 views

Multiple database servers for performance vs failover

If I have two database servers, and I am looking for maximum performance vs high-availability, what configuration would be best? Assuming the architecture is two load-balanced web/app servers in ...
1
vote
1answer
420 views

Experience using ScaleArc in test or production?

Has anyone had any experience using ScaleArc? My CTO has asked my thoughts on it, and I have seen no information out there regarding real-world experiences.
3
votes
1answer
227 views

MySQL licensing

I have looked at a few questions posted in stackoverflow http://stackoverflow.com/questions/225987/can-someone-explain-mysqls-license-and-what-it-means-to-closed-source-developme ...
1
vote
1answer
140 views

MySQL Cluster Steps To Recover Data If Catstrophic Failure Occurs

I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that ...
4
votes
1answer
2k views

Setting up MySQL Cluster on Two Systems

I am attempting to setup a MySQL Cluster. I have the folllowing setup one management node two data nodes another machine on which two more nodes reside Below is the config.ini file: [ndbd ...
2
votes
2answers
1k views

How to sync two MySQL high load tables with 10M rows?

I have two identical MySQL innodb table with 10M rows each. One is used at backend while other at application end. Thus, either of them loaded. I need to synchronize them in a way which is fast and ...
3
votes
1answer
136 views

Distribute MySQL in different cities?

We have our main MySQL server in city A. We have the bulk of our customer service staff in city B. The staff are complaining that the connection is too slow to the server. The options are: Have them ...
1
vote
1answer
162 views

MySQL CLuster SETUP

Good day! About MySQL Cluster, is it possible to set it up on only two machines? Is it advisable? We currently have MySQL replication setup on our two databases, and we would like to implement R/W ...
2
votes
1answer
277 views

Redesigning a multi-instance MySQL server for performance and resiliency

I've got a single MySQL server which currently runs N separate MySQL instances on, which are rapidly growing beyond the capabilities of that box. Is it possible to have an active-active MySQL ...
0
votes
1answer
163 views

memcached service stopped unexpectedly

I am working with MySQL Cluster 7.2.4 memcached 1.6 I started memcached service with ndb-caching option: memcached -E /usr/local/mysql/lib/ndb_engine.so -e ...
2
votes
1answer
443 views

Dual management node for mysql clustering

I currently have mysql cluster setup and running. Here is my current setup: 1 - management node 2 - data nodes 2 - mysql nodes I wish to incorporate a failover for the management node. The ...
0
votes
1answer
367 views

What are the parameters that are needed to be monitored for MYSQL Cluster

I am new to MySQL cluster. I had installed MySQL cluster successfully with 2 data nodes and 1 Management Node and 1 SQL node. I want to know where and how exactly the core data is getting stored. ...
1
vote
3answers
616 views

Best architecture solution for heavy data mining system, that can run on cloud

We are currently hosting our MySQL database on a dedicated server with lots of memory and processors. We would like to push it to a different architecture that would allow us to scale it easily, ...
5
votes
1answer
5k views

MySQL high availability, failover and replication with Latency

We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...