Tagged Questions
0
votes
0answers
18 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
0
votes
0answers
23 views
ERROR while doing coalesce partition Mysql Cluster
My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command ...
0
votes
1answer
37 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
23 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 ...
0
votes
0answers
24 views
After optimize table statement my data usage increased Mysql Cluster
I deleted 500000 rows in my mysql cluster table having 12468000 rows and then i tried to OPTIMIZE TABLE so that all the freed up data memory can be used by another table also, but after optimizing ...
0
votes
0answers
18 views
Re-use disk data extents after delete Mysql Cluster
In my mysql cluster i have 1 million rows and my disk data tables are using all the disk usage available to them ;i.e; free extents are 0 . Now i deleted 50K rows from ap_perf_tbl but still it show ...
0
votes
0answers
20 views
Why data usage increases when deleting rows Mysql Cluster?
My mysql cluster data nodes data usage increased to 95%. Then i tried to delete 500000 rows and my data usage of nodes started increasing initially and reached to 99% and above and TABLE FULL error is ...
1
vote
1answer
54 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 ...
0
votes
2answers
68 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
150 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.
0
votes
0answers
367 views
Which is more scalable, Oracle RAC or MySQL Cluster? [closed]
I'm looking for information about both products and your experience would be a big help. I'm aware that Oracle RAC and MySQL Cluster uses different architecture and that Oracle RAC has single point of ...
3
votes
1answer
119 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
83 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
809 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
824 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
119 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
145 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
209 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
122 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
214 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
248 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
443 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, ...
4
votes
1answer
3k 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 ...
