Notes from Michael Benzinger's "MySQL at Sabre" talk at the 2004 MySQL Users Conference.
Sabre had been the reservation system for American Airlines. They're also the backend for Travelocity as well.
Cost was the primary motivation for moving to MySQL.
Session, shop, price, sell, fulfill is the model they follow. Finding best fares is apparent a very hard problem. Lots of interesting algorithms to find the best paths and lowest costs. They price roughly 250 tickets per second.
Shopping finds the low fares. Shopping scales horizontally quite well. Pricing is used to print the ticket. Pricing used to be done on mainframes. Many companies still use them, but Sabre doesn't anymore. They run Linux on HP/Intel boxes now. They started with HP's PA-RISC running HP/UX but HP/UX didn't run on Intanium yet. Now they have 45 4 CPU Linux boxes. 1.5GHz, 6MB, 32GB RAM for shopping servers.
They also use GodenGate's Extractor/Replicator. InnoDB, 50-60GB of data, real-time updates, MySQL 4.0.15.
Interesting architecture diagram that I can't easily replicate here.
Development costs are way down (50%). Run-time and operational costs are significantly lower now too. They wrote their own API wrapper in C++ and have a pre-compiler used to convert the SQL for the MySQL API.
In addition to shopping, they use MySQL elsewhere too. Site59.com uses it. They're working on data mining and setting up a cheap data mart.
Posted by jzawodn at April 14, 2004 06:51 AM