Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 30

Displaying posts with tag: enterprise (reset)

MEB : The journey so far 2010-2013
Employee +4 Vote Up -0Vote Down

MySQL Enterprise Backup (MEB) was born 3 years ago as a newly branded avatar of InnoDB Hot backup. Wanted to share what has gone on so far, how we at Oracle think about backup, the milestones that we have achieved and the road ahead. The idea for this blog came to me after looking at Mikael's latest blog. While Mikael talks about MySQL, I want to talk about MEB.

When we started with InnoDB Hot backup the first challenge was to have it adhere to the development, quality and release processes for MySQL. This meant creating a quality plan, getting it into the development trees of MySQL and ensuring that each piece of new code went through architecture and code review. Though the initial implementer and architect of Hot backup continues to work with the MEB team, there

  [Read more...]
About MySQL 5.6
+14 Vote Up -2Vote Down

I am very excited and thrilled to use the latest release of MySQL 5.6 in production.

This is probably the most notable and innovative release in many years, if not ever.

During the last year, we had the chance to work with many new features and to test if the fixes to old issues were working fine.

To be honest, I was expecting to have MySQL 5.6 GA before now, and I even wagered with my colleague Francisco that it would be out before the end of 2012.

Nothing special just a beer in the Santa Clara Hyatt lounge.

Unfortunately for me, MySQL 5.6 is now in GA and given that it happen in 2013, I lost the bet and now have to pay for that beer.

But I have also lost the full list of things that we saw as relevant, interesting, or really innovative for MySQL.

So I took a step back, took my time, and reviewed what Oracle delivered in this new MySQL release.

  [Read more...]
Truly Parallel backup (MySQL Enterprise Backup 3.8 and later)
Employee +0 Vote Up -0Vote Down
How do you implement a parallel algorithm for a software which needs to be streamed to tapes?
How do you ensure that you have the capability to be able to tune the level of parallelism for varying input and output devices and varying levels of load?
These were some of the questions that we needed to answer when we were trying to implement multi-threading capability for MySQL Enterprise Backup (MEB).
The trivial way of achieving parallelism is by having the multiple threads pick up the different files (in a file per table) scenario. But this did not seem adequate because:
a) The sizes of these files (corresponding to the tables) could be different and then one large file would limit the level of parallelism since it would be processed by a single thread.
b) If you have to stream the backup how do you reconcile these




  [Read more...]
MySQL Enterprise Backup 3.8.1 release for 5.6 Server
Employee +0 Vote Up -0Vote Down

The MySQL Enterprise Backup 3.8.1 release's main goal was support MySQL 5.6 server. But also beyond that primary goal MEB team added some valuable new options and features to ensure you'll get most from the new features in 5.6 as well. At a glance, here are some of the highlights,

MEB copy of InnoDB undo log tablespaces

MySQL 5.6 introduces a new feature to store undo logs in separate files called as undo tablespaces for improved performance. These undo tablespaces are logically part of system  tablespace. All the commands associated with MEB - "backup", "apply-log" and "copy-back"  now take care of the undo tablespaces in the same way as they process the system tablespace. MEB now supports innodb_undo_directory[logs][tablespace] option variables. When backup is executed, undo datafiles (up to number

  [Read more...]
Redehost Transforms Cloud & Hosting Services with MySQL Enterprise Edition
Employee_Team +4 Vote Up -0Vote Down

RedeHost are one of Brazil's largest cloud computing and web hosting providers, with more than 60,000 customers and 52,000 web sites running on its infrastructure.

As the company grew, Redehost needed to automate operations, such as system monitoring, making the operations team more proactive in solving problems. Redehost also sought to improve server uptime, robustness, and availability, especially during backup windows, when performance would often dip.

To address the needs of the business, Redehost migrated from the community edition of MySQL to MySQL Enterprise Edition (http://www.mysql.com/products/enterprise/), which has delivered a host of benefits:

- Pro-active database management and monitoring using MySQL Enterprise Monitor (http://www.mysql.com/products/enterprise/monitor.html),

  [Read more...]
Serving Clients Rather than Falling Over
+1 Vote Up -0Vote Down

Dawnstar Australis (yes, nickname – but I know him personally – he speaks with knowledge and authority) updates on The Real Victims Of The Click Frenzy Fail: The Australian Consumer after his earlier post from a few months ago.

Colourful language aside, I believe he rightfully points out the failings of the organising company and the big Australian retailers. From the Open Query perspective we can just review the situation where sites fall over under load. Contrary to what they say, that’s not a cool indication of popularity. Let’s compare with the real world:

  • Brick & Mortar store does something that turns out popular and we see a huge queue outside, people need to wait for
  •   [Read more...]
    Top 10 Reasons to Use MySQL and MySQL Cluster as an Embedded Database
    Employee_Team +2 Vote Up -0Vote Down

    If you are considering using MySQL and/or MySQL Cluster as the embedded database solution for your application, you should join us for today's webcast where we will discuss how you can cut costs, add flexibility and benefit from new performance and scalability enhancements that are now available in MySQL 5.6 and MySQL Cluster 7.2.  We will cover the top 10 reasons that make MySQL and MySQL Cluster the best solutions for embedding in both shrink wrapped and SaaS provided applications, how industry leaders leverage MySQL products and how you can get started with the latest innovations and support offerings across the MySQL product line.

    You can learn more and reserve your seat here. (http://www.mysql.com/news-and-events/web-seminars/display-731.html)

    As always, thanks for your support of MySQL!


    MySQL Policy-Based Auditing Webinar Recording Now Availabile
    Employee_Team +3 Vote Up -0Vote Down

    For those who missed the live event, the recording of the "How to Add Policy-Based Auditing to your MySQL Applications" webinar is now available.  You can view it here. (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-728.html)

    This presentation builds on my earlier blog post on MySQL Enterprise Audit that was announced at MySQL Connect in late September.  The web presentation expands on the introductory blog and covers:

    • The regulatory problem to be solved (internal audit, PCI, Sarbanes-Oxley, HIPAA, others)
    • MySQL Audit solutions for both Community and Enterprise users:
      • General Log - use the basic features of the MySQL server
      • MySQL 5.5 open audit API - or


      [Read more...]
    How to Add Policy-based Audit Compliance to your existing MySQL applications
    Employee_Team +3 Vote Up -0Vote Down

    As a follow up to an earlier blog on the subject, please join us today at 0900 US PT to learn how to easily add policy-based auditing compliance to your existing MySQL applications.  This brief, informative session will provide an overview of the new MySQL Enterprise Audit plugin and will include a simple, practical step-by-step "how to" approach to get up and running with the new functionality.

    You can learn more and secure your seat for the presentation here (http://www.mysql.com/news-and-events/web-seminars/display-728.html).

     Thanks for your continued support of MySQL!

    MEB Support to NetBackup MMS
    Employee +0 Vote Up -0Vote Down

    In MySQL Enterprise Backup 3.6, new option was introduced to support backup to tapes via SBT interface. SBT stands for System Backup to Tape, an Oracle API that helps to perform backup and restore jobs via media management software such as Oracle's Secure Backup (OSB). There are other storage managers like IBM's Tivoli Storage Manager (TSM) and Symantec's Netbackup (NB) which are also supported by MEB but we don't guarantee that it will function as expected for every release. MEB supports SBT API version 2.0

    In this blog, I am primarily going to focus the interface of MEB and Symantec's NB. If we are using tapes for backup, ensure that tape library and tape drives are compatible.

    Test Setup

    1. Install NB 7.5 master and media servers in Linux OS. ( NB 7.1 can also be used but for testing purpose I used NB

      [Read more...]
    New in MySQL Enterprise Edition: Policy-based Auditing!
    Employee_Team +3 Vote Up -0Vote Down
    Normal 0 false false false EN-US X-NONE X-NONE Normal 0 false false false EN-US X-NONE X-NONE  [Read more...]
    MEB: Taking Incremental Backup using last successful backup
    Employee_Team +3 Vote Up -0Vote Down

    Introduction

    In MySQL Enterprise Backup v3.7.0 (MEB 3.7.0) a new option '–incremental-base' was introduced. Using this option a user can take in incremental backup without specifying the '–start-lsn' option. Description of this option can be found here. Instead of '–start-lsn' the user can provide the

      [Read more...]
    Announcing MySQL Enterprise Backup 3.7.1
    Employee_Team +2 Vote Up -0Vote Down

    The MySQL Enterprise Backup (MEB) Team is pleased to announce the release of MEB 3.7.1, a maintenance release version that includes bug fixes and enhancements to some of the existing features.

    The most important feature introduced in this release is Automatic Incremental Backup. The new  argument syntax for the --incremental-base option is introduced which makes it simpler to perform automatic incremental backups. When the options --incremental & --incremental-base=history:last_backup are combined, the mysqlbackup command  uses the metadata in the mysql.backup_history table to determine the LSN to use as the lower limit of the incremental backup. You no longer need to keep track of the actual LSN (as in the option --start-lsn=LSN) or even the location of the previous backup (as

      [Read more...]
    MySQL Enterprise Backup: Redo-log-only Incremental Backups
    Employee_Team +3 Vote Up -0Vote Down
    The latest release of MySQL Enterprise Backup (MEB 3.7.0) introduces a new method for performing incremental hot backups - the redo-log-only incremental backup. This new method of incremental backups allows for highly compact and fast incremental backups and MEB users now have the choice between data-file based incremental backups and the redo-log-only incremental backups.

    In data-file based incremental backups (performed using the '--incremental' option) MEB scans all InnoDB

      [Read more...]
    MySQL Enterprise Backup: Redo-log-only Incremental Backups
    Employee_Team +0 Vote Up -0Vote Down
    The latest release of MySQL Enterprise Backup (MEB 3.7.0) introduces a new method for performing incremental hot backups - the redo-log-only incremental backup. This new method of incremental backups allows for highly compact and fast incremental backups and MEB users now have the choice between data-file based incremental backups and the redo-log-only incremental backups.

    In data-file based incremental backups (performed using the '--incremental' option) MEB scans all InnoDB

      [Read more...]
    MySQL Enterprise Backup: Taking Incremental Backups without specifying LSN
    Employee_Team +5 Vote Up -0Vote Down
    In its latest release MySQL Enterprise Backup (MEB 3.7.0) rolled out a new feature called 'incremental-base' which can save a lot of time and effort of the users when taking incremental backups. Let us understand this new feature and how it can be helpful:   [Read more...]
    MySQL Enterprise Backup: Taking Incremental Backups without specifying LSN
    Employee_Team +0 Vote Up -0Vote Down
    In its latest release MySQL Enterprise Backup (MEB 3.7.0) rolled out a new feature called 'incremental-base' which can save a lot of time and effort of the users when taking incremental backups. Let us understand this new feature and how it can be helpful:   [Read more...]
    Announcing MySQL Enterprise Backup 3.7.0
    Employee_Team +5 Vote Up -1Vote Down

    The MySQL Enterprise Backup (http://mysql.com/products/enterprise/backup.html) (MEB) Team is pleased to announce the release of MEB 3.7.0, with several exciting and advanced features to benefit a wide audience. Included in this release are,


      [Read more...]
    Announcing MySQL Enterprise Backup 3.7.0
    Employee_Team +0 Vote Up -0Vote Down

    The MySQL Enterprise Backup (http://mysql.com/products/enterprise/backup.html) (MEB) Team is pleased to announce the release of MEB 3.7.0, with several exciting and advanced features to benefit a wide audience. Included in this release are,


      [Read more...]
    2011, A great year for MySQL in review...
    +11 Vote Up -0Vote Down
    I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

    I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

    I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

    Summary:







      [Read more...]
    WebOS and the open alternative live another day
    +0 Vote Up -0Vote Down

    There has been no shortage of reaction to HP’s move to make the Linux-based WebOS open source software. Below, I offer some of my thoughts on the meaning for the different players affected.

    *What’s it mean for WebOS?
    Moving WebOS to open source was best option for HP. It retains some value in the software depending on its involvement. It is also the best fate for the code, rather then being sold or simmered to its IP and patent value or even used as another weapon in the ongoing mobile software patent wars. Still, the move comes amid huge developer and consumer uncertainty for WebOS. Nevertheless, at least WebOS was already in the market with a compelling products, the Palm the Pre, in the modern smartphone market. WebOS will hopefully have a faster path to open source than Symbian since the former is based on Linux. I still think the greatest opportunity for

      [Read more...]
    MySQL 5.5.18 Debian packaging now available
    Employee_Team +0 Vote Up -0Vote Down

    I am happy to announce that MySQL 5.5.18 is now available via Debian native packaging.  We have gotten many requests for this and our build and release teams have pulled together to ensure that our DEB packages are delivered with the highest quality. 

    You can download MySQL 5.5.18 Debian 5 and 6 packages from the MySQL Community Download page or from the My Oracle Support portal.

    As always, thanks for your continued support of MySQL!

    MySQL 5.5.18 Debian packaging now available
    Employee_Team +8 Vote Up -0Vote Down

    I am happy to announce that MySQL 5.5.18 is now available via Debian native packaging.  We have gotten many requests for this and our build and release teams have pulled together to ensure that our DEB packages are delivered with the highest quality. 

    You can download MySQL 5.5.18 Debian 5 and 6 packages from the MySQL Community Download page or from the My Oracle Support portal.

    As always, thanks for your continued support of MySQL!

    Monitoring Related OpenWorld Talks
    Employee_Team +0 Vote Up -0Vote Down

    I gave two monitoring related talks at OpenWorld, thanks to all that came along!

    Both were monitoring related, the first an introduction to MySQL Enterprise Monitor, and the second a look at some of the new instrumentation that is getting developed, primarily within the MySQL 5.6 release. 

    If you'd like to get a quick overview of how MySQL Enterprise Monitor works, then take a look through the "Getting to Know MySQL Enterprise Monitor" talk. This gives you a high level view of how the different pieces fit together, and then each of the important factors within the user interface:

    Getting to Know MySQL Enterprise Monitor

    And if you are interested in seeing how the instrumentation and monitoring

      [Read more...]
    Monitoring Related OpenWorld Talks
    Employee_Team +0 Vote Up -0Vote Down

    I gave two monitoring related talks at OpenWorld, thanks to all that came along!

    Both were monitoring related, the first an introduction to MySQL Enterprise Monitor, and the second a look at some of the new instrumentation that is getting developed, primarily within the MySQL 5.6 release. 

    If you'd like to get a quick overview of how MySQL Enterprise Monitor works, then take a look through the "Getting to Know MySQL Enterprise Monitor" talk. This gives you a high level view of how the different pieces fit together, and then each of the important factors within the user interface:

    Getting to Know MySQL Enterprise Monitor

    And if you are interested in seeing how the instrumentation and monitoring

      [Read more...]
    CAOS Theory Podcast 2011.09.30
    +0 Vote Up -0Vote Down

    Topics for this podcast:

    *Cloud M&A potential around OpenStack
    *Oracle’s commercial extensions for MySQL
    *Puppet Labs rolls out Enterprise 2.0, hosts PuppetConf
    *Basho bolsters Riak distributed data store in NoSQL race
    *Our latest special CAOS report, ‘The Changing Linux Landscape’

    iTunes or direct download (25:59, 4.4MB)

    MySQL Cluster Manager hands on
    Employee +3 Vote Up -0Vote Down
    MySQL Cluster is, without doubt, the most interesting MySQL product Oracle offers to the people out there. It’s the flagship, the holy grail, based on the knowledge and technology developed doing our well known MySQL Server. I’m not going to go through why MySQL Cluster is so great, that you can find anywhere. I’m going [...]
    MySQL Enterprise Backup 3.6 - New backup streaming, integration with Oracle Secure Backup and other common backup media solutions
    Employee_Team +5 Vote Up -0Vote Down
    All DBAs understand the importance and priority of quick, reliable database backup and recovery operations.  In fact, dating back to my early days with MySQL, the most commonly requested product features from the MySQL user base have been around online, non-blocking backup solutions for running MySQL servers.  In response, Oracle now provides MySQL Enterprise Backup (http://mysql.com/products/enterprise/backup.html) ("MEB") which performs high performant, online "hot" backups for MySQL databases.  MEB provides all of the backup/recovery features and functionality DBAs expect, all from a scriptable command line interface.  You can learn all about MEB in the related MySQL docs.

    My congratulations and appreciation go out to Lars Thalmann and the MySQL Enterprise

      [Read more...]
    MySQL Enterprise Backup 3.5, the crash course
    Employee +1 Vote Up -0Vote Down
    Every ones loves hands-on tutorials with code snippets and stuff to establish the knowledge that something can be done. So here is my first one; MySQL Enterprise Backup 3.5. The new and shiny backup solution for MySQL. Our clients, for a long time, are asking for an enterprise ready, stable, safe, quick, easy, feature rich, [...]
    Free Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL (EN,IT) - January 20, 2011
    +3 Vote Up -0Vote Down
    Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

    In this Webinar you will learn:

    • Backup Strategies & Methods
    • Comparison of backup types for MySQL
    • MySQL Enterprise Backup: Features
    • MySQL Enterprise Backup Performance
    • MySQL Enterprise Backup: Architecture
    • MySQL Enterprise Backup: How it Works
    • MySQL Enterprise Backup: Script Examples




      [Read more...]
    Showing entries 1 to 30 of 30

    Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.