Page 257 - Open Soource Technologies 304.indd

Unit 10: Database

Notes
• Unlimited Deployment: MySQL 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: MySQL offers top quality support, with long-time MySQL developers
providing guaranteed 30 minutes response time for MySQL Enterprise Platinum
customers. It is invaluable for Big Fish Games to receive problem solving advice from
MySQL support engineers when business-critical applications go down at midnight.
• Support for popular Operating Systems: MySQL 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: MySQL 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 MySQL Replication, Big Fish Games further increases scalability by using
Memcached, a distributed caching layer. All the web content is stored in Memcached, and
most of the website queries are processed by this in-memory cache, which significantly
improves response time as well as scalability.

Sun Fire x64 Servers
• Big Fish Games utilizes a 3-tier server deployment strategy, and Sun’s x64 servers have
been chosen because of their excellent reputation for performance and reliability.
• Sun Fire X2100 server is best for applications which require lots of local disk space but
less I/O or CPU speed.
• Sun Fire X4100 server works well for applications which demand fast processors but
do not need speedy local disk I/O.

Sun Fire X4140 server is optimal with 8 drive bays for applications where faster local disk
I/O via RAID 10 and battery backed up write cache is essential.
By identifying the requirements for each application and the right server for each condition,
Big Fish Games has gained 20x in performance by merely replacing an X4100 server with
an X4140 machine.
Questions:
1. What do you mean by MySQL Query Analyzer?
2. Explain MySQL Replication.

Self Assessment

Multiple choice questions:
4. SQL stands for
(a) Standard Query Language (b) Structured Query Language
(c) State Query Language (d) None of these
5. The command DROP TABLE is use to
(a) Change a table (b) Delete a table
(c) Remove a table (d) None of these.

LOVELY PROFESSIONAL UNIVERSITY 251