Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 246 10 Older Entries

Displaying posts with tag: cluster (reset)

See the benefits of MySQL Cluster through Oracle Training
Employee_Team +2 Vote Up -0Vote Down

If the following items items describe what you need in a high-availability solution, then MySQL Cluster is for you:

  • High scale, reads and writes
  • 99.999% availability
  • Real-time
  • SQL and NoSQL
  • Low TCO

And what better way to get started on MySQL Cluster than taking the authentic MySQL Cluster training course.

In this 3-day course, you learn important cluster concepts and get hands-on experience installing, configuring and managing a cluster. Some events already on the schedule for this course include:

 Location

  [Read more...]
MySQL Cluster 7.3 DMR2: Increasing Developer Flexibility and Simplicity
Employee_Team +5 Vote Up -0Vote Down
Highlights: Foreign Keys, NoSQL JavaScript Connector, MySQL 5.6 and Auto-Tuned Clustering
The MySQL team at Oracle are excited to announce the immediate availability of the second MySQL Cluster 7.3 Development Milestone Release (DMR)
Some might call MySQL Cluster 7.3 “the foreign keys release” – and sure enough it is a major engineering achievement to build a distributed database that enforces referential integrity across a shared-nothing cluster, while maintaining ACID compliance and cross-shard JOINs. But MySQL Cluster 7.3 is a lot more as well. 
The design focus has been on enabling developer agility – making it simpler and faster than ever to enhance new services with a highly scalable, fault tolerant, real-time database – with minimum development


  [Read more...]
MySQL Cluster Tutorial: NoSQL JavaScript Connector for Node.js
Employee_Team +4 Vote Up -0Vote Down

This tutorial has been 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

  [Read more...]
Converting InnoDB Tables to MySQL Cluster
Employee +0 Vote Up -0Vote Down

If you're considering using MySQL Cluster, you might be tempted to try it out on one of your existing databases. MySQL Cluster 7.3 (available as a development release at the time of this post) supports foreign keys, so it seems sensible to try migrating an InnoDB database with foreign keys to MySQL Cluster.

What won't work

For this example, I'm using the world_innodb.sql script available from the MySQL sample databases. It's a simple database with three tables: Country, City, and CountryLanguage. Both City and CountryLanguage have foreign keys referencing the Country table's Code field.

So, you might try something like this:

ALTER TABLE Country
  [Read more...]
MariaDB Galera Cluster is a unique technology worth testing
+2 Vote Up -0Vote Down

As alway with new technology there is always different approaches regarding the adoption. You can try to use the bleeding edge features or start with a very standard configuration. My personal advise to new users is to start with the most basic configuration.

This allow you to get familiar with the fundamentals : - how [...]

Multi-master data conflicts - Part 1: understanding the problem
+3 Vote Up -0Vote Down

What is a conflict?

Readers of this blog know that one of my favorite tools, Tungsten Replicator, can easily create multi-master replication topologies, such as all-masters, star, fan-in. While this is good news for system designers and ambitious DBAs, it also brings some inconvenience. When you allow updates to happen in more than one master, you risk having conflicts. You may have heard this term before. For the sake of clarity, let's define what conflicts are, before analyzing each case in detail.

You have a conflict when several sources (masters) update concurrently the same data in asynchronous replication.

It's important to stress that this happens with asynchronous replication. In a truly synchronous cluster, where all data is kept consistent through

  [Read more...]
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...]
10 Newer Entries Showing entries 31 to 40 of 246 10 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.