Page 19 - Open Soource Technologies 304.indd

Open Source Technologies

Notes
analyzed. There is no need to switch the servers back and forth between on-line and off-line,
which eliminates unnecessary risks to server availability and reliability.
After deploying the My SQL Query Analyzer, Big Fish Games tripled its database performance
within three days, rather than weeks.
My SQL Enterprise Monitor

Big Fish Games also relies on the My SQL Enterprise Monitor and the Dashboard graphs,
which show the number of queries per second, CPU load and replication status, to ensure
that the website is performing well. Big Fish Games finds the My SQL Enterprise Monitor
valuable because it is built for My SQL and offers more relevant and useful information
than generic monitoring tools.
The My SQL Enterprise Monitor provides critical data points for Big Fish Games to analyze
and determine the optimal number of slaves to serve its current website traffic and to plan
for the future capacity requirements. This tool also helps the DBA team to gain insight into
the system status, usage patterns and potential problems, without having to wait to be
notified by the operations group.
Big Fish Games chooses to deploy My SQL Enterprise for the following reasons:
• High Performance: My SQL provides fast transaction speed to serve over 300,000
simultaneous users on BigFishGames.com.
• Ease of use: My SQL is very easy to use which allows DBAs to manage My SQL servers
without a steep learning curve.
• Low Maintenance: Using My SQL Enterprise Monitor, Big Fish Games employs just
two DBAs to monitor over 70 My SQL servers, 40 in active production and 30 in the
testing environment.
• Low TCO: My SQL enabled Big Fish Games to launch their business, grow fast and
establish themselves as the industry leader at a fraction of the cost compared to using
a proprietary database.
• Unlimited Deployment: My SQL Enterprise Unlimited gives Big Fish Games the
fixed-cost predictability to deploy additional servers without additional costs. This is
especially beneficial for companies with rapidly growing data.
• 24x7 support: My SQL offers top quality support, with long-time My SQL developers
providing guaranteed 30 minutes response time for My SQL Enterprise Platinum
customers. It’s invaluable for Big Fish Games to receive problem solving advice from
My SQL support engineers when business-critical applications go down at midnight.
• Support for popular Operating Systems: My SQL is well-integrated with all major Linux,
Solaris and Unix distributions, saving time for DBAs and improving administrative
experience.
• Support for C, C++, C#, PHP, Python, Ruby and Java: My SQL supports drivers for
a wide range of programming languages, including PHP, used by Big Fish Games for
the front-end presentation layer, and Java, used with the Tomcat application server in
the middleware layer.
Memcached
In addition to My SQL Replication, Big Fish Games further increases scalability by using
Memcached, a distributed caching layer. All the web content is stored in Memcached, and
Contd...

14 LOVELY PROFESSIONAL UNIVERSITY