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

Displaying posts with tag: MySQL Cluster (reset)

Load-balanced JDBC Tip for GlassFish Deployments
Employee +3 Vote Up -0Vote Down

Having supported a number of successful load-balanced JDBC applications using MySQL Cluster and MySQL Connector/J over the years, I’ve found a few problems that are unique to specific Java app servers.  A recent customer inquiry reminded me of a GlassFish-specific issue, and the Connector/J connection property we introduced to help solve it.  I thought it might be useful to document this here for any GlassFish users looking to deploy a load-balanced JDBC application with MySQL (Cluster or multi-master replication).

If you’re entirely new to the load-balancing functionality in MySQL Connector/J, you may want to review some earlier

  [Read more...]
MySQL Cluster: Troubleshooting Error 157 / 4009 Cluster Failure
+1 Vote Up -0Vote Down
0 0 1 519 2962 Severalnines AB 24 6 3475 14.0 Normal 0 false false false false EN-US JA X-NONE
Suddenly your application starts throwing "error 157" and performance degrades or is non-existing. It is easy to panic then and try all sorts of actions to get past the problem. We have seen several users doing:
  • rolling restart
  • stop cluster / start cluster
because they also see this in the error logs:120828 13:15:11 [Warning] NDB: Could not acquire global schema
  [Read more...]
MySQL Cluster Performance Best Practices: Q & A
Employee_Team +4 Vote Up -0Vote Down

With its distributed, shared-nothing, real-time design, MySQL Cluster (http://www.mysql.com/products/cluster/) has attracted a lot of attention from developers who need to scale both read and write traffic with ultra-low latency and fault-tolerance, using commodity hardware. With many proven deployments (http://www.mysql.com/customers/cluster/) in web, gaming, telecoms and mobile use-cases, MySQL Cluster is certainly able to meet these sorts of requirements.

But, as a distributed database, developers do need to think a little differently about data access patterns along with schema and query optimisations in order to get the best possible performance.

Sharing best practices developed by working with MySQL Cluster's largest users, we recently ran a Performance Essentials webinar

  [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 Powers El Chavo from Playful Play, Latin America’s Most Popular Facebook Game
Employee_Team +2 Vote Up -0Vote Down
0 0 1 1176 6705 Homework 55 15 7866 14.0 Normal 0 false false false EN-GB JA X-NONE

Introduction

Attracting over 2m subscribers in just 4 months and growing by 30,000 new users per day, Playful Play needed a database that was able to

  [Read more...]
Optimizing Performance of the MySQL Cluster Database – White Paper update
Employee +3 Vote Up -0Vote Down

Engineering threads within a Data Node

A new version of the white paper “Guide to Optimizing Performance of the MySQL Cluster Database (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_performance.php" target="_blank)” has been released; download it here (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_performance.php" target="_blank).

This paper steps you through:

  • Identifying if your application is a good fit for MySQL Cluster
  • Measuring performance and identifying problem performance
  [Read more...]
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...]
How to Stop Playing “Hop and Seek”: MySQL Cluster and TokuDB, Part 2
+1 Vote Up -0Vote Down

In my last post, I wrote that I observed many similarities between TokuDB and MySQL Cluster. Many features that benefit TokuDB also benefit MySQL Cluster, and vice versa, with Hot Column Addition and Deletion (HCAD) being an example. Over my next few posts, I expand on some more of these possibly unexpected similarities.

Today I want to focus on optimizer support for clustering keys. Both MySQL Cluster and TokuDB can benefit from the MySQL optimizer supporting clustering keys. For TokuDB, the

  [Read more...]
NoSQL Java API for MySQL Cluster: Questions & Answers
Employee_Team +3 Vote Up -0Vote Down

The MySQL Cluster engineering team recently ran a live webinar, available now on-demand (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-716.html) demonstrating the ClusterJ and ClusterJPA NoSQL APIs for MySQL Cluster (http://www.mysql.com/products/cluster/), and how these can be used in building real-time, high scale Java-based services that require continuous availability.

Attendees asked a number of great questions during the webinar, and I thought it would be useful to share those here, so others are also able to learn more about the Java NoSQL APIs.

First, a little bit about why we developed these APIs and why they are interesting to Java developers.

ClusterJ and Cluster JPA

ClusterJ is a Java interface to MySQL Cluster that provides either a static or dynamic domain object model, similar to the data model used

  [Read more...]
MySQL News
+0 Vote Up -0Vote Down

These past couple of weeks have been quite intense and generated a lot of news.

What stood out to me was the escalation in the race between MySQL/Oracle and MariaDB to be better. I have to say that all of us are benefiting from this competition. I am also not fully sure that Oracle would have put in such effort if Monty and his team was not pushing so hard. Certainly, Thomas Ulin has his agenda, but Monty is doing a great job for his product and in pushing the competitor to do his best. The result is that MySQL is becoming a better product day by day.

Thanks guys!

MySQL Internals

Is it a crazy idea to use MySQL for Json and HTTP embedded? I love crazy things, and this seems crazy, but it is closer to our reality than we can imagine:

“PoC: HTTP, JSON, JavaScript, Map&Reduce built-in to MySQL

What if MySQL had an HTTP interface and would reply JSON?


  [Read more...]
SkySQL at SELF
+3 Vote Up -2Vote Down

 

The South East LinuxFest is this weekend (June 7-9) in Charlotte, North Carolina and SkySQL will be attending the conference both as a sponsor and with talks. 

read more

MySQL News – June 5
+0 Vote Up -0Vote Down

Stalls During DDLFaster DROP TABLE Courtesy of the InnoDB Team

Mark Callaghan mentioned a simple issue on DDL operation. I found the back porting interesting, but not always a possible option. I have nothing to comment on top of what was already stated there, but I’ll mention it because it is interesting to read.

Why do threads sometimes stay in ‘killed’ state in MySQL?

Customers often ask me (and I believe all MySQL DBAs can relate): “Why did that query remain in a KILL state and does not go away?”

As we know, KILLed queries remain in MySQL until a clean up takes place, given that the action

  [Read more...]
MySQL Cluster 7.3 Labs Release – Foreign Keys Are In!
Employee_Team +5 Vote Up -0Vote Down
0 0 1 1097 6254 Homework 52 14 7337 14.0 Normal 0 false false false EN-US JA X-NONE

Summary (aka TL/DR):

Support for Foreign Key constraints has been one of the most requested feature enhancements for MySQL Cluster

  [Read more...]
MySQL Cluster running on Raspberry Pi
Employee +8 Vote Up -0Vote Down

MySQL Cluster running on Raspberry Pi

I start a long weekend tonight and it’s the kids’ last day of school before their school holidays and so last night felt like the right time to play a bit. This week I received my Raspberry Pi – if you haven’t heard of it then you should take a look at the Raspberry Pi FAQ - basically it’s a ridiculously cheap ($25 or $35 if you want the top of the range model) ARM based PC that’s the size of a credit card.

A knew I had to have one to play with but what to

  [Read more...]
Configuring MySQL Cluster Data Nodes
Employee_Team +2 Vote Up -0Vote Down
0 0 1 692 3948 Homework 32 9 4631 14.0 Normal 0 false false false EN-US JA X-NONE

In my previous blog post, I discussed the enhanced performance and scalability delivered by extensions to the multi-threaded data

  [Read more...]
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...]
Previous 30 Newer Entries Showing entries 91 to 120 of 408 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.