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 91 to 120 of 392 Next 30 Older Entries

Displaying posts with tag: MySQL Cluster (reset)

MySQL Cluster 7.2: Over 8x Higher Performance than Cluster 7.1
Employee_Team +2 Vote Up -0Vote Down
0 0 1 893 5092 Homework 42 11 5974 14.0 Normal 0 false false false EN-US JA X-NONE

Summary

The scalability enhancements delivered by extensions to multi-threaded data nodes enables MySQL Cluster 7.2 (http://mysql.com/products/cluster/) to deliver over 8x higher

  [Read more...]
See you at MySQL Innovation Day!
Employee +4 Vote Up -0Vote Down

I’m excited to attend the MySQL Innovation Day at Oracle headquarters in Redwood Shores next Tuesday. There are some great sessions planned on MySQL advances, including:

  • InnoDB online operations
  • Global transaction IDs for replication and failover
  • NoSQL interfaces to InnoDB and NDB
  • PERFORMANCE_SCHEMA improvements
  • Optimizer enhancements

This is a great opportunity for MySQL users to get details straight from MySQL developers on upcoming features.  While the focus is entirely on what is being done in Engineering to drive MySQL forward, I’ll be around to chat about MySQL Support at the community reception in the afternoon.  If you’re a MySQL Support user, or just interested in learning more about the value MySQL Support can offer

  [Read more...]
MySQL Cluster Manager 1.1.6 released
Employee +3 Vote Up -1Vote Down

MySQL Cluster Manager 1.1.6 is now available to download from My Oracle Support.

Details on the changes can will be added to the MySQL Cluster Manager documentation . Please give it a try and let me know what you think.

Note that if you’re not a commercial user then you can still download MySQL Cluster Manager 1.1.5 from the Oracle Software Delivery Cloud and try it out for free. Documentation is available here.

MySQL 5.6 Replication – webinar replay
Employee +4 Vote Up -0Vote Down

MySQL 5.6 Replication - Global Transaction IDs

On Wednesday (16th May 2012), Mat Keep and I presented on the new replication features that are previewed as part of the latest MySQL 5.6 Development Release.

The replay for that webinar (together with the chart deck) is now available from here (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-711.html" target="_blank).

In addition, there were a huge number of great questions raised and we had a couple of  key engineers answering them on-line –

  [Read more...]
Performance Testing of MySQL Cluster: The flexAsynch Benchmark
Employee_Team +4 Vote Up -0Vote Down
0 0 1 509 2903 Homework 24 6 3406 14.0 Normal 0 false false false EN-US JA X-NONE

Following the release of MySQL Cluster 7.2 (http://mysql.com/products/cluster/), the Engineering has been busy publishing a range of new performance benchmarks

  [Read more...]
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.2.6 is available for download
Employee +5 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.2.6 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.2.6 (compared to 7.2.5) are available from the 7.2.6 Change log.

Upcoming conferences to learn more about MySQL Cluster & Replication
Employee +5 Vote Up -0Vote Down

There are a couple of conferences coming up where you can expect to learn about the latest developments in MySQL Cluster and MySQL Replication (as well as what else is happening in MySQL 5.6).

The first is the Oracle MySQL Innovation Day which is being held in Oracle HQ at Redwood Shores. This is an all-day event on 5th June – unfortunately I won’t be able to attend this one but there will be lots of great Cluster and replication sessions. If you can’t make it out to California then there will be a live Webcast. You can register here to attend in person or join the

  [Read more...]
On-line add-node with MCM; a more complex example
Employee +4 Vote Up -0Vote Down

I’ve previously provided an example of using MySQL Cluster Manager to add nodes to a running MySQL Cluster deployment but I’ve since received a number of questions around how to do this in more complex circumstances (for example when ending up with more than 1 MySQL Server on a single host where each mysqld process should use a different port). The purpose of this post is to work through one of these more complex scenarios.

The starting point is an

  [Read more...]
Fun with Cluster and Locking
+3 Vote Up -0Vote Down

I've been dealing with MySQL Cluster in one way or another since around 2005 or so (back in the MySQL 4.1 days) but it is still full of "funny" surprises. This post is a collection of different locking related issue i ran into during the previous weeks that i had not been aware of up to now (or simply may have forgotten over time)

== Unique hash indexes lock exclusively ==

This is the one that regular users are most likely to run into: in general row logs in MySQL Cluster distinguish between reads and writes so that writers can block other writers, but not readers and readers from other transactions always see the last committed row value (Cluster currently only supports the READ COMMITTED isolation level). As soon as you have a secondary unique index in addition to a primary key things are different though. Internally a unique index that is not

  [Read more...]
NoSQL and MySQL – free webinar, replay now available
Employee +3 Vote Up -0Vote Down

Schema-free NoSQL Data

Update – the webinar replay is now available from here (https://www.mysql.com/news-and-events/on-demand-webinars/display-od-695.html" target="_blank).

On Thursday, I’ll be presenting a webinar on NoSQL (of course with a MySQL twist!) – as always it’s free to attend but you need to register here in advance (http://www.mysql.com/news-and-events/web-seminars/display-695.html" target="_blank). Even if you can’t attend, it’s worth registering as you’ll be sent a link to the replay and the charts. The session will introduce the concepts and motivations

  [Read more...]
Guide to MySQL & NoSQL, Webinar Q&A
Employee_Team +3 Vote Up -0Vote Down
0 0 1 959 5469 Homework 45 12 6416 14.0 Normal 0 false false false EN-US JA X-NONE

Yesterday we ran a webinar discussing the demands of next generation web services and how blending the best of relational and NoSQL technologies enables developers and architects to deliver the agility, performance and

  [Read more...]
MySQL Cluster 7.2.5 available for download
Employee +5 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.2.5 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.2.5 (compared to 7.2.4) will appear in the 7.2.5 Change log.

MySQL Cluster 7.2 & Future Webcasts
Employee +2 Vote Up -0Vote Down

Check out this MySQL Cluster 7.2 Demo

From the Cluster 7.2 Demo

if you have missed any of the new features.

And upcoming MySQL Webcasts on Cluster, MySQL on Windows, MySQL Enterprise Edition, NoSQL access to MySQL, and Building High Performance and High Traffic PHP applications are available for registration!



  [Read more...]
MySQL Cluster Quick Start Script
Employee +6 Vote Up -0Vote Down

Many Windows users first looking to experiment with MySQL Cluster (http://www.mysql.com/products/cluster/" target="_blank) may find the process of getting everything up and running daunting.  Fortunately, there’s MySQL Cluster Manager (MCM) which can help jump-start that process – and that’s all many people will need.

In my work, I frequently have to install specific version of MySQL Server or Cluster to validate behavior of a handful of commands, and MCM is a bit overkill.  I have a couple of tricks that I use to quickly set up MySQL Cluster on Windows environments:

  • I always use the .ZIP packages
  • I have a set cluster data directory (in my case, D:\cluster-data)
  • I have a standard Cluster configuration file (config.ini) that I
  •   [Read more...]
    Who will win a MySQL Cluster 7.2 shirt today??
    Employee +4 Vote Up -0Vote Down

    Someone will win a limited edition and very rare MySQL Cluster 7.2 shirt today

    Someone will win this shirt at the North Texas MySQL User Group meeting on Monday March 12th

    at the North Texas MySQL Users Group Meeting. Many other prizes including thumb drives, buttons, and lanyards plus we will have pizza. Please RSVP to make sure we get enough food!

    The presentation will be on MySQL 5.6 + 20 MySQL Tips in 20 Minutes!

    Date: Monday, March 12, 2012 Remind Me
    Time: 4:45 PM – 7:00 PM
    Oracle Corporation
    6031 Connection Drive
    Room



      [Read more...]
    Getting the best performance out of MySQL Cluster – White Paper
    Employee +7 Vote Up -0Vote Down

    There are a number of resources available to help get you up and running with MySQL Cluster so that you can start experimenting – including the quick start guides from the download page (http://www.mysql.com/downloads/cluster/) but what happens when you get further down the line and need to get the best performance from your Cluster? One useful source is the Guide to Optimizing Performance of the MySQL Cluster Database (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_performance.php) which covers how best to configure MySQL Cluster as well as what you should be doing with your application and schema to get the best performance.

    Any feedback on this white paper would be greatly appreciated – whether it be a recommendation that you found gave good results, something that didn’t work or a killer tip that we missed out.

    MySQL Scaling breakfast seminar – London, April 25th
    Employee +2 Vote Up -0Vote Down

    I’ll be presenting on/demoing MySQL Cluster 7.2 at this free breakfast seminar in Oracle’s London office on 25th April – starting with coffee at 9:00 and ending with lunch at 13:00 (quite a generous take on

      [Read more...]
    Connector/J extension points – Load Balancing Strategies
    Employee +2 Vote Up -0Vote Down

    A fourth and final Connector/J extension point I covered in my JavaOne and Silicon Valley Code Camp presentations is load-balancing strategies.  This exists in order to allow you to define behavior for balancing load across multiple back-end MySQL server instances.  MySQL Connector/J’s load-balancing implementation is a simple internal connection pool.  What appears to your application as a single Connection object can actually have multiple physical connections to MySQL servers underneath (one per configured host/port pair).  At specific points, Connector/J will re-balance and choose another host to

      [Read more...]
    Where Would I Use MySQL Cluster?
    Employee_Team +0 Vote Up -0Vote Down
    0 0 1 910 5191 Homework 43 12 6089 14.0 Normal 0 false false false EN-US JA X-NONE

    0 0 1 881 5025 Homework 41 11 5895 14.0 Normal 0 false false false EN-US JA X-NONE

      [Read more...]
    Deploy MySQL Cluster 7.2 GA in 288 seconds
    +3 Vote Up -0Vote Down
    It seems that our friends at Oracle have been pretty busy with the GA release of MySQL Cluster 7.2.

    This is not just old wine in new bottles.

    While it may be a dot release, it does appear to be a more significant step forward than a dot release would imply.

    First off, we are very excited to announce that the Severalnines Cluster Configurator now includes support for 7.2 GA.

    As the title of this blog suggests, it is possible, as we have experienced, to deploy 7.2 GA in 288 seconds, i.e. just a few minutes. This was done on m1.large instances on Amazon. We have published a quick how-to deployment guide for Amazon here:







      [Read more...]
    MySQL Cluster 7.2 GA Released
    +0 Vote Up -0Vote Down
    MySQL Cluster 7.2 is the best release to date, enabling projects and applications to benefit from web-scalability with carrier-grade availability and developer agility.


    Oracle is delighted to announce the immediate availability of the production-ready, GA release of MySQL Cluster 7.2, available for download under the GPL, and as part of the commercial MySQL Cluster Carrier Grade Edition, including management tools, product certifications and 24x7 global support.



    70x Higher JOIN Performance, NoSQL Key-Value API & Cross Data Center Sharding with Synchronous






      [Read more...]
    1 Billion queries per minute and much more – free webinar on MySQL Cluster 7.2 GA
    Employee +2 Vote Up -0Vote Down

    1 Billion queries per minute with MySQL Cluster

    Oracle announced the General Availability of MySQL Cluster 7.2 today. Join this live webinar to learn about what’s new in the production-ready, GA release of MySQL Cluster 7.2, enabling the latest generation of web and telecoms applications to take advantage of high write scalability, SQL and NoSQL interfaces and 99.999% availability, including:

    • Performance enhancements delivering 1 billion queries per minute, using just 8 data
      [Read more...]
    MySQL Cluster 7.2 GA Released, Delivers 1 BILLION Queries per Minute
    Employee_Team +0 Vote Up -0Vote Down
    0 0 1 14 83 Homework 1 1 96 14.0 Normal 0 false false false EN-GB JA X-NONE

    70x Higher JOIN Performance, NoSQL Key-Value API & Cross Data Center Sharding with Synchronous Replication 

    0 0 1 535 3052 Homework 25 7 3580 14.0 Normal 0 false  [Read more...]
    1 Billion Queries Per Minute – MySQL Cluster 7.2 is GA!
    Employee +10 Vote Up -0Vote Down

    1 Billion queries per minute with MySQL Cluster

    Oracle have just announced that MySQL Cluster 7.2 is now GA and available for production deployments.

    Amongst the highlights for the release are:

    • Performance enhancements delivering 1 billion queries per minute, using just 8 data nodes
    • 70x higher JOIN performance with Adaptive Query Localization, enabling real-time analytics across live data sets
    • New NoSQL API via Memcached, creating a
      [Read more...]
    MySQL Cluster Manager 1.1.4 Released – includes support for MySQL Cluster 7.2
    Employee +5 Vote Up -0Vote Down

    MySQL Cluster Manager 1.1. is now available to download and try from Oracle E-Delivery (select “MySQL Database” as the product pack).

    There’s lots of good stuff gone in under the covers as part of this release, with some of the highlights being:

    • Support for MySQL Cluster 7.2
    • Configuration of MySQL Server parameters
    • Verbose option added to commands for extra info on what’s going on
    • Faster Cluster rolling
      [Read more...]
    Scalable, persistent, HA NoSQL Memcache storage using MySQL Cluster
    Employee +15 Vote Up -0Vote Down

    Memcached API with Cluster Data Nodes

    The native Memcached API for MySQL Cluster is now GA as part of MySQL Cluster 7.2

    This post was first published in April 2011 when the first trial version of the Memcached API for MySQL Cluster was released; it was then up-versioned for the second MySQL Cluster 7.2 Development Milestone Release in October 2011. I’ve now refreshed the post based on the GA of MySQL Cluster 7.2 which includes the completed Memcache API.

    There are a number of attributes

      [Read more...]
    70x Faster Joins with AQL now GA with MySQL Cluster 7.2
    Employee +11 Vote Up -0Vote Down

    70x faster joins with AQL

    The new GA MySQL Cluster 7.2 Release (7.2.4) just announced by Oracle includes 2 new features which when combined can improve the performance of joins by a factor of 70x (or even higher). The first enhancement is that MySQL Cluster now provides the MySQL Server with better information on the available indexes which allows the MySQL optimizer to automatically produce better query execution plans. Previously it was up to the user to manually provide hints to the optimizer. The second new feature is Adaptive Query Localization which allows the work of

      [Read more...]
    MySQL Cluster by Ralf Gebhardt
    +0 Vote Up -0Vote Down

    Ralf Gebhardt of SkySQL.

    Cluster: shared nothing architecture (no single point of failure), synchronous replication between nodes, ACID transactions, row level locking. In-memory storage (some data can be stored on disk, but indexes must be in-memory). Checkpointing to disk for durability. It supports two types of indexes – ordered T-trees, unique hash indexes. Online operations like adding node groups, software upgrades, table alterations. Quick standard architecture diagram displayed about MySQL Cluster.

    Network partitioning protocol is designed to avoid a split brain scenario. Is there at least one node from each node group? If not then this part cannot continue – graceful shutdown. Are all nodes present from any node group? If so, then this is the only viable cluster – continue to operate. Ask the

      [Read more...]
    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.

    Previous 30 Newer Entries Showing entries 91 to 120 of 392 Next 30 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.