News about Oracle's Solaris and Sun Hardware
System News
Sep 22nd, 2014 — Sep 28th, 2014 Generate the Custom HTML Email for this Issue
System News System News for Sun Users
Volume 199, Issue 4 << Previous Issue | Next Issue >>
Sections in this issue:
click to jump to section

Why SQL is becoming the goto language for Big Data analysis
Technically superior
Keith Laker writes, "Since the term big data first appeared in our lexicon of IT and business technology it has been intrinsically linked to the no-SQL, or anything-but-SQL, movement. However, we are now seeing that SQL is experiencing a renaissance. The term 'noSQL' has softened to a much more realistic approach "not-only-SQL" approach. And now there is an explosion of SQL-based implementations designed to support big data. Leveraging the Hadoop ecosystem, there is: Hive, Stinger, Impala, Shark, Presto and many more. Other NoSQL vendors such as Cassandra are also adopting flavors of SQL. Why is there a growing level of interest in the reemergence of SQL? ..."
MySQL Workbench 6.2.3 GA has been released
New version of the official MySQL graphical development tool
MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

  • A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and taking advantage of the new GIS capabilities in MySQL 5.7.
  • Support for new MySQL 5.7.4 SQL syntax and configuration options.
  • Metadata Locks View shows the locks connections are blocked or waiting on.
  • MySQL Fabric cluster connectivity - Browsing, view status, and connect to any MySQL instance in a Fabric Cluster.
  • MS Access migration Wizard - easily move to MySQL Databases.

Other significant usability improvements were made, aiming to raise productivity for advanced and new users:

Latest MySQL 5.7 Development Milestone Release Enhances Database Performance and Manageability
New release delivers 645,000 SQL queries per second and more than 1 million NoSQL queries per second in benchmark tests
Oracle announced a new development milestone release for MySQL 5.7. Continuing to meet the demands of today's web, cloud, and embedded applications, the new release further extends the performance, scalability, and reliability of MySQL, the world's most popular open source database, while enhancing management capabilities. Oracle also announced several additional MySQL product releases and early access features as well as the availability of MySQL source code on
MySQL Notifier 1.1.6
Enables developers and DBAs to easily monitor, start and stop all their MySQL database instances

The MySQL Windows Experience team is proud to announce the release of MySQL Notifier version 1.1.6.

MySQL Notifier enables developers and DBAs to easily monitor, start and stop all their MySQL database instances. It provides a familiar Microsoft SQL Server look and feel and integrates with MySQL Workbench.

MySQL Notifier is installed using the MySQL Installer for Windows which comes in 2 versions:

  • Full (150 MB) which includes a complete set of mysql products with their binaries included in the download
  • Web (1.5 MB - a network install) which will just pull the MySQL Notifier over the web and install it when run.

You can download MySQL Installer from our official Downloads page.

MySQL for Excel 1.3.2 GA
An application plug-in enabling data analysts to very easily access and manipulate MySQL data

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

  • Importing MySQL data into Excel
  • Exporting Excel data directly into MySQL to a new or existing table
  • Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for Windows which comes in 2 versions...

Oracle OpenStack for Oracle Linux
Enterprise-scale solution for OpenStack allows extended deployment options to best fit customers' needs; supports latest OpenStack Icehouse release
Ronen Kofman writes that Oracle has announced "the general availability of Oracle OpenStack for Oracle Linux 1.0. With this announcement we are now providing production OpenStack support to Oracle Linux and Oracle VM customers. The support for OpenStack is available as part of the Oracle Linux and Oracle VM Premier Support at no additional cost..."
Oracle Linux 5.11 is now available
Eleventh and final update release for Oracle Linux 5
Michele Casey writes, "We're happy to announce the availability of Oracle Linux 5.11, the eleventh and final update release for Oracle Linux 5. ISO images will soon be available from the Oracle Software Delivery Cloud and the individual RPM packages have already been published to our public yum repository. This release includes the Unbreakable Enterprise Kernel Release 2 (2.6.39-400), Oracle's recommended kernel for Oracle Linux. For further details, please see the Oracle Linux 5.11 Release Notes.

Oracle Linux can be downloaded, used and distributed free of charge and updates and errata are freely available..."

SPARC Processor Documentation
Systems Documentation
Darryl Gove writes, "I'm pretty excited, we've now got documentation up for the SPARC processors. Take a look at the SPARC T4 supplement, the SPARC T4 performance instrumentation supplement, the SPARC M5 supplement, or the familiar SPARC 2011 Architecture..."
In-Memory Query Acceleration of Oracle Database
Using Software in Silicon Technology in Oracle's SPARC M7 microprocessor

With the growing size of information stored in today's databases, accessing and using the right information has become increasingly critical. Compression of the stored data to contain the storage footprint is a key business proposition in every IT system design. At the same time, being able to access, decompress and run queries faster on the stored data is the burning need of any enterprise performing analytics to shape their future business. Oracle software engineers have incorporated various features into the Oracle Database to effectively leverage the hardware resources such as cores, IO channels, and memory of the underlying server. Oracle Database follows a 'shared everything architecture' which allows flexibility in parallel execution and high concurrency without overloading the system.

Oracle's focused investment in various technologies has allowed unparalleled innovation across the stack from Application to Hardware...

ZFS storage appliance Simulator
By UnixArena
Lingeswaran writes, "You can download the ZFS storage appliance from oracle. This is a pre-built virtual machine simulating the actual Sun ZFS Storage Appliance that comes with the Oracle Super Cluster. Here we will see how to install and configure ZFS storage appliance for demonstration purpose..."
Top Ten Articles for last few Issues
Vol 199 Issues 1, 2 and 3; Vol 198 Issues 1, 2, 3, 4 and 5;
We track how frequently each article is viewed on the web site to determine which the readers consider the most important. For last week, the top 10 articles were:

  • Oracle Board Appoints Larry Ellison Executive Chairman and CTO
  • Reliable, Scalable, Secure: Oracle Solaris 11.2
  • Oracle Developer Cloud Service is Live!
  • How-To: Creating Oracle Solaris 11 Zones
  • Choosing 64 and/or 32 bit Java
  • Oracle SAAS And PAAS Cloud Revenue Up 32%, Software And Cloud Revenue Up 6% To $6.6 Billion
  • How to Install and Configure a Two-Node Cluster for Oracle Solaris Cluster 4.1 Using SR-IOV/IB Interfaces
  • Making Sure Your Exadata Is Running Right
  • Solaris Cluster 4.2 is available with Solaris Cluster Manager GUI
  • MySQL Cluster - What You Need To Know

The longer version of this article has list of top ten articles for the last 8 weeks.

    Creating a Server Pool for Oracle Solaris 11 Zones
    Big advantages to pooling your zones

    Owen Allen writes, "I talked a bit last week about creating Oracle Solaris 11 zones by following the zone creation how-to. If you're creating zones on at least two systems, it's a good idea to create a server pool for them. A zones server pool lets you group 2 or more global zones (hosts) that have the same processor architecture. The hosts must share storage resources and have access to the same virtual and physical networks..."

    Oracle VM Server for SPARC
    New maintenance release

    Jeff Savit writes, "A new maintenance release to Oracle VM Server for SPARC has been released, providing several enhancements described in the What's New page. This update adds support for private VLANs and relieves virtual I/O scalability constraints. This was already announced in the Virtualization Blog, but the I/O scalability improvement deserves further discussion.

    Previous blog entries have described scalability improvements that improve virtual disk and network I/O performance. This new update adds scalability in a different context, by increasing the number of virtual I/O devices a domain can have..."

    Java Technology
    2014 Duke's Choice Award Winners
    12th year of the Duke's Choice Awards
    Caroline Kvitka writes, "In this, the 12th year of the Duke's Choice Awards, we are proud to recognize 12 winners for their innovative uses of Java. The 2014 winners are an eclectic bunch of developers, innovators, and educators. Some are using the Java platform to address real-world challenges to improve road and air safety, assist refugees, and increase grain crop quality and quantity to help feed the hungry. Others are promoting Java in home automation and game development, solving important technical issues, educating Africa's Java community, and hoping to resolve a longstanding community debate.

    The 2014 Duke's Choice Award winners are..."

    Spotlight on GlassFish 4.1: #11 Enable Remote Admin
    highlights specific enhancements of the latest GF release
    "When you unzip GlassFish 4.1, the Administration user has no password set. This was introduced quite some time ago to simplify the developer experience. For obvious security reasons, the remote admin capabilities are also disabled. So the default Admin user is 'admin' and its password is empty.

    To enable remote Admin, you should first define a password for the admin user and then enable remote admin. The trick is that the change-admin-password command is asking the admin password, in that case you should leave it empty..."

    Trending in
    Vol 229, Issue 4
    Trending IT Articles