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 30 of 45 Next 15 Older Entries

Displaying posts with tag: MySQL CLuster 7.0 (reset)

MySQL Cluster Database 7: Performance Benchmark
Employee +6 Vote Up -0Vote Down

(Note that this is a copy of the original article from Hasham Pathan posted on 21st April 2009).

Summary of Results:

We recently conducted a Performance Benchmark of the newly released version of MySQL Cluster database software version 7.0 using the DBT2 Benchmark. The results are very impressive.

Highlight of the results:

  • For 4 Node Cluster, we achieved 251,000 Transactions per minute which is more than 4X improvement over the MySQL Cluster 6.3 release.
  • For 2 Node Cluster, we achieved 143,000 Transactions per minute which is more than 4X improvement over the MySQL Cluster 6.3 release.
  • Whether a user is looking to take advantage of the latest multi-core, multi-thread server processors, or is seeking to
  [Read more...]
On-demand-webinar – What’s New in Managing MySQL Cluster
Employee +8 Vote Up -2Vote Down

The recording of this webinar is now available to view on-line here.

There will be a live webinar on Wednesday January 12 describing the new ways that you can manage MySQL Cluster (with a bit of monitoring thrown in). As always, the webinar is free but you need to register here (http://www.mysql.com/news-and-events/web-seminars/display-599.html" target="_blank). The event is scheduled for 09:00 Pacific / 17:00 UK / 18:00 Central European time but if you can’t make the live webinar it’s still worth registering so that you’re emailed the replay after the event.

By their very nature, clustered environments involve more effort and resource to administer

  [Read more...]
MySQL Cluster 7.0.13 binaries released
Employee +3 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.0.13 has now been made available at http://dev.mysql.com/downloads/cluster/ under the GA tab.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.13 (compared to 7.0.12) can be found in the MySQL Cluster 7.0.13 Change Log.

MySQL Cluster on Windows – webinar replay available
Employee +1 Vote Up -0Vote Down

If you missed the recent webinar on running MySQL Cluster on Windows then you can watch/listen to the replay at http://www.mysql.com/news-and-events/on-demand-webinars/display-od-517.html (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-517.html" target="_blank)

Presenting Cluster tutorial at MySQL UC (and discount code!)
Employee +4 Vote Up -0Vote Down

Together with Geert and Andrew I’ll be teaching the MySQL Cluster tutrial at this year’s MySQL Cluster User Conference – Santa Clara, on April 12th. If you’re interested in using MySQL Cluster but aren’t sure how to get started (or you’ve used it but would like some tips) then this is a great opportunity. Check out the tutorial description.

If you

  [Read more...]
MySQL Cluster 7.0.11b source released
Employee +2 Vote Up -0Vote Down

The source version for MySQL Cluster 7.0.11b has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.41-ndb-7.0.11b/

This replaces MySQL Cluster 7.0.10 and 7.0.11.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.11b (compared to 7.0.10) can be found in the MySQL Cluster 7.0.11b Change Log

MySQL Cluster 7.0.11 source released
Employee +4 Vote Up -0Vote Down

The source version for MySQL Cluster 7.0.11 has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.41-ndb-7.0.11/

This replaces MySQL Cluster 7.0.10.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.11 (compared to 7.0.11) can be found in the MySQL_Cluster_7_0_11_ChangeLog.

Upcoming webinar – MySQL performance tuning best practices
Employee +4 Vote Up -0Vote Down

MySQL Cluster Performance Tuning Best Practices

Are you experiencing current performance bottlenecks in your high availability applications ? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?

Benefits of connection pooling

Then this free web presentation is for you! You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance when using MySQL

  [Read more...]
Running MySQL Cluster over multiple Windows servers
Employee +3 Vote Up -0Vote Down


Following on from the earlier article on running MySQL Cluster on a single Windows host, this one looks at installing and running over multiple Windows machines.

Note that MySQL Cluster is still for development use only on Windows – use LINUX or Solaris for live deployments. For the latest status of which platforms are supported for development and deployment, refer to the Supported Platforms matrix (http://www.mysql.com/support/supportedplatforms/cluster.html" target="_blank).


  [Read more...]
CMON - Install Instructions
+3 Vote Up -1Vote Down
CMON - the Cluster Monitor has recently been released and here is a little how to about how to install from binary and source (at the end), deployment etc.

1. Download the cmon binary package to a monitoring host
Currently there are binaries available for Linux 64-bit and 32-bit (statically linked) and works for MySQL Cluster 7.0.9 and later.

In this case the monitoring host will be on 'ndb05' (IP address 10.0.1.5) - see 9. Suggested Deployment for a picture describing the setup.

The Monitoring machine should have installed:
  • a mysql server up and running that will store the cmon database (if you build from source you need to have the mysql cluster libraries and include files)
  • apache (if you want to have the web interface) + php_mysql
  • rrdtool (if you want to have







  [Read more...]
MySQL Cluster 7.0.10 source released
Employee +4 Vote Up -0Vote Down

The source version for MySQL Cluster 7.0.10 has now been made available at ftp://ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.39-ndb-7.0.10//

This replaces MySQL Cluster 7.0.9.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.10 (compared to 7.0.9) can be found in the MySQL_Cluster_7_0_10_ChangeLog.

New white paper: Guide to Optimizing Performance of the MySQL Cluster Database
Employee +3 Vote Up -0Vote Down

MySQL Cluster Connection Pooling

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

The Guide concludes with recent performance benchmarks conducted with the MySQL Cluster database, an overview of how MySQL Cluster can be integrated with other MySQL storage engines, before summarizing additional resources that will enable you to optimize MySQL Cluster

  [Read more...]
Node failure handling - take 2
+2 Vote Up -0Vote Down
Jonas improved the node failure handling in MySQL Cluster 7.0.9 (and 6.3.29) so here comes a re-run of the a previous blog post. And the node failure handling time has improved a lot - see below.

I created in total 11345 tables, each with 128 columns, and then hit this bug.

When all tables were created, I stopped one node and measured how long time it takes for the other node to perform the node failure handling. Here is what was written into the cluster log (look at the bold lines):

2009-11-27 13:39:21 [MgmtSrvr] ALERT -- Node 4: Node 3 Disconnected

2009-11-27 13:39:21 [MgmtSrvr] ALERT -- Node 4: Network partitioning - arbitration required

2009-11-27 13:39:21 [MgmtSrvr] INFO









  [Read more...]
Scaling - going from 2 to X data nodes
+2 Vote Up -0Vote Down
When moving from two data nodes to a bigger Cluster it is not necessarily true that you will have better performance. In fact you can get worse.

Here are some things to think about:
  • Database Load (traffic to Cluster) - if you can handle query load X on a two node cluster and move the same load X to a four data node cluster you will likely get new_load_X=0.8X, i.e., a performance degradation. This has to do with 1) buffers are not filled up fast enough so the data nodes will do "timeout" based sending or 2) that the access patterns aren't scaling. To correct 1) you need to increase the load on the cluster so that internal communication buffers fill up faster.
Access pattern related "problems":

  • For primary key operations (reads, updates, deletes) you will always go to the correct node to fetch the data with PK






  [Read more...]
MySQL Cluster 7.0.9 GA binaries released
Employee +1 Vote Up -0Vote Down

The GA binaries for MySQL Cluster 7.0.9 have been released – download them from http://dev.mysql.com/downloads/select.php?id=14

A summary of the changes can be found in the MySQL Cluster 7.0.9 Change Log

Free Webinar: Shopatron’s eCommerce Services Powered by MySQL Cluster – Best Practices
Employee +0 Vote Up -0Vote Down

As one of the world’s leading eCommerce Service Providers, Shopatron needed to further improve scalability and availability of their eCommerce services to keep pace with their rapidly growing business, while at the same time, reducing costs.

After extensive evaluations, Shopatron selected MySQL Cluster to power its back-end database, running the entire eCommerce fulfillment engine.

Since deploying MySQL Cluster, Shopatron have achieved:

  • continuous service availability with sub-second failover and fully automated recovery
  • real-time performance, reducing query times from 3 seconds to 2 milliseconds
  • extreme levels of scalability on commodity hardware and open source software
  • reduced licensing, support
  [Read more...]
Free webinar: FreeRADIUS & MySQL Cluster: Scalable and Highly Available AAA Services – EMEA
Employee +0 Vote Up -0Vote Down

As network use grows and services become more dynamic, so existing Authentication, Authorization and Accounting (AAA) environments can struggle to keep pace with demand.

Tune into this webinar where you can hear from the Alan Dekok, one of the founders of the FreeRADIUS project and CEO of Network RADIUS, discuss the concepts and implementation of RADIUS services using the FreeRADIUS server and the MySQL Cluster database to deliver highly available and scalable AAA services.

As always, this webinar is free and you can register here (http://www.mysql.com/news-and-events/web-seminars/display-432.html" target="_blank). I will be manning the Q&A during the webinar.

In this session, you will learn about:

      [Read more...]
    MySQL Cluster 7.0.8a is now released
    Employee +0 Vote Up -0Vote Down

    The GA binaries for MySQL Cluster 7.0.8a (the “a” is used to indicate that this is an increment on the original 7.0.8 source release) have been released – download them from http://dev.mysql.com/downloads/select.php?id=14

    A summary of the changes can be found in the MySQL Cluster 7.0.8a Change Log

    Upgrade to 7.0.8 (with the Configurator)
    +1 Vote Up -0Vote Down
    MySQL Cluster 7.0.8 was released as a source distribution 30th of Sept 2009. You should upgrade if you can build from source or use the Configurator.

    See below how to upgrade when using the Configurator.

    7.0.8 contains a number of fixes in almost every area and you are recommended to upgrade if you experience problems with earlier version(s). Especially if you have encountered the "error 306" problem.

    The Configurator v2.9 has been updated to use this version.

    If you are already using the Configurator and build from source you can upgrade from MySQL Cluster 7.0.7 to 7.0.8 (and you are







      [Read more...]
    Free MySQL webinar today – High Availability Architectures for Online Applications
    Employee +0 Vote Up -0Vote Down

    Update: You can now download a recording of the webinar and the slides from http://www.mysql.com/news-and-events/on-demand-webinars/display-od-403.html (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-403.html" target="_blank)

    I’ll be presenting the fourth (and final) session of the MySQL for Online Applications webinar series (http://www.mysql.com/news-and-events/web-seminars/online-apps.html" target="_blank) today (29 September). Today’s High Availability Architectures for Online Applications (http://www.mysql.com/news-and-events/web-seminars/display-403.html) webinar covers:

    • MySQL Replication
    • MySQL Cluster
    • Distributed Replicated Block Device (DRBD)
    • Other high-availability technologies

    Register here

      [Read more...]
    MySQL Cluster 7.0.7 binaries released
    Employee +0 Vote Up -0Vote Down

    The binaries for MySQL Cluster 7.0.7 have now been released and can be downloaded from http://dev.mysql.com/downloads/cluster/7.0.html

    A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.7 (compared to 7.0.6) can be found in the MySQL Cluster 7.0.7 Change Log.

    MySQL Cluster on two hosts - options and implications
    +1 Vote Up -0Vote Down
    Considering that you have the following hosts and MySQL Cluster deployed in the following ways:

    A: ndb_mgmd, ndbd , mysqld
    B: ndb_mgmd, ndbd , mysqld

    Now you have a couple of options on how to handle potential network partitioning/split brain which could occur if the computer A and B lose contact with each other. Let's see the implications of these options.

    Option 1: ArbitrationRank=1, no NIC bonding
    • If ndb_mgmd on A is elected as the arbitrator and host A crashes, then data node on host B will also die (cannot reach arbitrator).
    • If ndb_mgmd on A is elected as the arbitrator and host B lose contact with host A, then the data node on B will shut down since it can't reach the arbitrator. For further discussions, call this situation X.
    • If you are in situation X and if you restart data node on B and you








      [Read more...]
    Upgrade to 7.0.7 (with the Configurator)
    +1 Vote Up -0Vote Down
    MySQL Cluster 7.0.7 was released as a source distribution 1st of Sept 2009. You should upgrade if you can build from source or use the Configurator.

    The Configurator v2.9 has been updated to use this version.

    If you are already using the Configurator and build from source you can upgrade from MySQL Cluster 7.0.6 to 7.0.7 (and you are recommended to upgrade because of the following changes/fixes) in four steps. Here is how:

    1. run the upgrade-706-to-707-src.sh script (put it in install/ and chmod u+x ./upgrade-706-to-707-src.sh):
    [cluster01]# pwd







      [Read more...]
    MySQL Cluster 7.0.7 source released
    Employee +2 Vote Up -0Vote Down

    Update: As explained in “MySQL Cluster 7.0.7 binaries released” you can now download the compiled binaries for your particular platform. I am going to leave this entry in place as it will hopefully be useful for future releases but for 7.0.7 you should refer to that other post.

    You’ll need to wait for the pre-built binaries but you can now download the source code and build it for yourself to get started. This article explains where to get it and how to build, install and test the installation.

    In this example, I’ve used Ubuntu.

    The first step is to download the compressed tar ball containing the source code by pointing your browser to

      [Read more...]
    OPTIMIZE TABLE on Cluster (revisited)
    +4 Vote Up -0Vote Down
    Jonas just wrote a patch to this bug on OPTIMIZE TABLE, and the issue that was also discussed in this blog post. Jonas also fixed this bug when he was at it.

    Before, OPTIMIZE TABLE hardly freed up any pages and to defragment you had to do a rolling restart of the data nodes.

    Now, there is only a 2% discrepancy between OPTIMIZE TABLE and doing a rolling restart. This is great stuff.
    This will fix will make it into 6.3.26 and 7.0.7.

    See below for details:

    Creating two tables, t5 and t6:

    CREATE TABLE `t5` (
    `id` varchar(32) CHARACTER SET utf8 NOT NULL,
    `name`












      [Read more...]
    Upgrade 6.3.x to 7.0.6
    +2 Vote Up -1Vote Down
    Currently a number of users has reported upgrade issues on 6.3.x to 7.0.6 (below is an example what might happen to you).

    Thus, we don't recommend you to upgrade from 6.3.x to 7.0.6 in a production system yet.
    However, we are very interested in bug reports and and help with testing.
    We are also of course working on fixing these issues and will keep you posted when things has improved. Sorry for the inconvenience.

    Currently the "best practice" to upgrade is to:
    1) backup / mysqldump
    2) start cluster 7.0.6 with initial so it is completely blank
    3) restore backup / load dump


    ERROR 1005 (HY000): Can't create table 'test.#sql-3d25_aa905' (Errno: 140)

    mysql> show warnings;
    +-------+------+--------------------------------------------------------------------------+
    | Level | Code | Message















      [Read more...]
    Webinar: MySQL Cluster 7.0: What’s New? (AS/ANZ/IN)
    Employee +0 Vote Up -0Vote Down

    Mat Keep and I will be presenting a Webinar on Wednesday, August 12, 2009 describing the new capabilities of MySQL Cluster 7.0. The time is designed to be Asia/Australasia-friendly but of course it’s open to everyone.

    Register for the MySQL Cluster 7 Webinar here (http://www.mysql.com/news-and-events/web-seminars/display-399.html" target="_blank).

    By attending this webinar, you will learn more about the next generation of MySQL Cluster, and how it enables you to deliver 99.999% database availability, with real time performance and linear scalability, while slashing TCO.

    Boasting a range of breakthrough capabilities, MySQL Cluster 7.0 will enable you to stay ahead of your most demanding, mission-critical application requirements. Enhanced scalability delivers higher database performance with fewer nodes to simplify deployment and

      [Read more...]
    Cluster + Dolphin DX = Sweet!
    +0 Vote Up -0Vote Down
    At a customer I have had the opportunity to work with some really state of the art equipment.

    The customer is in the online gaming industry and we are building a platform based on MySQL Cluster where we are consolidating a number of applications. Workload is mainly inserts, updates, pk reads, and index scans (quite frequent), and a few joins. The cluster handles the transient data (current working set), and is replicating to a long term data store (following this approach), and we are also feeding other back-end support systems from this.

    The cluster (>8 computers) is interconnected with Dolphin DX adapters. Computers are SUNs



      [Read more...]
    MySQL Cluster Data Node restart times
    Employee +0 Vote Up -0Vote Down

    Restarts are required for certain, infrequent maintenance activities. Note that there is no loss of service while a single node restarts.

    When a data node restarts, it first attempts to load the data into memory from the local log files and then it will catch up with any subsequent changes by retrieveing them from the surviving node(s) in its node group.

     Based on this, you would expect the time taken to restart a data node to be influenced by:

  • The amount of data that was stored on the data node before the restart
  • Rate of updates being made to the data during the restart
  • Network performance (assuming the data is being updated during recovery)
  • The times will also be influenced bycertain configuration parameters, performance of the host machine and whether the multi-threaded data node (ndbmtd) is being used.

    To

      [Read more...]
    Doxygen output for MySQL Cluster NDB API & MGM API
    Employee +0 Vote Up -0Vote Down

    NDB API Documentation


    A new page has been added to this site: NDB API Docs which presents the information from the header files for both the NDB API and the NDB Management API.

    The material has been generated using doxygen and will be refreshed shortly after any new major, minor or maintenance release is made generally available (starting from MySQL Cluster 7.0.6).

    Showing entries 1 to 30 of 45 Next 15 Older Entries

    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.