Just released - the all new MySQL Cluster training course.
This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster's open-source and enterprise components.
This 4-day training course is a must for those who want to learn about MySQL Cluster as you will not only learn about the concepts and features but you will get extensive hands-on experience. You can follow this training course from your own desk via a live-virtual training or by traveling to an education center to follow this course. [Read more...]
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-on-demand
We are pleased to inform you that the new Continuent Tungsten 2.0.3 is now available. This is a
recommended release for all Continuent Tungsten clustering customers as
it contains important updates and improvements to the stability of the
manager component, specifically with respect to possible stalls and
memory usage that would cause manager failures:
A number of fixes to the Manager
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:
Sao [Read more...]
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...]
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 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:
Sao [Read more...]
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...]
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...]
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:
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.
Berlin, Germany [Read more...]
Join Web and Telecom companies who have adopted MySQL Cluster to facilitate application in the following areas:
- High volume OLTP
- User profile management
- Session management and caching
- Content management
- On-line gaming
- 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...]
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
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:
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
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
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.
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
June 17, 2013
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...]
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:
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...]
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
- 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...]
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.