Wednesday, March 23, 2011

New on-demand webinar: MySQL Multi-Master and Multi-Source Replication with Tungsten

Multi-master replication is the key to applications ranging from credit card processing to online testing. Up until now things haven't exactly been easy for MySQL users, though. MySQL native replication cannot move data from multiple masters into a single slave (a.k.a. multi-source replication). MySQL also has poor support for masters in multiple locations. With Tungsten you can now look forward to solving all of these problems. It's not quite multi-master nirvana but we're getting close.

In this on-demand webcast we teach you how to design and implement multi-master replication using Tungsten. The topics covered include:

  • Introduction to Tungsten Replicator 2.0
  • Aggregating data from multiple masters into a single slave
  • Configuring multi-master with 2, 3 or more masters
  • Handling data conflicts
  • Adding masters and slaves
  • Recovering from failures within and across sites.
Learn how you can take advantage of Tungsten's powerful multi-master capabilities today!

Tuesday, March 22, 2011

Continuent Improves 24x7 Data Availability and Database Performance for MySQL and PostgreSQL with Next Version of Tungsten Enterprise

This latest version of Tungsten Enterprise includes a number of features to improve the management, performance, flexibility and reliability of Tungsten clusters. Furthermore, it includes architectural changes to the Tungsten Replicator, connectivity improvements, upgrades to MySQL binlog parsing and PostgreSQL replication, including:

Improved Performance
  • 5x boost in replication throughput.
  • New disk-based logging improves performance and simplifies log management.
Improved Management And Monitoring
  • Enhanced failure detection logic allows for configurable confirmation. You can now configure more than a single check for aliveness and increase Tungsten's ability to avoid false triggering.
  • Redundant confirmation of database server failures. Failures will be confirmed once they are detected the first time to further ensure right automatic response upon failure.
  • New ‘monitoring by proxy'. In the case where a manager fails on a database host, you can still monitor and detect failures on a given host as long as there is at least one manager remaining.
  • Support of virtual IP addresses makes them easier to set up and manage. You now can configure the VIP address and Ethernet interface at installation time.
Improved Connectivity
  • New Tungsten SQL Router and Connector management protocols allow processes to run without a Tungsten Manager process on the same host. This greatly simplifies management for clusters with large numbers of application servers.
  • You can now specify URL options for all connections that go through the connector to a given IP address. This functionality allows you to configure the connector to always connect to an available slave.
Improved Replication
  • Significant architectural improvements allow Tungsten Replicator to define custom replication flows (pipelines) for native Tungsten Replication as well as to manage non-Tungsten mechanisms such as PostgreSQL warm standby replication.
  • New features facilitate online upgrade of MySQL databases, including commands to stop replication for multiple slaves at the same transaction in the log and to restart replication from arbitrary transactions. Tungsten also certifies specialized replication pipelines that offer high-speed, restartable schema upgrade.
  • Extensions to MySQL support including handling of international character sets and binary data in MySQL, as well as handling of non-English locales for PostgreSQL servers. These improvements allow Tungsten to function more effectively in internationalized environments.
  • Complete replication of all items from MySQL 5.0 and 5.1 binlogs directly from a disk or using relay logs.
  • MySQL to Oracle replication for real-time integration of applications running on Oracle but needing MySQL data, and data warehousing from MySQL into Oracle.
  • MySQL to PostgreSQL replication for real-time integration of applications running on PostgreSQL and needing MySQL data.
  • MySQL to Greenplum replication for real-time data warehousing from MySQL into PostgreSQL-based Greenplum.
See press release and release notes for more details!

Friday, March 4, 2011

Zoom, Zoom, Zoom! MySQL Parallel Replication with Tungsten Replicator 2.0 - On Demand Webcast

MySQL database performance has increased remarkably thanks to recent hardware and software improvements. While this is great news for transaction throughput, single-threaded MySQL replication is looking increasingly creaky with wasted resources and severe slave lag to boot.

Join us for this introduction to Tungsten parallel replication and learn how to cure the MySQL master/slave impedance mismatch. We introduce the Tungsten Replicator architecture and show you how to optimize replication throughput using pipeline parallelism, multiple replication services, and sharded parallel apply. We also cover tricks from the Tungsten masters to look at and tune replicator performance. At the end of this webcast, you'll understand not only how Tungsten Replicator 2.0 works but how to set it up and make it run.

Watch and learn how to make replication go fast!

On-demand Webinars - A convenient way to learn about our expert consulting and software solutions.

Because business never stops, you need a convenient and cost-effective way to access information about our expert consulting and software solutions. Our on-demand webcasts bring you and our database experts together to access information about support services, products, technologies, best practices and more. These are recorded replays of our most popular live web seminars and cover a wide range of topics ranging from:
  • MySQL Parallel Replication with Tungsten Replicator 2.0
  • Implementing Zero-Downtime MySQL Upgrades
  • What MySQL Replication Cannot Do. And How To Get Around It.
  • Managing Big Data with Percona Server, XtraBackup and Tungsten.