November 19, 2013 By Severalnines

The Severalnines team is pleased to announce the release of ClusterControl 1.2.4. This release contains key new features along with performance improvements and bug fixes.

We have outlined some of the key features below. For additional details about the release:

• 1.2.4 ChangeLog
• Documentation
• Upgrade instructions
  • Manual upgrade instructions
  • …

Dear MySQL users,

The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.8.

MySQL Workbench 6.0 is the new version the GUI Development and Administration tool for MySQL. This maintenance release contains over 50 bug fixes since version 6.0.7

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model Synchronization, lets you compare and update your EER model or database with ALTER scripts and properly handle corner cases involving objects renamed externally or sync schemas with different names
• improved support for model printing to PDF files

• all …

Dear MySQL users,

The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.7, a maintenance release for the new MySQL Workbench 6.0

MySQL Workbench 6.0 is the new major update of the GUI Development and Administration tool for MySQL. This version contains more than 30 new features and a redesigned, more modern UI. Over 200 enhancement requests and bugs filed by the community have been addressed since version 5.2.47. This release fixes over 20 bugs encountered since version 6.0.6

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model Synchronization, lets you compare and update your EER model or database with …

I checked some updates to Shard-Query into SVN. Partitioning support has been extended for MySQL 5.6+ to ALL partitioning types.

This includes all previously unsupported types including RANGE LIST/COLUMNS partitioned tables that are partitioned over more than one column, and HASH/KEY/LINEAR variants as well. Shard-Query now exclusively uses the PARTITION hint for partition elimination instead of WHERE clauses in MySQL 5.6. For 5.5 and previous versions, support remains limited to LIST,RANGE, and LIST/RANGE COLUMNS over a single column.

The old mysql interface DAL has been replaced completely by the PDO DAL.

There is no major difference for end users except that you have to check that the return of the query() method is an object with the is_object() function instead of checking that it is a resource with the is_resource() function. I updated bin/run_query, which is the example application.

I …

Dear MySQL users,

The MySQL developer tools team at Oracle is excited to announce the first GA (Generally Available) release of MySQL Workbench 6.0.6.

MySQL Workbench 6.0 is the new major update of the GUI Development and Administration tool for MySQL. This release contains more than 30 new features and a redesigned, more modern UI. Over 200 enhancement requests and bugs filed by the community have been addressed since version 5.2.47

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model Synchronization, lets you compare and update your EER model or database with ALTER scripts and properly handle corner cases involving objects renamed externally or sync …

The MySQL Developer Tools team is pleased to announce the availability of MySQL Workbench 6.0.5 Release Candidate. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes over 200 bug fixes and implemented enhancement requests, 30 new features and a new redesigned UI. As a development version, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

As always, MySQL Workbench is natively available on Windows, Mac, Linux.

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model …

The MySQL Developer Tools team is pleased to announce the availability of the third beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes almost 200 bug fixes (~40 since 6.0.3), 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

As always, MySQL Workbench is natively available on Windows, Mac, Linux.

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model Synchronization, lets you …

What is Amazon Redshift and how does it compare to Shard-Query?

Amazon Redshift is the petabyte scale data warehousing system built by Amazon.   It is (currently at the time of this writing)  a beta-quality data warehouse as a service platform hosted in the AWS cloud.   It has has been built from ParAccel technology.  Amazon is an investor in ParAccel.

Amazon Redshift works similarly to Shard-Query.   Both systems allow you to spread data over many machines and treat them as one logical machine.  This architecture  is called “shared nothing” and it has developed the short name “sharding”.

Both systems essentially provide a “virtual database” composed of smaller database.  It is like a RAID array of databases.  You could think of it as a “redundant array of independent databases” in fact.

Sharding

Both Redshift and Shard-Query shard your data …

The MySQL Developer Tools team is pleased to announce the availability of the second beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes over 150 bug fixes (~40 since 6.0.2), 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

As always, MySQL Workbench is natively available on Windows, Mac, Linux.

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model Synchronization, lets you …

I posted the slides to my talk on SlideShare.  This talk includes high level information about Shard-Query, why it is needed, and the kind of schema it works well with.
http://www.slideshare.net/MySQLGeek/introduction-to-shard-query-m

You can also find a more technical information about Shard-Query and the how it works here:

Divide and conquer in the cloud from Justin Swanhart