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 中文
Showing entries 1 to 30 of 243 Next 30 Older Entries

Displaying posts with tag: cluster (reset)

Picking the right clustering for MySQL: Cloud-only services or flexible Tungsten clusters?
+0 Vote Up -0Vote Down
As businesses head into the cloud, it is tempting to reach for the first product that offers to make database operation as simple as punching a few buttons on a menu.  However, there’s a big difference between firing up cloud database services such as Amazon RDS for testing or development and finding a solution that can handle hundreds of millions of transactions daily. This webinar explores how
MySQL Cluster High Availability Through Data Replicas
Employee_Team +0 Vote Up -0Vote Down

MySQL Cluster enables high availability by storing data replicas on multiple hosts. MySQL Cluster maintains connections between data nodes by using high-speed interconnects over TCP/IP - standard or direct connections - or SCI (Scalable Coherent Interface) sockets.

To learn more about MySQL Cluster, take the MySQL Cluster training course.

This course is currently scheduled for the following locations:

 Location

 Date

 Delivery Language

 Sao

  [Read more...]
Automatic Database Sharding with MySQL Cluster
Employee_Team +1 Vote Up -0Vote Down

MySQL Cluster automatically shards at the database layer, spreading the database out across nodes so that developers do not have to write complex and intrusive application-sharding logic (which is required by other platforms).

To understand the types of nodes in a MySQL Cluster and to learn how to design, install, configure, and maintain this product, take the MySQL Cluster training course. Below is a selection of the events already on the schedule for this 3-day training course:

 Location
  [Read more...]
Geographically distributed multi-master MySQL clusters
+0 Vote Up -0Vote Down
In today's webinar, we discuss the multi-master capabilities of Continuent Tungsten to help you build and manage systems that spread data across multiple sites.  We cover important topics such as setting up large scale topologies, handling failures, and how to handle data privacy issues like removing personally identifiable information or handling privacy law restrictions on data movement. We
MySQL Cluster in Environments Requiring Real-Time Analytics
Employee_Team +0 Vote Up -0Vote Down

MySQL Cluster is used by many different industries. MySQL Cluster thrives in the most complex data environments that demand real-time analytics such as:

  • Financial trading with fraud protection
  • Feed-streaming analysis and recommendations
  • Massive online multiplayer games
  • Communication services

To learn more about MySQL Cluster, take the MySQL Cluster training course. Below is a selection of events already on the schedule for this 3-day instructor led course:

 Location  Date  Delivery Language
 Sao
  [Read more...]
innodb_flush_logs_on_trx_commit and Galera Cluster
+0 Vote Up -0Vote Down

We deploy Galera Cluster (in MariaDB) for some clients, and innodb_flush_logs_on_trx_commit is one of the settings we’ve been playing with. The options according to the manual:

  • =0 don’t write or flush at commit, write and flush once per second
  • =1 write and flush at trx commit
  • =2 write log, but only flush once per second

The flush (fsync) refers to the mechanism the filesystem uses to try and guarantee that written data is actually on the physical medium/device and not just in a buffer (of course cached RAID controllers, SANs and other devices use some different logic there, but it’s definitely written beyond the OS space).

In a non-cluster setup, you’d always want it to be =1 in order to be ACID compliant and that’s also InnoDB’s default. So far so good. For cluster setups,

  [Read more...]
Ghosts of MySQL Past, Part 8: The First Fork.
+1 Vote Up -0Vote Down

This is the 8th installment in the rather long series that started with Part 1 about a month ago.

Back in 2006, we were in the situation where MySQL 5.0 had taken forever, and the first “GA” release was not suitable for production. Looking towards MySQL 5.1, it was also unlikely to be out any time soon. The MySQL Cluster team had customers that needed new features in a stable release. The majority of users didn’t use the MySQL server at all, they directly used the C++ NDB API for the vast majority of queries – so the vast majority of release blocker bugs in the MySQL server would not affect the production

  [Read more...]
Reports exaggerated
Employee +1 Vote Up -0Vote Down
I've been letting the blog rest recently, and not so recently as well.  The problem is not a lack of subjects, but a lack of time to do them any justice.  However it is quite sad to see that my last entry was in September 2012, so it is time to post again.

Of late I have been pondering what I have to say about :
  • Distributed MVCC and write-scaling
  • Different approaches to eventual consistency with replicated RDBMS
  • Various MySQL Cluster related topics
  • Various general rambling and unstructured topics
However, these will take some time to percolate and calcify.

In the meantime here are some things I have found interesting recently :






  [Read more...]
Auto increments in Galera
+0 Vote Up -0Vote Down

Lets start by considering a scenario where records are being inserted in a single auto-increment table via different nodes of a multi-master cluster. One issue that might arise is ‘collision’ of generated auto-increment values on different nodes, which is precisely the subject of this article.

As the cluster is multi-master, it allows writes on all master nodes. As a result of which a table might get same auto-incremented values on different nodes on INSERTs. This issue is discovered only after the writeset is replicated and that’s a problem!

Galera cluster suffers with the similar problem.

Lets try to emulate this on a 2-node Galera cluster :

1) On node #1:

MariaDB [test]> CREATE TABLE t1(c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT)ENGINE=InnoDB;
Query OK, 0 rows affected (0.07 sec)

MariaDB [test]> START TRANSACTION;
Query OK, 0
  [Read more...]
MySQL Cluster is a Resilient and Scalable Database Platform
Employee_Team +0 Vote Up -0Vote Down

MySQL Cluster is a highly resilient and scalable database platform designed to deliver 99.999% availability with features such as self-healing and online operations, and capable of performing over 1,00,000,000 updates per minute. The full feature set includes development and management platforms alongside monitoring and administration tools, all backed by Oracle Premier Lifetime Support.

To learn more about MySQL Cluster, consider taking the MySQL Cluster training. Events already on the schedule for this 3-day instructor-led course include:

 Location

 Date

  [Read more...]
MySQL Cluster, Shared-Nothing Clustering and Auto-Sharding
Employee_Team +0 Vote Up -0Vote Down

MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.

To learn more about MySQL Cluster, take the 3-day MySQL Cluster training course. Below is a selection of events already on the schedule for this course.

 Location

 Date

 Delivery Language

 Berlin, Germany

  [Read more...]
Join Companies in Web and Telecoms by Adopting MySQL Cluster
Employee_Team +0 Vote Up -0Vote Down

Join Web and Telecom companies who have adopted MySQL Cluster to facilitate application in the following areas:

Web:

  • High volume OLTP
  • eCommerce
  • User profile management
  • Session management and caching
  • Content management
  • On-line gaming

Telecoms:

  • Subscriber databases (HLR/HSS)
  • Service deliver platforms
  • VAS: VoIP, IPTV and VoD
  • Mobile content delivery
  • Mobile payments
  • LTE access

To come up to speed on MySQL Cluster, take the 3-day MySQL Cluster training course. Events already

  [Read more...]
MariaDB CONNECT Storage Engine and parallelism
+1 Vote Up -1Vote Down

The CONNECT Storage engine implement the concept of a table made of multiple tables. These underlying tables can be distributed remotely. For example the underlying remote tables can be of ODBC or MySQL table type. this allows to execute distributed queries. What is nice is that we can execute this distributed query with parallelism.

How [...]

Continuent Tungsten at The OpenStack Summit HK
+0 Vote Up -0Vote Down
Continuent is proud to sponsor The OpenStack Summit, November 5-8, at the AsiaWorld Expo in Hong Kong! Don't miss this presentation by Edward Archibald: Deploying a Highly-Available Database-as-a-Service in OpenStack In his talk, Edward Archibald, CTO at Continuent, will demonstrate the ease of deploying a multi-site, highly-available, scalable Database-as-a-Service across two OpenStack
MySQL Fabric with MariaDB Galera Cluster ?
+2 Vote Up -0Vote Down

MySQL Fabric is a very promising sharding framework. If I take Ulf Wendel definition of MySQL Fabric :

MySQL Fabric is an administration tool to build large “farms” of MySQL servers. In its most basic form, a farm is a collection of MySQL Replication clusters. In its most advanced form, a farm is a collection of [...]

Percona XtraDB Cluster – A Drop-in-place Clustering Solution for MySQL
+0 Vote Up -0Vote Down
Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server. I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post. So here I will be doing a high-level comparison between MySQL NDB Cluster and Percona XtraDB Cluster.
Extreme Real-Time Performance With MySQL Cluster
Employee_Team +0 Vote Up -0Vote Down

For those looking for extreme real-time performance, high availability and speed, consider MySQL Cluster.

In the MySQL Cluster training, within 3 days, you learn to:

  • Describe the different nodes in MySQL Cluster
  • Install, start and stop nodes
  • Understand and work with configuration files
  • Upgrade a cluster
  • Explain node failure and understand how restart works
  • Configure the cluster for optimal performance

Here is a selection of the events currently scheduled for this live instructor-led course:

  [Read more...]
How Marketo solved key data management challenges with Continuent Tungsten
+0 Vote Up -0Vote Down
Marketo provides the leading cloud-based marketing software platform for companies of all sizes to build and sustain engaging customer relationships. Marketo's SaaS platform runs on MySQL and has faced data management challenges common to all 24x7 SaaS businesses: Keeping data available regardless of DBMS failures or planned maintenance Utilizing hardware optimized for multi-terabyte MySQL
Must-see webinars for SaaS and business-critical MySQL users
+0 Vote Up -0Vote Down
Join Continuent and our customers Modernizing Medicine and Marketo to learn how to run business-critical MySQL applications in the cloud or on-premises. Modernizing Medicine is a fast-growing SaaS company, offering electronic medical records management solution. Matthew Lang, Sr. Site Reliability Engineer at Modernizing Medicine, describes how Modernizing Medicine serves thousands of customers
Tap into the 5 Nines of MySQL Cluster with Oracle Training
Employee_Team +1 Vote Up -0Vote Down

With its distributed, shared-nothing architecture, MySQL Cluster has been designed to deliver 99.999% availability ensuring resilience to failures and the ability to perform scheduled maintenance without downtime.

With the MySQL Cluster training course, in 3 days, you learn important clustering concepts as well as how to install and configure MySQL Cluster and manage cluster nodes. 

Below is a selection of events already on the schedule.

 Location

 Date

  [Read more...]
Connection Failures Between Nodes in MySQL Cluster
Employee +0 Vote Up -0Vote Down

If you're setting up MySQL Cluster on Oracle Linux or another Linux such as Red Hat, CentOS or Fedora, you might have come across some problems getting the nodes to communicate. There are two ways you might bump into problems with network connectivity: The iptables firewall, and SELinux. These security mechanisms might prevent your various nodes—management, data, and API—from communicating with each other in various ways and with various symptoms.

Let's have a look at what you're likely to see. 

Data nodes stuck at "starting"

The first thing you might notice is that your data nodes get stuck in the "starting" state. Running show in the management client gives something like this:

[ndbd(NDB)]     2 node(s)
id=2    @192.168.56.211  (mysql-5.6.11
  [Read more...]
Fun with Bugs #12 - MySQL Cluster 7.3 GA
+0 Vote Up -0Vote Down
I had always tried to avoid all kinds of clusters, from Oracle RAC to MySQL NDB Cluster and Percona XtraDB Cluster, as much as possible. But these days clusters become common and it seems new developments in this area can not be just ignored. So, I decided to devote this issue of "Fun with Bugs" to MySQL Cluster 7.3, that was released as GA this week and still is in the news.

The release was mostly about adding foreign keys support (one of the features that some users were missing for years comparing to InnoDB and other cluster database solutions). At the same time, MySQL Cluster is now based on MySQL Server 5.6 code. I've decided to quickly check how community adopted 7.3 and what it means in terms of bug reports.

If one would just search for active bugs in version "7.3" at the public bugs



  [Read more...]
How to Cluster Magento, nginx and MySQL on Multiple Servers for High Availability
+0 Vote Up -0Vote Down
June 17, 2013 By Severalnines

Magento is an open-source e-commerce platform built on Zend PHP and MySQL. It is widely adopted by online retailers with some 150,000 sites known to use it. Single server setups are easy to set up, but if your store is a huge success, then you probably need to think about clustering your environment with multiple servers. Clustering is done at the web, database and file-system level, as all web nodes need access to catalog images. 

 

This post is similar to our previous posts on scaling Drupal and

  [Read more...]
Meet Database Challenges with MySQL Cluster
Employee_Team +0 Vote Up -0Vote Down

MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime and agility. With the MySQL Cluster training course:

  • Learn how to develop, deploy, manage and scale your MySQL Cluster applications more efficiently
  • Keep your mission-critical applications and essential services up and running 24x7
  • Deliver the highest performance and scalability using MySQL Cluster best practices

    Below is a selection of events on the schedule for this 3 day instructor-led course:

  •   [Read more...]
    Pacemaker Failed Actions ‘not installed’ And ‘not configured’
    +0 Vote Up -0Vote Down

    Playing around with Percona Replication Manager, and being new to Pacemaker, some errors were somewhat cryptic.

    May 26 09:53:39 [2181] ha01.localdomain    pengine:   notice: unpack_rsc_op:    Preventing p_mysql from re-starting on ha02.localdomain: operation monitor failed 'not installed' (rc=5)
    May 26 09:53:39 [2181] ha01.localdomain    pengine:   notice: unpack_rsc_op:    Preventing op from re-starting on ha02.localdomain: operation monitor failed 'not installed' (rc=5)

    First, it says here that I have ‘operation monitor failed’ on node ha02.localdomain. This error simply means ‘I cannot run the operation monitor because it is not installed’. Where does this operation supposed to come from, from the resource agent. Turns out, I did not have the mysql resource agent in place under

      [Read more...]
    Make MySQL clustering work for you
    +0 Vote Up -1Vote Down
    We’ve told you all about MySQL mult-master replication’s limitations. If you write to two masters it is bound to fail for myriad reasons. Now what? Do what the pros do that’s what. A. Don’t write to both masters Using multi-master replication works great as long as you do so in active-passive mode. Never write to [...]
    Galera pre-deployment check
    +0 Vote Up -0Vote Down

    One of the first things we do when preparing a client’s infrastructure for Galera deployment is see whether their schema is suitable.

    • Avoiding quirks and edge cases, we can say that Galera simply requires all tables to be InnoDB and also have a PRIMARY KEY (obviously having a PK in InnoDB is important anyway, for InnoDB-internal reasons).
    • We want to know about FULLTEXT indexes. With recent InnoDB versions also supporting FULLTEXT we need to check not just whether a table has such an index, but actually which engine it is.
    • Spatial indexes. While both InnoDB and MyISAM can deal with spatial datatypes (POINT, GEOMETRY, etc), only MyISAM has the spatial indexes.

    Naturally, checking a schema in the server is more effective than going through other sources and possibly missing bits. On the downside, the only viable way to get this info out of MariaDB

      [Read more...]
    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...]
    Showing entries 1 to 30 of 243 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.