Tuesday Mar 26, 2013

Upcoming MySQL Events in Europe

Oracle's MySQL team in Europe is very busy running or participating to a number of events during the upcoming couple of months.

Join us to learn about the latest developments and get all your questions answered!

More events will be scheduled worldwide and listed on our events page.

MySQL User Group meeting, Stockholm, Sweden
April 10

MySQL Tech Tour: Delivering Flexible, Robust and Elastic Solutions for the Web and the Modern Enterprise - Reading, UK
April 11

MySQL Tech Tour: From the Web to the Cloud - München, Germany

April 17

Norwegian User Group Conference 2013 - Oslo, Norway
April 17

MySQL Tech Tour: From the Web to the Cloud - Hannover, Germany

April 18

MySQL Tech Tour: From the Web to the Cloud - Baden, Switzerland
April 24

MySQL Tech Tour: From the Web to the Cloud – Rome, Italy
May 7

MySQL Tech Tour for Software & Hardware Vendors: Improving Your Products with New MySQL Features and Faster Performance - London, UK
May 15

We hope to see many of you there!

Thursday Mar 21, 2013

ip.access Relies on MySQL to Support Mobile Traffic Growth

ip.access specialises in delivering full end-to-end small cell solutions for Tier 1 and Tier 2 telecom operators around the world. Headquartered in Cambridge, UK, ip.access has been deploying small cell solutions for over 10 years, initially in 2G but now with 3G and 4G products.  They have products integrated in over 100 customer networks around the world, with the capability to accelerate the introduction of small cell solutions into networks irrespective of use case, technology or deployment model.

Small Cells are low-power wireless Access Points that are deployed via standard internet connections and operate within the Mobile Operators' licensed spectrum. Network coverage and signal quality are major influences on subscriber satisfaction and retention, so operators leverage small cells to cost-effectively support the growth in mobile data traffic and cover areas of poor network coverage.

In addition to the small cell access points, the ip.access complete solutions include gateways that bridge between the small cell network and the existing mobile core networks, and a Network Orchestration System for configuration, management, monitoring and reporting across the network.


  • ip.access solutions are deployed within mission critical telecom environments. The database they would integrate needed to provide five nines (99,999%) availability in order to ensure continuous coverage and access to the mobile operators’ networks.
  • The Network Orchestration System (NOS) required a database consolidating the network inventory, status and monitoring data into one centralized, scalable and secure system.  It had to be capable of serving a network of over a million small cell units. Moreover, the database was to provide the high performance read/write access needed today as well as in the future, with transactional demands rising as the next generation self-organizing networks drive ever more sophisticated event processing within the NOS.
  • A cost-effective database solution was critical in order to allow operators to test the ip.access offerings during a trial period, or to start with relatively small deployments. Yet, the database had to be highly scalable in order to support the larger deployments of Tier 1 mobile operators as they take early stage pilots to full national roll-out.
  • The system was designed around the same concepts as the so-called “brain” within mobile networks, the HLR (Home Location Register) which stores details of every subscriber and their location. Like traditional telecoms Intelligent Network (IN) platform architectures, there is a master database running on centralized servers, accessed by application services running on front-end servers. Consequently, the database had to be plug & play across multiple back-end servers to scale the solution in an N+1 environment.
  • Database integrity was paramount, including strong referential integrity checking, as losing data or its full relationship, was not an option.
  • Other considerations included but were not limited to:
  • Non-service affecting backup of the database and High Availability mechanisms
  • Geographical redundancy
  • Low to zero administration overhead
  • Access to maintenance releases, bug fixes, patches and updates
  • Availability of database performance monitoring and tuning tools
  • 24 X 7 Support
  • Globally deployable and locally supportable through local partners
  • Access to database tuning experts and architecture consultancy services to optimise performance in the core product and in individual projects.


  • The ip.access team evaluated several databases, and also considered the option to build its own database solution. They ultimately selected MySQL, which delivered the required performance & scalability, high availability and zero administration capabilities, while being a cost-effective solution fulfilling their other requirements. Additionally, the MySQL database and MySQL Cluster are proven solutions in telecom environments that demand five nines availability, powering the mission critical HLR systems of numerous Network Equipment Providers.
  • MySQL databases are integrated within the small cell access controller, providing real-time information about the access points connected to the network, as well as within the NOS, ensuring the configuration, monitoring and management of the system and delivering real-time performance information, alarms and various Key Performance Indicators (KPIs).
  • For installations counting up to 250K small cells, MySQL Enterprise Edition is deployed on active-standby servers. High Availability and geographical redundancy are achieved through DRBD (Distributed Replicated Block Device) and three-way replication.
  • In networks comprising over 250K small cells, or requiring utmost read/write access performance for the new breed of location presence services, performance KPIs threshold calculation and correlation…etc, MySQL Cluster Carrier Grade Edition is typically implemented.
  • The MySQL Enterprise Monitor and Query Analyzer management tools included in the MySQL Enterprise and MySQL Cluster Carrier Grade Editions enable simple and rapid performance monitoring and tuning when needed.
  • Relying on Oracle’s MySQL database solutions, ip.access delivers complete end-to-end systems to mobile operators, beyond access points, enabling them to “small cell enable” their networks. Moreover, the company’s broad portfolio allows Mobile Service Providers to start pilot projects and run tests cost-effectively, and then to very rapidly scale as needed.
  • Choosing MySQL paid off for ip.access. It enabled the company to focus on what they do best, investing their resources in the development of a differentiated solution. It accelerated time to market and allowed ip.access to offer flexible solutions to its customers, without imposing major pricing constraints on entry-level deployments. Finally, the features and MySQL innovation driven by Oracle ensure ip.access that the MySQL database and MySQL Cluster will continue to represent a foundation of choice for their next generation offerings.                
  • Oracle is a strategic partner to ip.access, which furthermore uses the AcmePacket products for its security gateways, and offers Oracle Sun hardware products to operators wishing the hardware to be supplied as part of the end-to-end small cell solutions. Oracle RAC can also be used within the ip.access solutions should the operator requirement be defined.

“Oracle’s MySQL solutions allow us to focus on building differentiated solutions on top of a solid foundation that we don’t need to worry about. The ability to define a cost effective standard solution that can scale up to meet any operator's need was critical to us.  MySQL made the build vs buy decision an easy one.” Gavin Ray, VP Product & Marketing, ip.access

Thursday Mar 14, 2013

MySQL User Group Meeting

MySQL User Group meeting, Stockholm, Sweden - April 10, 2013
After some time the Swedish MySQL User Group is organizing and announcing the upcoming MySQL User Group meeting in Stockholm!!! Everyone who are around that area on April 10, 2013, please make sure that you do not miss this great opportunity to listen and ask questions the main guest Mats Kindahl, (the Senior Principal Software Developer MySQL) who will be talking on Replication news on MySQL 5.6.!!!  

Above this main topic and Q&A on MySQL Replication, you will also have an opportunity to suggest topics for the upcoming SMUG meetings as well as enjoy the food & mingle.

Date: April 10, 2013
Start: at 4pm
Where (address) : Emineo; Lilla Västerbron 20; 11219 Stockholm; Sweden
URL for registration & updates: LinkedIn; Facebook
Proposed Agenda:

  • Replication news in MySQL 5.6 by Mats Kindahl, Senior Principal Software Developer MySQL
  • Q&A MySQL Replication
  • Topics for upcoming SMUG meetings
  • Food & mingle

Come to join us!!!

The MySQL Connect 2013 Call for Papers is Open!

Following the success of its first MySQL Connect edition, Oracle will hold MySQL Connect 2013 on September 21-23 in San Francisco.

The Call for Papers is now open, and will be running until April 12. We highly encourage MySQL users, customers, partners and community members to submit session proposals now.

MySQL Connect represents a unique opportunity to learn about the latest features of the best MySQL product releases ever, discuss product roadmaps, and connect directly with the engineers driving MySQL innovation.

The Conference is chock-full with technical sessions, hands-on labs, Birds of a Feather (BOF) sessions and tutorials delivered by MySQL community members, users, customers, partners and Oracle’s MySQL engineers.

The event will include five tracks: Performance and Scalability, High Availability & Replication, Cloud & Big Data, Database Administration & DevOps, Architecture and Application Development.

This is your chance to share real-world experiences, best practices and insights you’ve gained with the MySQL Community at large. You’ll be able to address not only long time MySQL users and highly experienced professionals but also newer and eager MySQL customers traditionally attending Oracle OpenWorld. Don’t miss this opportunity and submit your sessions today.

Interested in exhibiting and sponsoring? Email MySQL-Connect-Exhibit_ww@oracle.com for details.

Friday Mar 08, 2013

MySQL Web Reference Architectures - Your Guide to Innovating on the Web

MySQL is deployed in 9 of the top 10 most trafficked sites on the web including Facebook, Twitter, eBay and YouTube, as well as in some of the fastest growing services such as Tumblr, Pinterest and box.com

Working with these companies has given MySQL developers, consultants and support engineers unique insight into how to design database-driven web architectures – whether deployed on-premise or in the cloud.

The MySQL Web Reference Architectures are a set of documented and repeatable best practices for building infrastructure that deliver the highest levels of scalability, agility and availability with the lowest levels of cost, risk and complexity. 

Four components common to most web and mobile properties are sized, with optimum deployment architectures for each:

User authentication and session management

Content management


Analytics and big data integration

The sizing is defined by database size and load, as shown below

For each reference architecture, strategies for scaling the service and ensuring high availability are discussed, along with approaches to secure, audit and backup user data, and tools to monitor and manage the environment.

The Reference Architectures cover the core underlying technologies supporting today’s most successful web services including:

- MySQL Database

- MySQL Cluster

- MySQL Replication

- Caching with Memcached and Redis

- Big Data with Hadoop


- Geographic Redundancy

- Hardware Recommendations

- Operational Best Practices

An example of the "Large" reference architecture is shown below

To learn more:

- Download the MySQL Web Reference Architectures Guide

- View the MySQL Web Reference Architectures slides

The Reference Architecture are designed as a starting point which we hope will enable you build the next web and mobile phenomenon!


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




« March 2013 »