Parallel replication and GTID - A tale of two implementations
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Wednesday, 20 February 2013 13:23

MySQL 5.6 is probably the version of MySQL with the biggest bundle of new features. You may want to try it soon, since it's now released as GA, and I would like to offer some practical experience on how to use some of the advanced features. Since replication is my main interest, I will focus on some of the new features in this field, and I will compare what's available in MySQL 5.6 with Tungsten R...


Tungsten Replicator 2.0.7 is released
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Tuesday, 19 February 2013 16:13

Tungsten Replicator 2.0.7 (http://tungsten-replicator.org) was released today. In addition to a large number of bug fixes, this release adds several improvements for multi-master management, and support for Amazon RDS (as a slave) (http://code.google.com/p/tungsten-replicator/issues/detail?id=425).While the Release Notes (http://code.google.com/p/tungsten-replicator/wiki/Release_Notes) show a long...


New Tungsten Replicator w/ MySQL 5.6 & Amazon RDS support
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Tuesday, 19 February 2013 10:11




Data Fabric Design Patterns: Fabric Connector
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Tuesday, 19 February 2013 04:14

This article is the third in a series on data fabric design (http://scale-out-blog.blogspot.com/2013/02/introducing-data-fabric-design-for.html) and introduces the fabric connector service design pattern. The previous article in this series (http://scale-out-blog.blogspot.com/2013/02/data-fabric-design-patterns.html) introduced the transactional data service design pattern, which defines individu...


MySQL Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Friday, 15 February 2013 06:33




Provisioning an Oracle slave using Tungsten and MySQL Sandbox
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Thursday, 14 February 2013 11:49

A few years ago, I used MySQL Sandbox (http://mysqlsandbox.net) to filter binary logs (http://datacharmer.blogspot.it/2010/11/filtering-binary-logs-with-mysql.html). While that one was a theoretical case, recently I came across a very practical case where we needed to provision an Oracle database, which is the designated slave of a MySQL master.In this particular case, we needed to provision the O...


MySQL Sandbox as a riddle
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Tuesday, 12 February 2013 08:19

Shlomi Noach is the next chairman of the Percona Live 2013 (http://www.percona.com/live/mysql-conference-2013/). As such, he has opened the preview of the conference by posting some talks of interests (http://code.openark.org/blog/mysql/sessions-of-interest-in-percona-live-2013), which includes a riddle to win a free pass.The riddle went unanswered, and Shlomi submitted it also to members of the r...


MySQL Sandbox 3.0.30 - now adapted to work with 5.5.30 and 5.6.10
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Thursday, 07 February 2013 07:55

The latest releases of MySQL Sandbox (http://mysqlsandbox.net), in addition to deal with minor bugs, have mostly been necessary because of compatibility issues in MySQL, both 5.5 and 5.6. When I found that MySQL 5.6 has some InnoDB tables inside the 'mysql' schema, I had to change the way that the sandbox used to remove all contents (the ./clear command.) To achieve a smooth clean up, MySQL Sandbo...


Data Fabric Design Patterns: Transactional Data Service
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Wednesday, 06 February 2013 16:56

This article is the second in a series on data fabric design and introduces the transactional data service design pattern. The previous article in this series (http://scale-out-blog.blogspot.com/2013/02/introducing-data-fabric-design-for.html) introduced data fabrics, which are collections of off-the-shelf DBMS servers that applications can connect to like a single server. They are implemented f...


Tungsten University: Unleashing the Power of Tungsten Connectors
Source:  Continuent blogs: The Scale-out, The Data Charmer, Flying Clusters and Continuent Tungsten blogs
Wednesday, 06 February 2013 09:53