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 31 to 60 of 240 Next 30 Older Entries

Displaying posts with tag: cluster (reset)

Boost your use of MySQL Cluster with Oracle Training
Employee_Team +3 Vote Up -0Vote Down

Get the most out of your use of MySQL Cluster by attending the MySQL Cluster training course. This three day course:

  • Explains the concepts of MySQL Cluster in detail
  • Describes the different nodes in MySQL Cluster and their purposes
  • Explains how the data is distributed and replicated in the MySQL Cluster
  • Installs all the different nodes used in the MySQL Cluster
  • Starts and stop the different nodes as needed
  • Shows how the different configuration files work and be able to configure all possible types of clusters
  • Uses the cluster in single user mode, and explains when this is necessary
  • Shows how to upgrade cluster components and
  [Read more...]
Deploying remote MySQL sandboxes
+4 Vote Up -0Vote Down

Stating the problem.

In my job, I do a lot of testing. And no matter how much organized we try to be, we end up with fewer machines than we would need to run all the tests that we want.

For some tasks, we can run MySQL Sandbox, and get the job done. But sometimes we need to make sure that applications and systems work well across the network, and we need to install and run systems on separate servers.

However, when you test replication systems, and every cluster takes three or four servers, you run our of available hosts very quickly. So you decide to use the clusters that are dedicated to automated testing to also run your own manual tests. Soon you realize that the tests that you are running manually are clashing with the automated ones, or with the ones that your colleagues are running.

A simple solution

  [Read more...]
MySQL Web Reference Architectures - Your Guide to Innovating on the Web
Employee_Team +5 Vote Up -0Vote Down

MySQL is deployed in 9 of the top 10 most trafficked sites on the web including Facebook, Twitter, eBay and YouTube, as well as in some of the fastest growing services such as Tumblr, Pinterest and box.com

Working with these companies has given MySQL developers, consultants and support engineers unique insight into how to design database-driven web architectures – whether deployed on-premise or in the cloud.

The MySQL Web Reference Architectures (http://www.mysql.com/why-mysql/white-papers/mysql-reference-architectures-for-scalable-web-infrastructure/) are a set of documented and repeatable best practices for building infrastructure that deliver the highest levels of scalability, agility and availability with the lowest levels of cost, risk and complexity. 

Four components common to most web and mobile properties are sized, with optimum

  [Read more...]
Take MySQL Cluster Training to Meet Database Challenges
Employee_Team +2 Vote Up -0Vote Down

Take the authentic MySQL Cluster training to meet database challenges of next generation web, cloud and communication services with uncompromising scalability, uptime and agility.

This 3 day instructor-led class provides you a full understanding of cluster concepts as they relate to MySQL Cluster  as well as how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes and provide a better understanding of the internals of the cluster.

Here are some of the events already on the schedule for this course:

 

 Location  Date  Delivery Language
 London, England
20 March 2013



  [Read more...]
NoSQL Memcached API for MySQL: Latest Updates
Employee_Team +4 Vote Up -0Vote Down

With data volumes exploding, it is vital to be able to ingest and query data at high speed. For this reason, MySQL has implemented NoSQL interfaces directly to the InnoDB and MySQL Cluster (http://www.mysql.com/products/cluster/) (NDB) storage engines, which bypass the SQL layer completely. Without SQL parsing and optimization, Key-Value data can be written directly to MySQL tables up to 9x faster, while maintaining ACID guarantees.

In addition, users can continue to run complex queries with SQL across the same data set, providing real-time analytics to the business or anonymizing sensitive data before loading to big data platforms such as Hadoop, while still maintaining all of the advantages of their existing relational database infrastructure.

This and more is discussed in the latest Guide to MySQL and NoSQL

  [Read more...]
Learn More About the Scalability, Uptime, and Agility of MySQL Cluster
Employee_Team +2 Vote Up -0Vote Down

Learn more about the uncompromising scalability, uptime, and agility of MySQL Cluster by taking the authentic MySQL Cluster training course.

During this three day class, you will learn how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes as well as get a better understanding of the internals of the cluster.

Events currently on the schedule for this class include:

 Location

 Date

 Delivery Language

 Wein, Austria

 4 February 2013

  [Read more...]
Solving replication problems with Tungsten replicator
+1 Vote Up -0Vote Down

On Monday afternoon, Neal Armitage and I will be speaking at Percona Live in London. It will be a three hours tutorial about Tungsten replicator.

The contents of this tutorial are mostly new. We have released recently a new and easier way of installing different topologies, in the shape of cookbook scripts, which are distributed with the replicator tarball.

Using this cookbook, any user can simply install multiple topologies, from the simple master/slave to all-masters, fan-in, and star.

There are recipes for showing the replication cluster, switching roles between master and a chosen slave, taking over MySQL replication, installing direct slaves with parallel replication, testing each topology, and

  [Read more...]
MySQL and Hadoop Integration - Unlocking New Insight
Employee_Team +4 Vote Up -0Vote Down

“Big Data” offers the potential for organizations to revolutionize their operations. With the volume of business data doubling every 1.2 years, analysts and business users are discovering very real benefits when integrating and analyzing data from multiple sources, enabling deeper insight into their customers, partners, and business processes.

As the world’s most popular open source database, and the most deployed database in the web and cloud, MySQL is a key component of many big data platforms, with Hadoop vendors estimating 80% of deployments are integrated with MySQL.

The new Guide to MySQL and Hadoop (http://www.mysql.com/why-mysql/white-papers/mysql_wp_hadoop.php) presents the tools enabling integration between the two data platforms, supporting the data lifecycle from

  [Read more...]
Webinar 12/6 - Multi-master, star, and fan-in replication made easy with Tungsten
+0 Vote Up -0Vote Down
December 6th @ 10 am PT/1pm ET Learn more at http://bit.ly/U51cM5   Tungsten Replicator is a popular replacement for MySQL replication. With new 2.0.6 release, it has now become a mature and robust product, with an easy-to-use installer. While installing a simple master/slave topology was made as easy as it could possibly be, installing complex topologies was still a matter for advanced users
MySQL Cluster 7.3: On-Demand Webinar and Q&A Available
Employee_Team +3 Vote Up -0Vote Down

The on-demand webinar for the MySQL Cluster 7.3 Development Release is now available.

You can learn more about the design, implementation and getting started with all of the new MySQL Cluster 7.3 features from the comfort and convenience of your own device, including:

- Foreign Key constraints in MySQL Cluster

- Node.js NoSQL API 

- Auto-installation of higher performance distributed, clusters

We received some great questions over the course of the webinar, and I wanted to share

  [Read more...]
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...]
Jumpstart your MySQL Cluster Knowledge
Employee_Team +2 Vote Up -0Vote Down

Join companies in the web, gaming, telecoms and mobile areas by learning about MySQL Cluster's distributed, shared-nothing, real-time design.

The 3 days, MySQL Cluster course teaches you how to configure and manage the cluster nodes to ensure high availability. Learn how to install different nodes and understand cluster internals. Here is a sample of some events on the schedule for this course:

 Location

 Date

 Delivery Language

 Wien, Austria

 4 February, 2013

  [Read more...]
EmblaCom Oy Maximizes Database Availability and Reduces Costs with MySQL Cluster
Employee_Team +1 Vote Up -0Vote Down
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Headquartered in Finland, EmblaCom Oy provides turnkey and cloud-hosted voice solutions to mobile operators around the globe. Since launching the original mobile private branch exchange (PBX) in 1998, the company has focused on helping its partners

  [Read more...]
New Options for MySQL High Availability
Employee_Team +2 Vote Up -0Vote Down

Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of revenue and reputation.

There is not a “one size fits all” approach to delivering High Availability (HA). Unique application attributes, business requirements, operational capabilities and legacy infrastructure can all influence HA technology selection. And then technology is only one element in delivering HA – “People and Processes” are just as critical as the technology itself.

For this reason, MySQL Enterprise Edition (http://www.mysql.com/products/enterprise/) is available supporting a range of HA solutions, fully certified and supported by Oracle. MySQL Enterprise HA

  [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...]
Slides of my HOL on MySQL Cluster
Employee_Team +4 Vote Up -0Vote Down
Hi!

Thanks everyone who attended my hands-on lab on MySQL Cluster at MySQL Connect last Saturday.

The following are the links for the slides, the HOL instructions, and the code examples.

I'll try to summarize my HOL below.


Aim of the HOL was to help attendees to familiarize with MySQL Cluster. In particular, by learning:
  • the basics of MySQL Cluster Architecture
  • the basics of MySQL Cluster Configuration and Administration










  •   [Read more...]
    Saturday at MySQL Connect
    Employee +2 Vote Up -0Vote Down
    The first day of the first MySQL Connect conference is done.  It's been a busy day!  Many attendees are interested in the new MySQL Server 5.6 release, but of course MySQL Cluster is the main draw here.  After a session from Oracle on the new features in 7.2, and early access features in 7.3, I attended Santo Leto's MySQL Cluster 'hands on lab'.  Despite having started more clusters than most, it felt like a new and exciting experience installing and running my cluster alongside everyone else.  The lab machines had some networking issues, but with Santo's help we seamlessly failed-over to some downloads he'd prepared earlier - very professional!

    Afterwards it was my turn to talk on the subject of MySQL Cluster performance.  The quality of the questions was

      [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...]
    Getting Started with MySQL Cluster, Hands-on Lab, Next Saturday, MySQL Connect
    Employee_Team +1 Vote Up -0Vote Down

    Hi!

    I'm speaking at MySQL Connect next Saturday, Sep. 29. My Session is a hands-on lab (HOL) on MySQL Cluster (http://www.mysql.com/products/cluster/).

    If you are interested in familiarize a bit with MySQL Cluster this is definitely a session for you.


    I will start by briefly introducing MySQL Cluster and its architecture. Then I will guide you through the needed steps to install a local MySQL Cluster, connect to it (using the command line), monitor its logs, and safe shutdown it.

    We will hence have a chance to see which are the most common commands using in MySQL Cluster







      [Read more...]
    Automated MySQL Master Failover
    +1 Vote Up -0Vote Down
    After the GitHub MySQL Failover incident a lot of blogs/people have explained that fully automated failover might not be the most optimal solution.

    Fully automated failover is indeed dangerous, and should  be avoided if possible. But a complete manual failover is also dangerous. A fully automated manually triggered failover is probably a better solution.

    A synchronous replication solution is also not a complete solution. A split-brain situation is a good example of a failure which could happen. Of course most clusters have all kinds of safe guard to prevent that, but unfortunately also safe guards can fail.

    Every failover/cluster should be considered broken unless:
  • You've tested the failover scripts and procedures
  • You've tested the failover scripts and procedures under normal load
  • You've tested the failover scripts







  •   [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...]
    Scale Up, Partitioning, Scale Out
    +1 Vote Up -0Vote Down
    On the 8/16 I conducted a webinar titled: "Scale Up vs. Scale Out" (http://www.slideshare.net/ScaleBase/scalebase-webinar-816-scaleup-vs-scaleout):


    ScaleBase Webinar 8.16: ScaleUp vs. ScaleOut from ScaleBase
    The webinar was successful, we had many attendees and great participation in questions and answers throughout the session and in the end. Only after the webinar it only occurred to me that one specific graphic was missing from the webinar deck. It was occurred to me after answering



      [Read more...]
    MySQL Cluster performance revisited - tcmalloc kicks some ***
    +1 Vote Up -0Vote Down
    My now long-running series of posts on getting max performance from a very simple MySQL Cluster setup (see details here) is continuing here. As a short intro to what I am trying out here, is to see if I can validate the claim that MySQL Cluster / NDB would be a good replacement for a Key Value Store (KVS) such as MongoDB. I test this in a rather simple single-server environment, but this is for a reason, just not a coincidence: The reason is that RAM is getting inexpensive and servers that can take a lot of RAM are also getting less expensive, which in turns means that the saying that many small servers are more cost-effective that few big ones, might not be as valid as it used to be. Also, I wanted to test what MySQL Cluster can do for me, from a KVS centric  [Read more...]
    Session at MySQL Connect
    Employee +3 Vote Up -0Vote Down

    I will double my all-time total of public speaking engagements this September at the MySQL Connect conference in San Fransisco.

    The title of my session is "Delivering Breakthrough Performance with MySQL Cluster", and it's between 17:30 and 18:30 on Saturday 29th September.

    The content is not finalised yet, so if there's something you would like to hear about which fits with the abstract, then comment below.  If it doesn't fit in with the




      [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 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...]
    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...]
    ARM based data center. Inspiring.
    +1 Vote Up -1Vote Down
    In a previous post I wrote ARM based servers. Since then, and thanks to all the comments and responses I got, I looked more into this ARM thing and it's absolutely fascinating...

    Look at this beauty (taken from the site of Calxeda, the manufacturer):

    What is it? A chip? A server? No, it's a cluster of 4 servers...

    And this:







      [Read more...]
    The catch-22 of read/write splitting
    +2 Vote Up -0Vote Down
    In my previous post I covered the shard-disk paradigm's pros and cons, but the conclusion that is that it cannot really qualify as a scale-out solution, when it comes to massive OLTP, big-data, big-sessions-count and mixture of reads and writes.

    Read/Write splitting is achieved when numerous replicated database servers are used for reads. This way the system can scale to cope with increase in concurrent load. This solution qualifies as a scale-out solution as it allow expansion beyond the boundaries of one DB, DB machines are shared-nothing, can be added as a slave to the replication "group" when required.



      [Read more...]
    New MySQL & MariaDB Instructional Videos from SkySQL
    +3 Vote Up -0Vote Down

    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.

    read more

    Previous 30 Newer Entries Showing entries 31 to 60 of 240 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.