MySQL Enterprise Edition: Customer Successes
API Outsourcing is a technology company and provider of CentreviewsBusiness Intelligence Suite, a simple, scalable, and secure solution for back office departments and professionals to automate their accounts payable, accounts receivable and document management processes. MySQL has been the core of the Centreviews platform since the inception in 2005. It stores all the data to support invoice approval workflow and the associated documents to data archives and remittance processes. MySQL serves over 10,000 Centreviews users daily and processes over 100 million transactions annually.
TickTrade Systems, based out of Toronto Canada, is a next generation electronic trading and analytics software provider for financial institutions and their clients. To support all of these cutting-edge technologies, TickTrade chose MySQL as the building block of its database solution.
Based in Italy, SERNAV Group was founded in 1989 and manages the complete cycle of marine transportation activities. The companies of the group handle shipping agents, customs operations, overland and nautical transportation of conventional goods & containers, storing, loading and unloading of containers as well as logistics and distribution.
forTravel Updates 300 Million Records Instantly, Ensures Stable Travel Portal Business Operations, and Supports 20% Annual Growth
forTravel, Inc. is the third largest subsidiary of Kakaku.com, Inc., which operates Japan’s most popular consumer goods price review site. To align with the corporate philosophy of “everything for travel”, forTravel manages an online travel portal that provides the country’s highest number of travel reviews and price comparison information. The portal also enables 80 million travelers per year to make travel reservations, research information and read reviews prior to departure, keep a journal during the trip, and share the experience with others on their return. With over 13 million visitors to Japan in 2014, forTravel is aiming to improve its service quality and support rapid growth in the domestic travel industry.
Lumata is an independent company focusing on business-to-business (B2B) services in the mobile marketing sector. The company, controlled by Francisco Partners and Buongiorno S.p.A., provides consumer brands, mobile operators, and hardware manufacturers with the tools required to interact with their customers via mobile devices. Lumata serves the international market through 15 offices that partner with more than 100 clients, including some of the world’s top-tier international phone companies and blue chip brands.
Established in 2007, Isibet, a registered trademark of Totoinvest S.p.A., is an online gaming and gambling business that offers betting on sporting events, casino games, poker, and other activities. Based in Italy, the company differentiates itself from its competitors with high-level gaming performance and ensures 24/7 online gaming and betting service for its customers.
Genoscope, the French National Sequencing Center, was created in 1997 and is one of the largest sequencing centers in Europe. It implemented MySQL Enterprise Edition to enable the scientific community to access genomic data via web applications.
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 team particularly valued its performance and scalability in addition to the opportunity to reduce database TCO by 90% compared to Microsoft SQL Server.
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.
Fabrikant.ru is a Russian electronic-trading platform that brings together market players-buyers, brokers, and suppliers-across different industries. Fabrikant.ru deployed MySQL Enterprise Edition with MySQL Database as a powerful, open-source database solution.
Zyme Relies on MySQL Enterprise Edition to Deliver High Quality Global Channel Insights to Customers
Zyme, based in Redwood Shores, California, is the global leading provider of Channel Data Management (CDM) solutions to companies selling through indirect channels. For high tech and consumer electronic products alone, over $1 trillion USD worth of goods are flowing through those indirect sales channels every year. However, when companies sell products through multi-tier channel partners and retailers around the world, it has proven to be challenging in acquiring global, standardized channel inventory and sales data cost-effectively. As a result, companies lacking of such critical information often miss the opportunities to make timely and accurate business decisions either to increase revenue, reduce costs or to prevent losses.
Having a vision to solve such channel visibility problems for customers including Symantec, Logitech, Seagate and Xerox, Zyme built its channel data management solutions that not only get reliable, high-quality channel data from thousands of partners worldwide, but also have the capability to integrate with customers’ existing on-premise or cloud CRM, Data Warehousing or Business Intelligence systems to bring such channel visibility and information to the field sales and marketing teams and drive better business results.
Gina Tricot is a Swedish fashion chain that consists of over 180 stores across Sweden, Norway, Denmark, Finland and Germany. They selected MySQL to power their e-commerce application based on its reputation as default database for web-based transactional applications and its low Total Cost of Ownership (TCO)
Atos Manages Transaction Clearing for the Euronext Markets in Continental Europe with MySQL Enterprise Edition
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. Atos adopted an Open Source strategy and completely re-engineered the application relying on a software stack including Linux, MySQL Enterprise Edition, Apache/Tomcat, and the C and Java languages.
"Oracle's MySQL solutions allow us to focus on building differentiated solutions on top of a solid foundation that we don't need to worry about. The ability to define a cost effective standard solution that can scale up to meet any operator's need was critical to us. MySQL made the build vs buy decision an easy one."
Gavin Ray, VP Product & Marketing, ip.access
Verizon Wireless, the #1 mobile carrier in the United States, operates the nation’s largest 3G and 4G LTE network, with the most subscribers (109 millions) and the highest revenue ($70.2 Billion in 2011). Seeing the stupendous rise in social media, video streaming, live broadcasting…etc which redefined the scope of technology, Verizon Wireless, as a technology savvy company, wanted to provide a platform to its employees where they could network socially, view and host microsites, stream live videos, blog and provide latest news.
"MySQL is the key component of Verizon Wireless' mission-critical employee portal application," said Shivinder Singh, senior DBA at Verizon Wireless. "We achieved 1400% performance improvement by moving from MyISAM storage engine to InnoDB, upgrading to the latest GA release MySQL 5.5, and using the MySQL Thread Pool to support high concurrent user connections. MySQL has become part of our IT infrastructure, on which potentially more future applications will be built."
The Phone House Telecom, headquartered in Muenster, Germany, is a wholly-owned subsidiary of UK-based The Carphone Warehouse plc - the world's largest independent mobile telephone retailer. The company has more than 850 employees, and more than 1.5 million customers. The Phone House's online shop, content management and online billing systems were distributed on different systems running Informix and Oracle databases. This legacy environment was difficult to maintain - especially when facing significant growth in the number of visitors to its online shop. The company decided to consolidate all these systems on one database platform, one that was easily scalable and less costly to administer.
Gumtree.com was started in March 2000 as a local online community notice board. The company has grown to cover over 70 cities across 8 countries, and is now the UK's biggest website for local community classifieds, including flat share, flat rentals and jobs - with more than 1 million live ads at any one time, and over 5.5 million visitors per month. >From the beginning, Gumtree needed a database to power its operations that would be reliable, robust and affordable - but most of all: scalable. The company chose MySQL, and has never looked back.
Adresseavisen was founded in 1767 and is the oldest newspaper in Norway. Adressa.no was launched in 1998 and now has an average of 100,000 unique visitors per day, and growing.
Adresseavisen is the largest web property in Polaris Media ASA, a Norway based media group with publishing, newspapers and digital services providing news via several other channels including radio and local-television (TV) stations, web TV and mobile phones.
Sahlgrenska University Hospital (SU) is one of the major hospitals in Europe and was founded in 1997 when three hospitals in Sweden merged; Mölndal Hospital, Sahlgrenska Hospital and Östra Hospital. Sahlgrenska provides emergency and basic care within the city of Göteborg with 700,000 inhabitants, as well as highly specialized care for the Västra Götaland county with 1.7 million inhabitants.
Every year, Sahlgrenska University Hospital records two million referrals and comments through the Central Registry system which is powered by MySQL. All in all, the Central Registry manages about 100 gigabytes of data with up to 2,000 concurrent users on a yearly basis. Moreover, Sahlgrenska's various care units have different requirements regarding the set up of the patient's medical profile within the Central Registry, which calls for a flexible and adjustable database solution.
Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.
The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the new MySQL Query Analyzer.
Uppsala Clinical Research Center, UCR, is a national center of competence for healthcare quality registries in Sweden, and is an independent unit under Uppsala University Hospital and the Disciplinary Domain of Medicine and Pharmacy at the University of Uppsala. UCR's overarching mission is to develop and improve healthcare by offering service in clinical research, clinical testing, quality registries, and quality development. UCR's National Quality Registries include treatment and outcome data based on all hospital patients in Sweden, and is used by thousands of doctors, nurses, medical secretaries and representatives within county councils. This range of comprehensive coverage makes the National Quality Registries one of its kind worldwide.
PA Digitale helps the Italian government authorities achieve the objectives established by the Italian e-government plan for Public Digital Administration. A reliable and easy to use database is key to delivering on the vision of providing efficient e-government tools. Based on its ease of use and reliability, PA Digitale selected the MySQL database as the engine in the core of its technology infrastructure. By administering databases activities with the MySQL Enterprise Monitor and the Query Analyzer, PA Digitale can meet the database requirements with extremely intelligent and easy-to-use tools.
The Øresund sound is the strait that separates Denmark from Sweden. The total length of the bridge is 15.9 kilometers (52,493 feet), and about 30,000 vehicles cross the combined two-track rail and four-lane road bridge-tunnel on a daily basis. It is the longest combined road and rail bridge in Europe and connects the two metropolitan areas of the Øresund Region: the Danish capital of Copenhagen and the Swedish city of Malmö.
In order to support and monitor the daily traffic data and transactions from 30,000 vehicles, the Øresund Bridge purchased a MySQL EnterpriseTM Platinum subscription from Sun Microsystems.
Cashpoint is a betting and gaming enterprise founded in 1996 in Austria and is the market leader in several EU countries including Germany and Austria. Cashpoint has an extensive network of betting offices, more than 3,000 betting terminals, and an online betting platform.
The Sybase database that was originally deployed at Cashpoint no longer met their ever-increasing data management requirements. The stability, reliability, and performance did not allow Cashpoint to achieve the required level of service availability. Therefore Cashpoint searched for a stable and low administration database environment to optimize their performanc levels, maintenance times, and availability demands.
be2 started in 2004 with its German web site be2.de and is now one of the world's leading matchmaking services with more than 17 million members in 36 countries and 20,000 new members joining be2 every day.
Today be2 uses MySQL Enterprise Server to store data like user information, customer administration, behavioural information, website configuration and content, business management (pricing etc.), payment records as well as email campaign and tracking data. A MySQL based data warehouse is used for additional reporting and analytical data like business metrics and online performance. With the MySQL Enterprise Gold subscription be2 receives all the tools needed for effective query analysis and database monitoring. Even with a strong and experienced DBA team, be2 benefited considerably from MySQL consulting resulting in further improvements to database stability, scalability and redundancy saving cost.
CASPUR is a non-profit inter-university consortium which was founded in 1992, based in Rome. It deals with scientific supercomputing applications and innovative technologies. CASPUR relies on MySQL because it is the de-facto standard database for the Bioinformatics industry. CASPUR employs a MySQL Enterprise subscription that allows them to monitor application reliability using MySQL Monitor, and improves query performance through the MySQL Query Analyzer.
Like many social network products, TweetMeme was initially developed in PHP using the MySQL open source database. With Twitter users growing at a month-over-month rate of approximately 82% for the first half of 2009, TweetMeme needed to manage incredible scalability demands being placed upon its database infrastructure. The nature of real-time search also meant that to stay competitive, TweetMeme needed to be highly available, offer lightning fast service delivery capability, while ensuring that management and administration costs didn’t grow out of control.
Ladok is the national system used for administration of higher education and documentation of academic information. The system is jointly owned by Swedish higher education institutions. Almost all institutions, 35 today, are part of the consortium together with the Swedish National Board of Student Aid. Ladok is also used for the institutions’ reporting to external recipients of information, among others the Swedish National Board of Student Aid, Statistics Sweden, the Ministry of Education and Research and the Swedish National Agency for Higher Education. The system is mainly used for matriculation and registration of students and their academic results and degrees.
The aim is to facilitate and abridge the daily work of departments and administration, for local and central planning as well as following up academic results, and to ensure the legal security and rights for the individual student.
thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
thePlatform is a leading, fast-growing video management and publishing company for broadband, mobile and TV. Since its debut, thePlatform quickly grew revenue, as well as momentum, in the media sector, and has successfully gained well-known customers, including Comcast, NBC-Universal, Associated Press, BBC Global News, HIT Entertainment and CNBC.
With 31,000 students and 4,300 scientists and employees the University of Duisburg-Essen not only ranks among the ten largest universities in Germany, it is also one of the most important employers in the region.
Since 2007, the University of Duisburg-Essen, the Technische Universität Dortmund and Ruhr-Universität Bochum have cooperated at different levels within the scope of the University Alliance Metropolis Ruhr (UAMR). As part of this alliance, UDE's task was to develop a joint E-learning platform to track and manage the students' compulsory courses. All data required for hundreds of available online courses is managed in MySQL -- including student and teacher information, course descriptions, curriculum, user activity, and results attained.
Aftonbladet was founded in 1830 and is the largest media group in Sweden. The Aftonbladet newspaper is the largest and most read newspaper in the Nordic region, with about 1,209,000 readers a day.
Aftonbladet.se is the largest news site in the Nordic region with approximately 4.2 million unique visitors per week, and growing. It is run by Aftonbladet Nya Medier and has received numerous prizes and awards through the years, amongst others the most honourable journalism award Stora Journalistpriset. Aftonbladet Nya Medier also delivers news via several other channels such as teletext, radio, web TV and mobile phones.
Clickability is the global leader in on demand Web Content Management, serving over 350 million page views per month for hundreds of customers. With the help of the MySQL Query Analyzer, Clickability investigated the cost of the most frequent queries and successfully identified a time-consuming one. By enhancing the application code, Clickability was able to reduce the database load and double the publishing application's performance. As a result, Clickability saves time and money in debugging, gets better utilization of their hardware, and scales with fewer resources by identifying the bottlenecks and removing them early in the development and deployment cycle.
Big Fish Games is a global leader in the online games industry, with over 25 million unique customer accounts and over 2.5 million visitors per month. MySQL allowed Big Fish Games to quickly grow their business with lower cost and hardware requirements, and has scaled with the company as it has grown into an industry leader. With the MySQL Query Analyzer, Big Fish Games was able to identify and analyze problematic SQL code, and tripled its database performance within three days, rather than weeks.
Clickability is the global leader in on demand Web Content Management, serving over 350 million page views per month for hundreds of customers, including Cisco, NetApp, Philly.com and CNN Interactive. faster. MySQL stores the core application data which is used across multiple applications that include serving 500+ million advertisements and distributing 10+ million emails every month.