MySQL Enterprise Backup team is excited to announce the new release of MySQL Enterprise Backup (MEB) 3.9.0.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Overview

MEB 3.9.0 focusses more on the ease of use of the product and addresses some of the challenges faced currently by database administrators.  With growing data the need for hardware for database backups has significantly increased. Keeping that in mind MEB 3.9.0 has extended the product capability to save disk space during backup and restore.  MEB 3.9.0 has also enhanced some of the existing features helping MEB users to perform their tasks in a more user friendly way without much overhead. 

Product Enhancements

 MEB 3.9.0 is a major release with the following valuable features.

·         Single …

Dear MySQL users,

MySQL Connector/Net 6.5.7, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release for 6.5.x.
This release is feature complete. It is recommended for use in production environments.
It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

Enjoy and thanks for the support!Enjoy and thanks for the support!

Connector/NET Team

This Log Buffer Edition starts with an awesome post by Dana Pylayeva from Rakuten LinkShare, a long term Pythian client, about her deep and insightful reflections about security. And as usual, it also brings together all the sparkling gems of Oracle, SQL Server, and MySQL. Enjoy!

Oracle:

Alberto illustrates the algorithm used by Oracle (in 11.2.0.3) to fast refresh a materialized view (MV) containing only the SUM aggregate function.

Tim Hall writes about Oracle 12c Multitenant Option : CDBs and PDBs. …

If you have thread_concurrency, innodb_additional_mem_pool_size or innodb_use_sys_malloc in one of your my.cnf or my.ini files please remove it at your next opportunity unless one of the unlikely exceptions applies.

Thread_concurrency is a setting for only Solaris that has no effect in recent Solaris versions like 11. For Solaris 8 and earlier it gave the thread system a hint about how many threads to use for MySQL. Solaris 8 was last a supported platform for MySQL 5.1. We have deprecated this setting from 5.6.1 and removed it from 5.7.

…

In my recent SQL work for a large Swiss bank, I have maintained nested database view monsters whose unnested SQL code amounted up to 5k lines of code, joining the same table over and over again in separate subselects combined via UNION operations. This monster performed in way under 50ms, no matter how we queried … Continue reading The Myth About Slow SQL JOIN Operations →

UPDATE 2013-08-30: Tungsten 2.1.2 was released.

UPDATE 2013-08-23: We have found a few problems that happen when replicating with RBR and temporal columns. We will have to publish an updated bugfix release quite soon.

Tungsten Replicator 2.1.1 is out. Key features in this release are:

• A better installer, of which we have already given a preview in tpm, the multi-master composer. The new installer allows faster and more powerful deployments of both single and multiple masters topologies. And it also allows the next feature:
• Secured communication layer. Now the replicator data and administrative …

Dear MySQL users,

MySQL Connector/Net 6.6.6, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release for 6.6.x.

This release is feature complete. It is recommended for use in production environments.

It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

This post will show how to use Connector/NET and Windows Store Apps in Windows 8 to connect and retrieve data from a MySql Server database.

Does size matter? This question has been teasing mankind since the beginning. But now, due to improvements in technology, size doesn’t really matter. Databases now have the features to tackle all data: big, medium, small, or very small. This Log Buffer Edition is here once again to bring you your data news of all sizes.

Oracle:

Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.

Niall installs …

We know very well that database technologies need a blog presence, and how to best offer that blogging experience — without the danger of boredom — is something tons of Oracle, SQL Server, and MySQL bloggers continue to show through Log Buffer. Enjoy!

Oracle:

Various approaches exist to organize your groovy scripts and package up utilities.

Oracle Certification announces the release of the new Oracle Linux 6 certification paths.

Designed for the Cloud, the new multitenant architecture of Oracle Database 12c now enables customers to greatly simplify and accelerate database consolidation by …