Monday May 30, 2016

Myriad Group Connects Mobile Users Worldwide to Online Services with MySQL Cluster

Although smartphone penetration and 3G/4G coverage is increasing, the cost of data access is still beyond most people’s reach in emerging markets. The GSMA Foundation estimates (i) that only one-fifth of mobile connections in Sub-Saharian Africa are based on 3G, with 4G accounting for less than 1% of the connection base. The GSMA also estimates that "despite the shift in the region towards smartphones and mobile broadband, nearly 450 million connections will still be based on feature phones by 2020".

Myriad Connect Division is working closely with Mobile Network Operators (MNOs) worldwide to provide "no data access users" innovative and compelling services, creating new opportunities for operators to achieve 100% market reach worldwide and generate new revenues. The company offers MNOs & B2B integrators a best-in-class Unstructured Supplementary Service Data (USSD) platform, allowing them to easily create and deploy compelling cost-saving mobile services and boost monetization. In essence, Myriad connects users to online services without mobile internet access. It gives them for example access to the most popular social networks and connected services.

Myriad’s USSD+ platform is an enabler for a plethora of connected USSD applications in several domains, such as self-care portals and financial transactions, reaching all mobile users. Addressing for instance the challenge of low bank subscription rates in emerging markets, Myriad bridges the gap between mobile penetration and financial access, letting end-users check their bank account, make in-store transactions, bill payments and peer-to-peer money transfers, while conducting micro-credit and saving operations. Sub-Saharan Africa currently leads the world in the adoption of mobile money services, with more registered mobile money accounts than banks accounts in a number of countries.



Challenges

  • Deliver 5 nines (99,999%) availability for the mission critical USSD platform, including a disaster recovery capability ensuring transparent and instantaneous business continuity to MNOs in case of a natural disaster.
  • Effectively serve tens of millions of subscribers per operator with a high performance and highly scalable database.
  • Implement a solution trusted by Mobile Networks Operators, on which they would feel highly confident relying.

Solution
  • The Myriad R&D team evaluated several options and selected Oracle’s MySQL Cluster based on its characteristics and proven reputation in the communications industry. MySQL Cluster is an open source, ACID-compliant transactional database designed to deliver real-time in-memory performance and 99.999% availability. It powers the subscriber databases of major communications service providers and mobile networks with nearly a billion subscribers.
  • Numerous operators actually recommended MySQL Cluster to Myriad. Not only did they trust the proven database but they also very much valued its open source nature, providing them with the desired flexibility and ease of integration with existing infrastructures.
  • The flexibility of MySQL Cluster would furthermore allow Myriad to offer its solutions on-premises and in the cloud, while implementing different business models with its customers such as revenue sharing or "pay as you go" models.
  • Myriad’s "all in one" premium USSD platform integrates a gateway and a portal available for both cloud-based and in-network environments:
    • Myriad CellGate is a robust USSD gateway bridging the GSM/UMTS SS7 network to the IP world.
    • The USSD portal CellCube provides mobile operators with an environment for launching successful interactive services.
    • MySQL Cluster is implemented at the heart of the CellCube portal.

  • MySQL Cluster powers Myriad’s Disaster Recovery Center Active-Active (DRC A/A): USSD platforms are implemented at physically distant sites with synchronous replication between them, providing geographic redundancy and a capability for immediate & automatic disaster recovery without human intervention.  With its active-active geographic replication, MySQL Cluster ensures that each site can actively serve read and write requests while maintaining data consistency across the clusters.
  • On average the system processes 3000 messages per second for the largest MNOs and about 1000 messages per second for the mid-size ones.

"Mobile Network Operators demand solutions exhibiting high performance & scalability as well as high availability, with geographic redundancy and transparent failover. MySQL Cluster squarely addresses those needs and enables us to offer a USSD platform featuring a world-class Disaster Recovery capability."
Jean-Christophe Malinowski, Product & Marketing Director, Myriad Group.




(i) https://gsmaintelligence.com/research/?file=721eb3d4b80a36451202d0473b3c4a63&download 

Wednesday May 04, 2016

They Scale with MySQL

We sometimes get the question "Will MySQL scale to meet my needs?". Well, consider the following examples:


  • Booking.com processes 2 billion events/day relying on MySQL.
  • Facebook started out with MySQL, and scaled to 1.6 billion monthly active users.
  • Playing Candy Crush? You’re not the only one, 850 million games are played/day, served by MySQL.
  • PayPal built a globally-distributed database with 100 TB of user-related data based on MySQL Cluster. It is used for fraud detection globally; a highly mission critical transactional application.
MySQL solutions have become very popular in Asia as well, where certain countries with very large populations are relying on MySQL technologies to meet extremely high scalability requirements for mission critical applications. For instance:
  • MySQL Cluster powers a mobile network supporting over 800 million subscribers.
  • A government processed IDs for over 1 billion citizens with MySQL.
As we work closely with digital disruptors and organizations of all sizes demanding ever greater scalability from MySQL solutions, we are challenging ourselves to innovate and constantly evolve to meet their present and future needs. For example:
  • MySQL 5.7, our latest GA release, is 3x faster than MySQL 5.6.
  • After adding native JSON support in MySQL 5.7, Oracle recently announced the MySQL Document Store, enabling you to benefit from the best of the NoSQL and SQL worlds in the same MySQL database! You will be able to combine the flexibility of schema-less document stores with the power and proven performance of the relational model. In case you haven’t seen the short video introducing the MySQL Document Store, watch it now. And then try it out.
  • Security is a major topic, and we recently released MySQL Enterprise Transparent Data Encryption to protect your critical data by enabling data-at-rest encryption in the database.
And Oracle keeps driving MySQL innovation in many other ways, benefiting all our users and customers.

So in case you’re wondering if you’ll be able to scale with MySQL…They do, and chances are that you will as well. Contact us directly to discuss your specific requirements with our representatives.


Friday Apr 29, 2016

May 2016 - December 2016 => Events where you can find MySQL

As an update to the blog posted on Apr 29, 2016, please find below list of events where you can find either MySQL Community team or MySQL experts at.  Please find more details at each conference below.  New events are marked with NEW! Any update to already announced event is marked as UPDATE!:

  • July 2016:
    • NEW! Debian Conference 2016, Cape Town, Africa (July 2-9, 2016) 
      • MySQL Community team is going to support this conference financially even without staffing. 
    • Open Source Conference Okinawa 2016, Japan (July 2, 2016)
      • As tradition we are going to actively participate at this OS event, this time in Okinawa, Japan. There will be a MySQL booth in expo area as well as MySQL talk as follows:
        • general topic "State of Dolphin" focusing more on "Document Store ant X Dev API" given by Ryusuke Kajiyama, the MySQL Sales Consulting Manager of Asia Pacific and Japan. 
    • Texas Linux Fest, Austin, US (July 8-9, 2016)
      • MySQL Community team is supporting this event and we are planning to have a MySQL booth. The schedule is not yet announced, but we are planning to have a MySQL talk as well. Please watch the organizers website for further updates.
    • NEW! db tech showcase, Tokyo, Japan (July 13-15, 2016)
      • MySQL team is going to attend the db tech showcase conference in Tokyo, Japan. This time we are going to have a huge presence by MySQL talks. The schedule can be found on the conference url. Please do not miss following talks:
        • "RDBMS & NoSQL, Best of the booth worlds" by Shinya Sugiyama, the MySQL Sales Consultant, scheduled for Jul 13@13:00
        • "MySQL 5.7 - Inno DB" by Mikiya Okuno, the MySQL Support team, scheduled for Jul 14,@10:00
        • MySQL replication talk by Yoshiaki Yamasaki, the Senior Sales Consultant for Asia Pacific and Japan, scheduled for Jul 14@16:00

  • August 2016
    • FrOSCon 2016, Sankt Augustin, Germany (August 20-21, 2016)
      • As a tradition MySQL Community team is going to support this event with a MySQL expert on site. This year we are going to have a MySQL booth at the expo area as well as we will be submitting a MySQL talk. Please watch the organizers website for further updates.
    • NEW! COSCUP 2016, Taiwan, Taipei (August 20-21, 2016)
      • We are pleased to announce MySQL attendance at COSCUP 2016. This time there are 2 workshops approved one on Configuring MySQL HA architecture with Group Replication and Router and second one on Implementing and operation MySQL document store both given by Ivan Tu, the Principal Sales Consultant. There will be also at least one MySQL talk once that is approved. Please watch the organizers website for further information.
  • September 2016
    • NEW! Open Source Conference Enterprise, Tokyo, Japan (September 1, 2016)
      • As a tradition we are going to be part of this OSC conference in Tokyo. You can find our MySQL staff at the booth in expo area and also you can talk to us after the MySQL session. Do not miss the talk! please watch the organizers website for the timing.
    • UPDATE! SwanseaCon 2016, Swansea, UK (September 12-13, 2016)
      • This year for the first time MySQL Community team is going to be part of this development conference. We have secured a Gold sponsorship with a MySQL booth in the expo area. Do not miss the opportunity to stop at our booth to talk to our MySQL members and attend our talk on "Scaling MySQL" given by David Stoke, the MySQL Community Manager, scheduled for September 13, 2016 @11:35am.
    • PyCon Japan, Tokyo, Japan (September 20-22, 2016)
      • MySQL is going to become a Silver sponsor of this conference with a MySQL booth in expo area. We are also planning to submit several talks and we strongly hope they will be approved. Please watch the organizers website for further updates.
    • UPDATE! WebExpo, Prague Czech republic (September 23-24, 2016)
      • We are happy to announce that MySQLis part of this technology conference in lovely Prague this year for the second time. We are planning to have a MySQL booth & talk on "MySQL 5.7 and MySQL Document Store" given by Johannes Schlueter, the Lead on Connector/Node.JS for MySQL. Please watch the organizers website for program updates & do not miss the opportunity to talk to our MySQL members at the booth!!
    • PyCon India, New Delphi, India (September 23-25, 2016)
      • Again this year we are planning to become a sponsor & partner of this PyCon in India with a MySQL booth and several talks. Please watch organizers website for further updates.
  • October 2016:
    • Ohio Linux Fest, Columbus, US (October 7-8, 2016)
      • We are pleasure to announce that MySQL Community team is part of this show. We are going to have a MySQL booth at this show and MySQL talks as scheduled below:
        • MySQL 5.7, scheduled on October 3@1-2pm
        • MySQL's NoSQL, scheduled on Oct 3@3-4pm, both given by David Stokes, the MySQL Community Manager.
    • NEW! PHP Brno, Brno, Czech Republic, (October 15, 2016)
      • It's our pleasure to announce that MySQL Community team is going to be part of this PHP show in Brno. We are going to be Gold sponsor with at least one already approved talk on "MySQL 5.7 & JSON: New Opportunities for Developers" given by Frederic Descamps, the MySQL Community Manager. More talks will be hopefully approved once the schedule is set. Please watch organizers' website for further updates.
  • November 2016:
    • PHP.RUHR, Dortmund, Germany (November 10, 2016)
      • MySQL team is going to be part of this show with a MySQL talk. Please watch organizers website for further updates. 
    • DOAG 2016, Nuremberg, Germany (November 15-18, 2016)
      • As a tradition we are again plan to attend the DOAG 2016 with MySQL talks as well as with MySQL representatives at the Oracle booth in expo area. 
    • NEW! BuzzConf 2016, Phoenix Park, Ballan, VIC (November 25-27, 2016)
      • Please find our MySQL representatives at this very special event called BuzzConf. It's partially an conference and partially festival. Come to have a lot of fun with organizers as well as do not miss to find our MySQL guys! 
  • December 2016:
    • NEW! IT Tage,  Frankfurt, Germany (December 12-15, 2016)
      • We are pleased to announce that MySQL team is going to attend and talk at IT Tage this year. There will be 3 talks given by our MySQL experts:
        • “MySQL as a Document Store: Best of Both Worlds” by Mario Beck, MySQL Sales Consulting Manger
        • "MySQL Security talk" given by Carsten Thalheimer, the MySQL Sales Consultant.
        • Third one is still TBC, please watch the organizers website for further updates.
      • Come to hear our sessions and talk to our MySQL staff! We are looking for meeting you there!
    • NEW! PHP Brazil 2016, Sao Paulo, Brazil (December 7-11, 2016)
      • We are happy to announce MySQL Community team attendance at PHP Brazil this year. We are planning to have MySQL talks & MySQL booth in the expo area. Please find our staff there and watch organizers website for further updates. 
There is more events planned for the second half of the 2016. We will keep you informed or you can check the MySQL Community platform for more information.

Wednesday Apr 27, 2016

Thank You for Attending the MySQL Innovation Day


The MySQL Innovation Day took place on Monday, April 25, at the Oracle Conference Center in Redwood Shores, California. Jam-packed with 9 sessions delivered by Oracle's MySQL team, the event offered great opportunity for the attendees to learn the latest products and features in MySQL 5.7, including replication, security, optimizer, JSON-support, as well as the recently-announced MySQL Document Store.

We would like to thank all the attendees for participating in this event. Your enthusiasm for learning more about MySQL, through interactive discussions in each of the sessions and through sharing your own experience using MySQL, made this event even more unique and valuable for speakers and your fellow attendees.

If you missed this event or would like to review the content, you can access the presentations here or download individual sessions below:

We hope you enjoyed the MySQL Innovation Day as much as we did, and we look forward to seeing you in future MySQL events!

Tuesday Apr 12, 2016

New! Announcing MySQL Enterprise Transparent Data Encryption

[This blog was written by Mike Frank, MySQL Product Management Director at Oracle]

We're very happy to announce release of MySQL Enterprise Transparent Data Encryption (TDE), included with MySQL Enterprise Edition.

About TDE

MySQL Enterprise Transparent Data Encryption (TDE) protects your critical data by enabling data-at-rest encryption in the database. It protects the privacy of your information, prevents data breaches and helps meet regulatory requirements including the Payment Card Industry Data Security Standard (PCI DSS), Health Insurance Portability and Accountability Act (HIPAA) and numerous others.

MySQL Enterprise TDE highlights:

  • Data at Rest Encryption
    • Strong AES 256 encryption for your MySQL InnoDB Tables
  • Transparent to applications and users
    • No application code, schema or data type changes
  • Transparent to DBAs
    • Keys are hidden from DBAs, no configuration changes
  • Key Management
    • Keys are securely stored away from the data
    • Key rotation is simple and secure
  • Key Vault Support


Use MySQL Enterprise TDE to meet regulatory requirements to protect data:

  • PCI – DSS: Payment Card Data (esp. 3.5 and 3.6)
  • HIPAA: Privacy of Health Data
  • Sarbanes Oxley
  • EU Data Protection Directive: Protection of Personal Data
  • Data Protection Act (UK): Protection of Personal Data

For additional details, please join us for the upcoming webinar: MySQL Security – Discover the New Transparent Data Encryption.

MySQL Enterprise TDE is included in MySQL 5.7.12. You can download MySQL Enterprise TDE from My Oracle Support or Oracle Software Delivery Cloud. You can find the complete documentation here. If you have any questions or encounter any problems, please let us know by opening a support ticket or filing a bug report. If you're not already a MySQL Enterprise Edition customer, start your free 30-day trial today!

Thank you for using MySQL!

Monday Mar 14, 2016

MySQL User Group Turkey - upcoming meeting

we are pleased to invite you to the half day MySQL meeting organized by the MySQL Turkey User Group. Please find more details below:
  • Date: April 7, 2016
  • Place: Bahcesehir University Besiktas (map)
  • Start at 13:30 (for ½ day)
  • Agenda: 
    • 1.Yasin Saygılı, ISV IMC Consultant at Oracle Migration Center --- Key Note Speaker
    • 2.Yiğithan Tavşanoğlu, MySQL UG Turkey Leader --- MySQL Enterprise Backup
    • Break
    • 3.Ömer Faruk Şen, ‎IT Infrastructure and Security Consultant, ‎Serra Bilisim --- Open Source World and MySQL
    • 4.Ali Koyuncu, Partner at Partnerteknoloji --- Cassandra Vs Mysql
    • Break
    • 5.Merve Koc, MySQL Turkey UG --- MySQL JSON Support
Please find more information & register yourself at MySQL UG Turkey page.

Friday Mar 04, 2016

MySQL User Camp, Bangalore India - March 11, 2016

We are happy to announce the upcoming quarterly event "MySQL User Camp, Bangalore" on March 11, 2016, see details below:

 

  • Proposed agenda:
    • Listen to a MySQL Developer talking about "What's New in MySQL-5.7 Security
    • Listen to a MySQL Developer talking about "What's New in MySQL-5.7 Replication"
    • Discussion & interaction with MySQL developers and users
We are looking forward to meeting you on March 11!

Thursday Feb 25, 2016

Learn From MySQL Experts at OTN Virtual Technology Summit

We're excited to participate in upcoming Virtual Technology Summit hosted by Oracle Technology Network, with three MySQL sessions presented by engineers from Oracle's MySQL team:

  • Improve Performance by 3x with MySQL 5.7 - presented by Geir Høydalsvik, Sr. Software Development Director, Oracle
  • Analyze and Tune MySQL Queries for Better Performance - presented by Øystein Grøvlen, Senior Principal Software Engineer, Oracle
  • Oracle Enterprise Manager for MySQL Database: Discover the New Features - presented by Carlos Proal Aguilar, Principal Software developer, Oracle
Complete agenda and abstracts can be viewed here.

Choose among the three live events, and register for the one that best suits your schedule:

Join us online and take this opportunity to interact with MySQL engineers directly and sharpen your MySQL knowledge. We look forward to meeting you virtually!

Thursday Feb 18, 2016

Upcoming MySQL Tech Tours in EMEA

Want to learn how to unleash the power of MySQL 5.7? Oracle’s MySQL team is running a series of Tech Tours across EMEA, join us!

MySQL 5.7 is 3x faster than MySQL 5.6 and improves manageability. Our technical experts will help you understand how to leverage the latest innovations in InnoDB performance & scalability, replication, JSON support, instrumentation with the Performance Schema, GIS, optimizer improvements and more! You’ll also understand how the world’s most popular open source database can help you drive digital transformation initiatives, how to ensure the highest levels of MySQL security leveraging new features & best practices, and you’ll learn how to develop better MySQL applications.

We hope to see you in one of the following locations:


Wednesday Feb 03, 2016

MySQL 5.7 European Tour: Learn and Have Fun at User Groups!

Want to learn about MySQL 5.7 & JSON and get all your questions answered? Morgan Tocker is currently visiting many European cities and talking at user groups. Morgan was previously Community Manager and recently joined the MySQL Product Management team at Oracle. He’s got a very busy schedule and was last night in Helsinki after a weekend at Fosdem in Brussels and a user group meeting the following day in Amsterdam (hosted by Booking.com).

Thanks much to Solinor for hosting the meeting last night in Helsinki! Great atmosphere, good discussions, pizza and beer…


Here is Morgan's schedule for the upcoming days, join him if you can!

Seize this opportunity to learn and have some fun with peers if Morgan happens to be soon in a city near you!

Tuesday Dec 01, 2015

SERNAV Group Dispatches Containers with MySQL Enterprise Edition, Oracle Linux & Oracle VM

Based in Italy, SERNAV Group was founded in 1989 and manages the complete cycle of marine transportation activities. The companies of the group handle shipping agents, customs operations, overland and nautical transportation of conventional goods & containers, storing, loading and unloading of containers as well as logistics and distribution.




Challenges

  • Modernize the customer application allowing the management of all necessary documents related to the different marine transportation activities of the SERNAV Group.
  • Implement an enterprise-class infrastructure delivering the required performance, reliability and uptime while maintaining a low Total Cost of Ownership (TCO).

Solution

  • SERNAV hired the system integrator & Oracle partner Teleion to help them select, implement and manage the new infrastructure.
  • Teleion recommended relying on MySQL Enterprise Edition in order to address the requirements for high performance, reliability & uptime as well as low TCO. Additionally, the SERNAV IT team would get access to powerful tools including the MySQL Enterprise Monitor and MySQL Enterprise Backup as well as advanced security features to help them effectively manage their infrastructure.
  • In order to further reduce TCO and benefit from end-to-end technical support across the entire infrastructure, Oracle VM and Oracle Linux were selected. Oracle VM server virtualization is designed to enable rapid enterprise application deployment and simplify lifecycle management. Oracle Linux delivers extreme performance and is used in all x86-based Oracle Engineered Systems. Moreover, Oracle Linux allows customers to take advantage of features such as Ksplice and DTrace, respectively enabling zero-downtime kernel updates and allowing administrators to answer questions about the behaviour of the operating system and user programs in real time. The installation of the complete system was extremely fast and simple using the Oracle VM Template for MySQL Enterprise Edition, which provides a pre-installed and pre-configured virtualized MySQL Enterprise Edition software image running on Oracle Linux and Oracle VM, certified for production use.
  • The MySQL-based application stores about one Terabyte (TB) of data. Replication is implemented between two different MySQL databases running in two geographically distant data centers to guard the company against natural disasters and other risks.
  • Front-line technical support is delivered by Teleion, with back-end support provided by Oracle’s MySQL engineers. Oracle’s MySQL consultants have worked directly with the SERNAV IT team to help them get the most of the innovative MySQL features.
  • Plans include the implementation of replication to a dedicated MySQL database for reporting and Business Intelligence (BI) purposes.


"MySQL is a very powerful database, and the MySQL Enterprise Edition management tools enable us to very effectively administer our environment." Gianluca Schiavina, IT Manager, SERNAV Group


http://www.sernav.it/images/sernav.gif

"Our partnership with Oracle’s MySQL team is very successful. We receive all the support we need to deliver tremendous added value to our customers." Sergio Gallina, Sales Manager, Teleion



Thursday Nov 26, 2015

Forum PHP 2015 & Upcoming Tech Tour in Paris

Earlier this week the MySQL team participated to the Forum PHP in Paris. It was a great conference, attracting over 600 developers who could attend about 40 talks in 3 parallel tracks. An excellent way to celebrate the 20 years of PHP and the 15 years of AFUP, the French PHP users association in charge of the event; great job! 2015 really is a year of anniversaries!


Oracle’s MySQL VP of Engineering Tomas Ulin delivered a very well received presentation entitled “MySQL 5.7 & JSON: New opportunities for developers”. The slides are available on slideshare. Thanks to Morgan Tocker for his help with the content.

While in Paris Tomas met with Le Monde Informatique, you can read their article here.

To learn more about the latest MySQL news and especially how you can benefit from MySQL 5.7, join our upcoming Tech Tour in Paris (in French) December 8! Check out the agenda and register now! We look forward to seeing you there.

Friday Oct 16, 2015

MySQL Central @ OpenWorld: Sessions from Users & Customers

MySQL Central @ OpenWorld offers you the chance to hear directly from a number of users and customers about their MySQL experience:

Some of the sessions are already getting full...reserve your seat in sessions now with My Schedule!

Not registered for Oracle OpenWorld yet? Register now to save $200 over the on-site price.

We look forward to seeing you soon in San Francisco!

Thursday Oct 08, 2015

Database Partitioning at Airbnb Leveraging MySQL Replication

Willie Yao recently posted a very interesting blog: "How We Partitioned Airbnb’s Main Database in Two Weeks". He describes how Airbnb's engineering team leveraged MySQL Replication to save significant time in their effort to scale their databases:

 "Heading into the 2015 summer travel season, the infrastructure team at Airbnb was hard at work scaling our databases to handle the expected record summer traffic. One particularly impactful project aimed to partition certain tables by application function onto their own database, which typically would require a significant engineering investment in the form of application layer changes, data migration, and robust testing to guarantee data consistency with minimal downtime. In an attempt to save weeks of engineering time, one of our brilliant engineers proposed the intriguing idea of leveraging MySQL replication to do the hard part of guaranteeing data consistency."...read the blog!

Wednesday Oct 07, 2015

Plan Your MySQL Central @ OpenWorld Sessions with My Schedule

MySQL Central @ OpenWorld is right around the corner!