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

The MySQL developer tools team announces the availability of version 5.2.47
of the MySQL Workbench GUI tool. This is a minor maintenance release, addressing a problem during data copy in databases with triggers, during migrations and server upgrades.

For a full list of issues fixed in this release, see the release notes.

Please get your copy from our Downloads site. In Windows, you can also
use the MySQL Windows Installer to update Workbench and other MySQL products.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found …

If you are looking for some of the great blog posts of the week in database technologies like Oracle, SQL Server and MySQL, then Log Buffer #307 is the place to be. Enjoy.

Oracle:

When Jeremy Schneider writes, it stays written. He relishes and shares as how to troubleshoot OEM  12c Cloud Control Auto-Discovery.

Chris Kawalek informs that Oracle VM provides SAP customers with a fully supported and certified virtualization environment for the Oracle database.

Peter Lorenzen is hardening the Apache HTTP Server.

…

MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master and its replicas is now enforced. As we’ll see, it’s not that easy.

First, here are a few common reasons why data integrity may be broken (the list is not exhaustive):

• writes executed on a replica instead of the master
• non deterministic queries
• bad use of replication filters
• rollback of transactions mixing transactional and non-transactional tables

The real problem is that replication may keep on running without error, not letting you know that all servers no longer have the same data.

Will replication checksums detect such problems? Unfortunately, no, they won’t.

That …

TempoDB’s timely DBaaS for the Internet of Things. ScaleBase 2.0. And more

For 451 Research clients: TempoDB has timely database service for the Internet of Things bit.ly/YcQuqA

— Matt Aslett (@maslett) February 13, 2013

For 451 Research clients: ScaleBase provides centralized management of distributed MySQL databases bit.ly/YcQTcs

— Matt Aslett (@maslett) February 13, 2013

For 451 Research clients: XtremeData turns its attention to cloud-based data warehousing bit.ly/XB7MLY

— Matt Aslett (@maslett) …

Le 27 mars de 14h à 19h à l'Atelier du France, Paris

SkySQL et Monty Program organisent une demie journée de conférences consacrées aux bonnes pratiques et retours d'expériences autour des bases de données MySQL®et MariaDB, l'objectif étant de répondre aux préoccupations actuelles des administrateurs de bases de données.

read more

A few years ago, I used MySQL Sandbox to filter binary logs. 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 Oracle slave with some auditing features in place. Therefore, mass load functions were not considered. What we needed was the contents of the MySQL database as binary rows i.e. the same format used for row-based replication.

To achieve the purpose as quickly and as painlessly as we could, I thought to employ the services of a MySQL Sandbox. The flow of information would be like this:

1. Install a sandbox, using the same version and character set of the master;
…

My previous writings were mostly teoretical, so I wanted to give a more practical example, showing the actual state of the current code. I also wanted to show how I have tried to make the feature fit well into the existing replication features, without requiring the user to enable lots of options or understand lots of restrictions before being able to use it.

So let us start! We will build the code from lp:~maria-captains/maria/10.0-mdev26, which at the time of writing is at revision knielsen@knielsen-hq.org-20130214134205-403yjqvzva6xk52j.

First, we start a master server on port 3310 and put a bit of data into it:

    server1> use test; …

This is just a quick record of my attempt to build the new GA version of mysql 5.6.10 on an amazon linux instance on aws.

Background: 
Output from uname -a:

Linux dz1 3.2.36-1.46.amzn1.x86_64 #1 SMP Mon Jan 14 04:42:23 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux


Prerequisites: 
Use "sudo yum list installed" for each of these to see if they exist, or just install using "sudo yum install" :


make.x86_64
cmake.x86_64
ncurses-devel.x86_64
libaio-devel.x86_64
gcc47-c++.x86_64
bison.x86_64

I created a mysql user and an installation directory in /opt/mysql. That is where I copied the downloaded source file mysql-5.6.10.tar.gz. Exctracting creates the new mysql-5.6.10 subdirectory:

Created a "build" subdirectory:


cd /opt/mysql/mysql-5.6.10
mkdir …

We are very pleased to announce the addition of HP and Amazon Web Services as keynote speakers for the Percona Live MySQL Conference and Expo which is April 22-25 in Santa Clara, California. Amazon Web Services is sending Simone Brunozzi, Senior Technology Evangelist, who will speak on “Databases in the Cloud: Present and Future.” HP will be represented by Brian Aker, a Fellow at HP’s Cloud Division, and a returning keynote presenter from the 2012 conference. HP, the newest Diamond Plus conference sponsor, joins additional new conference sponsors GenieDB, GreenSQL, DaniWeb, Software Developer’s Journal, and Web and PHP Magazine.

One Day …