Tuesday Apr 30, 2013

NetMotion Wireless Migrates Product from Microsoft SQL Server to MySQL: Reduces Costs and Increases Flexibility


NetMotion Wireless develops software to manage and secure wireless data deployments for organizations with mobile field workers. Founded in 2001, NetMotion Wireless is one of the fastest growing wireless and technology companies and the recipient of over 25 awards for outstanding technology.  NetMotion Wireless has over 2,500 customers, including Advocate Healthcare, Comcast, and Unilever.


NetMotion Wireless had used Microsoft SQL Server with Mobility Analytics, their mobile VPN product’s analytics module, but found it was too costly and lacked the platform and language flexibility to be a good [embedded] database. As a result, when the NetMotion Wireless product team was developing Locality, a cellular network management product, they decided to find an alternative database to use with it and with Mobility Analytics. The team compared MySQL with Microsoft SQL Server on a number of key criteria and, after finding nothing in the “con column”, decided to use MySQL.


According to Jonathan Wiggs, NetMotion Wireless database architect, MySQL has been able to meet their products’ needs for:

  • Real-time Data Collection and Analysis – with the ability to scale to hundreds of terabytes.
  • Strong .NET and Java Support“MySQL works every bit as well with ado.net as SQL Server, and its Java integration is equally good,” said Wiggs.
  • Database Profiling and Tracing – MySQL Enterprise Monitor provided back level visibility on par with other enterprise databases, providing the data analytics and caching levels their products require.  
  • Easy, Transparent Administration -“MySQL’s administration is automated, easy to configure, and highly configurable: we can get it to leap through any flaming hoops we need,” said Wiggs.
  • “The Perfect Trifecta” - “There has been no tradeoff in using MySQL.  MySQL has provided the perfect trifecta of feature parity, ease of integration, and lower cost,” said Wiggs.

Read more>>

Big Fish Selects MySQL Cluster for Real-Time Web Recommendations

The world's largest producer of casual games has selected MySQL Cluster to power its real-time recommendations platform.

High velocity data ingestion, low latency reads, on-line scaling and the operational simplicity delivered by MySQL Cluster has enabled Big Fish to increase customer engagement and deliver targeted marketing, providing a more personalized experience to its users.

You can read the full Big Fish Games and MySQL Cluster case study here - and a summary below

BUSINESS NEED

The global video gaming market is experiencing explosive growth. Competition is intense, and so to differentiate services and engage users, progressive gaming companies such as Big Fish are seeking solutions to more fully personalize the customer experience.

Using Business Intelligence (BI) and predictive analytics Big Fish can segment customers based on a range of demographic and behavioural indicators. This enables Big Fish to serve highly targeted recommendations and marketing, precisely personalized to a user's individual preferences.

Big Fish's Marketing Management Service platform, powered by MySQL Cluster, is used across all of the company's customer management systems, including customer support and the company's "Game Manager", to provide a unique customer experience to each of its millions of monthly users whenever they come in contact with Big Fish.

TECHNOLOGY SELECTION

Big Fish already has an extensive deployment of MySQL databases powering web applications, including the storefront. They knew MySQL could power the recommendations database, but would require additional engineering efforts to implement database sharding to support data ingest and future scaling needs, coupled with a Memcached layer for low-latency reads.

As a result, they began evaluations of MySQL Cluster, in addition to other database technologies. Using MySQL Cluster, the Engineering teams were able to leverage their existing MySQL skills, enabling them to reduce operational complexity when compared to introducing a new database to the Big Fish environment.

At the same time, they knew MySQL Cluster, backed by Oracle, provided the long-term investment protection they needed for the MMS recommendations platform.

Through their evaluation, the Big Fish engineering team identified MySQL Cluster was best able to meet their technical requirements, based on:

Write performance to support high velocity data ingest

Low latency access with in-memory tables 

On-line scalability, adding nodes to a running cluster

Continuous availability with its shared-nothing architecture

SQL and NoSQL APIs to the cluster supporting both fast data loading and complex queries

PROJECT IMPLEMENTATION

As illustrated in the figure below:

  • User data is replicated from the MySQL databases powering the gaming storefront to the Big Fish BI platform;
  • User data is analyzed and segmented within the BI platform;
  • Recommendations are loaded as user records into MySQL Cluster using the NoSQL Cluster_J (Java) Connector;
  • The SQL interface presented by the MySQL Servers then delivers personalized content to gamers in real-time, initially serving over 15m sessions per day.


Big Fish has subscribed to MySQL Cluster CGE providing the Engineering team with access to 24x7 Oracle Premier Support and MySQL Cluster Manager, which reduces operational overhead by providing:

  • Automated configuration and reconfiguration of MySQL Cluster;
  • Automated on-line node addition for on-demand scaling.

The online scalability of MySQL CGE can help Big Fish to meet future requirements, as it expands its use of MySQL CGE to include all new website developments, channels and gaming platforms. 

LEARN MORE

Read the full Big Fish Games and MySQL Cluster case study

Read the press release 


About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« April 2013 »
SunMonTueWedThuFriSat
 
1
3
5
6
8
11
12
13
15
16
19
20
21
23
24
27
28
29
    
       
Today