Friday May 01, 2015
Wednesday Jun 25, 2014
By Bertrand Mattheli�-Oracle on Jun 25, 2014
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.
- Make a large amount of scientific data available to biologists worldwide via a database combining performance, ease of use and cross-platform availability.
- Rapidly and easily deploy new database applications to address the constantly growing needs of genomic analysis.
- Genoscope initially relied on Sybase for its database applications but faced a number of constraints, especially in terms of ease of use and administration as well as of cross-platform availability.
- Evaluation and selection of MySQL as new database standard to eliminate those constraints.
- About 300 MySQL databases storing 8 terabytes of data have been deployed so far by the sequencing center, including :
- 250 MySQL databases enabling the scientific community to access genomic data via web applications. Each application is dedicated to a specific type of data, for example "metagenomes" or the comparison of different genomes. The most important one handles over 5 terabytes of data, relying on approximately 30 MySQL databases.
- About 50 MySQL databases are used for Business Intelligence as well as project management applications.
- Genoscope relies on MySQL 5.6 for new applications; and on MySQL Workbench for their design and development. Sylvain Bonneval, DBA in the Genoscope systems team underlines "Beyond the performance and ease of use of MySQL, we particularly appreciate the fast pace of innovations delivered by Oracle. MySQL 5.6 integrates numerous very useful new features, and there’s no doubt that tremendous progress is being made with MySQL."
- MySQL Enterprise Edition was implemented to allow the teams to access Oracle’s MySQL technical support, and to benefit from monitoring tools including the MySQL Enterprise Monitor and MySQL Query Analyzer.
"MySQL allowed us to significantly increase database usage in our organization. It is a tool perfectly suited to public research applications considering both its performance and open source nature." Sylvain Bonneval, DBA, Genoscope
Le Genoscope met les données génomiques à disposition des scientifiques avec MySQL Enterprise Edition
By Bertrand Mattheli�-Oracle on Jun 25, 2014
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 énergies alternatives.
- Mettre un volume important de données scientifiques à disposition des biologistes du monde entier via une base de données alliant performance, portabilité et simplicité d’utilisation.
- Rapidement et simplement déployer de nouvelles applications de bases de données pour répondre aux besoins croissants d’analyse génomique.
- Le Genoscope a initialement utilisé Sybase comme base de données mais faisait face à plusieurs contraintes, notamment en termes de portabilité sur différentes plateformes ainsi que de simplicité d’utilisation et d’administration.
- Evaluation et sélection de MySQL comme nouveau standard de base de données pour répondre à ces contraintes.
- Environ 300 bases MySQL contenant 8 téraoctets de données sont déployées par l’institut à ce jour, incluant:
- 250 bases MySQL utilisées pour mettre les données génomiques à disposition de la communauté scientifique via des applications Web. Chaque application est dédiée à un type particulier de données, par exemple les "métagénomes" ou la comparaison de différents génomes. L’application la plus importante gère plus de 5 téraoctets de données, s’appuyant sur une trentaine de bases MySQL.
- Une cinquantaine de bases de données MySQL utilisées pour des applications d’informatique décisionnelle et de gestion de projets.
- Le Genoscope utilise MySQL 5.6 pour les nouvelles applications, ainsi que MySQL Workbench pour leur modélisation et développement. Sylvain Bonneval, DBA de l’équipe système, souligne "Outre la performance et la simplicité d’utilisation de MySQL, nous apprécions particulièrement le rythme des innovations délivrées par Oracle. MySQL 5.6 intègre de nombreuses nouvelles fonctionnalités très utiles et nous constatons à quel point MySQL est une base de données en pleine progression."
- MySQL Enterprise Edition a été mis en place pour permettre aux équipes de bénéficier de l’accès au support technique MySQL d’Oracle ainsi que des outils de monitoring comme le MySQL Enterprise Monitor et MySQL Query Analyzer.
"MySQL nous a permis de largement accroître l'usage des bases de données au sein de notre organisation. C’est un outil parfaitement adapté aux applications de recherche publique, tant par sa performance que par sa nature open source." Sylvain Bonneval, DBA, Le Genoscope
Friday Mar 28, 2014
Monday Mar 24, 2014
Thursday Mar 20, 2014
By Bertrand Mattheli�-Oracle on Mar 20, 2014
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.
- Rely on a database delivering high performance and scalability to power Buongiorno’s mobile services. The database additionally needed to be very easy to use in order to rapidly launch and easily manage new fast growing applications.
- Implement an effective monitoring solution in order to increase Dev-Ops productivity and focus resources on strategic operations.
- Maintain a low Total Cost of Ownership (TCO) for its infrastructure, both initially and over time.
- Selected MySQL to power Buongiorno’s platform. The team especially valued its performance and scalability for mobile applications, including the ability to very quickly open and close connections to the database. MySQL was moreover extremely easy to use, and would allow the company to cost-effectively scale-out, adding more database servers at low cost to fuel its growing business.
- MySQL instances are hosted on virtualized servers. The architecture currently consists of over 50 MySQL database instances including:
- Over 40 “MySQL chains” as illustrated in the below diagram with circular replication between master and slave servers (or "Master Backup") to ensure High Availability, and replication to a second slave server for reporting purposes.
- Over 10 additional similar MySQL chains without replication to another slave server for reporting needs.
- More than 8 TB of data are stored in the MySQL master servers (excluding the replicas). The application handles:
- Over 50,000 queries/second
- Over 15,000 transactions/second
- While several MySQL versions are still in use in the platform, all servers are being migrated to MySQL 5.6 in order to take advantage of the latest features.
- Standardized on MySQL Enterprise Edition. Relying on the MySQL Enterprise Monitor Visual dashboard to monitor all MySQL databases at a glance. Automated alerts enable the Buongiorno DBAs to immediately focus on potential problems and fix them before they impact the system.
- Leveraging Oracle’s MySQL Technical support to assist their team. "We turn to the support team whenever we don’t know the answer, they are extremely good and really responsive" said Carmine Giordano, DBA Manager.
- Planning to use MySQL Enterprise Backup, that now integrates with their central company backup solution.
"MySQL is an excellent database to deliver mobile applications; it’s really fast, reliable and easy to use. I highly recommend MySQL Enterprise Edition; the latest version of the MySQL Enterprise Monitor is extremely useful and saves us a lot of time and efforts." Carmine Giordano, DBA Manager, Buongiorno
MySQL Enterprise Monitor provides real-time visibility into the performance and availability of all your MySQL databases. Learn More.
Thursday Jan 30, 2014
By Bertrand Mattheli�-Oracle on Jan 30, 2014
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.
- 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.
- Selected MySQL to power Gina Tricot’s e-commerce application based on its reputation as default database for web-based transactional applications, its low Total Cost of Ownership (TCO) and the recommendation of the local partner in charge of the implementation.
- Decided to outsource both the physical infrastructure to a public cloud services provider and the day-to-day database administration to Oracle partner Emineo in Sweden.
- Implemented MySQL replication to improve performance and scalability. While the system was initially built using MySQL Community Edition, upgraded to MySQL Enterprise Edition in order to ensure better performance, reliability and security. The MySQL Enterprise Monitor visual dashboard furthermore provides the Gina Tricot IT managers with an overview of the health of the databases at any point in time.
- Using the MySQL Enterprise Monitor and MySQL Query Analyzer to detect poorly performing queries and to fix both existing and potential issues before they impact the application.
- Achieved objective of maintaining visibility on all key database performance indicators and control over the application while delegating the execution of the database administration tasks to a partner.
"MySQL Enterprise Edition enables us to expand and grow online sales in both existing and new countries while maintaining a low TCO. It is a high performance, scalable and easy to monitor database; we’re extremely pleased with it." Nicklas Griphem, Manager Server & Infrastructure, Gina Tricot
Wednesday Jan 29, 2014
Atos Manages Transaction Clearing for the Euronext Markets in Continental Europe with MySQL Enterprise Edition
By Bertrand Mattheli�-Oracle on Jan 29, 2014
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.
- Migrate from a proprietary HP NonStop-SQL/MP environment towards an open source infrastructure enabling both a drastic reduction in the Total Cost of Ownership (TCO) as well as technology independence.
- Guarantee the robustness and the high availability of this highly mission critical financial application.
- Increase the performance and the scalability of UCS to address constantly growing transactions volumes.
- Adoption of an Open Source strategy and complete re-engineering of the application relying on a software stack including Linux, MySQL Enterprise Edition, Apache/Tomcat, and the C and Java languages. The new system is architected around several servers or clusters of blade servers running Linux, some of them virtualized, and a SAN. The application primarily relies on the InnoDB storage engine, using the Memory storage engine to a lesser extent.
- Implementation of an architecture built around business processes acting as sub-components multi-instantiated to allow for better scalability. The previous architecture allowed siloed processes to become bottlenecks.
- Geographical redundancy achieved using synchronous replication between two data centers, separated by 40 kilometers.
- The UCS application handles :
- In excess of 1 million transactions per day, peaking at 2 million per day during the summer of 2011
- 8000 files sent to customers daily
- 700 batch processes each night
Several benchmarks were run to ensure that the application could scale to handle more than 6 million daily transactions. Vincent Cornet, DBA Support Manager at Atos, recalls "During one of our benchmarks we faced a crash. We turned to Oracle’s MySQL support team and obtained a fix within 48 hours, which was subsequently integrated within the official MySQL version. We were extremely pleased with such responsiveness."
- The reengineering of the application handling the clearing for the Cash markets was a project that lasted for 15 months, involved 12,000 man-days of effort and resulted in:
- An entirely reworked platform and software architecture
- New data centers
- New SAN and commodity blade servers
- New administration and monitoring tools, including MySQL Enterprise Monitor and MySQL Workbench
- Successful delivery, and an extremely pleased customer
- Following that achievement, similar re-architecting of the clearing system for derivative products. Requiring teamwork between more than 40 people from different departments and a 24/7 task force for 6 months.
- The objective of drastically reducing TCO was realized while at the same time the maintenance of the system was simplified and its performance increased. The new UCS application has been a success and has been praised by all parties involved. In addition to being one of the best transactional solutions on the market, it also represents a great technological and human achievement thanks to the very strong cooperation between all of the teams to drive change using new technologies. Atos has moreover acquired an expertise valuable to other customers across multiple industries.
- Beyond an upgrade to MySQL 5.6, Atos is now also considering using MySQL Cluster within the UCS architecture or other similar applications in the future.
"MySQL allows us to sleep soundly at night, which was far from being the case with the old system. We deliver better results at a lower cost, and the quality of Oracle’s MySQL support is exemplary." Vincent Cornet, DBA Support Manager, Atos
Tuesday Jan 14, 2014
Atos Gère le Clearing des Transactions des Marchés Euronext en Europe Continentale avec MySQL Enterprise Edition
By Bertrand Mattheli�-Oracle on Jan 14, 2014
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 solde net dû ou à recevoir ainsi que par des flux nets de titres à livrer ou à recevoir.