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 89 Next 30 Older Entries

Displaying posts with tag: enterprise (reset)

Genoscope Makes Genomic Data Available to Scientists with MySQL Enterprise Edition
Employee_Team +3 Vote Up -0Vote Down

Genoscope, the French National Sequencing Center, was created in 1997 and is one of the largest sequencing centers in Europe. Its mission is to acquire, to "sequence" and to analyze the genetic information of various organisms presenting a scientific, medical or economic interest. DNA sequencing is the process of determining the precise order of nucleotides within a DNA molecule. Genoscope produces various types of data, such as complete or partial genome sequences, that are then compared and analyzed. Following its role as a major actor in the Human Genome Project, Genoscope has changed its orientation toward environmental genomics. Since 2007, Genoscope is part of CEA, the French Alternative Energies and Atomic Energy Commission.



  [Read more...]
Le Genoscope met les données génomiques à disposition des scientifiques avec MySQL Enterprise Edition
Employee_Team +2 Vote Up -0Vote Down

Créé en 1997, le Genoscope - Centre National de Séquençage - est un grand équipement au service de la communauté scientifique. Sa mission est d'acquérir, de "séquencer", et d'analyser l'information génétique de divers organismes d'intérêt scientifique, médical ou économique. Concrètement, le séquençage consiste à déterminer l'ordre dans lequel s'enchaînent les molécules élémentaires qui constituent les molécules d'ADN. Le Genoscope produit des données de nature diverse - séquences entières ou partielles de génomes ou de produits d'expression des gènes - qu'il compare et interprète. Après avoir été l'un des acteurs du projet génome humain, le Genoscope met aujourd'hui le cap vers la génomique environnementale. Depuis 2007, le Genoscope est intégré à l'institut de Génomique du CEA, le Commissariat à l'énergie atomique et aux

  [Read more...]
MySQL Enterprise Backup Improved Compression Algorithm for 3.10
Employee +1 Vote Up -0Vote Down

Background:

Prior to version 3.10, MySQL Enterprise Backup (MEB) used zlib compression for in-memory compression of datafiles. The compression worked by splitting the innodb datafiles into fixed size blocks and compressing each block independently.After searching on the web we found there are many compression algorithms available which can be used for compression. This triggered the idea of testing the performance of available compression algorithms. If the benchmark shows improved performance we can make backup and/or restore faster by adding the new compression algorithm to MEB.

Implementation :

The idea to implement the algorithms procceded as follows .

1. Select a "long list" of algorithms based on literature and what Google and other databases are using.
2. Create a

  [Read more...]
Sharecat Enables Oil and Gas Supply Chain Management with MySQL Enterprise Edition
Employee_Team +1 Vote Up -0Vote Down

Sharecat provides supply chain management solutions to oil and gas operators, delivering an innovative collaborative environment which includes the manufacturers' equipment catalogues and technical information. The products provide visibility and fully validated content to all parties in the plant lifecycle. Based in Norway, the company has offices in the UK, Australia and the United States.


  [Read more...]
Just Published! MySQL March Newsletter
Employee_Team +2 Vote Up -0Vote Down

Have you read the MySQL March Newsletter? Check it out to learn more about the Call of Papers for MySQL Connect @ OpenWorld 2014, MySQL in action in the finance, retail and channel management sectors, as well as numerous technical tips written by MySQL experts at Oracle and in the community. The highlights in this edition include:

  • Submit Sessions for MySQL Connect @ OpenWorld 2014
  • MySQL Connector/NET 6.8.3 Available as Official MySQL NuGet Packages
  • New Case Studies: MySQL in Action in Finance, Retail, and Channel Management
  • New White Paper: Guide to the MySQL Workbench Migration Wizard: From



  [Read more...]
Buongiorno Relies on MySQL Enterprise Edition to Power its Mobile Services
Employee_Team +2 Vote Up -0Vote Down

Buongiorno is known in the worldwide mobile ecosystem for developing and managing paid applications and content that help consumers get greater enjoyment from their mobile devices.


Buongiorno’s strategic goal is to deliver directly to consumers around the world a broad portfolio of content & services on all their personal devices, exploiting social and location based propositions, and letting telecom operators be in control of the billing. With direct connections to more than 130 telecom operators in 25 countries, over 10 years’ experience and a team of 600 professionals, Buongiorno makes the mobile internet experience happen for consumers globally. Buongiorno’s web apps brands include Gamifive, MuchGossip, Fingerbooks, Appsfuel HTML5 Marketplace, Winga, Play.me and the mobile payments solution Cashlog.

  [Read more...]
Gina Tricot Scales Online Sales with MySQL Enterprise Edition
Employee_Team +1 Vote Up -0Vote Down

Gina Tricot is a family-owned, Swedish fashion chain that consists of over 180 stores across the following five markets: Sweden, Norway, Denmark, Finland and Germany. Combined with growing online sales, the company reaches fashion-conscious women in 28 countries across Europe. In 2012, Gina Tricot reported sales of SEK 2.3 billion.


Challenges

  • Implement a reliable and scalable infrastructure to drive online sales both in countries with a physical presence via stores and in countries where the company sells exclusively online.
  • Outsource the day-to-day administration of the e-commerce system, including the databases, to a local partner while maintaining overall overview and control of the system.



  [Read more...]
Atos Manages Transaction Clearing for the Euronext Markets in Continental Europe with MySQL Enterprise Edition
Employee_Team +1 Vote Up -2Vote Down

Atos is an international information technology services company with annual revenue of EUR 8.8 billion and 77,100 employees in 52 countries. Serving a global client base, it delivers IT services in 3 domains, Consulting & Technology Services, Systems Integration and Managed Services & BPO and transactional services through Worldline.

In 2009 Atos was asked to drastically reduce the costs of the UCS application (Universal Clearing System): the compensation engine for the Euronext Cash (stocks and bonds) and derivatives markets in the Euro zone. In the financial sector, clearing is exercised by aggregating all purchases and sales by the type of product/assets held by each account holder, resulting in a balance of net payables or receivables as well as the net flows of securities delivered or received.

  [Read more...]
Atos Gère le Clearing des Transactions des Marchés Euronext en Europe Continentale avec MySQL Enterprise Edition
Employee_Team +1 Vote Up -0Vote Down

Acteur international des services informatiques avec un chiffre d’affaires annuel de 8,8 milliards d’euros et 77,100 collaborateurs dans 52 pays, Atos fournit à ses clients du monde entier des services informatiques dans 3 domaines, Conseil & Services Technologiques, Intégration de Systèmes et Infogérance & BPO, ainsi que Services Transactionnels de Haute Technologie avec Worldline.

En 2009, Atos s’est vu confier le projet de réduire drastiquement les coûts du moteur de compensation des marchés Cash (actions et obligations) et Produits Dérivés d’Euronext en Zone euro: l’application UCS (Universal Clearing System). Dans le domaine financier, la compensation, ou le "clearing", s'exerce par l'agrégat de toutes les positions d'achats et de ventes par type de produit/actif détenu par chaque teneur de compte, et se matérialise par un

  [Read more...]
MEB integration with Workbench
Employee +0 Vote Up -0Vote Down

The latest versions of MySQL Workbench starting from version 6 have the capability to integrate with MySQL Enterprise Backup (MEB).

Though all the functionality of MEB is not supported, it is still a great tool to begin your backup and get your backup setup in minutes. Workbench also provides the additional capability to be able to schedule your backups.

The sections below illustrate the setup and usage of the Workbench UI to be able to setup and execute backup using MEB.

This is a quick start guide to setup, make a backup and do a recovery using MySQL Workbench and MEB.

The installation of WB and MEB is not discussed; it should be a simple automated install for both packages.

Setup

Workbench now comes with a new MySQL enterprise options in its navigator menu on the left. You need to click the Online

  [Read more...]
Improved Backup Progress in MySQL Enterprise Backup(MEB) 3.8.2
Employee +0 Vote Up -0Vote Down

Nowadays huge amount of data is stored in databases and it is very inevitable for business needs. With parallel backup, MEB has best in class performance and continues to improve. With terabytes of data, it can take hours to backup the data. As a DBA you'd like to know how much of the backup is done, how much data in MB still remains and also what's currently happening in backup.

So MEB 3.8.2 has an enhanced progress indicator which will help the DBA in many ways like

  • You can analyze current and expected space requirements so that you can release some space by removing files on a file system or stop the backup if the space isn't there,to try other options like compressed backup.

      [Read more...]
    MySQL Enterprise Backup 3.8.2 has been released!
    Employee +3 Vote Up -0Vote Down

    MySQL Enterprise Backup v3.8.2, a maintenance release of online MySQL backup tool, is now available for download from My Oracle Support  (MOS) website as our latest GA release.  It will also be available via the Oracle Software Delivery Cloud in approximately 1-2 weeks. A brief summary of the changes in MySQL Enterprise Backup version 3.8.2 is given below.


      A. Functionality Added or Changed: 

    • MySQL Enterprise Backup has a new --on-disk-full command line option. mysqlbackup could hang when the disk became full, rather than detecting the low space condition. mysqlbackup now monitors disk space when running backup commands, and users can now specify the action to take at a disk-full condition with the --on-disk-full option. For more details, refer this

      [Read more...]
    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 test the fixes to old issues. 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. It was 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 happened 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 some time, and reviewed what Oracle delivered in this new MySQL release.

    Short premise

    Oracle developer teams

      [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...]
    Excluding a Table From Backup
    Employee +0 Vote Up -0Vote Down

    Let's say you have a database that stores not only current transactional data, but also historic data that's unchanging. In particular, you have a large table containing hundreds of gigabytes worth of last year's data, and it won't change. Having backed it up already, you don't need to back it up every time. Is there any way to exclude this table from a backup?

    For InnoDB tables with innodb-file-per-table enabled (the default as of MySQL 5.6), MySQL Enterprise Backup supports this feature in inverse. Specifically, you can choose to include specific innodb-file-per-table tables in addition to those stored in the system tablespace.

    In order to exclude a specific table, you need to provide a regular expression to the --include option that includes every table except

      [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...]
    Showing entries 1 to 30 of 89 Next 30 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.