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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 82 Next 22 Older Entries

Displaying posts with tag: MySQL Backup and Recovery (reset)

Protecting CFD (and making more money as a MySQL DBA)
+0 Vote Up -0Vote Down

No, this is not a blog about Computational Fluid Dynamics - my least favorite subject in college. This is about a more exciting (sorry mechanical engineers!) CFD: Customer Facing Data. This is the data that is typically available on the website of an organization that their customers interact with. CFD can range all the way from profiles of users on a social networking site such as Facebook to the customer information database of an e-commerce company such as Travelocity.

CFD represents today’s data protection challenge. Probably the biggest challenge while planning a backup solution for CFD is that it is very hard to figure out what to plan for. You might be starting with a very small database which might grow much more rapidly than what you think. If the data can be segmented based on users or some other characteristic,

  [Read more...]
Highly Scalable MySQL Backups using Snapshots (ZFS or NetApp)
+0 Vote Up -0Vote Down

We have been focusing on providing the best possible backup solution for following scenario: 100 GB+ of data stored in MySQL database, Transaction intensive workload (i.e. rapid rate of change of data), with a business requirement to be able to perform point-in-time restoration of the MySQL database. Oh, the solution also needs to take into account that the database can grow to 1TB or more very quickly.

For such a scenario, we believe that the best possible solution today is a combination of:

  • Storage level snapshots - a capability built into ZFS (Solaris), NetApp, LVM (Linux), VxFS, and VSS (Windows)
  • Transaction logs generated by MySQL
  • Point-and-click restore capability provided by Zmanda Recovery Manager for MySQL
  • Two reports came out today which go into nitty-gritty of above. First is a joint report written by NetApp

      [Read more...]
    MySQL Backup and Recovery Training from Zmanda
    +0 Vote Up -0Vote Down

    Worried about Backup and Recovery of your MySQL Databases? MySQL Backup school from Zmanda provides hands on and in depth training on Backup and Recovery of MySQL. Just sign up and show up with your laptop. More information available here.

    Sun/MySQL to resell Zmanda Recovery Manager for MySQL
    +0 Vote Up -0Vote Down

    Today Sun and Zmanda announced our agreement to deliver a comprehensive, global data backup and recovery solution for MySQL Enterprise subscribers. Starting April 1st, MySQL Enterprise customers will be able to purchase ZRM for MySQL directly from Sun worldwide.

    I think Zack’s comment in the press release captures the rationale for the deal:

    “Protecting corporate data through effective backup and recovery is one of the most crucial tasks for a database administrator, and it can be a complex undertaking — especially for today’s large Web-scale applications,” said Zack Urlocker, VP of products, Sun Microsystems database group. “MySQL users have told us that global backup and recovery is very important to them, and we are thrilled that we can now offer ZRM for MySQL as an easy-to-use solution for protecting all of

      [Read more...]
    Webinar: New Levels of Backup and Recovery for MySQL
    +0 Vote Up -0Vote Down

    Zmanda has introduced a new version of Zmanda Recovery Manager (ZRM) which adds quite a few capabilities for MySQL users. Version 2.1 includes enhanced snapshot support that enables backup without application downtime or interruption to online data access. Version 2.1 also has global management of backups so that you can manage all your MySQL backup jobs from a single graphical console. You can now run the entire ZRM solution on Solaris as well as on Linux.

    Join us for an overview and a live demo of ZRM 2.1 on Thursday 3/20 at 10am PST. Click here to register.

    Zmanda Recovery Manager 2.1 - Keep those MySQL Databases Zipping
    +0 Vote Up -0Vote Down

    Today we announced a significant enhancement to our Zmanda Recovery Manager (ZRM) for MySQL product. Here are major highlights of this new version (2.1):

    End-to-end support for Solaris: We have had increasing number of requests from customers for supporting Solaris. While we always protected MySQL databases running on Solaris, we needed customers to run the ZRM core engine on a Linux box. Now we are able to run the ZRM core engine on Solaris itself. So a pure Solaris shop can use ZRM without getting a Linux server. The coinciding of this support with MySQL’s acquisition by Sun was not a planned thing

    Enhanced Snapshot support: One of the coolest features

      [Read more...]
    Webcast - Enterprise Backup to Amazon S3
    +0 Vote Up -0Vote Down

    We are hosting a webcast this Wednesday to talk about backing up corporate data to Amazon?s Simple Storage Service (S3) using Amanda Enterprise. We will demonstrate live, how enterprise users can now use Amanda Enterprise to harness Amazon S3 for a complete data backup, archiving and disaster recovery solution. The webcast will take place on Wednesday February 27 at 10:00AM PST and will last about an hour, including a Q&A session at the end. We hope you can join us to discover a new & cost effective way to leverage online storage services such as Amazon S3 as a part of your corporate data protection strategy. Click here to register.

    Congratulations to Sun and MySQL
    +0 Vote Up -0Vote Down

    Congratulations to Marten and team on Sun’s acquisition of MySQL today! This is a billion dollar stamp of approval on the importance of the LAMP stack. This also gives another strong backing to the business model which involves giving one’s software away for free to up to 99+% of users!

    This announcement comes at an interesting time for Zmanda. Just last week we announced support for the Solaris platform for our Amanda Enterprise product line. With our industry leading MySQL backup solution, we now have full coverage of operating systems and database software from the new Sun!

    A great day for open source software and business of open source software!

    Webinar Q & A: MySQL Backup Techniques for the Oracle DBA
    +0 Vote Up -0Vote Down

    We presented a webinar along with MySQL last week. The topic was MySQL Backup from the perspective of an Oracle DBA. We got some really good questions at the end of the webinar. Here is a transcript of Q&A:

    Q from Trey: Will this Webinar be available online for viewing later?

    A from MySQL: Yes. It will be on our site in a few days at http://www.mysql.com/news-and-events/on-demand-webinars/

    Q from Randy: Is a copy of presentation available on web? Where?

    A from Zmanda : slides are available on Zmanda Network: http://network.zmanda.com/

    Q from Jing: Converting database from oracle to MySQL, any limitation regards the version compatibility?

    A from MySQL: We provide a free GUI migration tool that helps migrate Oracle data objects to MySQL. For a complete and

      [Read more...]
    Backup and Recovery Techniques for MySQL Database
    +0 Vote Up -0Vote Down

    If you are migrating your production environment to MySQL database or even thinking about it, you do not want to miss this webinar Experts from Zmanda and MySQL will present various methods to backup MySQL database and correlate them with tools and terminology you may be familiar with in other databases, including Oracle.

    A good pre-read for this webinar would be Paddy’s blog on online MySQL Backup

    WHO:

    Chander Kant, CEO, Zmanda

    Robin Schumacher, Director Product Management, MySQL

    WHAT:

    MySQL Backup Techniques for the Oracle DBA (web presentation)

    WHEN:

    Thursday, December 13, 2007, 10:00 am PDT, 1:00 pm EDT, 18:00 GMT
    The presentation will be approximately 45 minutes long followed by Q&A.


      [Read more...]
    Do I really need backups?
    +0 Vote Up -0Vote Down

    I was reading, this article (subscription required) by Ben Worthen on WSJ about a study on how well companies are prepared for a disaster. I was not at all surprised by (one of) the findings (paraphrased):

    …While 70% of 189 tech leaders surveyed by Forrester Research Inc. said that their companies are prepared for a disaster, the reality was quite different…

    We run into this all the time, in talking to (prospective) customers. People “think” they are prepared for a disaster. The truth hits them when you start peeling the layers of the supposed plan. Some things to keep an eye on are

    • Is it robust and reliable?
    • Do you have the right resources engaged in the plan - both design and implementation?
    • How often are the plans tested?
    • How well is the plan
      [Read more...]
    ZRM for MySQL 1.2.1 released
    +0 Vote Up -0Vote Down

    Community version 1.2.1 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and intelligent solution for backup and recovery of MySQL databases is available for download at Zmanda downloads page.

    Changes in this release:

  • Bug fixes
  • Source tar ball (including debian package files)
  • Help from ZRM online sites
  • For documentation see, ZRM for MySQL users manual. Please use bugzilla to report bugs and feature requests. If you have questions or feedback, please post them in forums.

    The a,b,c?s of MySQL Backup Planning
    +0 Vote Up -0Vote Down

    The role of data stored in MySQL database in today’s world is already known - it powers business and mission critical apps. Protecting this data is of utmost important to any enterprise. Before you actually have a backup in place, that are some very important things to think about the backup implementation. Like for instance, how soon would you want your data recovered after a user or system error? This article provides an indepth analysis about the basics of what needs to be considered while planning a Backup and Recovery solution for your MySQL database.

    Webinar: Zmanda Management Console for MySQL Backup
    +0 Vote Up -0Vote Down

    Zmanda’s MySQL Backup and Recovery Solution is the only comprehensive backup solution that addresses the unique needs of MySQL databases — such as multiple database storage engines. Zmanda Recovery Manager (ZRM) for MySQL now features graphical tools to simplify the process of protecting MySQL data.

    This free presentation from experts in open-source backup and recovery of MySQL will demonstrate Zmanda Management Console for ZRM , which is a web based service integrated with Zmanda Network. It provides management and visualization tools for defining all backup activities of a MySQL DBA:

    •  what to backup, e.g. all databases or just the selected tables
      • where to store the backup images
      • when to perform backups, e.g. schedule daily, weekly or monthly full and incremental backups
      [Read more...]
    Change the world? Our job is to keep the world the way it was.
    +0 Vote Up -0Vote Down

    One of the candidates for a marketing position (btw, we are looking for a very technical marketing talent, drop me a line at dj at zmanda dot com) asked me if Zmanda wants to change the world. The way I see it, our job is just opposite to changing the world. We want to keep the world the way it was. If your hardware dies or a user drops a table, we give you the ability to go back in time and to recover your file with Amanda Enterprise or your MySQL database with Zmanda Recovery Manager (ZRM).

    How do we actually accomplish going back in time? Are we talking here about super-expensive and complicated Continues Data Protection (CDP) technologies? Our solution delivers the same result, but without the cost and complexity of CDP. ZRM incremental backups result in a copy of the MySQL

      [Read more...]
    New face of MySQL backups
    +0 Vote Up -0Vote Down

    Check out  this short demo of Management Console of MySQL backup 

     

    tk

    Sexy back(up)
    +0 Vote Up -0Vote Down

    Could not resist the title after reading what Matt wrote. Sexy and exciting, indeed. Most of the crew here have their heads buried with the upcoming releases of Amanda Enterprise and Zmanda Recovery Manager (ZRM) for MySQL. We are continuing to enhance the Management console for Network backup. And with the next release of ZRM for MySQL, backup of MySQL database will never be the same. Dmitri already wrote about how easy it will be to manage MySQL backups from Iphone. Additionally we are fixing stuff in the Management console for ease of use. You can see, touch and feel them at LinuxWorld. Come check us out. And watch

      [Read more...]
    Managing backup of MySQL via iPhone
    +0 Vote Up -0Vote Down

    Given a chance, I always check www.zmanda.com on different gadgets with various browsers and form factors. As soon as iPhone became available, I was at the Apple store checking out the new device and especially its web browsing capabilities.

    It took me a couple of attempts to type the URL, but then I got it right and I could see our web site, wiki and forums. Everything looked great. Surprisingly, I could see most of the page without too much zooming and moving the window. Our upcoming Management Console for backup and recovery of MySQL is built on a LAMP stack with a look and feel similar to our website. What if we could actually manage all or at least some frequent day to day backup activities of MySQL DBA via iPhone?

    Here at Zmanda we are moving fast, and within a few days we presented to a couple of our customers how to manage MySQL backups via iPhone. Here

      [Read more...]
    ZRM for MySQL backup version 1.2 released
    +0 Vote Up -0Vote Down

    Version 1.2 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and intelligent solution for backup and recovery of MySQL databases is available at Zmanda downloads page.

    Changes in this release:

    • Code restructured into modules
    • Snapshot plugin interface. LVM snapshots implemented as a plugin.
    • ZRM should be run as user belonging to mysql group.
    • Numerous bug fixes

    Documentation is available at ZRM for MySQL wiki. Ask questions and provide feedback in Zmanda forums.

    Provide feedback on MySQL backup console
    +0 Vote Up -0Vote Down

    We are working on Zmanda Management Console for our MySQL backup product line: Zmanda Recovery Manager (ZRM) for MySQL. ZRM for MySQL is an enterprise backup and recovery solution for MySQL.


    We are looking for MySQL administrators in San Francisco bay area who would be interested in providing functionality and usability feedback for the user interface. We are particularly interested in MySQL administrators responsible for implementing backup solution for their MySQL databases. Please send an email to me (paddy-at-zmanda-dot-com) with your availability and why you would meet our requirement. We will pay a small stipend for your time.

    ZRM for MySQL Cluster Edition
    +0 Vote Up -0Vote Down

    ZRM for MySQL Cluster Edition, released during MySQL users conference last month, provides non-blocking backup and recovery for MySQL cluster databases. In addition to backup and recovery for MySQL clusters, the cluster edition also supports online backup and recovery of other MySQL storage engines such as MyISAM, InnoDB. Most applications using MySQL Clusters also store data in other storage engines. The Cluster edition provides a common user interface for backing and recovering applications that use multiple MySQL storage engines.

    ZRM for MySQL supports both MySQL Cluster (http://www.mysql.com/products/database/cluster/) as well as the MySQL Cluster Carrier Grade (http://www.mysql.com/products/database/clustercge/) edition.

    A demo of ZRM for

      [Read more...]
    New ideas and users? requirements for backup of MySQL
    +0 Vote Up -0Vote Down

    The MySQL User’s Conference provides very fertile environment for new ideas. For example, last year we came to the conference with a conviction to build a MySQL agent for our Amanda Enterprise backup and recovery software. However, after talking to many MySQL users about their backup needs we got convinced that stand-alone solution optimized for MySQL DBAs was a better way to go, and that is how Zmanda Recovery Manager for MySQL was conceived.

    This year we received a lot of insightful feedback and suggestions from MySQL users and our customers. Special thanks to MySQL engineering and product management for providing their perspective. Here are the major takeaways for us, the MySQL backup guys:

    • Back up the MySQL server configuration files when you do backup of the database — that will
      [Read more...]
    MySQL Users conference: ZRM for MySQL - Vision and Roadmap
    +0 Vote Up -0Vote Down

    Thanks to everyone who attended the talk in person.

    The slides used in the talk is available at ZRM for MySQL wiki

    If you have questions or comments, please send them to me.

    Data Protection for the LAMP Economy
    +0 Vote Up -0Vote Down

    The value of data stored in LAMP applications is increasing at an exponential pace. Indeed, the LAMP stack fuels an economy of its own - with its own currency, lingo and players. While e-commerce is the clear and present evidence of the LAMP powered economy, the currency for this economy is by no means just monetary. Value is manifested in many factors other than financial gains: personal reputation and legacy, karma points, creativity etc. The LAMP stack fires up innovation by enabling new ideas - you can quickly and cost-effectively prototype a concept which other’s may find bizarre.

    User generated content (UGC) is one key currency of the LAMP stack. UGC, even votes (ok, diggs) on other’s UGC store tangible and lasting value. While naming “You”, a proxy for UGC, the Time’s Person of the Year 2006, The Time magazine said: “It’s a story about community and

      [Read more...]
    Zmanda at MySQL Conference and Expo
    +0 Vote Up -0Vote Down

    Zmanda is a Diamond sponsor of MySQL users conference. Come Visit us at booth 415.
    Various membes of our team are also presenting at the conference. If backup of MySQL databases is
    of interest to you, you do not want to miss any of the following presentation:

    Zmanda Speakers

    Keynote: Data Protection for the LAMP Economy
    Presenter: Chander Kant, CEO, Zmanda
    Date: Thursday, April 26, 2007
    Time: 9:50am-10:20am
    Location: Ballrooms E-H

    Track: Security & Database Administration
    Topic: MySQL Backup: Roadmap & Vision
    Presenters: Paddy Sreenivasan, VP Engineering, Zmanda
    Lars Thalmann, Replication & Clustering Technology, MySQL
    Date:









      [Read more...]
    Zmanda Webinar: Backup and Recovery of MySQL Clusters
    +0 Vote Up -0Vote Down

    Event Information

    Topic:
    Backup and Recovery of MySQL Clusters

    Date and Time:
    Thursday, April 12th , 2007 10:00 am
    Pacific Daylight Time (GMT -07:00, San Francisco)

    Panelist(s) Info:
    Shailen Patel - Professional Services Engineer,
    Paddy Sreenivasan - VP, Engineering,
    Ram “TK” Krishnamurthy - VP, Services and Support

    Duration: 1 hour

    Description:
    Zmanda Recovery Manager [ZRM] for MySQL provides a simple and easy way to backup and recover MySQL clusters. Zmanda Engineers will provide an overview of ZRM for MySQL and demonstrate its ability to backup and restore MySQL cluster.

    Open Source ?Unconference? in India
    +0 Vote Up -0Vote Down

    On Saturday, 24th March ‘07, Open Source ?Unconference? was held at Mumbai, India.

    It was great learning experience for everyone and a good event to network with MySQL users and developers in India. K. K. George, the project leader for open source Zmanda Recovery Manager for MySQL, gave a talk about MySQL backup and recovery. Zmanda Recovery Manager is Zmanda’s MySQL backup and recovery project that has become quite popular with MySQL administrators. It has scheduling, reporting and monitoring functionalities for MySQL databases. In addition, it can do incremental backups and can also parse the complex binary log files of MySQL dump. Remote MySQL server backup is also supported through SSH and socket options. There was lot

      [Read more...]
    Backup and recovery benchmarks with Zmanda Recovery Manager for MySQL
    +0 Vote Up -0Vote Down

    The MySQL database has become the world?s most popular open source database because of its fast performance, high reliability and ease of use. The DBAs expect the same virtues from a backup solution for MySQL. Often times we are asked what performance to expect from Zmanda Recovery Manager (ZRM) for MySQL. That is why recently we measured backup and recovery performance for MyISAM and InnoDB storage engines using various backup methods available with ZRM.

    In our testing we used MySQL 5.0 running Netflix databases available as part of Netflix Prize project. Our 2-way Red Hat Enterprise 4 server with 4 GB of memory was able to copy large files with an average transfer rate of 37 Mb/s.

    All details and results are described in a white paper available with a free registration to the Zmanda Network. Here are the important takeaways:

    • Logical
      [Read more...]
    Webinar: Zmanda Management Console for Amanda
    +0 Vote Up -0Vote Down

    Event Information

    Topic:
    Zmanda Management Console for Amanda Enterprise Edition

    Date and Time:
    Thursday, March 22, 2007 10:00 am
    Pacific Daylight Time (GMT -07:00, San Francisco)

    Panelist(s) Info:
    Shailen Patel - Professional Services Engineer,
    Dmitri Joukovski - VP of Product Management,
    Ram “TK” Krishnamurthy - VP of Services and Support

    Duration: 1 hour

    Description:
    The recently released Amanda Enterprise Edition 2.6, contains Zmanda Management Console [ZMC]. ZMC is a web-based services that is integrated with the Zmanda Network. This release also includes Amanda Rapid Installer, a very simple and easy to







      [Read more...]
    What, Where, When and How of Backup - We skipped ?Why?
    +0 Vote Up -0Vote Down

    Today we launched our Amanda Enterprise Edition 2.6. This comes with Zmanda Management Console - a totally cool way to install, configure and manage backup environments. This was result of an amazing effort done by our developers in past few months. This is how the navigation bar of the Zmanda Management Console (ZMC) looks like:

    One of our most important goals while designing a graphical interface for Amanda was to simplify the life of a backup administrator. We found existing backup products in the market to be unnecessarily complex to setup and manage. I (and rest of Zmanda team) believe that managing your backups should be simple. In order to get backup going, all we need to know is:

    What do you

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 82 Next 22 Older Entries

    Planet MySQL © 1995, 2014, 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.