Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: online add node (reset)

online add node - preliminary numbers (2)
+0 Vote Up -0Vote Down
Scenario: Grow from two data nodes to four using ONLINE ADD NODE and REORGANIZE PARTITION of a 2GB table, and UPDATE traffic

Setup for each data node:
* Dual cpu - quad core running at 2.33GHz.
* 8GB of RAM
* DataMemory=4096MB
* MaxNoOfExecutionThreads=8
* Configuration generated by Configurator
* Bound execution threads to cores (LockExec/Maint....Thread..)
* Completely distributed setup.

Created the following table and filled it with 2M rows which gives a table (different of last time to simplify further tests) of 2GB in size:

CREATE TABLE `t1` (
`a` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`b` int(10) unsigned DEFAULT NULL,
`c` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`d` varbinary(768) DEFAULT NULL,
`e`

















  [Read more...]
online add node - preliminary numbers
+0 Vote Up -0Vote Down
I want to measure the time it takes to do various ONLINE ADD NODE operations in MySQL Cluster 7.0 and especially how long time it takes to repartition the data onto the newly added nodes. So here comes the first post on the subject.

First off: Go from two data nodes to four using ONLINE ADD NODE and REORGANIZE PARTITION of 2GB tables, and no traffic system.

Setup for each data node:
  • Dual cpu - quad core running at 2.33GHz.
  • 8GB of RAM
  • DataMemory=4096MB
  • MaxNoOfExecutionThreads=8
  • Configuration generated by Configurator
  • Bound execution threads to cores (LockExec/Maint....Thread..)
  • Completely distributed setup.






  [Read more...]
MySQL Cluster 7.0.4 - online add node scripts
+0 Vote Up -0Vote Down
MySQL Cluster 7.0.4 (beta, a and formerly known as 6.4) was released yesterday in source format. The new versions fixes a number of bugs in e.g the areas of online add node and parition pruning for some index scans.

Morveover Configurator has been updated (and all the scripts have got improved error handling and usability) to support add nodes with a procedure according to the docs.

To add a new node group using the Configurator you do like this:
  • Make sure you have a MySQL Cluster 7.0 running.
  • cd mysqlcluster-70/cluster/scripts
  • Add the two new data nodes to the config.ini
    • vi







  •   [Read more...]
    Showing entries 1 to 3

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.