| |||
|
|
 | |||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||
| |||
52606 |
Saturday, July 10, 2010
What's New in Oracle Application Express 4.0?
Friday, July 9, 2010
MySQL Newsletter: July 2010
July 2010
mysql-newsletter@sun.com
Articles in this newsletter:
Highlights
- Tutorial: Getting Started with MySQL Workbench
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: Guide to MySQL for Microsoft Windows
- Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup
- Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials (Thursday, July 22)
New Product Releases
- New Release of MySQL Workbench 5.2.25 (GA)
- New Release of MySQL Community Server 5.1.48 (GA)
- New Release of MySQL Connector/J 5.1.13 (GA)
Hints & Tips
- Documentation: InnoDB INFORMATION_SCHEMA Tables
- Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010
- PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
- PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
- PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
- PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
- PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
- PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
- PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
- PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
- PlanetMySQL Blog: How many IOPs can InnoDB do?
- PlanetMySQL Blog: Lock wait timeout on slaves
Spotlight: MySQL Embedded Server in Network Management
- On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine
- Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance
Events
- Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine (Wednesday, July 14)
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals (Thursday, July 15)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA
- Live Webinar: What's New in MySQL - Japanese (Thursday, July 22)
- On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
- On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
-------------------------------------------------------------------
Highlights
Tutorial: Getting Started with MySQL Workbench
This tutorial provides a quick hands-on introduction to using MySQL Workbench for beginners. In order to complete this tutorial you will need to have a locally installed MySQL Server. This tutorial requires MySQL Workbench version 5.2.16 or above.
View the Tutorial:
http://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial.html
White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
This paper looks at various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php
White Paper: Guide to MySQL for Microsoft Windows
As we will discover over the course of this paper, MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, hosting providers and organizations developing custom web, departmental and enterprise applications.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_onwindows.php
Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup
The Pyro Group has selected the MySQL Cluster database to power their InRoam SDP (Service Delivery Platform). InRoam enables Cell C and their network partners to provide low cost, border-less mobile communications services to hundreds of thousands of football fans from around the world as they descend on South Africa for the 2010 FIFA World Cup tournament.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs-pyro_telecoms.php
Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials
Thursday, July 22, 2010 - 9am PT
Join us for Part 2 of the "MySQL Essentials" webinar series with Mike Frank from the MySQL Product Management group at Oracle. In this presentation, we'll demonstrate the fundamentals of SQL scripting with MySQL. We will cover SELECTs, JOINs, CREATE, DELETE, INSERTs and a host of other DML and DDL operations. Also covered will be essential management commands for administering and monitoring MySQL. We will be demonstrating how to accomplish these tasks both at the command line and in an automated fashion using MySQL's built-in scheduler, MySQL Workbench and MySQL Enterprise Monitor.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-553.html?p=newsletter
-------------------------------------------------------------------
New Product Releases
New Release of MySQL Workbench 5.2.25 (GA)
We're pleased to announce the release of MySQL Workbench 5.2.25. This release is GA (Generally Available). We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications. MySQL Workbench 5.2 GA provides:
- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)
View the complete list of changes:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-25.html
Download now:
http://dev.mysql.com/downloads/workbench/
Read the Documentation:
http://dev.mysql.com/doc/workbench/en/index.html
New Release of MySQL Community Server 5.1.48 (GA)
MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 is recommended for use on production systems.
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-48.html
Download now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads
New Release of MySQL Connector/J 5.1.13 (GA)
MySQL Connector/J 5.1.13, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.13 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.
View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-13.html
Download Now:
http://dev.mysql.com/downloads/connector/j/5.1.html
-------------------------------------------------------------------
Hints & Tips
Documentation: InnoDB INFORMATION_SCHEMA Tables
There are seven INFORMATION_SCHEMA tables that contain live information about compressed InnoDB tables, the compressed InnoDB buffer pool, all transactions currently executing inside InnoDB, the locks that transactions hold and those that are blocking transactions waiting for access to a resource.
Read the Documentation:
http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-information-schema-overview.html
Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry
Sahlgrenska University Hospital (SU) is one of the major hospitals in Europe and was founded in 1997 when three hospitals in Sweden merged. Every year, Sahlgrenska University Hospital records two million referrals and comments through the Central Registry system which is powered by MySQL.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs-enterprise-sahlgrenska_hospital.php
PlanetMySQL Blog Posts
The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.
Visit PlanetMySQL:
http://planet.mysql.com/
Submit Your Blog Feed:
http://planet.mysql.com/new
PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010
Giuseppe Maxia
Oracle OpenWorld is the conference of everything related to Oracle. This year's edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.
Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle OpenWorld show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.
Read the PlanetMySQL BlogPost:
http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle
PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
Andrew Morgan
The new version of MySQL Workbench (5.2.25) has just gone GA - see the Workbench Blog for details. So what's the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes.
Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql/mysql-workbench-5-2-goes-ga-partial-support-for-mysql-cluster/
PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
Andrew Morgan
A series of quick-start guides are now available to get you up and running with MySQL Cluster in as little time as possible; they are available for LINUX/Mac OS X, Windows and Solaris. The configuration is intentionally a simple 1 - 2 data nodes, 1 management node and 1 MySQL Server. Once you have this up and running, your next experiment may be to extend this over multiple hosts.
Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql/download-install-configure-run-and-test-mysql-cluster-in-under-15-minutes/
PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
Ulf Wendel
The mysqlnd plugin API is a well hidden gem of mysqlnd. Mysqlnd plugins operate on a layer between PHP applications and the MySQL server. This is comparable to MySQL Proxy. MySQL Proxy operates on a layer between any MySQL client application, for example, a PHP application, and the MySQL server.
Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=284
PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
Ulf Wendel
The first public mysqlnd plugin adds client side query result caching to all MySQL extensions of PHP. The cache is written in C. It does not change any of the PHP MySQL APIs and works with any PHP application using MySQL. Query results are stored on the client.
Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=286
PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
Anders Karlsson
The MySQL Cluster daemon for MySQL Cluster (ndbd and ndb_mgmd) doesn't by themselves yet let them run as a service. But there are ways to fix this, using some simple Windows tools and some registry hacking.
Read the PlanetMySQL BlogPost:
http://karlssonondatabases.blogspot.com/2010/06/running-mysql-cluster-as-service-on.html
PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
Chris Calender
There are many advantages to using the plugin as opposed to the built-in version (aside from just the new I_S tables, and more importantly, numerous performance enhancements), and it's breeze to set up, so I wanted to provide a quick start guide to using the new InnoDB plugin.
Read the PlanetMySQL BlogPost:
http://www.chriscalender.com/?p=99
PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
Bob Zurek
Over a month ago, Infobright was invited to join the Oracle MySQL Storage Engine Advisory Board and last week was the first in a series of meetings that Oracle will be hosting for the Advisor Board members. Oracle did a terrific job stepping up to the task of assembling a well known group of companies as part of the board. The meeting last week was clearly a sign of commitment by Oracle to work closely with the storage engine vendors in the market. This resonated very well with the advisory board members.
Read the PlanetMySQL BlogPost:
http://www.infobright.org/Blog/Entry/oracle_mysql_storage_engine_advisory_board_-_its_happening/
PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
Venu Anuganti
Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes.
Read the PlanetMySQL BlogPost:
http://venublog.com/2010/06/23/how-read_buffer_size-impacts-write-buffering-and-write-performance/
PlanetMySQL Blog: How many IOPs can InnoDB do?
Mark Callaghan
I previously tested InnoDB on an 8-core server to determine how many IOPs it can do for a simple IO-bound workload. The limits were ~12k disk reads/second for MySQL 5.0 and ~18k reads/second for MySQL 5.1. I just repeated the tests using a 16-core server and the results are much better. I can get 20,000 to 30,000 disk reads/second using InnoDB 5.1.
Read the PlanetMySQL BlogPost:
http://www.facebook.com/note.php?note_id=403975340932
PlanetMySQL Blog: Lock wait timeout on slaves
Alex Lurthu
We had one of our slave servers frequently stops replicating with the "Innodb Lock Wait Timeout" error. The slave IO thread would continue to fetch the binlogs while the slave SQL thread kept stopping with the above mentioned error.
Read the PlanetMySQL BlogPost:
http://alexlurthu.wordpress.com/2010/06/07/lock-wait-timeout-on-slaves/
-------------------------------------------------------------------
Spotlight: MySQL Embedded Server in Network Management
Many new technologies and applications are creating a significant increase in network traffic volume and complexity, making it more difficult to maintain a high performance network that doesn't disrupt application availability. MySQL enables ISVs and OEMs to overcome these limitations and build modern network management products by providing high performance, cost-effectiveness, ease of installation, zero administration, and much more.
On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine
MySQL offers a variety of storage engines that can be matched to application requirements. Data can be integrated seamlessly between storage engines. When none of the existing engines look like a perfect match to your requirements, you can add your own. MySQL provides a SQL stack for your data. By leveraging the integration between storage engines, you are free to concentrate on just the design of key tables.
Register for this Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-424.html
Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
NetQoS delivers products and services that enable some of the world's most demanding enterprises, including American Express, Boeing, and Chevron, to improve network performance. NetQoS ReporterAnalyzer relies on MySQL and tells IT organizations which applications and users are consuming bandwidth, and when, so they can optimize the wide area network and improve IT service delivery.
NetQoS found that MySQL provided the ideal combination of performance, reliability, and ease of administration for ReporterAnalyzer. In addition, MySQL's affordable licensing model enabled NetQoS to reduce its database costs by several thousand dollars per network appliance.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_netqos.php
Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Server, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php
Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance
To give the entire IT organization better visibility and control over the performance and availability of their networks, systems and applications, ScienceLogic relies on the performance and scalability of MySQL to process real-time information from thousands of networked devices.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php
-------------------------------------------------------------------
Events
Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine
Wednesday, July 14, 2010 - 9am PT
The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-551.html?p=newsletter
Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals
Thursday, July 15, 2010 - 9am PT
In Part I of a three-part performance series, MySQL performance expert Brian Miezejewski will take you through the fundamentals of architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.
In this session, Brian will go through the first steps to take when designing your database for high performances. He will also show you how to spot and quickly resolve the most common performance bottlenecks.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-552.html?p=newsletter
Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA
Join this technical webinar for an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access.
Register for the German Webinar on July 16:
http://dev.mysql.com/news-and-events/web-seminars/display-554.html
Register for the Italian Webinar on July 22:
http://dev.mysql.com/news-and-events/web-seminars/display-555.html
Live Webinar: What's New in MySQL - Japanese
Thursday, July 22, 2010 - 2pm JST
As a result of the acquisition of Sun Microsystems and Oracle, MySQL is now part of Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and further drives its innovation.
The latest release of MySQL Enterprise includes many new features and improvements, which are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. In this webinar, we will share the latest updates from MySQL, including exciting new product development.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-556.html
On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.
Register for this Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-538.html?p=newsletter
On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. There are classes of web services, however, that are update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.
Register for this Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-545.html?p=newsletter
Read the White Paper "Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached":
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.
View the full list of webinars:
http://dev.mysql.com/news-and-events/web-seminars/index.html
-------------------------------------------------------------------
Want to receive the latest MySQL updates and interact with the MySQL community?
Follow MySQL on Twitter:
http://twitter.com/mysql
Follow MySQL Community on Twitter:
http://twitter.com/mysql_community
-------------------------------------------------------------------
About the Newsletter
You can send us queries and give us feedback online.
http://dev.mysql.com/contact/
You can unsubscribe from this newsletter online:
http://dev.mysql.com/unsub?email=johandontmessup@gmail.com
Read more about the newsletter and view previous issues.
http://dev.mysql.com/news-and-events/newsletter/
--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.
Get to Know Oracle's New Public Sector Planning and Budgeting Solution
| ||||||||||||||||||||||||||||||||||||
Tuesday, July 6, 2010
Announcing the Most Complete, Open, and Integrated x86 Systems
| |||||||||||||||||||||||||||||||||||||||||||||
52027 |
Friday, July 2, 2010
Eighteen Oracle Certification Beta Exams Currently Available
 | |
| June 2010 | Register | Contact Us |
 | |
Hi Everyone, This month's Oracle Certification E-Magazine has an interesting assortment of helpful info. We have some good helpful program tips, as well as some disappointing news regarding action we had to take on illegal/cheating activity. On a more positive note though, Global Knowledge released their 2010 IT Skills and Salary Report, which again denotes how certification is valued by the majority of managers and those who become certified. A lot of new certification development is in progress which we hope you find interesting and helpful for your technical proficiency an career. Read more below, and as always - share your thoughts on the OTN Forum and/or the Oracle Certification Blog! Thank you , | |
| USEFUL LINKS  |
ORACLE CERTIFICATION NEWSTime To Consider Getting Your Oracle Certification? A recent interesting study from Global Knowledge titled: 2010 IT Skills and Salary Report contains a lot of great information related to IT worker trends including roles, required skills, demographics, salaries and more. Certification is valued by the majority of managers and those who become certified, which … Who's Who? - Oracle Certification Email Contacts
Certification Cheating Incident Oracle Certification Survey - Becoming Oracle Certified
| |
SERVER & STORAGE SYSTEMS CERTIFICATIONSJava EE 6 Certification Beta Testing Now UnderwayBe one of the first in the world to become Certified for Java Platform, Enterprise Edition 6. Testing is either underway or will be underway soon for several new Java Platform, EE 6 certifications. There are Oracle certification exams for each of the following… Get a Free Certification Retake with Java and Oracle Solaris Certification Value PackagesFor the first time, Oracle is introducing all-inclusive Java and Oracle Solaris Certification Value Packages which can save you up to 20% and includes a free retake - just in case you don't pass on your first try… | |
ORACLE PARTNER CERTIFICATIONSBeta Testing Completes For Five New Partner Certification ExamsBeta testing has completed for five new partner certification exams, including JD Edwards EnterpriseOne Financial Management Essentials, Oracle SOA Foundation Practitioner, Oracle Application Express 3.2: Developing Web Applications… Beta Testing Underway For EIGHTEEN New Partner Certification ExamsBeta testing has gotten underway for 18 new partner certification exams, including Oracle Application Grid Essentials, Oracle Database 11g Security Options Essentials, Oracle Essbase 11 Essentials, WebCenter 11g Essentials… | |
  | |
Comments? Suggestion? Want to stay up to date? ORACLE UNIVERSITY | SUBSCRIBE / UNSUBSCRIBEVisit the Oracle Certification Blog or follow us on Twitter (OracleCert) | |
The Oracle Certification Program has several email aliases that you can use depending on what you need to accomplish. Oracle University has released this short video (1:54) in which Harold Green shows you how to contact those who can best help you. …
Oracle Certification has taken some recent actions with someone who tried to cheat on a test. Just last week…
At Oracle University, we're interested to know what kinds of challenges you face as you approach your task of getting certified. We know that getting Oracle certified is not an easy process, and we would like your input on which factors tend to be more or less of an issue to you personally…| 51657 |
Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL - E-mail Services, Redwood Shores, CA 94065, United States |
