Tuesday Apr 22, 2014

MySQL April Newsletter: Latest MySQL Product Releases and More

MySQL April Newsletter is now available! Read this edition to learn more details about the abundant product announcements we made recently, including MySQL 5.7 Development Milestone Release, MySQL Workbench 6.1 GA, as well as the Release Candidate of MySQL Fabric. You'll also find information regarding the latest white papers, upcoming webinars and events, and technical blogs for tips and tricks using MySQL.

Enjoy and hope you find it informative! 

Monday Apr 21, 2014

Start Learning MySQL Database at Your Own Pace

The MySQL for Beginners training course is your first step to mastering relational databases concepts, using MySQL products.

You can take this training course at your own pace through the Training-on-Demand delivery option. Watch recorded training sessions by Oracle expert instructors and have access to a dedicated lab environment to get hands-on experience. With a Training-on-Demand course, you can start training within 24 hours of registration, booking time to do lab exercises at your own convenience.

In the MySQL for Beginners course, you will use the world's most popular open source database to:

  • Explain the relational database model
  • Describe the features and benefits of MySQL
  • Install and configure the MySQL server and clients
  • Design efficient databases
  • Use Structured Query Language (SQL) to build your database and query data
  • Employ appropriate MySQL tools

You can also take this course in live events as a live-virtual class, training from your own desk, or by traveling to an education center to attend an in-class event. Below is a selection of the in-class events already on the schedule:

 Location  Date  Delivery Language
Sao Paolo, Brazil
5 May 2014 Brazilian Portuguese
London, England
28 July 2014 English
Milan, Italy
14 July 2014 Italian
Rome, Italy
12 May 2014 Italian
Turin, Italy
12 May 2014 Italian
Riga, Latvia
26 May 2014 Latvian
Petaling Jaya, Malaysia
12 May 2014 English
Lisbon, Portugal
22 September 2014 European Portuguese
Porto, Portugal
22 September 2014 European Portuguese

To register for a class or learn more about the authentic MySQL  curriculum, go to http://education.oracle.com/mysql.

Monday Apr 14, 2014

Developing with MySQL and NoSQL

MySQL adopts a very different approach to 'NoSQL' than other databases. With the memcached plugin, MySQL provides the speed and high availability benefits of a standard 'NoSQL' database solution, while mitigating many of the drawbacks to this approach.

A traditional memcached application bypasses the SQL layer entirely, and stores all its data in memory. This makes data access extremely fast, but there is a risk that the data will disappear in the event of a system problem. 

The MySQL memcached plugin for InnoDB also bypasses the SQL and optimization layers, resulting in excellent performance. It goes further, writing key-value data directly to  InnoDB tables. The result is fast data access while retaining the advantages provided by the existing relational database infrastructure, such as the ability to run complex queries with SQL, maintain data integrity, provide real-time analytics to the business, and work with big data platforms such as Hadoop.

MySQL Developers can learn about topics such as using NoSQL and memcached, as well as much more in the MySQL for Developers course.

This live 5-day instructor-led course is available as a:

  • Live-Virtual Event: Take this course from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this course. Below is a selection of the events already on the schedule:

 Location  Date  Delivery Language
 Vienna, Austria
 17 November 2014
 German
 Brussels, Belgium
 12 May 2014
 English
 Sao Paolo, Brazil
 12 May 2014
 Brazilian Portuguese
 London, England
 29 September 2014
 English
 Rome, Italy
 19 May 2014
 Italian
 Nairobi, Kenya
 19 May 2014
 English
 Petaling Jaya, Malaysia
 14 April 2014
 English
 Utrecht, Netherlands
 12 May 2014
 English
 Makati City, Philippines
 29 September 2014
 English
 Lisbon, Portugal
 26 May 2014
 European Portuguese
 Porto, Portugal
 26 May 2014
 European Portuguese
 Madrid, Spain
 3 November 2014
 Spanish
 Valencia, Spain
 24 November 2014
 Spanish
 Basel, Switzerland
 4 August 2014
 German
 Bern, Switzerland
 4 August 2014
 German
 Zurick, Switzerland
 4 August 2014
 German

To register for an event, request an additional event, or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

The MySQL for Developers course is the recommended training for the MySQL 5.6 Developers OCP certification exam.

Tuesday Apr 08, 2014

Summary of Announcements, Blogs, and more...

Considering last week was very rich in terms of announcements, we thought it might be useful to provide a summary of the information we shared, including the blogs from Oracle’s MySQL Engineers aggregated for easier access:

We sent out this press release last Monday to announce:

  • The latest development milestone release of MySQL 5.7, 2x faster than MySQL 5.6 and 3x faster than MySQL 5.5
  • The Release Candidate of MySQL Fabric, providing high availability management and scale out through sharding (included in the Release Candidate version of MySQL Utilities 1.4.2).
  • The General Availability of MySQL Workbench 6.1, delivering additional capabilities for performance assessment and query optimization.
  • Early access to features under development via labs.mysql.com including Geographic Information System (GIS), multi-source replication improvements, and a preview of MySQL Cluster 7.4 for community testing and feedback.

The news generated a number of press articles, such as:

Oracle doubles the speed of MySQL query handling

Oracle MySQL 5.7 Release Boosts Performance, Scalability

Oracle’s VP of MySQL Engineering Tomas Ulin delivered a keynote at the Percona Live conference entitled: "Raising the MySQL Bar". Tomas demonstrates how Oracle keeps raising the bar for MySQL, and talks about the latest news and developments. He also took the opportunity to welcome "WebScaleSQL", a fantastic initiative from Facebook, Google, LinkedIn, and Twitter announced the week before.

You can access the video here and the slides here.


Oracle’s MySQL Engineers have been actively blogging about what’s new and their blogs are aggregated below:

The MySQL 5.7.4 Milestone Release is available

MySQL 5.7 just rocks! ;-)

InnoDB Crash Recovery Improvements in MySQL 5.7
MySQL 5.7.4 now supports Transportable Tablespaces for InnoDB Partitions
InnoDB Spatial Indexes in 5.7.4 LAB release
InnoDB Transparent PageIO Compression

MySQL Replication – Multi-Threaded Slave just got a whole lot faster
MySQL-5.7.4- Change master without stopping slave altogether

MySQL Performance Schema : Prepared Statements Instrumentation

A new dimension to MySQL query optimizations:

SQL parser refactoring in 5.7.4 LAB release

Server-side SELECT statement timeouts

Building MySQL with Boost
Why Boost.Geometry in MySQL?

Password expiration policy in MySQL Server 5.7

Test improvements in MySQL 5.7.4

MySQL Fabric 1.4.2 Released
MySQL Fabric RC - Adding High Availability and/or Scaling to MySQL
Configuring and running MySQL Fabric 1.4.2

New! MySQL Utilities release-1.4.2-RC
New MySQL Utility: Replication Synchronization Checker
Announcing MySQL Multi-Source Replication Utility

What’s New in MySQL Workbench 6.1

Data Encryption with MySQL Enterprise Backup 3.10

MySQL Cluster 7.4.0 Labs Release
MySQL Cluster 7.4.0 Lab Release Improvements


Fusion-io made the following announcement:
Fusion-io Collaborates with Oracle to Double Usable Capacity for MySQL


Last but not least, we were very pleased to receive the Corporate Contributor of the year award at the Percona Live 2014 MySQL Community awards ceremony.


It is a very exciting time for MySQL, and we look forward to a great MySQL Connect @ OpenWorld! Remember the call for papers is open until April 15, don’t miss the opportunity to submit sessions.


Monday Apr 07, 2014

MySQL Utilities Make a DBA More Efficient and Productive

MySQL Utilities provide a collection of command line utilities that make it easy for database administrators to maintain and administer MySQL servers. The utilities perform a range of otherwise complex operations via a simple command, making DBAs more efficient and productive.

There are utilities for copying databases, comparing databases running on different servers, checking disk usage and for redundant or duplicate indexes, automatic failover, verifying replication configuration, cloning a running server, and working with audit logs. You can use all these utilities either standalone or with MySQL Workbench.

You can learn about MySQL Utilities and much more by taking the MySQL for Database Administrators course. This highly popular 5-day instructor-led course is available in the following training formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace and scheduling time on a lab environment to suit your schedule.
  • Live-Virtual Events: Attend a live class from your own desk - no travel required, choosing from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to attend an event. Below is a selection of events already on the schedule.

 Location  Date  Delivery Language
Brisbane, Australia
7 April 2014 English
Sao Paolo, Brazil
19 May 2014 Brazilian Portuguese
Brussels, Belgium
12 May 2014 English
Cairo, Egypt
13 April 2014 Arabic
London, England
19 May 2014 English
Milan, Italy
12 May 2014 Italian
Rome, Italy
14 April 2014 Italian
Nairobi, Kenya
28 May 2014 English
Petaling Jaya, Malaysia
19 May 2014 English
Mexico City, Mexico
5 May 2014 Spanish
Utrecht, Netherlands
12 May 2014 English
Makati City, Philipinnes
28 May 2014 English
Madrid, Spain
9 June 2014 Spanish
Bangkok, Thailand
21 April 2014 English
Istanbul, Turkey
9 June 2014 Turkish
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

The MySQL for Database Administrator course is the recommeneded training to prepare you to take the MySQL 5.6 Database Administrator OCP certification exam.

Thursday Apr 03, 2014

MySQL at LOADays Conference in Antwerp, Belgium (Apr 5-6, 2014)

This weekend we are going to be part of the LOADays Conference (Linux Open Administration Day) a free open source event hold in Antwerp, Belgium, followed by the tutorial on Monday, April 7th.

Do not miss to attend this small but friendly event hold in Antwerp, the second biggest city in Belgium and the capital of the Antwerp province. So, you can join the sightseeing with attending LOADays and getting in touch not only with a Linux people but also with MySQL!!

MySQL is represented by our colleague Carsten Thalheimer who is going to have a talk about "Why MySQL in a Business critical environment". His talk is planned for Sunday, April 6, 2014 @ 13:30.

For the whole conference plan you can check the Schedule section of the LOADays website.

See you there! 

Annual EMEA User Group Leaders' Summit - May 21-22, 2014

Are you already a MySQL User Group Leader?

or

Are you thinking about taking this role in the near future?

If yes, please let me invite you to the Annual User Group Leaders' Summit organized by Oracle User Group team. The purpose of this 2 days meeting is sharing the expertise, knowledge and share experience with leading the UG as well as learning of the new ways how to handle groups by using new technologies & tools (i.e. Cloud..).

It is great opportunity to talk to other User Group leaders and share the experience and knowledge with them. There will be Java User Group, Oracle User Group and of course MySQL User Group Leaders!

Find details about this event below and if you are interested and/or want to know more, please do not hesitate to contact myself or make a registration at the link below. You will be contacted by us with a confirmation of your registration and with a logistic details.

Event name: Annual EMEA User Group Leaders' Summit

Date: May 21-22, 2014

Place: Sofia, Bulgaria

Registration & Agenda

During the event we (MySQL) will have dedicated 3 sessions for our own topics. First two sessions will be dedicated to the technical side of MySQL and its future. Our MySQL Senior Engineer Georgi Kodinov will be talking about what is new in the upcoming release as well as about MySQL from the strategic point of view. Also we might get an InnoDB expert to the venue, if attendees are interested.  We might work on the content of those 2 sessions, just need to hear from you what would be the most interesting topic! Do not hesitate to let me know!

The last session on the day two, will be dedicated to myself as a MySQL User Group Manager responsible for EMEA and APAC. I will be talking about User Group creation, administration and the support we might provide you with if you want to run or currently run a MySQL UG in your region. This session will be mostly about networking, questions/answers and discussion. I really want to hear what you see as the most problematic area when leading the MySQL User Group as well as what is the greatest about that! :)

Regarding logistic & cost funding: do not hesitate to ask me if you have any question on logistic or if you want to know more about funding accommodation costs!!

We are looking forward to meeting you in lovely Sofia! 

Tuesday Apr 01, 2014

New MySQL 5.7 DMR, MySQL Fabric RC, MySQL Workbench 6.1 GA...and more

We were very pleased to make the following announcement yesterday:


"Oracle Improves Database Performance with Latest Development Milestone Release for MySQL 5.7
New Release of the World’s Most Popular Open Source Database is 2x Faster than MySQL 5.6 and Over 3x Faster than MySQL 5.5 in Benchmark Tests

News Summary: Continuing to lead MySQL innovation, Oracle announced the immediate availability of a new Development Milestone Release for MySQL 5.7. To meet the demands of today’s web, cloud, and embedded applications, the new release extends the performance, scalability and reliability of MySQL, the world’s most popular open source database, while also enhancing management capabilities. In addition, Oracle announced the availability of several other MySQL product releases and early access features."

The full press release is available here.

Oracle’s MySQL Engineers have then provided more detailed information via a number of blog posts and articles including:

Enjoy the information and watch out for more blog posts on Planet MySQL during the next few days!

Monday Mar 31, 2014

MySQL Cluster in Environments Requiring Real-Time Analytics

MySQL Cluster is used by many different industries. MySQL Cluster thrives in the most complex data environments that demand real-time analytics such as:

  • Financial trading with fraud protection
  • Feed-streaming analysis and recommendations
  • Massive online multiplayer games
  • Communication services

To learn more about MySQL Cluster, take the MySQL Cluster training course. Below is a selection of events already on the schedule for this 3-day instructor led course:

 Location  Date  Delivery Language
 Sao Paolo, Brazil
 28 April 2014
 European Portuguese
 Berlin, Germany
 26 May 2014
 German
 Hamburg, Germany
 29 September 2014
 German
 Munich, Germany
 14 April 2014
 German
 Rome, Italy
 12 May 2014
 Italian
 Petaling Jaya, Malaysia
 16 July 2014
 English
 Warsaw, Poland
 4 June 2014
 Polish
 San Francisco, CA, United States
 28 May 2014
 English

To register for an event, request an additional event, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Friday Mar 28, 2014

Sharecat Enables Oil and Gas Supply Chain Management with MySQL Enterprise Edition

Sharecat provides supply chain management solutions to oil and gas operators, delivering an innovative collaborative environment which includes the manufacturers' equipment catalogues and technical information. The products provide visibility and fully validated content to all parties in the plant lifecycle. Based in Norway, the company has offices in the UK, Australia and the United States.



Challenges

  • Deliver Software-as-a-Service (SaaS) based solutions with a Web interface to oil and gas operators. The database powering the applications needed to store and deliver fast access to a large amount of information, including all components necessary for the construction and the maintenance of oil rigs. Product catalogs are updated on a continuous basis with manufacturers, product numbering, data templates and documentation. They contain information captured over an 18-year period, including products no longer in production but still installed at thousands of assets.
  • Implement an enterprise-class database to power the supply chain solutions. They had initially been developed with a Microsoft Access back-end, and had outgrown its capabilities.
  • Maintain a low Total Cost of Ownership over time.

Solution
  • Evaluated several databases and selected MySQL to power the Sharecat applications. The team particularly valued its performance and scalability in addition to the opportunity to reduce database TCO by 90% compared to Microsoft SQL Server. "MySQL allowed us to build a professional solution to serve our global clients at low cost. It fulfilled our requirements extremely well."  said Tom-Kenneth Fossheim, Chief Technology Officer.
  • The Sharecat products run in a Windows-based virtualized environment. MySQL Replication is used both for High Availability and to scale-out read operations.
  • While MySQL 5.5 is currently in use with a mix of InnoDB and MyISAM tables, the company plans to upgrade to MySQL 5.6 and solely rely on the InnoDB storage engine.
  • Sharecat subscribed to MySQL Enterprise Edition in order to take advantage of the MySQL Enterprise Monitor and MySQL Enterprise Backup functionalities. They also wanted to be able to rely on Oracle's MySQL support team. "We’re very happy with Oracle’s MySQL support, the engineers are really good, and we get fast answers." said Eirik Andersen, Database Administrator.
  • The software is currently hosted in-house, but the company is evaluating the opportunity to migrate to a public cloud in order to benefit from increased flexibility and reliability, and to further reduce costs.

"MySQL just works, it’s a very stable, high performance and cost-effective database. In addition, we get great service from Oracle."
Tom-Kenneth Fossheim, Chief Technology Officer, Sharecat

Wednesday Mar 26, 2014

MySQL Powers AlSego's Solutions

Based in Luxembourg, AlSego is an Independent Software Vendor delivering Web, e-Commerce and financial applications including:
  • A Rapid Application Development (RAD) and Business Process Oriented (BPO) Web Server Platform.
  • E-payment and e-banking "Plug & Play" solutions.
  • Archiving solutions for the banks' SWIFT data.

AlSego counts some of the largest banks in Luxembourg, Belgium and Switzerland among its clients and partners.



Challenges

  • Supporting multiple database platforms for its products' master repositories generated a relatively high number of technical support incidents as end-users did not always master the various technologies involved. This in turn increased costs for both customers and AlSego, and negatively impacted the customer experience.
  • The company wanted to offer its clients turnkey solutions delivering the desired results out of the box, without requiring significant tuning for each new and different environment, nor an expensive and complex infrastructure.
  • The database underpinning the AlSego applications needed to deliver very high performance and reliability, paramount criteria for financial applications.


Solution

  • Decision to standardize on one database for all its products' master repositories in order to cost-effectively deliver the best customer experience. Customers would get a turnkey solution, optimized to deliver outstanding performance out of the box. Additionally, they would only have one company to turn to should they encounter any issue.
  • Evaluated several databases and decided to standardize on MySQL based on the following criteria:
    • Features: Among many others, stored procedures, views and triggers were essentials, and MySQL had all the needed features.
    • Ability to handle large volumes of data: e-banking solutions generate a significant volume of transactions and related data, and some data may need to be archived for over 10 years.
    • Performance: Financial institutions have typically been very pleasantly surprised and delighted by the MySQL performance during Proofs of Concept.
    • Flexibility: MySQL demonstrated the fairly unique ability to deliver excellent performance in different environments with minimal and predictable configurations changes. Additionally, when compared to other databases it did not require an expensive infrastructure to deliver the needed performance and scalability.
  • AlSego’s e-banking solutions are typically able to handle millions of system transactions per day, and store up to a Terabyte of data in large banks.
  • Developments and tests for the AlSego products integrating MySQL are often conducted on either Linux or Windows platforms, while production environments tend to also include UNIX-based or Mainframe-based platforms, running for example on Oracle Solaris or IBM zOS.
  • MySQL enabled AlSego to deliver solutions that were simpler to use and faster to implement, while reducing the Total Cost of Ownership (TCO) of its customers.
  • To make it even easier for its clients, AlSego is now evaluating the opportunity to integrate MySQL more deeply, embedding it within its core solutions.


"MySQL is one of the most mature and stable database products on the market. It is clear that Oracle understands the need to continuously develop the database, adding new features and making it a better solution for its various and different customers." Marc Van Oost, CEO, AlSego

Tuesday Mar 25, 2014

Upcoming EMEA Events with MySQL in 2014 - Continued

As an update to the previous announcement from Feb 27, 2014 we would like to update you on the conferences which MySQL Community team is supporting with an attendance of MySQL technical staff and sometimes with Java, Oracle VM and Oracle Linux experts as well. You are invited to meet our engineers at any of the event below.  

EMEA 

  • NEW! Open Source Days 2014, Bielsko, Poland, March 28-30, 2014
  • NEW! LOADays, Antwerp, Belgium, April 5-6, 2014
    • This is the first time we are attending also this small Belgian event focused on admins. MySQL is attending this time together with Oracle Linux team which will be talking about Ksplice during their submitted talks. Do not miss this presentation by Oracle Linux as well as other MySQL ones.
  • OpenSUSE Conference - Dubrovnik, Croatia, April 24-28, 2014
    • You can meet the MySQL team at our booth or at any of approved talks. Schedule for this event is not yet published. The Sneak Preview of oSC14 Sessions can be found here.
  • JavaScript UnConference, Hamburg, Germany, Apr 26, 2014
    • Ulf Wendel from MySQL team will attend & talk at the conference. Please come to meet him either at our table or at his talk.
  • PHP UnConference, Island of Majorka, May 17-18, 2014
    • There is no schedule set for such events as UnConference. This event is mostly for PHP experts and engineers and the whole schedule is done usually on the place. MySQL is presented by Ulf Wendel for sure! 
  • Solutions Linux & Open Source, Paris, France, May 27-28, 2014
    • Meet our MySQL, Oracle VM and Oracle Linux staff at our booth in the exhibition area!
    • The schedule is not yet announced, please watch the organizers' website.
  • NEW! PHP Tour Lyon, France, June 23-24, 2014
    • MySQL team is going to be part of this show as well, we are not going to have a booth here but very active networking by our french MySQL team around the event. Come to meet us and talk to us!
  • NEW! Froscon 2014, St.Augustin, Germany, August 23-24, 2014
    • As usual MySQL will be part of this great event in St.Augustin. You can find and talk to our MySQL engineers at our booth as well as during MySQL talks. The schedule for this event is not yet published, so watch the Froscon website for any news.  
  • DrupalCon Amsterdam, Holland, Sep 30 - Oct 3, 2014
    • Come to meet our MySQL team at our booth in Amsterdam!
    • The schedule is not yet announced, please watch the DrupalCon website for news.
  • NEW! All Your Base, Oxford, UK, October 17, 2014
    • Our local MySQL team is going to attend the one day database conference for web developers - All Your Base hold in the UK. Come to visit our MySQL booth and talk to our MySQL experts, you can also find MySQL presentations in the conference schedule once announced. Check the organizers’ website for upcoming updates on the schedule and other information. 

APAC

  • Update! Open Source Developers' Conference 2014, Taipei, Taiwan, April 11-12, 2014
    • It is first time when MySQL Community team with a help of local MySQL team supports the Open Source Developers Conference in Taiwan. You can find our MySQL staff at our booth or attend any of following presentations submitted:
      • Sharding and Scale-out using MySQL Fabric
        • Speaker: Ryusuke Kajiyama - Oracle MySQL JAPAC Sales Consultant Manager
        • Agenda: MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle. It make management of farms of MySQL servers easy and available for both applications with small and large number of servers. MySQL Fabric organizes the servers in groups and deploys high-availability solutions within each group.
      • MySQL Utilities
        • Speaker: Ivan Tu - Oracle MySQL Sales Consultant
        • Agenda: MySQL Utilities works can  help you to perform many crucial MySQL operations such as copying data between databases without, compare data, set the master-slave replication, and fail-over/back between master and slave servers atomically, thus enhance the usability and availability of your MySQL Databases. This talk would show the features, and use case of MySQL Utilities.
  • NEW! Open Source Conference Japan, Hokkaido, June 13-14, 2014
    • Our local MySQL team is looking forward to talking to you during this conference. You can either find us at your MySQL booth or during the MySQL talks. The schedule is not yet announced, so please watch the conference website for any update.
  • NEW! Ruby Kaigi, Tokyo, Japan, September 18-20, 2014
    • Another event MySQL supports and attends in APAC region. Ruby Kaigi is the international Ruby Conference in Japan, Tokyo. Ruby started in Japan, so Ruby Kaigi has excellent speakers and developers! MySQL team is going to be present at this conference with MySQL talks and active networking around the venue. We are looking forward to seeing you at Ruby Kaigi!.
If you would like to see also other conferences which MySQL engineering & MySQL Community team attend, please check the MySQL wikis, with a complete list of events in EMEA, APAC and US where you can find our people.

Monday Mar 24, 2014

Just Published! MySQL March Newsletter

Have you read the MySQL March Newsletter? Check it out to learn more about the Call of Papers for MySQL Connect @ OpenWorld 2014, MySQL in action in the finance, retail and channel management sectors, as well as numerous technical tips written by MySQL experts at Oracle and in the community. The highlights in this edition include:

  • Submit Sessions for MySQL Connect @ OpenWorld 2014
  • MySQL Connector/NET 6.8.3 Available as Official MySQL NuGet Packages
  • New Case Studies: MySQL in Action in Finance, Retail, and Channel Management
  • New White Paper: Guide to the MySQL Workbench Migration Wizard: From Microsoft SQL Server to MySQL
  • Featured Video: How to Export Your Database with MySQL for Visual Studio
  • Blog: Today's Practical Use Case for MySQL Performance Schema
  • Blog: Repos and Distros: Upstream and Downstream

You can read it online or subscribe to it to receive the latest copy in your inbox automatically every month. Watch this tutorial to learn step-by-step instructions for newsletter subscription.

Enjoy!

Use MySQL API Extensions to Create Dynamic Web Pages

To create dynamic web pages, you can use PHP, a server-side, HTML-embedded scripting language. PHP is available for most operating systems and can access the MySQL database. PHP provides MySQL API extensions, MySQL Improved Extension and MySQL Functions.

To learn more about using MySQL and PHP, you can consult the MySQL and PHP reference manual. You can also take the MySQL and PHP: Developing Dynamic WebApplications training course.

Through a hands-on approach, this 4-day instructor-led course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure. You can take this course as a:

  • Live-Virtual Event: Attend a live class from your own desk - no travel required. Choose from the events on the schedule such as April 28th, July 22nd, and October 21st 2014.
  • In-Class Event: Travel to an education center to take a class, for example in Warsaw, Poland on the 22nd of April 2014.

To request additional events, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Thursday Mar 20, 2014

Buongiorno Relies on MySQL Enterprise Edition to Power its Mobile Services

Buongiorno is known in the worldwide mobile ecosystem for developing and managing paid applications and content that help consumers get greater enjoyment from their mobile devices.


Buongiorno’s strategic goal is to deliver directly to consumers around the world a broad portfolio of content & services on all their personal devices, exploiting social and location based propositions, and letting telecom operators be in control of the billing. With direct connections to more than 130 telecom operators in 25 countries, over 10 years’ experience and a team of 600 professionals, Buongiorno makes the mobile internet experience happen for consumers globally. Buongiorno’s web apps brands include Gamifive, MuchGossip, Fingerbooks, Appsfuel HTML5 Marketplace, Winga, Play.me and the mobile payments solution Cashlog.




Challenges

  • Rely on a database delivering high performance and scalability to power Buongiorno’s mobile services. The database additionally needed to be very easy to use in order to rapidly launch and easily manage new fast growing applications.
  • Implement an effective monitoring solution in order to increase Dev-Ops productivity and focus resources on strategic operations.
  • Maintain a low Total Cost of Ownership (TCO) for its infrastructure, both initially and over time.

Solution
  • Selected MySQL to power Buongiorno’s platform.  The team especially valued its performance and scalability for mobile applications, including the ability to very quickly open and close connections to the database. MySQL was moreover extremely easy to use, and would allow the company to cost-effectively scale-out, adding more database servers at low cost to fuel its growing business.
  • MySQL instances are hosted on virtualized servers. The architecture currently consists of over 50 MySQL database instances including:
    • Over 40 “MySQL chains” as illustrated in the below diagram with circular replication between master and slave servers (or "Master Backup") to ensure High Availability, and replication to a second slave server for reporting purposes.
    • Over 10 additional similar MySQL chains without replication to another slave server for reporting needs.

  • More than 8 TB of data are stored in the MySQL master servers (excluding the replicas). The application handles:
    • Over 50,000 queries/second
    • Over 15,000 transactions/second
  • While several MySQL versions are still in use in the platform, all servers are being migrated to MySQL 5.6 in order to take advantage of the latest features.
  • Standardized on MySQL Enterprise Edition. Relying on the MySQL Enterprise Monitor Visual dashboard to monitor all MySQL databases at a glance. Automated alerts enable the Buongiorno DBAs to immediately focus on potential problems and fix them before they impact the system.
  • Leveraging Oracle’s MySQL Technical support to assist their team. "We turn to the support team whenever we don’t know the answer, they are extremely good and really responsive" said Carmine Giordano, DBA Manager.
  • Planning to use MySQL Enterprise Backup, that now integrates with their central company backup solution.


"MySQL is an excellent database to deliver mobile applications; it’s really fast, reliable and easy to use. I highly recommend MySQL Enterprise Edition; the latest version of the MySQL Enterprise Monitor is extremely useful and saves us a lot of time and efforts." Carmine Giordano, DBA Manager, Buongiorno

MySQL Enterprise Monitor provides real-time visibility into the performance and availability of all your MySQL databases. Learn More.

About

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

Twitter


Facebook

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
5
6
9
10
11
12
13
15
16
17
18
19
20
23
24
25
26
27
28
29
30
   
       
Today