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 中文
Previous 30 Newer Entries Showing entries 31 to 45

Displaying posts with tag: MySQL CLuster 7.0 (reset)

Problems with .FRM files, auto-discovery and MySQL Cluster
+0 Vote Up -0Vote Down
There are some bug reports on the auto-discovery protocol in MySQL Cluster.
The idea of the auto-discovery protocol is to fetch the .frm files for the NDB tables stored in the data dictionary of the data nodes, and put them in the data directory of the mysql server.

However, sometimes (not always, which makes it more difficult to reproduce and hence fix), the auto-discovery seems to make strange things (from this bug report):
After shuting down and restoring my cluster I get the following error.

090211 9:59:26 [Note] NDB: mismatch in frm for panel.gatewayquestions, discovering...
090211 9:59:26 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$panel/gatewayquestions
090211 9:59:26 [Note] NDB Binlog: logging ./panel/gatewayquestions (UPDATED,USE_WRITE)

This









  [Read more...]
How to upgrade from 6.3 to 7.0
+2 Vote Up -0Vote Down
In order to upgrade from 6.3 to 7.0 you must follow these rules:
  • IT IS ONLY POSSIBLE TO UPGRADE FROM 6.3 to at least 7.0.6!
  • I would recommend to upgrade from 6.3.x to 6.3.latest before doing the upgrade. If the upgrade does not work then and you have a good config.ini , you have probably hit a bug.
  • You cannot upgrade from 6.3 to the multi-threaded binary of 7.0.6 in one go.
    You have to upgrade from 'ndbd' (6.3) --> 'ndbd' (7.0.6)
    Then you can do 'ndbd' (7.0.6) --> 'ndbmtd' (7.0.6)
  • So don't try to upgrade to 7.0.5 - it will fail.
    As usual when upgrading (version, configuration variables etc) you must do a rolling restart and restart:
  • ndb_mgmd (management servers)
  • ndbd (data nodes)
  • mysqld (mysql servers / direct api applications)






  •   [Read more...]
    Creating a simple Cluster on a single LINUX host
    Employee +1 Vote Up -0Vote Down

    It isn’t necessarily immediately obvious how to set up a Cluster on LINUX; this post attempts to show how to get a simple Cluster up and running. For simplicity, all of the nodes will run on a single host – a subsequent post will take the subsequent steps of moving some of them to a second host. As with my Windows post the Cluster will contain the following nodes:

    • 1 Management node (ndb_mgmd)
    • 2 Data nodes (ndbd)
    • 3 MySQL Server (API) nodes (mysqld)

    Downloading and installing

    Browse to the MySQL Cluster LINUX download page at mysql.com and download the correct version (32 or 64 bit) and store

      [Read more...]
    My first Cluster running on Windows
    Employee +4 Vote Up -1Vote Down

    I figured that it was time to check out how to install, configure, run and use MySQL Cluster on Windows. To keep things simple, this first Cluster will all run on a single host but includes these nodes:

    • 1 Management node (ndb_mgmd)
    • 2 Data nodes (ndbd)
    • 3 MySQL Server (API) nodes (mysqld)

    Downloading and installing

    Browse to the Windows section of the MySQL Cluster 7.0 download page and download the installer (32 or 64 bit).

    MySQL Cluster Windows Installer

    Run the .msi file and choose the “Custom” option. Don’t worry about the fact

      [Read more...]
    New MySQL Cluster maintenance release: 7.0.6
    Employee +0 Vote Up -0Vote Down

    MySQL Cluster version 7.0.6 has been released. MySQL Cluster 7.0.6 is available in source and binary form for a number of platforms from our download pages.

    The release in source form can in addition be downloaded from the MySQL FTP server.

    MySQL Cluster version 7.0.6 is using MySQL Server version 5.1.34 and contains all bug fixes and changes that MySQL Server 5.1.33 and 5.1.34 contain.
    Following changes were made in MySQL Cluster 7.0.6 since the previous release 7.0.5:



      [Read more...]
    HA MySQL, write scaling using Cluster to non-cluster replication
    +5 Vote Up -0Vote Down
    There are various setups and solutions to solve the problem of having redundant mysql masters and scaling writes on them. MySQL Cluster can be an alternative. Here is why and how:
    Pros:
    • No need to worry about DRBD failover and recovery times
    • No need to worry about potential data loss when failover from active master to standby master (has all binlog really been replicated over from the failed master?)
    • Writes go to any mysql server connected to the Cluster - thus writes are easy to scale
      The data nodes will then send the committed writes to every mysql server with --log-bin enabled.


      [Read more...]
    Webinar replay available: What’s New in the Next Generation of MySQL Cluster?
    Employee +1 Vote Up -0Vote Down

    There is another live webinar on MySQL Cluster 7.0 scheduled for 27th May 09:00 (Western European time) / 08:00 (UK time) / 11:00 (Eastern European time) and you can register here (http://www.mysql.com/news-and-events/web-seminars/display-350.html" target="_blank).

    Alternatively, if you can’t wait that long then you can watch/listen to the play-back of the original webinar (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-320.html).

    Note that you may need to install the WebEx Player (Windows and Mac) - unfortunately, there doesn’t seem to be a simple, supported solution for LINUX users but you can always download the slides (PDF format) from the same link or else wait until 27th May and view it live.

      [Read more...]
    Online configuration update and a new script
    +0 Vote Up -0Vote Down
    If you are using the scripts from the Configurator (and yes, the broken link is now fixed so it is actually possible to get the config package..), and want to tweak your configuration on a started Cluster then you can do like written below.

    There is also a new script in Configurator 2.2 (released 28th April 2009, PST1153AM , GMT07:53) that lets you check the values of different config parameters. Its use is described below.

    Pretend we want to extend the DataMemory from 1024M to 1536M:
  • cd mysqlcluster-70/cluster/scripts
  • vi ../config/config.ini
    This is the master config.ini file and will be copied out to the management server(s). Don't change /etc/mysql/config.ini, as that will have no effect.
  • Set







  •   [Read more...]
    Live Webinar: What’s New in the Next Generation of MySQL Cluster?
    Employee +0 Vote Up -0Vote Down

    Following on from the announcement  at the User Conference last week that MySQL Cluster 7.0 is now generally available, Mat Keep and I will present the first public webcast this Thursday. If you’d like to attend but the time isn’t convenient then you can either watch/listen to the recording after the event or wait for the next one to be announced (will be aimed at different time-zones).

    Details…..

    What’s New in the Next Generation of MySQL Cluster?
    Thursday, April 30, 2009

    Whether you’re racing to introduce a new service, or trying to manage an avalanche of data in real time, your database has to be scalable, fast and highly available to meet ever-changing market conditions and stringent SLAs.

    By attending this webinar, you will learn more about MySQL Cluster 7, and how it enables you to


      [Read more...]
    MC 7.0 New Features, LDAP For MySQL Cluster - UC2009 sessions
    +0 Vote Up -0Vote Down
    The presentations from the sessions MySQL Cluster 7.0 - New Features and LDAP For MySQL Cluster - back-ndb, and all other sessions on MySQL Cluster, are available for download from www.mysqlconf.com.
    Easiest way to try out new MySQL Cluster 7.0.5
    +0 Vote Up -0Vote Down
    Here is how to install and start MySQL Cluster 7.0.5 in eight steps:
  • Go to the configurator and setup the configuration you wish to have. Make sure you select "MySQL Cluster 7.0.x" in the first drop down.
  • Copy the package you either download or receive by email to one of the computers that will run one of the management servers.
  • tar xvfz mysqlcluster-70.tgz
  • cd mysqlcluster-70/scripts/install
  • Download MySQL Cluster 7.0 from MySQL website and put it in mysqlcluster-70/scripts/install
  • sh dist-tgz.sh
  • sh bootstrap.sh
  • cd .. && sh start-cluster-initial.sh
  • Okay, step 1) requires that you setup shared ssh




      [Read more...]
    MySQL Cluster 7.0 Launched
    Employee +1 Vote Up -0Vote Down

    MySQL (part of Sun Microsystems) have just announced the release of MySQL Cluster 7.0. This is a major new version of the database.

    The highlights of the release (as well as an overview of the MySQL Cluster architecture) have been published in a new white paper: MySQL Cluster 7.0: Architecture and New Features (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster7_architecture.php).

    For those in a rush, here are the highlights of the highlights:

    • Multi-threaded data nodes. Could previously exploit up to 2 cores/CPUs/threads for a single data node. This is extended to 8 cores by introducing a multi-threaded version of the ndb process. This delivers a very significant performance improvement if running on a host with more than  a dual core.
    • On-line add node. The ability to add a new node group to an
      [Read more...]
    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...]
    Previous 30 Newer Entries Showing entries 31 to 45

    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.