Monday Jan 13, 2014

MySQL - An Excellent Choice for a Low Cost Embedded Database

MySQL is an excellent choice for a low cost embedded database. Over 3,000 ISVs, OEMs and VARs choose MySQL for this purpose and benefit from significant cost savings when compared to using a competing database product.

The MySQL for Developers training course teaches you how to plan, design and implement applications using MySQL. Expert Oracle University instructors teach you through realistic examples, interactive instruction and hands-on exercises.

This course brings you lots of interesting facts. For example, the 'libmysqld' library is effectively a MySQL server in its own right. it is shipped as part of the standard MySQL installation. Developers with C/C++ ability can embed this library easily within their applications and it can do most of what a standard cient/server installation can do, with notable exceptions being the lack of replication capability and a limit on the number of simultaneous client connections. You can find out more about using embedded databases in MySQL by downloading this white paper.

You can take the MySQL for Developers course 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 time-zones.
  • In-Class Event: Travel to an education center to take this course. Below is a selection of the in-class events already on the schedule.

Location

 Date

 Delivery Langauge

Brussels, Belgium

 12 May 2014

 English

 Milan, Italy

 7 April 2014

 Italian 

 Rome, Italy

 10 March 2014

 Italian

Utrecht, Netherlands

 12 May 2014

 English

 Makati City, Philippines

 17 February 2014

 English

 Warsaw, Poland

 27 January 2014

 Polish

 Lisbon, Portugal

 26 May 2014

 European Portuguese

 Porto, Portugal

 26 May 2014

European Portuguese 

 Petaling Jaya, Malaysia

21 April 2014  

English 

 Singapore

17 February 2014  

English

 Madrid, Spain

17 February 2014  

Spanish 

 Valencia, Spain

21 April 2014  

 Spanish

 Bern, Switzerland

 17 February 2014

German 

 Zurick, Switzerland

17 February 2014  

German 

Learn to develop applications with PHP and use MySQL efficiently for those applications with the MySQL and PHP - Develop Dynamic Web Applications course. You can take this course as a live-virtual event or an in-class event. Some in-class events on the schedule include:

 Location  Date  Delivery Language
 Rome, Italy
 5 May 2014
 Italian
 Turin, Italy
 17 May 2014
 Italian
 Warsaw, Poland
 3 February 2014
 Polish
 Tunis, Tunisia
 17 March 2014
 French

To learn more about the authentic MySQL curriculum, register for an event or request an additional event, please go to the MySQL Training and Certification site.

Thursday Oct 31, 2013

After 10 Years, MySQL Still the Right Choice for ScienceLogic's "Best Network Monitoring System on the Planet"

ScienceLogic has a pretty fantastic network monitoring appliance.  So good in fact that InfoWorld gave it their "2013 Best Network Monitoring System on the Planet" award.  Inside their "ultraflexible, ultrascalable, carrier-grade" enterprise appliance, ScienceLogic relies on MySQL and has since their start in 2003.  Check out some of the things they've been able to do with MySQL and their reasons for continuing to use MySQL in these highlights from our new MySQL ScienceLogic case study.
  • Science Logic's larger customers use their appliance to monitor and manage  20,000+ devices, each of which generates a steady stream of data and a workload that is 85% write. On a large system, the MySQL database:
    • Averages 8,000 queries every second or about 1 billion queries a day
    • Can reach 175,000 tables and up to 20 million rows in a single table
    • Is 2 terabytes on average and up to 6 terabytes
    • "We told our customers they could add more and more devices. With MySQL, we haven't had any problems. When our customers have problems, we get calls. Not getting calls is a huge benefit."
      Matt Luebke, ScienceLogic Chief Software Architect.


  • ScienceLogic was approached by a number of Big Data / NoSQL vendors, but decided against using a NoSQL-only solution. Said Matt, "There are times when you really need SQL. NoSQL can't show me the top 10 users of CPU, or show me the bottom ten consumer of hard disk. That's why we weren't interested in changing and why we are very interested in MySQL 5.6. It's great that it can do relational and key-value using memcached."
  • The ScienceLogic team is very cautious about putting only very stable technology into their product, and according to Matt, MySQL has been very stable: "We've been using MySQL for 10 years and we have never had any reliability problems. Ever."
  • ScienceLogic now uses SSDs for their write-intensive appliance and that change alone has helped them achieve a 5x performance increase.

Learn more>>




Friday Sep 20, 2013

Tuning MySQL 5.6 for Great Product Performance: FAQs

“Will you expand the next webcast to 90 minutes? This one was too interesting to last only one hour” was one of the questions we got during the “Tuning MySQL for Great Product Performance: The Fundamentals, Updated for MySQL 5.6” webinar on August 27th.  The engineers on Q&A got a lot of good (and more technical) questions during the webcast.  For those of you who were unable to join us live, I’ve posted the questions and answers below, and you can listen to a recording of the webinar and get a .pdf of slides at this link.

The webinar was created specifically for the software and hardware vendors that include MySQL with their products, often “deeply embedded” so their customers do no separate installation, tuning, or admin. Their focus is great out of the box performance, but whatever your use case, you’ll get useful performance tips with an emphasis on some of the newer capabilities in MySQL 5.5 and 5.6.

Following are some related and new resources, and below that, the Q&A.  
•    "Developer and DBA Guide to What's New in MySQL 5.6" white paper
•    “What’s New in MySQL Workbench” on-demand webinar
•    “MySQL Workbench: Database Design. Development. Administration. Migration” white paper

And, don’t forget!  MySQL Connect starts on tomorrow!

FAQs
Performance Benchmarks
Q.  What tool did you use to perform the benchmarks?
A. We primarily use Sysbench. Here are more details regarding the benchmarks: http://dev.mysql.com/tech-resources/articles/mysql-5.6.html

Q. Does MySQL 5.6 Community Edition include the performance gains shown in the benchmarks?
A. Yes, everything that John has been discussing is in both releases of MySQL: Community Edition and the Commercial Editions.

Q. Do these performance results hold for NDB as well?
A. These graphs are based upon InnoDB. To better understand the performance characteristics of NDB, please review this information: http://www.mysql.com/why-mysql/benchmarks/mysql-cluster/

Buffer Pool

Q. Buffer Pool % of Available Memory: Does this mean RAM or virtual memory or combination? For 32-bit MySQL, would the maximum be 3 to 4 GB?   

A. We recommend basing this upon RAM, mapping to Virtual Memory might create some performance issues. Find more details here: http://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html 

For 32-bit MySQL, the max is (2^32 -1). Here are the details: http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size

Q. What’s the benefit of having multiple buffer pools instead of one large one? 

A. When the InnoDB buffer pool is large, many data requests can be satisfied by retrieving from memory. But, you might encounter bottlenecks from multiple threads trying to access the buffer pool at once.
Starting in InnoDB 1.1 and MySQL 5.5, you can enable multiple buffer pools to minimize this contention. Each page that is stored in or read from the buffer pool is assigned to one of the buffer pools randomly, using a hashing function. Each buffer pool manages its own free lists, flush lists, LRUs, and all other data structures connected to a buffer pool, and is protected by its own buffer pool mutex.

Q. How can I calculate the buffer pool size if we have 250 connections running simultaneously?
A. Ideally, you set the size of the buffer pool to as large a value as practical, leaving enough memory for other processes on the server to run without excessive paging. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the data from memory during subsequent reads. The buffer pool even caches data changed by insert and update operations, so that disk writes can be grouped together for better performance.

Q. When using JPA (e.g. EclipseLink) it has a cache for database objects; should that cache more or less replace the InnoDB pool?  
A.  Since every application's requirements are unique, we recommend that you architect your solution based upon your business objectives. As far as MySQL goes, I would still recommend scaling the size of the InnoDB buffer pool as large as possible. Application caching is very unique to your goals.

Performance Schema
Q.  How can I get the number of “hits”(query select/insert/update/delete) in a table in a day?
A. The Performance Schema in MySQL 5.6 will give you that insight. The counters can be reset at the start of the day and then examine the contents at the end of the day.
Here is the query that I use: SELECT object_schema.object_name, count_fetch AS SELECTS, sum_timer_fetch, count_insert AS INSERTS, sum_timer_insert, count_delete AS DELETES, sum_timer_delete, FROM performance_schema.table_io_waits_summary_by_table ORDER BY sum_table_wait DESC;

Q. How do you diagnose and analyze a Query (SELECT) statement that has a very short duration reported but very long fetch time reported. How do you find out the cause of a very slow fetch time? What is a slow fetch time a symptom of?    
A. If the EXPLAIN statement doesn't help, then with MySQL 5.6 you can try using the Optimizer Trace for more details on the cost of the SELECT statement. Or, I would recommend using the Performance Schema. This allows you to look at stages of a query and understand exactly where time is spent. http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html

Q. Can you please elaborate on performance schema usage? 
A. Performance Schema is designed to provide you with deeper details into how the MySQL server performs.  Details are located at: http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html If you want to discuss it further, please contact your local Sales Technical Consultant and we can dive into the details.

Other MySQL Storage Engines (not InnoDB)

Q. Which of the MySQL storage engines support built-in procedures etc.? 
A. The general new features such as views, stored procedures, triggers, INFORMATION_SCHEMA, precision math (DECIMAL column type), and the BIT column type, apply to all storage engines.

Q. Can index condition pushdown be used with NDB? 

A. This optimization can be used only by the NDB storage engine. See: http://dev.mysql.com/doc/refman/5.6/en/condition-pushdown-optimization.html

Q. Is that index is being internally created by the server while executing any query using order by in internal temp table?   
A. You must manually create the index; an index is not automatically created by a query using ORDER BY.

Q. Do you have any tuning suggestions or references for those of us who are heavily dependent on the Archive storage engine?  
A. Since you can't index tables in the ARCHIVE engine, there isn't much you can do - see: http://dev.mysql.com/doc/refman/5.6/en/archive-storage-engine.html 
You might want to take a look at using a different storage engine if performance is an issue.

OLTP

Q.  What disk types should be used for an OLTP environment?  
A.  That depends on the number of transactions per second, size of each transaction, etc. But you should at least have disks with high speeds (10,000 RPM), high access rates and with a large disk cache. But SSD's would be the best choice - if available.

Wednesday Feb 20, 2013

Enhance Your MySQL Skills with Virtual Developer Day: MySQL

MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations.


On March 12, we’re hosting the first Virtual Developer Day: MySQL at 9am PST to give you a one-stop shop to learn all the essential MySQL skills and the latest features in MySQL 5.6 GA. With a combination of presentations and hands-on lab experience, you’ll have the opportunity to practice in your own environment and gain more in-depth knowledge to successfully design, develop, and manage your MySQL databases.


Virtual Developer Day: MySQL

Featuring speakers coming from Oracle’s MySQL engineering, support, product management, and sales consulting teams, this FREE virtual event has two tracks tailored for both fresh and experienced MySQL users. Attend the live sessions and sharpen your skills to:
•    Develop your new applications cost-effectively using MySQL
•    Improve performance of your existing MySQL databases
•    Manage your MySQL environment more efficiently

If you’re in Europe, Middle East or Africa, don’t worry! We have another live event for you on March 19 at 9:00 GMT so you can join the sessions and get better with MySQL during your business hours.

Don’t miss this opportunity so reserve your spot today!

Thursday Jan 31, 2013

Tecnotree Empowers Communications Service Providers with Embedded MySQL

Tecnotree is a global provider of telecom IT solutions for the management of products, customers and revenue. Tecnotree helps communications service providers to transform their business towards a marketplace of digital services. Tecnotree empowers service providers to monetise on service bundles, provide personalized user experiences and augment value throughout the customer lifecycle. With over 1100 telecom experts, Tecnotree serves more than 100 service providers in over 70 countries. Tecnotree is listed on the main list of NASDAQ OMX Helsinki.

Challenges

  • Integrate a database well suited to power the mission critical Tecnotree solutions deployed by telecom operators in networks counting over 50 million subscribers.
  • Standardize on one database for the core Tecnotree products, while meeting the company’s technical and economic requirements.
  • Select a database delivering the configuration flexibility needed to provide the best performance and reliability in different settings.

Solution

  • Evaluation and selection of MySQL as embedded database based on its high performance, reliability, flexibility of deployment and cost-effectiveness.
  • Tecnotree leverages the built-in MySQL replication to confer up to 5 nines (99.999%) availability to its solutions; ensuring subscribers will continuously be able to access the operators’ network and billing infrastructure.
  • Implemented at the heart of front-end signaling systems transmitting information to other applications, MySQL commonly handles 20,000 queries and 2,000 transactions per second, for example allowing the real-time billing of subscribers.
  • MySQL databases powering the voice-mail and conferencing applications deployed by operators store up to a terabyte of data.
  • Tecnotree has been relying on MySQL for several years, and plans to embed it in additional products in the future, highly valuing the “hassle free” nature of the database.
  • The company also uses the Oracle database within its customer care and billing solutions.

“With MySQL we get a high performance solution that simultaneously delivers the flexibility to serve our different database needs.” Timo Ahomäki, CTO, Tecnotree


Thursday Nov 15, 2012

Considering Embedding a Database? Choose MySQL!

The M of the LAMP stack and the #1 database for Web-based applications, MySQL is also an extremely popular choice as embedded database.

Access our Resource Kit to discover the top reasons why:

 

  • 3,000 ISVs and OEMs rely on MySQL as their embedded database
  • 8 of the top 10 software vendors and hundreds of startups selected MySQL to power their cloud, on-premise and appliance-based offerings
  • Leading mobile and SaaS providers ensure continuous service availability and scalability with lower cost and risk using MySQL Cluster.

Learn how you can reduce costs and accelerate time to market while increasing performance and reliability. Access white papers, webinars, case studies and other resources in our Resource Kit.


 

Tuesday Nov 13, 2012

Top 10 Reasons to Use MySQL and MySQL Cluster as an Embedded Database

If you are considering using MySQL and/or MySQL Cluster as the embedded database solution for your application, you should join us for today's webcast where we will discuss how you can cut costs, add flexibility and benefit from new performance and scalability enhancements that are now available in MySQL 5.6 and MySQL Cluster 7.2.  We will cover the top 10 reasons that make MySQL and MySQL Cluster the best solutions for embedding in both shrink wrapped and SaaS provided applications, how industry leaders leverage MySQL products and how you can get started with the latest innovations and support offerings across the MySQL product line.

You can learn more and reserve your seat here.

As always, thanks for your support of MySQL!


Monday Nov 12, 2012

Attend MySQL Webinars This Week

Interested in learning more about MySQL as embedded database? In building highly available MySQL applications with MySQL and DRBD? Join our webinars this week! All information below.

Tuesday next week (November 20) we will provide an update about what's new in MySQL Enterprise Edition.

We have live Q&A during the webinars so you'll get the chance to ask all your questions.

Top 10 Reasons to Use MySQL as an Embedded Database

Tuesday, November 13
9:00 a.m. PT
Review the top 10 reasons why MySQL is technically well-suited for embedded use, as well as the related business reasons vendors choose MySQL initially, over time, and across product-lines.
Register for the Webcast.


MySQL High Availability with Distributed Replicated Block Device

Thursday, November 15
9:00 a.m. PT
Learn how to build highly available services with MySQL and distributed replicated block device (DRBD). The DRBD high-availability solution comprises a complete stack of open source software that delivers high-availability database clusters on commodity hardware, with the option of 24/7 support from Oracle.
Register for the Webcast.


Technology Update: What's New in MySQL Enterprise Edition

Tuesday, November 20
9:00 a.m. PT
Find out what's new in MySQL Enterprise Edition.
Register for the Webcast.

Thursday Oct 25, 2012

Tilgin Improves Subscriber Device Management with Embedded MySQL

Tilgin IPRG AB develops and delivers systems and software for the digitally-connected home. Using Tilgin home gateway software, as well as central software for remote control and operation of the network, Tilgin’s customers can offer their subscribers broadband services. The company has over 100 customers,  telecommunications and broadband operators, in more than 30 countries.

Tilgin needed a robust and scalable database solution for its auto-configuration server (ACS) product, tGem, used by its customers to manage the devices that provide their subscribers with access to television, internet, telephony, and other services. Tilgin chose MySQL as embedded database. This made it possible for Tilgin’s customers to easily and smoothly implement new generations of services, as well as to easily add new subscribers, ultimately enabling the company to save time and money.

Read the case study here.

Monday Oct 15, 2012

HERMES Medical Solutions Helps Save Lives with MySQL

HERMES Medical Solutions was established in 1976 in Stockholm, Sweden, and is a leading innovator in medical imaging hardware/software products for health care facilities worldwide. HERMES delivers a plethora of different medical imaging solutions to optimize hospital workflow.

HERMES advanced algorithms make it possible to detect the smallest changes under therapies important and necessary to optimize different therapeutic methods and doses.

Challenges

  • Fighting illness & disease requires state-of-the-art imaging modalities and software in order to diagnose accurately, stage disease appropriately and select the best treatment available.
  • Selecting and implementing a new database platform that would deliver the needed performance, reliability, security and flexibility required by the high-end medical solutions offered by HERMES.

Solution

  • Decision to migrate from in-house database to an embedded SQL database powering the HERMES products, delivered either as software, integrated hardware and software solutions, or via the cloud in a software-as-a-service configuration.
  • Evaluation of several databases and selection of MySQL based on its high performance, ease of use and integration, and low Total Cost of Ownership.
  • On average, between 4 and 12 Terabytes of data are stored in MySQL databases underpinning the HERMES solutions. The data generated by each medical study is indeed stored during 10 years or more after the treatment was performed.
  • MySQL-based HERMES systems also allow doctors worldwide to conduct new drug research projects leveraging the large amount of medical data collected.
  • Hospitals and other HERMES customers worldwide highly value the “zero administration” capabilities and reliability of MySQL, enabling them to perform medical analysis without any downtime.
  • Relying on MySQL as their embedded database, the HERMES team has been able to increase their focus on further developing their clinical applications.
  • HERMES Medical Solutions could leverage the Oracle Financing payment plan to spread its investment over time and make the MySQL choice even more valuable.

MySQL has proven to be an excellent database choice for us. We offer high-end medical solutions, and MySQL delivers the reliability, security and performance such solutions require.” Jan Bertling, CEO.

Tuesday Jul 03, 2012

Case Study: Polystar Improves Telecom Networks Performance with Embedded MySQL

Polystar delivers and supports systems that increase the quality, revenue and customer satisfaction of telecommunication services. Headquarted in Sweden, Polystar helps operators worldwide including Telia, Tele2, Telekom Malysia and T-Mobile to monitor their network performance and improve service levels.

Challenges

  • Deliver complete turnkey solutions to customers integrating a database ensuring high performance at scale, while being very easy to use, manage and optimize.
  • Enable the implementation of distributed architectures including one database per server while maintaining a low Total Cost of Ownership (TCO).
  • Avoid growing database complexity as the volume of mobile data to monitor and analyze drastically increases.

Solution

  • Evaluation of several databases and selection of MySQL based on its high performance, manageability, and low TCO.
  • The MySQL databases implemented within the Polystar solutions handle on average 3,000 to 5,000 transactions per second.
  • Up to 50 million records are inserted every day in each database. Typical installations include between 50 and 100 MySQL databases, up to 300 for the largest ones. Data is then periodically aggregated, with the original records being overwritten, as the need for detailed information becomes unnecessary to operators after a few weeks.
  • The exponential growth in mobile data traffic driven by the proliferation of smartphones and usage of social media requires ever more powerful solutions to monitor, analyze and turn network data into actionable business intelligence. With MySQL, Polystar can deliver powerful, yet easy to manage, solutions to its customers.
  • MySQL-based Polystar solutions enable operators to monitor, manage and improve the service levels of their telecom networks in over a dozen countries from a single location.
  • The new and innovative MySQL features constantly delivered by Oracle help ensure Polystar that it will be able to meet its customer’s needs as they evolve.

MySQL has been a great embedded database choice for us. It delivers the high performance we need while remaining very easy to use, manage and tune. Power and simplicity at its best.” Mats Söderlindh, COO at Polystar.

Monday Jan 23, 2012

MySQL Embedded Online Forum

Next Tuesday, January 31st, it’s going to be all about MySQL Embedded!

We will be running an Online Forum from 9.00 am to 12.00 pm PT. Oracle’s MySQL Embedded experts will deliver 4 technical sessions addressing “what all ISVs & OEMs should know about embedding MySQL…but often don’t”.

By attending the Online Forum you will learn:

  • Why MySQL is a great embedded database choice for both startups and the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an application's life cycle
  • MySQL installation options that require minimal or zero end-user effort, and how to easily build them into your application
  • How to secure MySQL embedded in applications, appliances, and devices
  • Tips to simplify your integration with MySQL using the most popular MySQL connectors, and guidance on selecting the settings that will maximize your application’s performance
  • Why MySQL delivers excellent performance and how to go beyond the default settings to optimize MySQL’s queries, reporting, and search capabilities

Check out the full agenda and register here!

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
25
26
27
28
29
30
   
       
Today