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...]
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...]
Are you looking to expand your knowledge about MySQL and MariaDB database solutions?
Well, you’re in luck! SkySQL is introducing an exclusive collection of educational videos featuring some of the industry’s leading experts on the MySQL database and related technologies. View informative, technical talks on a variety of topics, from the experts at SkySQL, MariaDB, Calpont InfiniDB, Continuent, ScaleDB, Severalnines, Sphinx, Webyog, and others.
Included in this collection is a video of Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, as they shared their insights on current and future trends pertaining to the world’s most popular open[Read more...]
Earlier this week, Andrew Morgan wrote a piece on running MySQL Cluster on Raspberry Pi. Since the term “Cluster” is hideously overloaded, I’ll note that we’re talking about the NDB cluster storage engine here, a very specific architecture originally acquired by MySQL AB from Ericsson (telco).
Raspberry Pi is a new single-board computer based on the ARM processor series (same stuff that powers most mobile phones these days), and it can run Linux without any fuss. Interfaces include Ethernet, USB, and HDMI video, and the cost is $25-50. I’m looking[Read more...]
I had to install Percona XtraDB Cluster, I think for the first time since it was announced stable. I remembered many problems I faced with beta releases, which was understandable given they were only for a preview, but this time I hoped for significant improvements.
I have to say I am generally quite sensitive about simple problems that could/should be easily discovered and corrected. Well, it didn’t take five minutes to see a few of such problems. These minutes I spent installing the database binaries from Percona Yum repository. It turned out that was enough to see a lot of errors for no reason. Not a good thing.
[..] Installing : 1:Percona-XtraDB-Cluster-server-5.5.23-23.5.333.rhel6.x86_64 5/5 ls: cannot access /var/lib/mysql/*.err: No such file or directory ls: cannot access /var/lib/mysql/*.err: No such file or directory[Read more...]
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...]
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...]
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...]
tldr; A single MySQL Cluster prioritises Consistency in Network partition events. Asynchronously replicating MySQL Clusters prioritise Availability in Network partition events.
0 0 1 881 5025 Homework 41 11 5895 14.0 Normal 0 false false false EN-US JA X-NONE[Read more...]
While doing some routine fiddling regarding some topic I've now forgotten, I discovered that
ndb_restore was doing something quite surprising. It's been common wisdom for some time that one can use
ndb_restore -m to restore metadata into a new cluster and automatically have your data re-partitioned across the data nodes in the destination cluster. In fact, this was the recommended procedure for adding nodes to a cluster before online add node came along. Since MySQL Cluster 7.0, though,
ndb_restore hasn't behaved that way, though that change in behavior doesn't seem to be documented and most don't know that the change ever took place.
I'll go through some of the methods you can use to find information about the partitioning strategy for an NDB table, talk a bit about why
ndb_restore stopped working the way most everyone expected
70x Higher JOIN Performance, NoSQL Key-Value API & Cross Data Center Sharding with Synchronous Replication0 0 1 535 3052 Homework 25 7 3580 14.0 Normal 0 false [Read more...]
SkySQL™ today announced the immediate availability of SkySQL™ Enterprise HA, its leading 360° degrees High Availability solution for the MySQL® & MariaDB® databases.
High Availability is the #1 requested enhancement to the MySQL & MariaDB servers, even more popular than scalability and performance. And with SkySQL's expertise at hand, it is now easier than ever before for customers to achieve the level of High Availability that they want.[Read more...]