Tagged Questions
0
votes
0answers
21 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
22 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
23 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
53 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
1answer
81 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 ...
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 ...
2
votes
1answer
213 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 ...
