Tuesday Oct 18, 2016

MySQL Cluster 7.5 Is Now GA!

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.5.4 GA release!

The development focus has been on improving overall performance and ease of use, combined with improved SQL support and the introduction of read optimized and fully replicated tables, all of which allow for better support of a variety of use cases. 

Use Case: Hadoop Performance Records Smashed by Hops and MySQL Cluster--delivers over 1.2 million operations per second

The key enhancements delivered by MySQL Cluster 7.5 are summarized below:

Improved Performance: Improvements in index/range scan performance and internal thread handling will allow for better use of existing hardware and a better overall user experience.

Improved Ease-of-Use: Improved logging and SQL views offer greater insight into the current configuration, state, and general database operations, all of which helps to decrease maintenance and support costs, increasing your ability to resolve issues early enough that they don't become bigger user impacting problems.

MySQL 5.7 Support: Developers can combine the InnoDB and MySQL Cluster NDB storage engines within a single database, using the very latest MySQL 5.7 release. This includes NDB support for the new native JSON data type, Generated Columns, and more!

Increased Capacity: With support for 128TB+ data set sizes per data node you can better utilize the much bigger commodity machines available today, which increases your ability to scale-up, in addition to scaling out.

Improved Read Scalability: You can mark all or individual tables as being read-optimized, thus effectively doubling your read throughput at the cost of slightly slower writes--a feature that is ideal for read-mostly tables. You can also declare some tables as being "global" or fully replicated--a feature that is ideal for lookup or fact tables which are relatively small, static, and often joined against (e.g. City, State, Product Type, etc.). These two features can greatly improve overall data locality--meaning that the data used for more complex queries (e.g. scans and joins) is local to a given data node, allowing you to avoid costly overhead associated with cross-node/cross-shard network communication and transaction management. 

You can see the full MySQL Cluster 7.5 changelogs here, and the online manual hereIf you're considering MySQL Cluster for a new application, please also see the Evaluation Guide.

Download the source and binaries today and get started now!  

Tuesday Sep 20, 2016

MySQL Enterprise Monitor 3.3 Is now GA!

Enterprise Backup Dashboard

We're very happy to announce the general availability of the next release of MySQL Enterprise Monitor, version 3.3 (see the full changelog here). This is the best in class tool for monitoring and management of your MySQL assets, included with your MySQL Enterprise Edition subscription.

What's New?

Backup Dashboard -- The new Backup Dashboard brings deeper integration with MySQL Enterprise Backup and provides key visibility into critical backup activities, allowing you to easily ensure that your most valuable assets are protected against data loss. Visually monitor high level backup metrics for your entire MySQL topology or individual groups, and drill in to view all key metrics and details for individual backups of specific instances. Best Practice Advisors also help you ensure that your backup jobs are running as expected by proactively alerting you when potential problems are detected.

Named Filters -- The UI now makes honing in on common problems even easier with support for "named filters". You can use these shortcuts to quickly select your preferred search criteria on views throughout the product, such as those for: Instances, Events, Query Analyzer, and the All Timeseries Graphs. We also now include some pre-defined filters for: "MySQL Instances using an EOL version", "Old MySQL Enterprise Monitor Agent Installations", "Currently Open Emergency Events", and more. In addition to the pre-defined filters, you can easily assign a name to your own favorite search conditions for easy reuse across sessions. 

You can download MySQL Enterprise Monitor 3.3 from My Oracle Support or Oracle Software Delivery Cloud. You can find the complete documentation here. If you have any questions or encounter any problems, please let us know by opening a support ticket or filing a bug report. If you're not already a MySQL Enterprise customer, start your free 30 day trial today

Thank you for using MySQL! 

Monday Sep 19, 2016

The #1 Open Source Database Now Available in Oracle Cloud

We're very excited to announce the General Availability of Oracle MySQL Cloud Service!

Oracle MySQL Cloud Service allows you to accelerate innovation and to rapidly, securely and cost-effectively develop & deploy modern applications powered by the world’s most popular open source database.

Built on the proven MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise-ready cloud service that enables organizations to deliver MySQL-based applications globally at scale.

Check out the Oracle MySQL Cloud Service video for a rapid overview:

The only public cloud service integrating MySQL Enterprise Edition, Oracle MySQL Cloud Service empowers developers and ISVs with the most comprehensive MySQL offering in the cloud, including advanced features, tools and technical support to accelerate the time to market of new modern applications. Customers benefit from:

  • Automated & Effective Management: Best-in-class Oracle management tools including web-based cloud tooling, MySQL Enterprise Backup, MySQL Enterprise Monitor, MySQL Query Analyzer, MySQL Workbench and integration with Oracle Enterprise Manager reduce administrative efforts and costs.
  • Multi-layered Security: Enterprise-grade security features such as network access control, MySQL Enterprise Firewall, MySQL Enterprise Authentication, MySQL Enterprise Encryption, MySQL Enterprise Transparent Data Encryption and MySQL Enterprise Audit help customers achieve regulatory compliance and ensure data is protected against external attacks and misuse of information.
  • Developer Enablement & Integrations: Pre-integration with Oracle Cloud Platform Application Development offerings such as Oracle Java Cloud Service and Oracle Application Container Cloud Service enables developers to quickly spin up a development environment. Pre-integration with Oracle Cloud Infrastructure gives them the choice to for example backup data to Oracle Storage Cloud.
  • Global Scalability: Developers & ISVs can instantly scale their applications globally relying on Oracle Cloud. Automated scaling enables users to elastically scale compute and storage resources as well as MySQL replicas. The MySQL Thread Pool provides sustained performance and scalability facing ever increasing user, query and data loads.
  • Hybrid Deployments: Relying on the exact same database platform and tools on premises and in the cloud allows customers to quickly and easily migrate existing applications to the cloud, move workloads between on-premises deployments and the cloud and architect hybrid deployments.
  • Expert Technical Support: Technical support is provided directly by the MySQL experts, backed by the engineers that develop MySQL solutions, to solve customer’s most complex issues and help them make the most of their MySQL deployments. Additionally, Oracle Premier Support gives customers a one-stop support solution for both cloud infrastructure and MySQL related issues.

Learn more and try it out now!

Digital disruptors rely on MySQL. The #1 Open Source Database in now available in the Oracle Cloud; it’s never been easier to rely on MySQL to drive your digital transformation initiatives and beat the competition. Innovate with Oracle MySQL Cloud Service!

Tuesday Sep 06, 2016

Plan Your MySQL Sessions @ OpenWorld with My Schedule

Oracle OpenWorld is right around the corner and now is the time to plan your agenda! My Schedule enables you to effectively plan your conference and reserve you seat in sessions. You’ll also get notified of potential updates. Last year we had to turn down folks for a number of MySQL sessions so it does make sense to book your seat in advance...