Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 70

Displaying posts with tag: MySQL Cluster CGE (reset)

Intelligent user-controlled partitioning and writing distribution-aware NDB API Applications
Employee +0 Vote Up -0Vote Down

Default partitioning

By default, Cluster will partition based on primary key

When adding rows to a table that’s using MySQL Cluster as the storage engine, each row is assigned to a partition where that partition is mastered by a particular data node in the Cluster. The best performance comes when all of the data required to satisfy a transaction is held within a single partition so that it can be satisfied within  a single data node rather than being bounced back and …

  [Read more...]
MySQL Cluster Multi-Range Read using NDB API
Employee +0 Vote Up -0Vote Down

As described in “Batching – improving MySQL Cluster performance when using the NDB API“, reducing the number of times the application node has to access the data nodes can greatly improve performance and reduce latency. That article focussed on setting up multiple operatations (as part of a single transaction) and then executing them as a single batch sent by the NDB API library to the data nodes.

The purpose of this entry is to show how a single NDB API operation can access multiple rows from a …

  [Read more...]
Batching – improving MySQL Cluster performance when using the NDB API
Employee +1 Vote Up -0Vote Down

As many people are aware, the best performance can be achieved from MySQL Cluster by using the native (C++) NDB API (rather than using SQL via a MySQL Server). What’s less well known is that you can improve the performance of your NDB-API enabled application even further by ‘batching’. This article attempts to explain why batching helps and how to do it.

What is batching and why does it help?

NDB API accessing data from the Cluster without batching

Batching involves sending multiple operations …

  [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 …

  [Read more...]
MySQL Cluster - flexibility of replication
Employee +1 Vote Up -0Vote Down

One of the better kept secrets about MySQL Cluster appears to be the flexibility available when setting up replication. Rather than being constrained to implementing a single replication scheme, you can mix and match approaches.

Just about every Cluster deployment will use synchronous replication between the data nodes within a node group to implement High Availability (HA) by making sure that at the point a transaction is committed, the new data is stored in at least 2 physical hosts. Given that MySQL Cluster is usually used to store the data in main memory rather than on disk, this is pretty much mandatory (note that the data changes are …

  [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.

Alternatively, if you can’t wait that long then you can watch/listen to the play-back of the original webinar.

Note that you may need to …

  [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, …


  [Read more...]
New MySQL Cluster White Paper - Building a Carrier-Grade Platform for Data Management
Employee +0 Vote Up -0Vote Down

A new white paper has been published by MySQL/Sun Microsystems and it can be downloaded from http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster7_open_cgp.php

Open Source Carrier Grade Platform - using MySQL Cluster CGE

Abstract:

The convergence of communication networks onto one which is IP (Internet Protocol) based is …

  [Read more...]
Enhanced MySQL Cluster Evaluation White Paper
Employee +1 Vote Up -0Vote Down

As part of MySQL Cluster 7.0, an existing white paper has been brought up to date and extended. If you’re considering evaluating MySQL Cluster or are in the process of an evaluation then I’d strongly recommend reading this paper. Even if you haven’t got that far in your database evaluation, it’s worth taking a look as it describes both where the database excels and situations where it may be less suitable or where extra attention would be needed.

The MySQL Cluster Evaluation Guide can be downloaded from the …

  [Read more...]
“Guide to Deploying Carrier Grade Services Using Open Source Technologies” - New White Paper Released
Employee +0 Vote Up -0Vote Down

A new white paper has just been released on mysql.com at http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_deploy_opencge.php

Open Source Carrier Grade hardware and software stack

Abstract:

Open source technologies and commodity, carrier-grade hardware can combine to create a highly available, scalable …

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 70

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.