Thursday, February 21, 2013

Tungsten University: Unleashing the Power of Tungsten Connectors



How To Configure Tungsten Connector For Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance

Tuesday, February 19, 2013

New Tungsten Replicator w/ MySQL 5.6 & Amazon RDS support

Tungsten Replicator 2.0.7 enables new MySQL versions, provides better support for multi-master and parallel replication, and improves setup of advanced topologies. In the MySQL area, we have added the ability to replicate from MySQL into Amazon RDS instances, as well as initial certification for MySQL 5.6. 

There are several important new features for multi-master replication, including better control of specific schemas that should be replicated between masters, as well as the ability for slave replicators switch automatically between a group of replicators in a Tungsten cluster.

There are a number of bug fixes to help with parallel replication, including a new relative latency setting that helps detect when replication is idle or stalled. Finally, we have improved cookbook recipes so that it is now easier to set up interesting topologies. 

Free download at http://code.google.com/p/tungsten-replicator/
See full release notes at http://code.google.com/p/tungsten-replicator/wiki/Release_Notes#Tungsten_Replicator_2.0.7

Friday, February 15, 2013

MySQL Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance

How To Configure Tungsten Connector For Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance 


Tungsten clusters use the Tungsten Connector to ensure your applications transparently connect to the master. This enables fail over and seamless switching of masters for online maintenance. However, you can do far more. Tungsten Connector allows you to make better use of hardware by load balancing SQL traffic to slaves. There is also a wealth of configuration settings to help Tungsten Connector manage connections efficiently. 

Learn standard deployment patterns, how to create users, control load balancing, how to distribute reads across local and remote sites, and other configuration tricks. We will also provide advice about how to adapt your applications to use load balancing more efficiently.

Course Topics
  • Deployment options and techniques 
  • Configuring users with regard to data services
  • Application configuration samples
  • Read/write splitting options and demos
  • Load balancing strategies
  • Optimization of connection and request speed
  • Understanding and fixing connectivity issues
Course Dates

Wednesday, February 6, 2013

Tungsten University: Unleashing the Power of Tungsten Connectors

Tungsten clusters use the Tungsten Connector to ensure your applications transparently connect to the master. This enables failover and seamless switching of masters for maintenance. However, you can do far more. Tungsten Connector allows you to make better use of hardware by load balancing SQL traffic to slaves. There is also a wealth of configuration settings to help Tungsten Connector manage connections efficiently. Learn standard deployment patterns, how to create users, control load balancing, how to distribute reads across local and remote sites, and other configuration tricks. We will also provide advice about how to adapt your applications to use load balancing more efficiently. 

Course Topics 
  • Deployment options and techniques
  • Configuring users with regard to data services
  • Application configuration samples
  • Read/write splitting options and demos
  • Load balancing strategies
  • Optimization of connection and request speed
  • Understanding and fixing connectivity issues 

Course Dates
Reserve your seat today!

Introducing Data Fabric Design for Commodity SQL Databases

Extract from THE SCALE-OUT BLOG
by Robert Hodges (CEO, Continuent)

http://scale-out-blog.blogspot.com

Data management is undergoing a revolution. Many businesses now depend on data sets that vastly exceed the capacity of DBMS servers. Applications operate 24x7 in complex cloud environments using small and relatively unreliable VMs. Managers need to act on new information from those systems in real-time. Users want constant and speedy access to their data in locations across the planet. 

It is tempting to think popular SQL databases like MySQL and PostgreSQL have no place in this new world. They manage small quantities of data, lack scalability features like parallel query, and have weak availability models. One reaction is to discard them and adopt alternatives like Cassandra or MongoDB. Yet open source SQL databases have tremendous strengths: simplicity, robust transaction support, lightning fast operation, flexible APIs, and broad communities of users familiar with their operation. The question is how to design SQL systems that can meet the new requirements for data management. 

This article introduces an answer to that question: data fabric design. Data fabrics arrange off-the-shelf DBMS servers so that applications can connect to them as if they were a single database server. Under the covers a data fabric consists of a network of servers linked by specialized connectivity and data replication. Connectivity routes queries transparently from applications to DBMS servers. Replication creates replicas to ensure fault tolerance, distribute data across locations, and move data into and out of other DBMS types. The resulting lattice of servers can handle very large data sets and meet many other requirements as well. 

Data fabric design is a big topic, so I am going to spread the discussion over several articles. This first article provides a definition of data fabric architecture and introduces a set of design patterns to create successful data fabrics. In the follow-on articles I will explore each design pattern in detail. The goal is to make it possible for anyone with a background in database and application construction to design data management systems that operate not only today but far into the future. At the very least you should understand the issues behind building these systems. 

Some readers may see data fabric design as just another reaction to NoSQL. This would be a mistake. Building large systems out of small, reliable parts is a robust engineering approach that derives from ground-breaking work by Jim Grey, Pat Helland, and others dating back to the 1970s. Data fabrics consist of DBMS servers that you can look at and touch, whereas NoSQL systems tend to build storage, replication, and access into a single distributed system. It is an open question which approach is more complex or difficult to use. There are trade-offs and many systems actually require both of them. You can read this article and those that follow it, then make up your own mind about the proper balance.

Read the entire article at http://scale-out-blog.blogspot.com.

Tuesday, February 5, 2013

Tungsten University: Setup & Operate Tungsten Replicator

Do you have the background necessary to take full advantage of Tungsten Replicator in your environments? Tungsten offers enterprise-quality replication features in an open source package hosted on Google Code. This virtual course will teach you how to set up innovative topologies that solve complex replication problems.
We start with a list of the main problems that Tungsten can solve, then show you how to set up Tungsten Replicator to link MySQL database servers. 
Course Topics
  • Checking host and MySQL prerequisites
  • Downloading code from http://code.google.com/p/tungsten-replicator/
  • Installation using the tungsten-installer utility
  • Transaction filtering using standard filters as well as customized filters you write yourself
  • Enabling and managing parallel replication
  • Configuring multi-master and fan-in using multiple replication services
  • Backup and restore integration
  • Troubleshooting replication problems
  • Logging bugs and participating in the Tungsten Replicator community
Replication is a complex technology. Join us to learn how to configure and use it more effectively for your projects in the cloud as well as on-premises hardware.
 

About Tungsten University

In the Tungsten University, you will learn the important details of clustering that you will need to understand to get started with Continuent Tungsten, 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. Training from Tungsten University helps you keep your mission-critical applications and essential services up and running 24x7. Our live virtual courses are online instructor-led trainings that are delivered in real time via Web conferencing and audio, plus interactive enhancements such as live chat, Q&A and simulations.

Tungsten University: Configure & provision Continuent Tungsten clusters

Are you unsure of the steps needed to get your Continuent Tungsten cluster up-and-running? In this virtual course, we will teach you how to get from a single database server to a scalable cluster, or from a brittle MySQL replication system to a transparent, manageable Tungsten cluster. 

We will discuss the benefits of leveraging Continuent Tungsten clustering with MySQL, and walk you through the steps to implement a Tungsten cluster in Amazon EC2. We'll cover the prerequisites, installing and configuring Tungsten, and best practices that are part of most production installations and proof-of-concepts. 

Course Topics
  • Configuring MySQL and the OS for proper installation
  • Installing a cross-site cluster
  • Schema upgrade on the master database server with minimal application downtime (switch operation)
  • Automated fail over when a MySQL database server crashes
  • Recovery of a failed master to a fully operational slave with a single command (recover operation)
  • Switching database operations to a remote site (geo-clustering, cross-site 'switch' operation)
We will also discuss and demonstrate basic operations, such as adding and removing a cluster node, basic monitoring and troubleshooting, and discuss the basic failure scenarios. 

Join us to learn how to quickly configure and provision highly optimized Continuent Tungsten deployments in the cloud or on-premises! Even if you can't make the live virtual course, it is still worth registering for the course as you will receive a notification when the replay will be available, to study on-demand at your convenience.




About Tungsten University

In the Tungsten University, you will learn the important details of clustering that you will need to understand to get started with Continuent Tungsten, 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. Training from Tungsten University helps you keep your mission-critical applications and essential services up and running 24x7. Our live virtual courses are online instructor-led trainings that are delivered in real time via Web conferencing and audio, plus interactive enhancements such as live chat, Q&A and simulations.