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 46

Displaying posts with tag: MySQL Cluster 7.1 (reset)

MySQL Cluster Scores with Pyro and Cell C at the FIFA World Cup – new case study
Employee +6 Vote Up -0Vote Down

The Pyro Group has selected the MySQL Cluster database to power their InRoam SDP (Service Delivery Platform). InRoam enables Cell C and their network partners to provide low cost, border-less mobile communications services to hundreds of thousands of football fans from around the world as they descend on South Africa for the 2010 FIFA World Cup tournament.

This new case study can be downloaded from http://www.mysql.com/why-mysql/case-studies/mysql_cs-pyro_telecoms.php (http://www.mysql.com/why-mysql/case-studies/mysql_cs-pyro_telecoms.php" target="_blank)

Solution Overview

  • Pyro InRoam SDP is an intelligent application
  [Read more...]
Configure MySQL Enterprise Monitor to monitor MySQL Cluster
Employee +6 Vote Up -0Vote Down

MySQL Cluster 7.1 introduced the ndbinfo database which contains views giving real-time access to a whole host of information that helps you monitor and tune your MySQL Cluster deployment. Because this data can be accessed through regular SQL, various systems can be configured to monitor the Cluster. This post gives one example, extending MySQL Enterprise Monitor to keep an eye on the amount of free memory on the data nodes (through a graph) and then raise an alarm when it starts to run low – even generating SNMP traps if that’s what you need.

One of the features of MySQL Enterprise Monitor is that you can define custom data collectors and that those data

  [Read more...]
Free webinar – learn about MySQL Cluster 7.1
Employee +4 Vote Up -0Vote Down

MySQL Cluster 7.1 was declared GA earlier this month and today (29 April) you have the chance to learn all about it by registering for this free webinar (http://www.mysql.com/news-and-events/web-seminars/display-529.html" target="_blank).

In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO; MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

NDB$INFO presents real-time usage statistics from the MySQL Cluster data nodes as a series of SQL tables, enabling developers and administrators to monitor database performance and optimize their applications.

Designed for

  [Read more...]
Tuning your Cluster with ndbinfo (7.1) part 1 of X
+2 Vote Up -0Vote Down
The new ndbinfo interface in 7.1 is really useful to assist in tuning MySQL Cluster. Here is an example (more will follow):

I started with one test where I inserted two blobs (1KB + 1KB) in one table.
From 16 threads (colocated with one mysqld, two data nodes, separate computers) and one application driving the load I reached about 6960TPS, and the utilization of the redo buffers (controlled by the parameter RedoBuffer in config.ini) looked like:

mysql< select * from ndbinfo.logbuffers;
+---------+----------+--------+----------+----------+--------+
| node_id | log_type | log_id | log_part | total | used |
+---------+----------+--------+----------+----------+--------+
| 3 | REDO | 0 | 1 | 50331648 | 196608 |
| 3 | REDO | 0 | 2 | 50331648 | 294912









  [Read more...]
MySQL Cluster 7.1 is GA
Employee +0 Vote Up -0Vote Down

MySQL Cluster 7.1 has been declared GA – including MySQL Cluster Connector for Java and MySQL Cluster Manager – see http://www.mysql.com/products/database/cluster/ (http://www.mysql.com/products/database/cluster/" target="_blank) for details.

Using ClusterJPA (part of MySQL Cluster Connector for Java) – a tutorial
Employee +4 Vote Up -0Vote Down

Fig. 1 Java access to MySQL Cluster

This is a follow up to the earlier post Using ClusterJ (part of MySQL Cluster Connector for Java) – a tutorial but covers the ClusterJPA interface rather than ClusterJ.

JPA is the Java standard for persistence and different vendors can implement their own implementation of this API and they can (and do) add proprietary extensions. Three of the most common implementations are OpenJPA, Hibernate and Toplink. JPA can be used within server containers or outside of them (i.e. with either J2EE

  [Read more...]
Using ClusterJ (part of MySQL Cluster Connector for Java) – a tutorial
Employee +5 Vote Up -0Vote Down

Fig. 1 Java access to MySQL Cluster

ClusterJ is part of the MySQL Cluster Connector for Java which is currently in beta as part of MySQL Cluster 7.1. It is designed to provide a high performance method for Java applications to store and access data in a MySQL Cluster database. It is also designed to be easy for Java developers to use and is “in the style of” Hibernate/Java Data Objects (JDO) and JPA. It uses the Domain Object Model DataMapper pattern:

  • Data is represented as domain objects
  • Domain objects are separate from business logic
  • Domain objects are mapped to database tables

The purpose of ClusterJ is to

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

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

Note that this beta load contains the latest NDBINFO and MySQL Cluster Connector for Java (ClusterJ) enhancements – please try them out and provide feedback (any bugs should be reported through bugs.mysql.com.

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

Build MySQL Cluster 7.1 from source – including MySQL Cluster Connector for Java
Employee +4 Vote Up -0Vote Down

If you want to try out the beta features in MySQL Cluster 7.1 then you can either use the appropriate binaries or you can build it for yourself from source. Here I explain how to do this on LINUX.

Note that if you want to make use of OpenJPA then you first need to install OpenJPA and Connector/J.

The example here was on Fedora12 with the MySQL Cluster 7.1.2 source:

CFLAGS=”-O3″ CXX=gcc CXXFLAGS=”-O3 -felide-constructors -fno-exceptions -fno-rtti” ./configure -prefix=/usr/local/mysql –enable-assembler –with-mysqld-ldflags=-all-static –with-plugins=max

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

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

Note that this beta load contains the latest NDBINFO and MySQL Cluster Connector for Java (ClusterJ) enhancements – please try them out and provide feedback (any bugs should be reported through bugs.mysql.com.

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

Presenting on new MySQL Cluster 7.1 features at MySQL UC (and discount code!)
Employee +1 Vote Up -0Vote Down

Together with Berndt I’ll be presenting on the new features in MySQL Cluster 7.1 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 presentation description.

If you register

  [Read more...]
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 Connector for Java – replay available for part 1 of the webinar
Employee +4 Vote Up -0Vote Down

The replay of the two webinars can now be accesed from mysql.com (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-487.html)

Remember that the second part of the webinar will be on March 3rd (details below).

ClusterJ Architecture

MySQL have been working on a new way of accessing MySQL Cluster using Java. Designed for Java developers, the MySQL Cluster Connector for Java implements an easy-to-use and high performance native Java interface and OpenJPA plug-in that maps Java classes to tables stored in the high availability, real-time MySQL Cluster database.

There is a series of 2 webinars coming up, as always

  [Read more...]
MySQL Cluster 7.1.1 (beta) - what's in there
+5 Vote Up -0Vote Down
The main new features in MySQL Cluster 7.1.1 (beta) is the following:
  • ndbinfo (aka ndb$info) - Finally!! System tables for MySQL Cluster describing live usage of a lot of resources (RedoBuffer, Redo Log space, counters etc etc). Looks promising - makes Cluster a lot more transparent. See examples below.
  • Cluster/J - for more information and to learn more about it - register to a webinar and meet the architect and developer of Cluster/J!
Severalnines/Configurator supports 7.1.1 - to try it out!

NDBINFO - examples

Ever wondered how much for the RedoBuffer you are actually using?
mysql>  SELECT * FROM ndbinfo.logbuffers;








  [Read more...]
Upcoming webinars for Java and JPA access to MySQL Cluster
Employee +4 Vote Up -0Vote Down

ClusterJ Architecture

MySQL have been working on a new way of accessing MySQL Cluster using Java. Designed for Java developers, the MySQL Cluster Connector for Java implements an easy-to-use and high performance native Java interface and OpenJPA plug-in that maps Java classes to tables stored in the high availability, real-time MySQL Cluster database.

There is a series of 2 webinars coming up, as always these are free to attend – you just need to register in advance:

Part 1: Tuesday, February 16, 2010: 10:00 Pacific time

  • an overview of the MySQL Cluster Connector for Java
  • what these technologies bring to
  [Read more...]
Java and OpenJPA for MySQL Cluster
Employee +3 Vote Up -0Vote Down

ClusterJ Architecture

MySQL have been working on a new way of accessing MySQL Cluster using Java. The aim being to give most of the performance of the C++ NDB API but in a much friendlier form for Java developers. There will in fact be 2 new interfaces – ClusterJ (MySQL’s own API) and a JPA solution (using OpenJPA). If you want to see for yourself then take a look at the Blog entry from Bernhard Ocklin – the engineering manager responsible for this work.

Previous 30 Newer Entries Showing entries 31 to 46

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.