System News for Sun Users

MySQL 5.0 and 5.1 available on Solaris 11

2012-01-24T17:00:00+01:00

MySQL 5.0 and 5.1 are now available for Solaris 11. A post on the Solaris and Systems Information for ISVs site all but performs the install (which it calls "as simple as typing) for you.

MySQL: An Introduction for Oracle DBAs

2012-01-23T17:00:00+01:00

Working from the assumption that there are DBAs with MySQL sitting idle on their corporate servers, Patrick Hurley was written "MySQL: An Introduction for Oracle DBAs," which employs a comprehensive approach that begins with connecting to MySQL and extends through such necessaries as determining which sessions are currently connected to MySQL; which users are defined and what is the scope of their authority; what are the techniques for backup and restore; and how does one install MySQL. This is truly introductory but nevertheless useful material, especially for DBAs who have not wet their feet in the mysterious MySQL waters.

Download MySQL Enterprise Backup 3.7.0

2012-01-16T17:00:00+01:00

MySQL Enterprise Backup 3.7.0 (MEB 3.7.0) is available with several advanced features that include:

Redo Log only Incremental Backup
Incremental Backup without specifying LSN
Validation of Backup Image using checksums
Hot Backup of InnoDB .frm files
Performance Improvements and
Enhancements for Third-Party Media Managers

Users can download the MEB 3.7.0 package from the Oracle Software Delivery Cloud web site. MySQL Enterprise customers can deploy MEB 3.7.0 immediately, while users without a MySQL Enterprise license can evaluate MEB 3.7.0 free for 30 days with the request send feedback to mysql-backup_ww@oracle.com.

Oracle Database Firewall Extended to Support MySQL

2012-01-09T17:00:00+01:00

Several important new features are included in the latest release of Oracle Database Firewsall. Among them is protection against data breaches extended to MySQL databases. In addition, there are now various reporting capabilities that include 10 new out-of-the-box reports to further help organizations comply with privacy and regulatory mandates, and a new reporting infrastructure for running and modifying the layout of existing reports. Oracle Business Intelligence Publisher customers will now be able to take advantage of all capabilities offered for authoring, managing, and delivering highly formatted documents that can be designed using familiar desktop products.

More Information

MySQL Enterprise Edition Produces 65% Cost Cuts at Globo.com

2012-01-09T17:00:00+01:00

Using MySQL Enterprise Edition Globo.com improved the performance and scalability of its web portal while improving flexibility and reducing costs by 65%. Globo.com set up a copy of MySQL Workbench in DBA's computers, ensuring autonomy for data modeling. The company also adopted a decentralized server architecture, freeing the IT team from its previous efforts at balancing network load. This structure enabled Globo.com to accommodate large traffic spikes without compromising site performance, such as 9.8 million Web visits and 31.5 million page views in one day during the 2010 World Cup.

CRN Includes MySQL 5.6 in 10 Best Wins Best Open Source Product of 2011 Awards

2011-12-19T17:00:00+01:00

CRN has named MySQL 5.6 as among the 10 best open source products for 2011, Bertrand Matthelie reports on Oracle's MySQL Blog. He quotes the CRN announcement, which said, "MySQL 5.6, now in beta, includes significant advances in text-based search inside a database, as well as performance enhancements. With the growth of the world's data set to explode like never before with the advent of data-capturing and data-creating mobile devices, MySQL 5.6 is firmly in place as the strongest open-source database.'

MySQL Enterprise Monitor 2.3.8 Mainjtenance Release in General Availability

2011-12-09T17:00:00+01:00

Readers can find MySQL Enterprise Monitor 2.3.8, a maintenance release that fixes several bugs, in General Availability on the My Oracle Support (MOS) web site and, within one or two weeks, on the Oracle Software Delivery Cloud. Similarly, binaries for the new release are also available on the MOS site and the Oracle Software Delivery Cloud. The changelog contains full details on this release.

Meet the MySQL Experts Podcast: Focus on Backup

2011-12-05T17:00:00+01:00

On a recent episode of the Meet the MySQL Experts Sveta Smirnova from the MySQL technical support organization provides an overview of the common MySQL backup practices and tools, specifically the benefits of using MySQL Enterprise Backup. MySQL Enterprise Backup provides hot online backup for InnoDB, which has been one of the most requested features from the MySQL user community for years.

Windows Native Authentication for MySQL

2011-10-17T16:00:00+01:00

With the release of MySQL 5.5.16 users can set up a password-less connection from clients into MySQL server using Windows SSPI authentication framework that is provided by the Windows Native Authentication (WNA) plugin distributed with the commercial version of 5.5.16 server. This information, along with the procedure for administrators needing to install the WNA plugin, is contained in the blog from oracle.com entitled "Windows Native Authentication for MySQL."

Synchronously Replicating Databases Across Data Centers

2011-10-15T16:00:00+01:00

Readers will find a generalized discussion of one of the most important features in MySQL Cluster 7.2, namely, Multi-Site Clustering, in Mat Keep's blog. While, as Keep points out, MySQL has long offered Geographic Replication, Multi-Site Clustering enables the deployment option of splitting data nodes across data centers. This feature, he writes, allows users to synchronously replicate updates between data centers with no need to modify applications or schema for conflict handling.

MySQL HA Solutions: New Guide Available

2011-10-05T16:00:00+01:00

The newly released MySQL Guide to High Availability Solutions is designed to navigate users through the HA maze, discussing in turn the causes, effects and impacts of downtime; methodologies to select the right HA solution; and different approaches to delivering highly available MySQL services. The discussion of these issues is framed in terms of three core principles:

The level of availability required to meet business objectives, within budgetary constraints
The profile of application being deployed (i.e. concurrent users, requests per second, etc.)
Operational standards within each data center

The guide leads users to the correct choices to ensure business continuity whether in internal departmental applications or geographically redundant, multi-data center systems delivering 99.999% availability.

New Commercial Extensions Worry MySQL Community

2011-09-26T16:00:00+01:00

A number of open-source devotees are not all that happy with Oracle's decision to follow the dual-licensing path for MySQL, given the querulous response to the release of three new commercial extensions. But, insists Brian Profitt in ITWorld, part of Oracle's agreement with the European Union Commission for being allowed to go through with the acquisition of Sun was the promise that Oracle would continue to support the dual-license scheme until January 28, 2015. Until then users will have to live with commercial and open licenses and just wait for the possibility of a proprietary, Profitt writes.

New Commercial Extensions for MySQL Enterprise Edition

2011-09-19T16:00:00+01:00

There are now three new commercial extensions to MySQL Enterprise Edition, which are:

MySQL Enterprise Scalability: Thread Pool
MySQL Enterprise High Availability: Features Oracle VM Template for MySQL Enterprise Edition and Windows Server Failover Clustering
MySQL Enterprise Security: Allows users to be authenticated using external libraries, directories, etc.

MySQL Quickstart Fundamentals On Demand Webcast

2011-09-14T16:00:00+01:00

In this On Demand webcast, Ron Soltani, a Principal Instructor at Oracle University, explains what's new in MySQL 5.5 and how to configure MySQL Server easily. Soltani's presentation topic include introduction of InnoDB as MySQL's default Storage Engine Management; improved availability and usability; and steps to configure and setup MySQL server easily. Registration and log in are required.

New MySQL Installer for Windows is GA

2011-09-12T16:00:00+01:00

As reported elsewhere in this issue of System News, MySQL Installer for Windows has been released to General Availability, according to Bertrand Matthelie's blog. MySQL Installer for Windows takes only a few minutes from downloading the MySQL Installer to having a ready-to-use MySQL system on your machine, radically simplifying the installation process for all MySQL users on the Windows platform. Oracle's certification for Windows Failover Clustering expands the range of High-Availability solutions available for MySQL on Windows, which previously included replication and MySQL Cluster.

Oracle Releases MySQL Installer for Windows

2011-09-07T16:00:00+01:00

Oracle's newly released MySQL Installer for Windows enables users to provision and deploy MySQL in minutes, allowing developers and DBAs to accelerate time to market. Oracle has in addition completed certification of MySQL Enterprise Edition for Windows Server 2008 R2 Failover Clustering, which enables Windows users to deploy business-critical applications that demand high levels of availability.

MySQL Enterprise Monitor 2.3.6 Now in GA

2011-09-07T16:00:00+01:00

Oracle announces the GA release of MySQL Enterprise Monitor 2.3.6, now available for download on the My Oracle Support (MOS) web site. It will shortly be available via Oracle E-Delivery as well. This is a maintenance release that fixes a number of bugs. More information on the contents of this release are available in the changelog. Binaries for the new release are available on My Oracle Support.

MySQL Relational Database Management

2011-08-31T16:00:00+01:00

Oracle University is presenting a two part series of free webinars on MySQL. The first, available now, is devoted to MySQL Relational Database Management with Angeliki Korovesi. She intends to cover the importance of MySQL; MySQL architecture; management; high availability; and backup and recovery. Registration and log in are required.

�Meet The MySQL Experts� Podcast Series

2011-08-31T16:00:00+01:00

From Oracle's MySQL blog comes the announcement by Bertrand Matthelie that the 2nd episode of the 'Meet The MySQL Experts' podcast series, where Oracle engineers share their expertise, is now available. In this episode Wei-Chen Chiu interviews InnoDB team member Inaam Rana, who discourses on the new InnoDB features and improvements delivered in MySQL 5.5 as well as in the first development milestone release of MySQL 5.6. Inaam also shares his views about the InnoDB features available in labs.mysql.com.

MySQL Newsletter August 2011

2011-08-18T16:00:00+01:00

The MySQL Newsletter for August 2011 highlights a number of upcoming events and includes as well articles on "MySQL Early Access Features -- InnoDB and Replication"; a MySQL Enterprise Edition demo; and two live Webinars: "What's New in mySQL 5.6, Part 1" and "MySQL Essentials for ISVs and OEMs, Part 1: Faster Development and Better Applications with MySQL workbench." The three-minute demo of MySQL Enterprise Edition is designed to help viewers understand how the solution reduces the risk, cost and time required in developing, deploying and managing business-critical MySQL applications. The Webinar on MySQL 5.6 (one of five parts) covers the improvements to Performance, InnoDB, Replication, Instrumentation and flexibility with NoSQL (Not Only SQL) access. The Webinar on MySQL Essentials reviews the versatility of MySQL Workbench, a visual database modeling and design tool, a SQL editor, and an administrative tool.

MySQL 5.6 Replication

2011-08-10T16:00:00+01:00

Further comments on the MySQL doings at OSCON include Mat Keep's observations on "MySQL 5.6 Replication - New Early Access Features."] Among the new features Keep mentions are te Binlog API; Binlog Group Commit and Enhanced Multi-Threaded Slaves; and durable Slave Reads. These new features build on the significant replication enhancements announced as part of the MySQL 5.6.2 Development Milestone Release back in April, Keep writes. This new functionality, which is focused on better integration, performance and data integrity, is available for evaluation now and can be downloaded today from http://labs.mysql.com/. Keep provides links to further information on each of these new features.

More New MySQL 5.6 Early Access Features

2011-08-10T16:00:00+01:00

Interest in MySQL could not have more clear at OSCON in Portland, where the many MySQL developers meeting with the MySQL community, conducting technical sessions, leading BOF sessions, and working the exhibit hall confirmed Oracle's leadership in the technical evolution of MySQL. The highlight of the week was the unveiling of even more 5.6 early access InnoDB and Replication features that are now available for early adopters to download, evaluate and shape via labs.mysql.com. InnoDB is one of MySQL's "crown jewels" and, beginning in 5.5, became the default storage engine. Replication is turning out to be by far the most popular and widely used MySQL feature.

Early Access to MySQL 5.6 New Features

2011-07-28T16:00:00+01:00

Early access to new features of MySQL 5.6, which focus on better scalability, performance and flexibility, is available for the community to test, deploy and provide feedback. Enhancements include the InnoDB storage engine, to provide support for full text search, greater performance for write-intensive applications, and better scalability under high concurrency/user loads.

In addition, new and improved MySQL replication features help with performance, scale-out and data integration. The following MySQL 5.6 early access features are available for community testing and feedback:

InnoDB Full-Text Search
InnoDB Buffer Pool Pre-loading Options
Larger InnoDB Redo Log Files
Binlog Group Commit
Binlog API

This opportunity provides users the chance to offer feedback on features that will eventually move into future Development Milestone and General Availability Releases.

MySQL Cluster Manager 1.1.1 Available for Free Download, 30-Day Trial

2011-07-25T16:00:00+01:00

"While managing clusters will never be easy, it keeps getting a whole lot simpler," or so writes Mat Keep in his blog post "Simpler and Safer Clustering: MySQL Cluster Manager Update." He writes further that, with MySQL Cluster Manager 1.1.1 now released to General Availability it is much simpler to get up and running and to manager a cluster or even multiple clusters from a single process. MySQL Cluster Manager 1.1.1 is available free for a 30-day trial at Oracle eDelivery, Keep notes, pointing out as well the numerous upgrade operations that can easily be performed online. He draws attention to the whitepaper on MySQL Cluster Manager and to the online demo as well.

The Oracle VM Template for MySQL Enterprise Edition

2011-07-20T16:00:00+01:00

The Oracle VM Template for MySQL Enterprise Edition is the fastest, easiest and most reliable way to provision virtualized MySQL instances, enabling users to meet the explosive demand for web-based services. The July 13, 2011 webinar dealt with how the Oracle VM Template for MySQL Enterprise Edition ensures rapid deployment and helps eliminate configuration efforts and risks by providing pre-installed and pre-configured virtualized software image, also taking advantage of Oracle VM's mechanisms to deliver high availability. The one hour webinar covered:

- An overview of the technologies packaged into the template - How to configure and deploy the template - How to use, modify and save an adapted template that supports specific application requirements

New �Meet The MySQL Experts� Podcast Series

2011-07-20T16:00:00+01:00

To keep users up to date on enhancements to the several MySQL products in Oracle's line there is now a new podcast series that is called "Meet the MySQL Experts." The first episode featured Oracle MySQL engineer Mats Kindahl on the subject of MySQL Replication. Registration and log in are required.

MySQL Enterprise Backup 3.6: Free Download, 30-day Trial

2011-07-20T16:00:00+01:00

MySQL Enterprise Backup 3.6 got the attention of blogger Rob Young who posts that MySQL Enterprise Backup (MEB) performs high performant, online "hot" backups for MySQL databases and provides all of the backup/recovery features and functionality from a scriptable command line interface. Young is especially gratified to find Single File Streaming, which allows DBAs to offload the footprint of backup images to a different server or storage device without an intermediate "save" step on the local MySQL database server. He is also enthusiastic about the inclusion of support for SBT interface, which enables the DBA to generate and stream MySQL backup images directly to advanced enterprise backup media management solutions (Oracle Secure Backup, Symantec Netbackup, most others) that are already deployed within an environment. MEB 3.6 is available for free download and 30-day trial at Oracle eDelivery.

Oracle VM Template for MySQL Enterprise Edition Released

2011-06-28T16:00:00+01:00

Developed to enable more efficient and lower cost deployments of virtualized MySQL environments, the first Oracle VM Template for MySQL Enterprise Edition was recently announced by Oracle. The new template helps eliminate manual configuration efforts and risks by providing a pre-installed, pre-configured and certified software stack that includes Oracle VM Server for x86, Oracle Linux with the Unbreakable Enterprise Kernel and MySQL Enterprise Edition. Oracle VM Templates greatly simplify installation, configuration and ongoing maintenance operations, allowing organizations to achieve faster time to market and to reduce costs, according to the Oracle press release. Users will benefit from faster deployments, increased reliability, and higher uptime with the Oracle VM Template for MySQL Enterprise Edition.

MySQL Enterprise Edition Demo

2011-06-21T16:00:00+01:00

Spend three minutes viewing the new MySQL Enterprise Edition Flash demo, urges Bertrand Matthelie in his post on Oracle's MySQL Blog. The demo will show viewers how Oracle's MySQL Enterprise Edition reduces the risk, cost and time required in developing, deploying and managing business-critical MySQL applications, he writes. Also included in the post are links to the MySQL Enterprise Edition Trial and to relevant whitepapers. (Registration and log in are required.)

New GA Release: MySQL Enterprise Monitor 2.3.4

2011-06-13T16:00:00+01:00

Oracle announces that MySQL Enterprise Monitor 2.3.4 is now GA, and available for download on the My Oracle Support (MOS) and Oracle E-Delivery web sites. Oracle describes the download as a "maintenance release that fixes a number of bugs and contains some new features, including graph export."