The world's most popular open source database
Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.
Below you will find valuable resources including case studies and white papers that will help you implement cost-effective database solutions using MySQL.
Download here MySQL Enterprise Edition ebook!
Introduction to MySQL Enterprise Edition
MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime. It reduces the risk, cost, and complexity in developing, deploying, and managing business-critical MySQL applications.
Customers References
Italtel enables Networking Convergence using MySQL Cluster Carrier Grade Edition
Italtel is an acknowledged leader in Next-Generation Network solutions. MySQL Cluster Carrier Grade Edition combined the flexibility of a general purpose database with unprecedented reliability and scalability for Italtel’s next generation products to satisfy the requirements to scale from a few thousand to millions of subscribers.
“We decided to use MySQL for our products because we found that it had wide-spread, proven deployments — and met our stringent reliability and scalability requirements for the communications industry.”
Franco Serio
UN's FAO Selects MySQL as its Open Source DB Standard
MySQL AB has announced the selection of MySQL as the open source server-side database standard by the United Nations Food and Agriculture Organization. “”One of the key requirements for our technical information systems is that they must be very easily available and accessible by the member countries as well as easy to set-up and maintain,” said Kurt Vertucci, Senior Officer, IT Governance for FAO. “We cannot dictate to countries what their infrastructure should be. Therefore, in addition to requiring very flexible licensing, these systems need to be portable and based on open standards.” After evaluating PostgreSQL and MySQL as possible alternatives, FAO selected MySQL as its open source database standard.”
“Looks like UN bureaucracy isn’t so great after all. They mention the improvements in MySQL 5, which are for real, but ignores MySQL ignorance of and misinformation on database basics and its inherent complexity due to the pluggable backends architecture.”
Leandro
Credorax delivers NextGen Payment Processing Technology
Credorax is a licensed Merchant Acquiring Bank, providing cross-border Smart Acquiring services to global merchants and payment service providers. Remaining true to their hi-tech roots and focus, Credorax is creating the next generation technology-driven banking solutions for the eCommerce arena.
Business Challenges
In 2007, Credorax saw an opportunity to fundamentally change the landscape of traditional merchant acquiring by using its technology assets and acumen to address the unique needs of online merchants of all sizes. This led the company to evolve into a Merchant Acquiring Bank. Remaining true to their hi-tech roots and focus, Credorax are creating the next generation of technology-driven banking solutions for the eCommerce arena. They are the first hi-tech company to become a principal member of Visa and MasterCard and a financial institution licensed under the PSD (Payment Services Directive). They needed an acquiring engine that scales the internet and is redundant with uptime of 5 Nines (99.999%). Today, Credorax’s Smart Acquiring & NextGen Payment Processing makes accepting payments simpler, safer and more cost effective than ever before.
Credorax’s Architecture
Credorax’s main payment processing engine uses MySQL at its core, for processing hundreds of transactions a second from customers globally. MySQL was chosen for it’s flexibility and modular design allowing it to fit into a custom designed architecture meeting Credorax’s specific throughput, availability and future scalability needs at a cost-effective price point.
Credorax utilizes a custom-meshed, highly available MySQL Architecture which enables both high levels of uptime and spreading of the load for reporting and time delayed backup.
Why MySQL?
Credorax chose MySQL for the following reasons:
- MySQL Flexibility – MySQL gives Credorax the flexibility to configure and optimize MySQL to meet the application requirements.
- MySQL Scalability – Sustained performance and scalability allowing Credorax to handle ever increasing users, queries and data loads.
- MySQL Reliability – MySQL Enterprise Edition is an enterprise-grade product that Credorax can rely on 24/7.
- Lower Database TCO – Allowing Credorax to deliver a high-performance solution that does not require specialized skills to operate.
- MySQL innovation – MySQL was a part of Credorax’s journey growing from Start-up to production, they have a unique and innovative solution; an entirely new breed of acquiring to PSPs, ISOs and online merchants. MySQL was the answer to an innovative technology that encourages thinking out of the box.
“As Credorax moved from a fin-tech startup to a Principal Member acquirer for Visa and Mastercard merchants, the need to be in full control of the data rose. We needed a database that is scalable, available at 99.99%, that supports cross geo-cluster replication, offers site failover support, built in tools, local principal expertise, Near Online monitoring and Real-time reporting. MySQL was able to offer all these at a reasonable cost.”
Nir Carasso
x.news Relies on MySQL Enterprise Edition
In the race to swiftly and accurately report on breaking news stories as they happen, today’s journalists are increasingly turning to social media outlets for the latest updates. At the same time, this rise of content has also led to a growing need for data filtering and verification – beyond that of human capability.
Seeing the growing need, Austrian based startup x.news decided to take action. In late 2015 they began collaborating directly with leading journalists from around the globe and developed a cloud-based social listening & news platform tool to support the continuous 24/7/365 news cycle. Using the free MySQL Community Edition, x.news quickly crafted an intuitive and flexible SaaS solution capable of digesting the mass amounts of data and presenting only the most relevant and verifiable pieces of information, via a customizable dashboard.
As the platform continued to grow and initial development was nearing completion, x.news took a look at several possible enterprise platforms to support their go-to-market solution.
Challenges
- Reliability: Provide uncompromised 24x7x365 availability to journalists around the world enabling them to quickly and accurately report on breaking news
- Scalability: Avoid expensive scalability and growth bottlenecks, commonly associated with a rapidly growing platforms and services
- Universal Device Support: Operate seamlessly on a cloud-based environment across mobile, tablet, and computers
- Simplicity: Simplify administrative functions in order to focus on core competencies and product development
- Backup: Implement a redundancy system, allowing for automatic failover protection in case of catastrophic events
Results
- MySQL Replication: Achieved 99.998% uptime using a MySQL Source + Replca Replication environment
- MySQL High Availability: Eliminated scalability concerns by upgrading to MySQL Enterprise Edition enabling High Availability on x.news servers
- MySQL Enterprise Monitor: Considerably reduced overall administrative duty time by taking advantage of MySQL Enterprise Monitor to fine tune their environment
From Inception to Market Solution
Like many startups, keeping costs low without compromising flexibility, reliability, and market responsiveness was a must for x.news. With these goals in mind, the decision was made to upgrade from MySQL Community Edition to MySQL Enterprise Edition to support their public launch.
One additional realized benefit was that developers wasted no time or money on training, giving them more time to focus on their core competencies.
“To support our enterprise launch, our engineers implemented a robust backup system using MySQL Enterprise Backup to ensure that our customers would face zero reliability concerns.” said Andreas Pongratz, CEO of x.news. “To date, x.news has achieved a 99.998% uptime window ensuring journalists never miss a story.”
“To date, x.news has achieved a 99.998% uptime window ensuring journalists never miss a story.”
Andreas Pongratz
Impeco innovates faster with MySQL Enterprise Edition
Impeco SA, based in Switzerland, is a pioneer in developing robotic solutions for automating and tracking the sample path in the Clinical Laboratories. Their solutions improve data traceability and process efficiency throughout the Laboratory workflow, from the beginning of the tube journey (at collection point) to the end, including any step in pre-analytical, analytical and post-analytical phases.
FlexLab is the trademark name for Impeco’s total lab automation solution that manages the tube processing, inside the Lab. It has been designed to provide hospitals and laboratories the freedom to connect analyzers from different suppliers and to extend the open approach to the largest possible portion of samples to be analyzed (e.g. for different analytical specialties).
As a result of being open, modular, scalable and fast, Impeco Automations have achieved the leadership position in their market.
Impeco Highlights
- Over 1500 Clinical lab automation systems installed worldwide
- Impeco systems operating in over 60 different countries
- 1.5 Billion tubes/year processed on Impeco systems
- 25 years experience in Clinical Laboratories
Business Challenges
- Simplicity: the platform needs to be simple to operate for Impeco’s non-IT customers (clinical labs, hospitals).
- Scalability: Impeco’s automation track sizes vary depending on the customers and can grow according to their evolving needs.
- Value for money: Impeco needed a reliable database solution with high performance and with competitive pricing model.
- Innovation: Impeco is built on innovation and it was imperative that their database choice would be able to offer more features as the Impeco Automation evolves.
Impeco’s Automation Architecture
Flexlab includes 2 main applications:
- The Sample Management System (SMS) which controls all the components of the automation, controls the deposition and routing of specimens, monitor where they are and where they should be. SMS is designed with the LabVIEW programming environment and runs on Windows.
- The Data Management Software (DMS), a software application that interfaces with the hospital and laboratory information system, receiving the orders from the labs and sending the results back once they are processed. DMS is written in PHP and runs on Linux.
Why MySQL?
Impeco chose MySQL for the following reasons:
- MySQL Flexibility: is designed to run on multiple platforms and operating systems. It is the ideal choice allowing Impeco to use the same database technology for both SMS and DMS applications, running on Windows and Linux respectively.
- MySQL Scalability: sustained performance and scalability allowing Flexlab to handle ever increasing users, queries and data loads.
- MySQL Reliability: MySQL Enterprise Edition is an enterprise-grade product that Impeco can rely on 24/7.
- Lower Database TCO: allowing Impeco to deliver a high performance, competitive solution that does not require specialized skills to be operated.
- MySQL innovation: Impeco’s vision is built around constant innovation. It is committed to continuous improvement of its Automation systems, to maximize customer satisfaction.
MySQL Enterprise Edition is enabling Impeco SA to rapidly evolve FlexLab into a robust solution, while optimizing development costs and efforts. “Our software manages big data and needs a robust database, since data history must be included as well; we were looking for a unique database able to tie together Linux and Microsoft architectures” – says Paolo Sestini, Systems Architecture Manager. “MySQL is able to meet Impeco’s needs and can also support our overall sample traceability program that starts at the collection point, with our ProTube solution.”
Impeco is innovating rapidly by delivering a remote real-time monitoring system that is going to be installed for all Impeco Automation systems, deployed worldwide for proactive maintenance. MySQL Enterprise Monitor, a key component of MySQL Enterprise Edition, is what Impeco is relying on for this project. Francesco Colloca, Supply Chain Manager, adds: “We were not just looking for a supplier, but we needed a partner to help us make our solutions outstanding; we needed excellence during both the development and the post sales phases, with an eye on value for money. Oracle MySQL and Oracle Team were the perfect fit for us.”
“To date, x.news has achieved a 99.998% uptime window ensuring journalists never miss a story.”
Paolo Sestini
Hospitality App Boosts Housekeeper Productivity, Hotel Profits
Fed up with recurring staff scheduling conflicts and delays getting hotel guest rooms cleaned, Virginie Lafon, the head of housekeeping at France’s legendary Hôtel le Negresco, set out to fix these problems when she designed the cloud-based mobile app 1Check.
Lafon founded 1Check, part of the Oracle Startup Cloud Accelerator program, in 2014 while working as the head of housekeeping at the Radisson Blu hotel in Nice, France. Her vision was to create an application to help hotel housekeeping staff work more efficiently and help hotel managers make more immediate and informed decisions about how to increase hotel profitability.
Real-Time Room Check
At the start of each shift, housekeepers log into the 1Check app from their mobile phones to view the schedule of rooms they need to clean. After clicking on a digital hotel map to see which part of the building they’ll be working in, they can double-click on individual room icons to verify guest check-in times and special cleaning instructions.
Before entering the rooms, housekeepers wave their phones in front of near-field communication tags mounted on the room doors and the front of their cleaning carts.
The app uses that data to indicate which rooms are being serviced, and estimate how long it will take to clean them and when they’ll be available for occupancy. After finishing a room, the housekeeper checks out using the tag on the front door and clicks on the room icon in 1Check to confirm the room is ready for inspection. Housekeeping managers also can receive alerts via phone when rooms have been cleaned.
“Hotel operations are no longer black boxes, controlled by the front desk,” says company vice president of marketing, Stephane Chauffriat. “Housekeepers can now use 1Check to inform the front desk precisely when rooms will be ready for guests to check into them.”
1Check claims its customers are seeing 7% to 8% increases in productivity per housekeeper, and improved overall housekeeping efficiency of around 35% annually.
One productivity gain comes from allowing employees to do tasks such as getting their work schedule, requesting a television repair tech, confirming a room inspection, or responding to a guest service request from their mobile phone instead of walking to make the request in person or to find a house phone. “A typical housekeeper could walk up to seven miles per shift,” Chauffriat says. But with 1Check, “staff can reduce the distance they walk during a shift to a single mile.”
Stability Matters
The 1Check app is built on an open source LAMP stack—Linux operating system, Apache web server, MySQL database, and PHP application software. The stack offered a low-cost, easy to deploy architecture, but 1Check had struggled with stability. For example, if the server running the database in a local data center crashed, “we’d have to contact an administrator who had to reboot the machine or restore a backup,” says company CTO, Ludovic Timbert.
That kind of downtime doesn’t fly in an industry that never shuts down. “Our customers operate on a 24/7 schedule,” Timbert says. “We need our app to always be available.”
To improve its reliability, 1Check now uses the replication and clustering features of Oracle MySQL Cloud Services, so its database runs as a virtual server in the cloud instead of on one physical server in a rented data center. By running on Oracle Cloud Infrastructure, “we can monitor our PHP application in real-time, migrate all of the day-to-day workloads, and then run them reliably and at scale,” Timbert adds.
1Check’s app is being used in 150 hotels and resorts throughout France. And the company is looking to expand into Chile, the US, Belgium, Italy, and Spain. Although 1Check’s app was developed as a hospitality management tool, the company is also exploring new markets such as hospitals and nursing homes, campsites, cruise ships, and passenger airplanes.
Having crafted technology, processes, and rules needed to meet the standards of 5-star hotels, “these can easily be adapted for any type of environment where cleaning, maintenance, and quality control are expected,” Chauffriat says.
To support its expansion strategy, 1Check is migrating its PHP modules into Oracle Container Cloud Service. Using Docker containers as cloud services, 1Check will be able to more quickly introduce new features, add new customers, and deploy its app anywhere in the world, without requiring manual administration or local, physical machines.
Better Measures
Another key feature of the 1Check app is its analytics dashboard that shows executives what the average cleaning and turnaround times are for each room. Pre-built and configurable reports help executives calculate the real cost of rooms by analyzing labor, energy consumption, and maintenance data. At most hotels, “these analytics don’t exist by room today,” Chauffriat says. “They only exist at the end of the month as an average for all of the rooms in the hotel.”
Rooms with consistently long turnaround times might indicate a need for upgrades, or a change in staff training.
Hospitality brands are vulnerable, Chauffriat says, because reputations can be built or ruined by any bad experience—especially when that experience is amplified on social media.
“This is why 1Check’s room analytics are so important,” Chauffriat says. “We can help hotels understand why a customer was unhappy. And we can inform them of what needs to be done to prevent the dissatisfaction in the future.”
Sasha Banks-Louie
Download Innovation ha aderito al Manifesto per la Repubblica Digitale: cultura informatica e competenze digitali sono requisiti essenziali della cittadinanza.
© Copyright Sorint.lab S.p.A. 2020