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 61 to 90 of 392 Next 30 Older Entries

Displaying posts with tag: MySQL Cluster (reset)

MySQL Cluster 7.3 - Join This Week's Webinar to Learn What's New
Employee_Team +1 Vote Up -0Vote Down

The first Development Milestone and Early Access releases of MySQL Cluster 7.3 were announced just several weeks ago. To provide more detail and demonstrate the new features, Andrew Morgan and I will be hosting a live webinar (http://www.mysql.com/news-and-events/web-seminars/display-726.html) this coming Thursday 25th October at 0900 Pacific Time / 16.00 UTC

Even if you can't make the live webinar, it is still worth registering for the event (http://www.mysql.com/news-and-events/web-seminars/display-726.html) as you will receive a notification when the replay will be available, to view on-demand at your convenience

In the webinar, we will discuss the enhancements being previewed as part of MySQL Cluster 7.3, including:

  [Read more...]
New MySQL Cluster 7.3 Previews: Foreign Keys, NoSQL Node.js API and Auto-Tuned Clusters
Employee_Team +3 Vote Up -0Vote Down

At this weeks MySQL Connect conference, Oracle previewed an exciting new wave of developments for MySQL Cluster (http://www.mysql.com/products/cluster/), further extending its simplicity and flexibility by expanding the range of use-cases, adding new NoSQL options, and automating configuration.

What’s new:

  • Development Release 1: MySQL Cluster 7.3 with Foreign Keys
  • Early Access “Labs” Preview: MySQL Cluster NoSQL API for Node.js
  • Early Access “Labs” Preview: MySQL Cluster GUI-Based Auto-Installer

In this blog, I'll introduce you to the features being previewed.

Review the blogs listed below for more detail on each of the specific features discussed.

Save the date!: A live webinar is scheduled for Thursday 25th

  [Read more...]
MySQL Oracle Connect 2012: Day Two
+1 Vote Up -0Vote Down

Another good day today: I attended the keynotes and found them quite interesting.

I especially liked the way Twitter uses MySQL to build up a NoSQL solution. Jokes aside, I took a few notes on things I must analyze and dig in.

The introduction of the Paypal models seemed very interesting, which brought me to attend the presentation later on. It was well constructed and had some good theoretical work, but I was quite disappointed. I found the presentation incomplete and missing real numbers for the MySQL Cluster NDB setup.

I attended the presentation done by Ronald B. It was good — nothing really advanced, but it was on purpose. He was very informative and explanatory for a junior MySQL DBA, and I enjoyed his presentation for the logical approach and construction.

Ronald also highlighted that it was the content of less then a chapter of one of his books and was done on purpose to

  [Read more...]
MySQL Oracle Connect 2012: Day One
+2 Vote Up -0Vote Down

I attend five sessions today, and I think that some of them were very interesting, like the one on the Optimizer insight. It was quite informative and accurate.

Another one, done by the MySQL Cluster (NDB) group on the installer and new Javascript API interface, left me a little bit…foggy. Why? Because in my mind, one of the most important things to accomplish in NDB is the correct dimensioning of the memory, buffers, possible operation, attributes, and so on. All these things should come from the schema definition review and from the application analysis.

Now given the review analysis of the schema is still not present in the installer, I think that we missed a very important piece of information. When I raised the issue, Bernd mentioned that they were thinking of integrating that as well. It’s a good move, and I hope to see it soon. About the

  [Read more...]
MySQL Oracle Connect 2012 Keynotes
+1 Vote Up -0Vote Down

I’m excited to be here not only to catch up with old friends and ex-colleagues, but also to witness what seems to be the start of a very significant conference from MySQL.

I really enjoyed the introductions done by Edward Screven and Thomas Ulin. Edward highlighted the fact that MySQL is increasing its presence in the market and in the community. This could be thanks to the unbelievable effort done by Oracle in keeping its production cycle on target. Thomas stressed that point and gave a great description of it. He demonstrated Oracle’s main focus points, which are mainly on InnoDB, with implementation and enhancement of the internal contentions, then on Optimizer improvements and NoSQL integration.

Replication remains a pending issue from my side because if we have the global transaction ID, we still suffer from delay in replication given that parallel

  [Read more...]
MySQL now provides support for DRBD
Employee +5 Vote Up -0Vote Down

Oracle has announced that it now provides support for DRBD with MySQL – this means a single point of support for the entire MySQL/DRBD/Pacemaker/Corosync/Linux stack! As part of this, we’ve released a new white paper which steps you through everything you need to do to configure this High Availability stack (http://www.mysql.com/why-mysql/white-papers/mysql_wp_drbd.php). The white paper provides a step-by-step guide to installing, configuring, provisioning and testing the complete MySQL and DRBD stack, including:

  • MySQL Database
  • DRBD kernel module and userland utilities
  • Pacemaker and Corosync cluster messaging and management processes
  • Oracle Linux operating system

DRBD is an extremely popular way of adding a layer of High

  [Read more...]
MySQL Cluster Auto-Installer – labs release
Employee +3 Vote Up -0Vote Down

Deploying a well configured cluster has just got a lot easier! Oracle have released a new auto-installer/configurator for MySQL Cluster that makes the processes extremely simple while making sure that the cluster is well configured for your application. The installer is part of MySQL Cluster 7.3 and so is not yet GA but it can also be used on MySQL Cluster 7.2. A single command launches the web-based wizard which then steps you through configuring the cluster; to keep things even simpler, it will automatically detect the resources on your target machines and use these results together with the type of workload you specify in order to determine values for the key configuration parameters.

Tutorial Video

Before going through the detailed steps, here’s a demonstration of the

  [Read more...]
Tutorial: Getting Started with the NoSQL JavaScript / Node.js API for MySQL Cluster
Employee_Team +2 Vote Up -0Vote Down

Tutorial authored by Craig Russell and JD Duncan 

The MySQL Cluster team are working on a new NoSQL JavaScript connector for MySQL. The objectives are simplicity and high performance for JavaScript users:

- allows end-to-end JavaScript development, from the browser to the server and now to the world's most popular open source database

- native "NoSQL" access to the storage layer without going first through SQL transformations and parsing.

Node.js is a complete web platform built around JavaScript designed to deliver millions of client connections on commodity hardware. With the MySQL NoSQL Connector for JavaScript, Node.js users can easily add data access and persistence to their web, cloud, social and mobile applications.

While the initial implementation is designed to plug and play with Node.js, the actual

  [Read more...]
MySQL Connect: What to Expect From the Wondrous Land of MySQL Cluster
Employee_Team +3 Vote Up -0Vote Down

The MySQL Connect conference is only a couple of weeks away, with MySQL engineers, support teams, consultants and community aces busy putting the final touches to their talks.

There will be many exciting new announcements and sharing of best practices at the conference, covering the range of MySQL technologies.

MySQL Cluster (http://www.mysql.com/products/cluster/) will a big part of this, so I wanted to share some key sessions for those of you who plan on attending, as well as some resources for those who are not lucky enough to be able to make the trip, but who can't afford to miss the key news. Of course, this is no substitute to actually being there….and the good news is that

  [Read more...]
More GlassFish loadbalancing tips for Connector/J
Employee +1 Vote Up -0Vote Down

Almost two weeks ago, I encouraged GlassFish users who need load-balanced JDBC connections to MySQL Cluster (or master-master replicated MySQL Server) to set the loadBalanceValidateConnectionOnSwapServer property to true in order to help ensure the connection chosen at re-balance is still usable.  That advice triggered finding a bug (14563127) which will cause the following Exception message:

No operations allowed after connection closed. Connection closed after inability to pick valid new connection during fail-over.

If you implemented the loadBalanceValidateConnectionOnSwapServer property and are seeing the above error message, updating your driver to the

  [Read more...]
MySQL Cluster to InnoDB Replication Howto
+6 Vote Up -0Vote Down

In this blog post I will show you how to setup a replication from MySQL Cluster  (ndbcluster) to a regular MySQL Server (InnoDB). If you want to understand the concepts, check out part 7 of our free MySQL Cluster training.

First of all we start with a MySQL Cluster looking like this, and what we want to do is to setup replication server to the Reporting Server (InnoDB slave).

0 0 1 125 713 Severalnines AB 5 1 837 14.0 Normal 0 false false false EN-US JA X-NONE

  [Read more...]
MySQL Cluster 7.2.8 Released
Employee +2 Vote Up -0Vote Down

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

Monty’s team announces the availability of MariaDB Galera Cluster!
+6 Vote Up -0Vote Down

We’re delighted to share the news that our friends at MariaDB today announced the availability of MariaDB Galera Cluster!

We’ve been talking a good bit about MariaDB in the past few months and it’s great to see the MariaDB & Codership partnership result in today’s announcement.

read more

Learn From MySQL Support Staff at MySQL Connect!
Employee +5 Vote Up -0Vote Down

Members of the MySQL Support Team wear a number of different hats here at Oracle.  Obviously, our top priority is to provide amazing technical support that makes customers rave (http://www.mysql.com/support/quotes.html" target="_blank).  We also have a team dedicated to processing bug reports from the MySQL Community.  Some of us are active bloggers or assist on mailing lists or forums, while others find other ways to contribute to the MySQL Community.  We help out with QA and product planning, write

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


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.


  [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...]
+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...]
Previous 30 Newer Entries Showing entries 61 to 90 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.