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 70 Next 30 Older Entries

Displaying posts with tag: MySQL Cluster CGE (reset)

MySQL Cluster Asynchronous Replication – conflict detection & resolution
Employee +3 Vote Up -0Vote Down

I was rooting through past blog entries and I stumbled accross a draft post on setting up multi-master (update anywhere) asynchronous replication for MySQL Cluster. The post never quite got finished and published and while the material is now 4 years old it may still be helpfull to some and so I’m posting it now. Note that a lot has happened with MySQL Cluster in the last 4 years and in this area, the most notable change has been the Enhanced conflict resolution with MySQL Cluster active-active replication feature introduced in MySQL Cluster 7.2 and if you’re only dealing with a pair of Clusters, that’s your best option as it removed the need for you

  [Read more...]
MySQL Cluster 7.3.2 is released on E-delivery
Employee +0 Vote Up -0Vote Down

The binary version for MySQL Cluster 7.3.2 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or Oracle’s Software Delivery Cloud for the commercial version.

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

MySQL Cluster 7.3 is now Generally Available – an overview
Employee +6 Vote Up -0Vote Down

MySQL Cluster 7.3 has now been declared GA! This means that you can deploy it in your live systems and get support from Oracle.

This post briefly describes the main new features in the release; for a deeper dive, refer to the What’s new in MySQL Cluster 7.3 white paper (http://www.mysql.com/why-mysql/white-papers/mysql-cluster-new-features-whitepaper/" target="New features in MySQL Cluster 7.3) and the more specialised blog posts that you’ll find links to from this post.

I’ll also be giving more details in the MySQL Cluster 7.3 Webinar

  [Read more...]
Foreign Keys in MySQL Cluster
Employee +13 Vote Up -0Vote Down

Foreign Key constraints between tables

The newly announced GA of MySQL Cluster 7.3 (7.3.2) builds upon second DMR (7.3.1 m2) released earlier in the year which added Foreign Keys to MySQL Cluster. Foreign Keys is a feature requested by many, many people and has often been cited as the reason for not being able to replace InnoDB with MySQL Cluster when they needed the extra availability or scalability.

Note that this post is an up-version of the original – and was first published with the 7.3 labs release in June 2012.

What’s a Foreign Key

The majority of readers who are already

  [Read more...]
“MySQL & Friends devroom” at FOSDEM 2013
Employee +3 Vote Up -0Vote Down

FOSDEM 2013

The Free and Open source Software Developers’ European Meeting (FOSDEM) is a two-day event organized by volunteers to promote the widespread use of Free and Open Source software. As in previous years, there is a dedicated stream of MySQL Sessions. On Saturday (2nd Feb) evening there’s a MySQL community dinner and then we’ve a packed program from 9:15 through 17:30 on Sunday (3rd Feb).

FOSDEM 2013 is a free event and there’s no requirement to pre-register – just get

  [Read more...]
MySQL Cluster Manager 1.2 – using the new features
Employee +4 Vote Up -1Vote Down

Oracle have just announced that MySQL Cluster Manager 1.2 is Generally Available. For anyone not familiar with MySQL Cluster Manager – it’s a command-line management tool that makes it simpler and safer to manage your MySQL Cluster deployment – use it to create, configure, start, stop, upgrade…. your cluster.

So what has changed since MCM 1.1 was released?

The first thing is that a lot of work has happened under the covers and it’s now faster, more robust and

  [Read more...]
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.2.7 released
Employee +4 Vote Up -0Vote Down

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

MySQL Cluster : Delivering Breakthrough Performance (upcoming webinar)
Employee +4 Vote Up -1Vote Down

MySQL Cluster partitioning key

I’ll be presenting a webinar covering MySQL Cluster performance on Thursday, July 26. As always, the webinar will be free but you’ll need to register here (http://www.mysql.com/news-and-events/web-seminars/display-719.html" target="_blank) – you’ll then also receive a link to the charts and a recording of the session after the event.

The

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

Enhanced conflict resolution with MySQL Cluster active-active replication
Employee +4 Vote Up -0Vote Down

Detecting conflicts

Part of the latest MySQL Cluster Development Milestone Release (MySQL Cluster 7.2.1 – select the “Development Release” tab at http://dev.mysql.com/downloads/cluster/#downloads) is a couple of enhancements to the conflict detection and resolution mechanism for active-active (multi-master) replication. While MySQL Cluster has had conflict detection for years it has now been made much more complete and a lot easier to

  [Read more...]
MySQL Cluster material from Oracle Open World 2011
Employee +3 Vote Up -0Vote Down

For those people that weren’t able to attend the MySQL Cluster demo or sessions at this year’s Oracle Open World (or even for those that did) and would like copies of the material, links are provided here.

  [Read more...]
My sessions at Oracle OpenWorld 2011
Employee +6 Vote Up -0Vote Down

Slight adjustment to some of the times + added the MySQL community reception (read  vodka!). Oracle OpenWorld (San Francisco) starts on Sunday 2nd October (including some MySQL community sessions) through Thursday 6th October. MySQL has a lot of sessions this year as well as 3 demo booths.

This year I’m going to be involved in 3 public sessions – if you’re attending, please come along and say hello!

  • Getting the Most Out of MySQL on Windows – 13:15 on Tuesday (Marriott Marquis – Golden Gate C2)
  • Building Highly Available and Scalable Real-Time
  [Read more...]
MySQL Cluster 7.1.15 released
Employee +6 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.15 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.15 (compared to 7.1.13) can be found in the official MySQL Cluster documentation for Cluster 7.1.14 & 7.1.15.

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.

Almost here – MySQL Cluster at Collaborate 11
Employee +5 Vote Up -0Vote Down


A quick reminder that MySQL is well represented at the Oracle Collaborate conference which starts in Orlando on Sunday.

For those not familiar with Collaborate, it’s the big community conference for Oracle users – this year it’s in Orlando from April 10th through 14th (I’ve just re-checked the weather forecast, 31 Celsius vs. -18 at the last conference I presented at – OOW Beijing in December – what a difference 4 months and 8,000 miles make!).

I’ll be presenting on MySQL Cluster in a session called “


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

MySQL Cluster 6.3.39 binaries released
Employee +2 Vote Up -0Vote Down

The binary version for MySQL Cluster 6.3.39 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 6.3.39 (compared to 6.3.38) can be found in the official MySQL Cluster documentation.

Glimpse of the future – massively improved JOIN performance for MySQL Cluster
Employee +9 Vote Up -0Vote Down

MySQL Cluster Push-Down Joins

A great chance to find out about the “SPJ” project that’s under way to improve the performance of complex table JOINs. A free webinar has been scheduled for Thursday, November 04 at 09:00 Pacific time (16:00 UK; 17:00 Central European Time) – just register for the webinar at mysql.com (http://www.mysql.com/news-and-events/web-seminars/display-583.html" target="_blank). Even if you can’t attend, by registering you’ll get an email telling you where to watch the replay shortly after the webinar.

MySQL Cluster performance has always been extremely high and scalable when the work load is primarily primary key

  [Read more...]
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 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...]
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...]
How can a database be in-memory and durable at the same time?
Employee +12 Vote Up -0Vote Down

There is often confusion as to how it can be claimed that MySQL Cluster delivers in-memory performance while also providing durability (the “D” in ACID). This post explains how that can be achieved as well as how to mix and match scalability, High Availability and Durability.

MySQL Cluster deployment options

As an aside, the user can specify specific MySQL Cluster tables or columns to be stored on disk rather than in memory – this is a solution for extra capacity but you don’t need to take this performance hit just to have the data persisted to disk. This post focuses on the in-memory approach.

There is a great deal of flexibility in

  [Read more...]
Free webinar – Scaling web apps with MySQL (an alternative to the MEMORY storage engine)
Employee +6 Vote Up -0Vote Down

Mat Keep and I will be presenting this free webinar on Wednesday 14 July.

The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. As these services evolve to support more users, so the scalability and availability demands can start to exceed the capabilities of the MEMORY storage engine.

The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands. MySQL Cluster can be configured and run in the same way as the MEMORY storage

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