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 46 Next 16 Older Entries

Displaying posts with tag: MySQL Cluster 7.1 (reset)

MySQL Cluster 7.1.29 Released
Employee +1 Vote Up -0Vote Down

The binary and source versions of MySQL Cluster 7.1.29 have now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank).

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.29 (compared to 7.1.28) is available from the 7.1.29 Change log.

MySQL Cluster 7.1.23 has been released
Employee +4 Vote Up -0Vote Down

The binary & source versions for MySQL Cluster 7.1.23 have now been made available at https://www.mysql.com/downloads/cluster/7.1.html#downloads (https://www.mysql.com/downloads/cluster/7.1.html#downloads" target="_blank) (GPL version) or https://support.oracle.com/ (commercial version).

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.23 (compared to 7.1.22) are available from the 7.1.23 Change log.

MySQL Cluster 7.1.22 is available for download
Employee +4 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.1,21 has now been made available at https://www.mysql.com/downloads/cluster/7.1.html#downloads (https://www.mysql.com/downloads/cluster/7.1.html#downloads" target="_blank) (GPL version) or https://support.oracle.com/ (commercial version).

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.22 (compared to 7.1.21) are available from the 7.1.22 Change log.

MySQL Cluster 7.1.19 is available to download
Employee +4 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.1.19 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or https://support.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.19 (compared to 7.1.18) will appear in the 7.1.19 Change log.

MySQL Cluster 7.1.18 is available to download
Employee +6 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.18 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or https://support.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.18 (compared to 7.1.17) will appear in the 7.1.18 Change log soon.

MySQL Cluster 7.1.17 available
Employee +4 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.17 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or https://support.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.17 (compared to 7.1.15a) can be found by combining the summaries from the official MySQL Cluster documentation for Cluster – 7.1.16 Change log & 7.1.17 Change log.

Further MySQL Cluster additions to MySQL Enterprise Monitor
Employee +2 Vote Up -0Vote Down

Data Node Restarted alert

About 11 months ago I described the MySQL Cluster functionality that was added to MySQL Enterprise Monitor 2.3; this new post is intended to just bring this up to date – briefly describing the new graph and advisors which have been added since then (up to and including MEM 2.3.7).

Cluster Data Node Has Been Restarted

This new alert flags when a data node has been

  [Read more...]
MySQL Cluster 7.1.15a is available
Employee +4 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.15a has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or https://edelivery.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.15a (compared to 7.1.15) can be found in the official MySQL Cluster documentation for Cluster 7.1.15a Change log.

Webinar: MySQL Cluster, Scaling Web Databases with Auto-Partitioning and SQL/NoSQL Access
Employee +4 Vote Up -0Vote Down

Scale-out with MySQL Cluster

Update: webinar replay is now available from http://event.on24.com/r.htm?e=311660&s=1&k=3DCFE1CB3E1CF3F0FD0969DC66D93989

(http://www.mysql.com/news-and-events/on-demand-webinars/display-od-613.html" target="_blank)On Thursday 26th May Mat Keep and I will be presenting a webinar on how MySQL Cluster can deliver linear scalability – together with some tips on how to

  [Read more...]
MySQL Cluster 7.1.13 Released
Employee +3 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.13 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.13 (compared to 7.1.10) can be found in the official MySQL Cluster documentation for Cluster 7.1.13, 7.1.12 & 7.1.11.

Getting started with Cluster/J - index search and table scans
+2 Vote Up -0Vote Down
This post follows the previous post, so set up the environment as described there.
In this example we will perform a full table scan (select * from my_data2) and an index scan (select * from my_data2 where userid=1).

The complete code is here from Severalnines.

Performing a full table scan (no search criteria)
Make sure you have records in the table my_data2.
To perform reads by primary key, we can just use Session::find(..), but here we will do a full table scan.
QueryBuilder qb = s.getQueryBuilder();

/*
* Run the query:
*/
List resultList = query.getResultList();
int count=0;













  [Read more...]
Getting started with Cluster/J - inserts (combined PK)
+3 Vote Up -0Vote Down
This post follows the previous post, so set up the environment as described there.
In this example we will have a slightly different table with a combined PK.
The complete code is here.

Create the table

The first thing we should do is to create the table we need for this example:
CREATE TABLE `my_data2` (
`userid` bigint(20) NOT NULL DEFAULT '0',
`friendid` bigint(20) NOT NULL DEFAULT '0',
`data` varbinary(255) DEFAULT NULL,
`last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`userid`,`friendid`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
/*!50100 PARTITION BY KEY













  [Read more...]
Getting started with Cluster/J - inserts
+1 Vote Up -0Vote Down
Cluster/J is a the Java direct API to MySQL Cluster which means it bypasses the MySQL Server and executes requests directly on the data nodes of MySQL Cluster. This gives very good performance (typically >2x faster than SQL) and low latency.

In this blog I will present how to get started and how to do simple lookups.

The complete source code (actually a bit extended to show batching) for this example can be found at Severalnines (here). The code you will see below is just snippets.

Environment

To start with you need MySQL Cluster up and running.
For development on localhost then you can get a sandbox from Severalnines.
If you want to have a









  [Read more...]
High Availability Solutions – part for the MySQL On Windows Forum
Employee +7 Vote Up -0Vote Down

STOP PRESS: the recording of this forum is now available for replay.

On March 16th, we’re holding an on-line forum to discuss MySQL on Windows – I’ll be handling the High Availability session (includes MySQL replication and MySQL Cluster). The event runs from 9 am Pacific Time until 12:00 pm; the HA session is schedules for 11:00 Pacific and runs for half an hour.

  [Read more...]
Web and Telco mode Cluster Configuration
+3 Vote Up -0Vote Down
The Core Scripts (aka Configurator) for MySQL Cluster has now been updated with a new feature that allows you to tune cluster for a particular workload.
Currently there are two types of workloads supported:
  • Web
  • Telco/Realtime
The Web workload is suitable for applications:
  • with long running transactions (scans, joins and/or large updates)
  • reading and especially writing of large chunks (BLOBs) of data where an "innodb" like behavior is wanted.
The Telco workload is suitable for realtime



  [Read more...]
Cluster/J - Document-oriented approach on MySQL Cluster
+2 Vote Up -0Vote Down
In a project Severalnines is engaged in, we are developing a realtime application based on Cluster/J. To start with, I must say cluster/j is fantastic and so far I am very happy with it and beaten our expectations big time. It is quite new however and we stumbled on a couple of issues, but those were fixed very fast by the Cluster/J developers. The bugs we encountered were:
Both which were worked around, and really we never did need to have a binary or a varbinary as the PK, we used a

Performance is great - we have two data nodes (nehalem, 32GB RAM, 146GB SAS 10K disk, 2x4 core 2.4GHz (E5620) ) and two application hosts (same spec, less RAM as data



  [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.1.9 binaries released
Employee +3 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.1.9 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.9 (compared to 7.1.8) can be found in the official MySQL Cluster documentation. In addition, there is a great BLOG posting from Johan Anderson explaining how to use the new table added to ndbinfo to tune DiskPageBufferMemory when storing tables on disk.

Monitoring MySQL Cluster with MySQL Enterprise Monitor
Employee +8 Vote Up -0Vote Down

MySQL Enterprise Monitor with MySQL Cluster

A few months ago, I posted a walkthrough of how to extend MySQL Enterprise Monitor in order to monitor MySQL Cluster. The great news is that as of MySQL Enterprise Monitor 2.3 (available from Oracle E-Delivery since 1st November) this functionality is included in the core product and so there is no need to add the extra features in manually. Of course, that post might still be of interest if you want to further extend MySQL Enterprise Monitor.

This

  [Read more...]
MySQL Cluster Demo from Oracle OpenWorld
Employee +4 Vote Up -1Vote Down

If you weren’t able to attend Oracle OpenWorld or didn’t get chance to  visit the MySQL demo booths then you can watch a recording of the demo here. The video gives a brief description of MySQL Cluster and then dives into a series of demos showing MySQL Cluster’s ability to cope with a number of events without losing service – including node failure, on-line upgrades and on-line horizontal scaling.

To view a higher quality version click here.

MySQL Cluster 7.1.8 binaries released
Employee +3 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.1.8 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.8 (compared to 7.1.5) can be found in the official MySQL Cluster documentation.

MySQL Cluster - Performance (UPDATE on PK) - >120K tx/sec
+7 Vote Up -0Vote Down
This post follows on the previous post on SELECT performance. In this post I want to show three things:
  • How many single row UPDATEs per second you can do on on a Cluster with two data nodes (updating 64B data by the PRIMARY KEY, no batching)
  • Show how MySQL Cluster scales with threads and mysql servers
  • How ndb_cluster_connection_pool affects performance
  • Next post will be what happens to INSERTs.

    Setup
    • two data nodes
    • one to four mysql servers
    • interconnected with Gig-E (single NIC)
    deployed on six computers (of varying quality, but not really modern, see below). www.severalnines.com/bencher was co-located with each mysql





      [Read more...]
    MySQL Cluster - Performance (SELECT on PK)
    +6 Vote Up -0Vote Down
    In this post I want to show three things:
  • How many single row SELECTs per second (on the PRIMARY KEY, no batching) you can do on on a Cluster with two data nodes
  • Show how MySQL Cluster scales with threads and mysql servers
  • How ndb_cluster_connection_pool affects performance
  • Next post will be what happens to INSERTs, and then UPDATEs.

    Setup
    • two data nodes
    • one to four mysql servers
    • interconnected with Gig-E (single NIC)
    deployed on six computers (of varying quality, see below). www.severalnines.com/bencher was co-located with each mysql servers to drive the load. The reads were a PK SELECT like:

    SELECT data1,data2 FROM t1 WHERE id=[random];
    data1 and data2 are each 256B, so in total 512B was read. There was 1M







      [Read more...]
    MySQL Cluster session from Oracle OpenWorld – replay is available.
    Employee +3 Vote Up -0Vote Down

    As part of “MySQL Sunday” at this year’s Oracle Open World, Mat Keep and I  presented on the MySQL Cluster architecture and the latest features. If you weren’t able to attend then you can watch/listen to the replay here.

    MySQL Cluster documentation on iPhone/iPad
    Employee +6 Vote Up -0Vote Down

    MySQL Cluster in iBooks

    MySQL documentation has now been made available in ePub format (fetch the MySQL Cluster versions from http://dev.mysql.com/doc/index-cluster.html ). This format is intended for various book readers.

    I’ve tried it on 2 iPhone applications; Apple’s iBooks and the iPhone version of Stanza. The documents render well in both applications but as with most reference books you get the best results if you reduce the font size so that you get more on the screen at once.

    With both applications, you can add the books through iTunes but Stanza also has the advantage that if you browse to the document

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

    The binary version for MySQL Cluster 7.1.5 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank)

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

    Upcoming webinar: MySQL Cluster deployment best practices
    Employee +4 Vote Up -0Vote Down

    On Wednesday 25 August, Johan Anderson and Mat keep will be presenting a free webinar on the best practices for deploying MySQL Cluster. If you’d like to attend then just register here (http://www.mysql.com/news-and-events/web-seminars/display-559.html" target="_blank).

    Johan has years of MySQL Cluster professional services experience – and so if you’re interested in deploying a product ready MySQL Cluster database then this is a must-view session. Even if you can’t make it live, register anyway and you’ll be sent a link to the recording and charts afterwards.

    Content

    An invaluable session for those who are about to, or who already have, deployed MySQL Cluster. Delivered by the lead MySQL Cluster professional services consultant in Oracle, this session will present best practices on

      [Read more...]
    Install, configure and run MySQL Cluster – demo video
    Employee +8 Vote Up -0Vote Down

    There is a new video available: Demonstration of installing, configuring and running MySQL Cluster (LINUX) (http://www.mysql.com/products/database/cluster/cluster_install_demo_linux.html" target="_blank) to accompany the MySQL Cluster Quick Start guides (http://www.mysql.com/products/database/cluster/get-started.html#quickstart" target="_blank). The Flash video video lasts for about 7 minutes.

    If you aren’t able to view Flash on your device then a (poorer quality) version is included here – watch the Flash version (http://www.mysql.com/products/database/cluster/cluster_install_demo_linux.html" target="_blank) if you’re able to!

    MySQL Cluster presentation at Oracle Open World 2010
    Employee +4 Vote Up -0Vote Down

    As part of “MySQL Sunday” at this year’s Oracle Open World, Mat Keep and I will be presenting on the latest MySQL Cluster features. We’ll be presenting at 15:30 (Pacific Time) on 19th September (the event starts with a key note at 12:30).

    If you’re attending Oracle Open World then please indicate that you’d like to attend the MySQL Sunday when you register. If you aren’t planning to go to Oracle Open World but will be in the San Francisco area then buying a Discover pass (only $50 if you register by 16 July) will get you into the MySQL Sunday sessions. Register

      [Read more...]
    Breakfast seminar on what’s new with MySQL – London
    Employee +2 Vote Up -0Vote Down

    If you’re in London on Thursday 24th June then there’s a great chance to find out what’s new in MySQL.

    Join us for an Oracle MySQL Breakfast Seminar to better understand Oracle’s MySQL strategy and what’s new with MySQL!
    Agenda:
    09:00 a.m.    Welcome Coffee/Tea
    09:30 a.m.    Oracle’s MySQL Strategy
    10:00 a.m.    What’s New – The MySQL Server & MySQL Cluster
    10.45 a.m.    Coffee/Tea Break
    11:00 a.m.    What’s New – MySQL Enterprise & MySQL Workbench
    11:45 a.m.    Q&A
    12:00 noon    End of the Breakfast Seminar

    Cost?
    None, it’s a free event! But places are









      [Read more...]
    Showing entries 1 to 30 of 46 Next 16 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.