<!-- /* Font Definitions */ @font-face {font-family:"ＭＳ 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"ＭＳ 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:-536870145 1073743103 0 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"ＭＳ 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-US;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"ＭＳ 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-US;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} -->

The Bay Area Drupal camp -BADCamp makes its mark in the Drupal world as the largest free Drupal gathering on earth. The recent Badcamp in Oct 2011 confirmed its reputation as the most significant Drupal event, attracting 1500 attendees and drawing on the brightest minds in Drupal. This event was bigger than any of the previous DrupalCon events. Speakers included the Dries Buytaert and Jeff Robins from Lullabot. The event included training workshops, presentations, a job fair, gathering and parties around Berkley.

The inspiration behind BADCamp is BarCamp, which are open international workshop events and are based on a variety of topics from politics to health. The open nature of this conference encourages open communication and sharing on the web, in the form of twitter and blogging. Barcamp’s success and large attendance has inspired other more focused conferences of this nature, including WordCamp, which focuses on Wordpress.

Drupal’s original creator and founder, Dries Buytaert was the one of the keynote speakers at this year’s 2011 BADCamp. The other keynotes were Jeff Robbins from Lullabot and Danese Cooper from the Bill and Melinda Gates Foundation. The preconference activities included Drupal training workshops, and summit events for non-profit, higher education and the west coast core developer summits.

BADCamp took place over 2 days. Each day comprised of sessions, gatherings and presentations. Coder sprints were available, which is a lounge for any participant who wants to contribute to a Drupal task. There was also a “Users Helping Users” session, in which Drupal users help each other with any Drupal issues being encountered. Drupal DropIn was a similar event, in which questions can be asked to experts, whoh can answer these questions. On the first evening, the keynote speakers gave their talks, followed by the party. On the second day, the Drupal Job Fair was on, in which those looking for jobs or a career in Drupal can network with employers seeking Drupal developers.

Whether you are an experienced or beginner Drupal developer, BADCamp is probably the best event to connect to the Drupal community. It is an opportunity to access the brightest minds in Drupal. If offers sessions where you can ask all the questions you might have about Drupal or offer your Drupal expertise. This open and participatory event is in the spirit of open source. The events of BADCamp and DrupalCon are one of the biggest reasons that Drupal is one of the best content management systems.

Mitchel Xavier attends Drupal events worldwide and is a Drupal Developer and Drupal development specialist.

Comment (0)

I wanted to reach out and let you know about free Application Security training materials we are providing.
Our five security vulnerability guides are packed with information yet easy to understand, and are useful for audiences ranging from IT executives to consumer-level cell phone users. A typical guide:
• Educates readers on threats like cross-site request forgery, SQL injections, mobile code security issues • Gives easy-to-follow steps, guidelines and helpful "cheat sheets" for preventing attacks • Provides further free resources to learn more about security risk management
You can find links to our five free guides below:
• SQL Injection: http://www.veracode.com/security/sql-injection
• Cross Site Scripting: http://www.veracode.com/security/xss
• Cross Site Request Forgery: http://www.veracode.com/security/csrf
• LDAP Injection: http://www.veracode.com/security/ldap-injection
• Mobile Code Security: http://www.veracode.com/security/mobile-code-security

Comment (0)

Comment (0)

Hey guys, I wanted to let you know about a great event for anyone from beginner to expert level who is interested in Drupal. Some of the best minds in the Drupal world will be presenting, and they are accepting submissions for presentation topics:

Organized for the third year by the Dallas Drupal Users Group, Dallas Drupal Days is a two day, community-centered event for learning, teaching and sharing Drupal, the premier open source Content Management Framework for building marketing-leading websites and web applications.

Each day will feature a keynote speaker followed by three tracks of sessions all day. Breakfast and lunch are included in the nominal registration fee. Come to both days for $70, or just the Saturday Drupal Camp for $35 (*early bird pricing, so don't wait).

You can view the sessions submitted so far, submit your own session, or propose a session topic you'd like to see.

Friday will be the Drupal Summit, focusing on how Drupal is used in business and how it brings value to many types of organizations, including Enterprise, Startups, Non-Profits, and everything in between. Learn from case studies on successful Drupal implementations, and sessions on business strategy, implementation and SEO.

Saturday will be the Drupal Camp, intended for sitebuilders, themers and developers. Expect sessions from beginner to expert level, with the sharpest minds in the Drupal world attending and presenting.

TO REGISTER OR FOR MORE INFORMATION, PLEASE VISIT:

http://dallasdrupal.org/register

Comment (1)

MySQL Newsletter
March 2011

Articles in this newsletter:

Highlights

- Live Webinar: MySQL on Windows Online Forum (March 16)
- Event: Collaborate 11 - Orlando, Florida (April 10-14)
- Event: MySQL Community Reception - Santa Clara, California (April 13)
- DevZone Interview: When the IOUG Meets the MySQL Community
- White Paper: MySQL Enterprise Backup - Fast, Consistent, Online Backups
- Live Webinar: MySQL Cluster 7.1, Latest Updates and Enhancements (March 24)
- Live Webinar: For MySQL ISVs/OEMs: Improve Product Performance, Lower Customer Support Costs (March 29)

New Product Releases

- New Release of MySQL Community Server 5.5.9 (GA)
- New Release of MySQL Community Server 5.1.56 (GA)
- New Release of MySQL Cluster 7.1.10 (GA)
- New Release of MySQL Workbench 5.2.32 (GA)
- New Release of MySQL Connector/J 5.1.15 (GA)
- New Release of MySQL Connector/ODBC 3.51.28 (GA)

Hints & Tips

- White Paper: MySQL Cluster for Presence & Location-Based Services
- White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: Simple lessons in improving scalability
  - PlanetMySQL Blog: Upgrading passwords from old_passwords to "new passwords"
  - PlanetMySQL Blog: Web and Telco mode Cluster Configuration
  - PlanetMySQL Blog: Checkpoint handling enhancements in Cluster 7.1 -or- *Ding Dong* GCP Stop is dead!
  - PlanetMySQL Blog: OurSQL Episode 34: Collaborating
  - PlanetMySQL Blog: PHP: Application calling plugin - on communication
  - PlanetMySQL Blog: MySQL Semi-Synchronous Replication. See the Magic. Try the Magic.
  - PlanetMySQL Blog: PHP: want transparent master slave load balancing in mysqlnd?
  - PlanetMySQL Blog: Video: MySQL 5.5 Overview by Bill Papp
  - PlanetMySQL Blog: VIEWS on INFORMATION_SCHEMA tables - Useful stuff
  - PlanetMySQL Blog: How to detect if a MySQL server is an active replication slave
  - PlanetMySQL Blog: Using SQL to create SQL (and other usefulness)
  - PlanetMySQL Blog: MySQL Enterprise Backup 3.5, the crash course

Events

- Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure - EMEA (March 15 & 16)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Portuguese (March 22)
- Live Webinar: MySQL 5.5 - What's New in Performance, Scalability and High Availability - Spanish (March 23)
- On-Demand Webinar: MySQL Reference Architectures for Highly Scalable Web Infrastructure

-------------------------------------------------------------------

Highlights

Live Webinar: MySQL on Windows Online Forum Wednesday, March 16, 2011 - 9:00AM PT

Would you like to reduce your database TCO on Microsoft Windows by up to 90% while increasing manageability and flexibility? Did you know that Windows is the #1 MySQL development platform? Join us for the "MySQL on Windows Online Forum" on March 16 and discover how you can win with MySQL on Windows!

Register Now:
  http://event.on24.com/r.htm?e=284490&s=1&k=583E2237A777967F8410211EC54EF3CB&partnerref=newsletter


Event: Collaborate 11 - Orlando, Florida April 10-14, 2011

Collaborate 11 is a user-driven technology and applications forum for the Oracle community, presented by three leading users groups - IOUG, OAUG, and Quest. This year, in response to the great interest in MySQL among its members, the IOUG creates a special "conference within a conference" on MySQL and features over 50 sessions with topics from technical tips to best practices. You can also meet with the MySQL experts from Oracle at the demo grounds and get all your questions answered!

Learn More about the MySQL sessions at Collaborate 11:
  http://collaborate11.ioug.org/tabid/133/Default.aspx

Register Now:
  http://collaborate11.ioug.org/Home/Registration/tabid/82/Default.aspx


Event: MySQL Community Reception - Santa Clara, California April 13, 2011 - 6:00PM PT

Join the MySQL Team on April 13, 2011, as we celebrate the health and growth of the MySQL community. Whether you are an attendee at O'Reilly MySQL Conference, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in the MySQL technology, you're all invited to Oracle's MySQL Community Reception. If you're at the MySQL Conference, don't miss Tomas Ulin's "State of the Dolphin" keynote, as he summarizes MySQL's first year under Oracle's stewardship, discusses the current and ongoing engagement with the MySQL user community, and offers insights into future roadmaps of the MySQL products.

RSVP for the MySQL Community Reception:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=131495&src=7011089&src=7011089&Act=10

Learn More about the "State of the Dolphin" Keynote:
  http://en.oreilly.com/mysql2011/public/schedule/detail/18530


DevZone Interview: When the IOUG Meets the MySQL Community

In light with the formation of the MySQL Council under the IOUG (Independent Oracle User Group) and two upcoming conferences with a lot of MySQL content - Collaborate 11 and O'Reilly MySQL Conference, we talked to Andy Flower, President of IOUG, Sarah Novotny, recognized MySQL community member and the Council Chair, as well as Lenz Grimmer and Dave Stokes, MySQL community managers at Oracle, on their thoughts and takes of the IOUG and the MySQL community.

Read the Interview:
  http://dev.mysql.com/tech-resources/interviews/flower-novotny-grimmer-stokes.html


White Paper: MySQL Enterprise Backup - Fast, Consistent, Online Backups

MySQL Enterprise Backup provides a high-performance, online "hot" backup solution with data compression technology to ensure your data is protected in case of downtime or an outage.

This white paper explores numerous backup methods to help you formulate your backup strategy. We also compare the advantages and disadvantages of these backup methods including mysqldump, LVM snapshots and MySQL Enterprise Backup. Backup and restore performance benchmarks, as well as illustrated examples of how MySQL Enterprise Backup works are provided.

Read the White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_backup.php


Live Webinar: MySQL Cluster 7.1, Latest Updates and Enhancements Thursday, March 24, 2011 - 9:00AM PT

MySQL Cluster is a leading real-time, write-scalable transactional database, combining high availability with the low TCO of open source. Join the live Webinar as we discuss the design concepts and most recent developments in MySQL Cluster.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-613.html?p=newsletter


Live Webinar: For MySQL ISVs/OEMs: Improve Product Performance, Lower Customer Support Costs Tuesday, March 29, 2011 - 9:00AM PT

MySQL Enterprise Monitor with best practice Advisors and the MySQL Query Analyzer are now available to OEMs in MySQL Enterprise Edition. MySQL OEMs can use MySQL Enterprise Monitor to provide higher levels of support to their customers, reduce support costs, and gain additional revenue.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-617.html

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.5.9 (GA)

MySQL 5.5.9 is a new release of the 5.5 production version of the world's most popular open source database. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/news-5-5-9.html

Download Now:
  http://dev.mysql.com/downloads/mysql/


New Release of MySQL Community Server 5.1.56 (GA)

MySQL Server 5.1.56, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.56 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-56.html

Download Now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Cluster 7.1.10 (GA)

The latest binary of MySQL Cluster 7.1.10 has been released.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-51-ndb-7-1-10.html

Download Now:
  http://dev.mysql.com/downloads/cluster/


New Release of MySQL Workbench 5.2.32 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.32. This is a maintenance release featuring a new and improved UI appearance and other enhancements.

View the Complete List of Changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-32.html

Download Now:
  http://dev.mysql.com/downloads/workbench/


New Release of MySQL Connector/J 5.1.15 (GA)

MySQL Connector/J 5.1.15, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL and version 5.1.15 is suitable for use with any MySQL version including 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-15.html

Download Now:
  http://dev.mysql.com/downloads/connector/j/5.1.html


New Release of MySQL Connector/ODBC 3.51.28 (GA)

MySQL Connector/ODBC 3.51.28, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version since 4.1.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-news-3-51-28.html

Download Now:
  http://dev.mysql.com/downloads/connector/odbc/3.51.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: MySQL Cluster for Presence & Location-Based Services

This whitepaper explores the different types of services that can take advantage of location and presence awareness, and considers their unique requirements for data management. A solution is then presented, based on MySQL Cluster, that allows operators to fully leverage the market opportunity and differentiation presented by these new services.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_cluster_location_presence.php


White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

This white paper introduces the concepts behind replication and what can be achieved with MySQL Replication. It steps through setting up replication as well as handling failover. In addition, the changes introduced to replication in MySQL 5.5 are covered as well as the differences when replicating with MySQL Cluster.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-replication.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: Simple lessons in improving scalability Ronald Bradford

It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them -- "the most efficient way to improve an SQL statement is to eliminate it".

Read the PlanetMySQL BlogPost - Part 1:
  http://ronaldbradford.com/blog/simple-lessons-in-improving-scalability-2011-02-16/

Read the PlanetMySQL BlogPost - Part 2:
  http://ronaldbradford.com/blog/part-2-simple-lessons-in-improving-scalability-2011-02-24/


PlanetMySQL Blog: Upgrading passwords from old_passwords to "new passwords"
Shlomi Noach

You have old_passwords=1 in your my.cnf. I'm guessing this is because you used one of the my-small.cnf, my-large.cnf etc. templates provided with your MySQL distribution.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords


PlanetMySQL Blog: Web and Telco mode Cluster Configuration Johan Andersson

The Core Scripts (aka Configurator) for MySQL Cluster has now been updated with a new feature that allows you to tune cluster for a particular workload. Currently there are two types of workloads supported: Web and Telco/Realtime.

Read the PlanetMySQL BlogPost:
  http://johanandersson.blogspot.com/2011/02/web-and-telcomode-cluster-configuration.html


PlanetMySQL Blog: Checkpoint handling enhancements in Cluster 7.1 -or- *Ding Dong* GCP Stop is dead!
Matthew Montgomery

One of the tasks that a data node must perform reliably is the Global Check Point. That is, to flush the transaction redo log to disk. The GCP completion must be synchronized on all data nodes in order to maintain a consistent end point for recovery.

Read the PlanetMySQL BlogPost:
  http://todointx.blogspot.com/2011/02/checkpoint-handling-enhancements-in.html


PlanetMySQL Blog: OurSQL Episode 34: Collaborating Sheeri Cabral and Sarah Novotny

In this episode, we talk about the Collaborate conference, including comparisons to the O'Reilly MySQL conference.

Read the PlanetMySQL BlogPost:
  http://technocation.org/content/oursql-episode-34:-collaborating


PlanetMySQL Blog: PHP: Application calling plugin - on communication Ulf Wendel

Imagine PECL/mysqlnd_ms could keep certain reads on certain slaves in a MySQL master-slave setup. You would have a good chance to profit from hot database caches. You would not only distribute read load, scale out horizontally by using MySQL replication, you would also optimize your reads for hot caches.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=301


PlanetMySQL Blog: MySQL Semi-Synchronous Replication. See the Magic. Try the Magic.
Ronen Baram

MySQL Replication is one of the most used and valued features of the MySQL Server. Unlike some other products on the market, it's out-of-the-box, easy to configure, non-paid and smart features. Most of our medium/large/super-large installation base are using replication to achieve "scale-out" scaling.

Read the PlanetMySQL BlogPost:
  http://blog.ronenb.com/2011/02/23/mysql-semisynchronous-replication/


PlanetMySQL Blog: PHP: want transparent master slave load balancing in mysqlnd?
Ulf Wendel

Are you interested in a master slave load balancing plugin for mysqlnd? It could have two operational modes. The automatic mode would operate transparent from an applications point of view. The manual mode would give you full control over all decisions. Automatic mode is for install and forget when you start with MySQL replication. Manual mode is for growing as your application evolves.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=299


PlanetMySQL Blog: Video: MySQL 5.5 Overview by Bill Papp Sheeri Cabral

At the February 2011 Boston MySQL User Group Meeting, Bill Papp of Oracle shared a presentation about what's new in MySQL 5.5. The video is already up on YouTube and is also embedded at the end of this post.

Read the PlanetMySQL BlogPost:
  http://palominodb.com/blog/2011/02/18/video-mysql-55-overview-bill-papp


PlanetMySQL Blog: VIEWS on INFORMATION_SCHEMA tables - Useful stuff Anders Karlsson

Views in MySQL really has quite a bad reputation, for bad performance mainly, but also there were some stability issues at some point. Now they are pretty stable, but I don't see them used that much. One place where I like to use them myself is in combination with INFORMATION_SCHEMA tables. The I_S tables are really useful and contain a lot of information, and by using VIEWs we can massage the data a bit.

Read the PlanetMySQL BlogPost:
  http://karlssonondatabases.blogspot.com/2011/02/views-on-informationschema-tables.html


PlanetMySQL Blog: How to detect if a MySQL server is an active replication slave Giuseppe Maxia

Sometimes you know for sure. And sometimes you wonder: is this server part of a replication system? And, most specifically, is it an active slave? The completeness of the answer depends on how much visibility you have on the server.

Read the PlanetMySQL BlogPost:
  http://datacharmer.blogspot.com/2011/02/how-to-detect-if-mysql-server-is-active.html


PlanetMySQL Blog: Using SQL to create SQL (and other usefulness) Sarah Novotny

Today, I had a task of modifying a slave to exclude (or if you want to say specifically include) tables. The situation is that this slave needs to only contain tables used for reporting. The added benefit is that with fewer tables to replicate, there will be less replication traffic, less disk I/O and less disk space used hence better performance for queries that digest statistical data.

Read the PlanetMySQL BlogPost:
  http://www.bluegecko.net/mysql/using-sql-to-create-sql-and-other-usefulness/


PlanetMySQL Blog: MySQL Enterprise Backup 3.5, the crash course Ronen Baram

Everyone loves hands-on tutorials with code snippets and stuff to establish the knowledge that something can be done. So here is my first one: MySQL Enterprise Backup 3.5, the new and shiny backup solution for MySQL.

Read the PlanetMySQL BlogPost:
  http://blog.ronenb.com/2011/02/21/mysql-enterprise-backup-3-5/

-------------------------------------------------------------------

Events

Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure - EMEA

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management.

Register for the Germany Webinar on March 15 at 10:00 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-612.html

Register for the Italian Webinar on March 16 at 15:00 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-616.html


Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Portuguese Tuesday, March 22, 2011 - 16:00 Sao Paulo Time

In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Register for the Portuguese Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-614.html


Live Webinar: MySQL 5.5 - What's New in Performance, Scalability and High Availability - Spanish Wednesday, March 23, 2011 - 17:00 Mexico City Time

MySQL, the world's most popular open source database, presents its latest release, MySQL 5.5. Join the Webinar and learn the details about improvements in performance, scalability and high availability, as a result of Oracle's investment in MySQL's community, developers and customers.

Register for the Spanish Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-615.html


On-Demand Webinar: MySQL Reference Architectures for Highly Scalable Web Infrastructure

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management.

Register for this On-Demand Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-606.html


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?

Read Oracle's MySQL Blog:
  http://blogs.oracle.com/mysql/

Join MySQL on Facebook:
  http://www.facebook.com/mysql

Follow MySQL on Twitter:
  http://twitter.com/mysql

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/?topic=newsletter

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@gmail.com

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

Problems reading the newsletter in your email client? View the newsletter on the web.
  http://dev.mysql.com/news-and-events/newsletter/2011/2011-03.html

--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.

Comment (0)

To get the page load time for a block of code you can do the following.

1. Add the code below before the block of code:
<?php
$starttime = microtime();
$startarray = explode(" ", $starttime);
$starttime = $startarray[1] + $startarray[0];
?>
Microtime is a function that returns a value giving the current time in seconds and milliseconds from the UNIX Epoch (internationally set as 0:00:00 January 1, 1970 GMT).   Explode then splits this value into its two component parts (seconds and milliseconds), and then inserts both values separately into a variable.

2. Insert the following code after the block of code:

<?php
$endtime = microtime();
$endarray = explode(" ", $endtime);
$endtime = $endarray[1] + $endarray[0];
$totaltime = $endtime – $starttime;
$totaltime = round($totaltime,5);
echo "This page loaded in $totaltime seconds.";
?>

This will show you the exact load time for a particular block of HTML code.

Comment (0)

Wordpress is very popular cms that every one want to use. But the some sites in wordpress has very lower performance due to its speed(Time to load in the
browser). Whenever we create any site we want that the site should load very fast with less time no matter it is in wordpress/joomla/ or any other opens CMS
or your own custom CMS.

Here are the few checklist that everyone should follow:

1. Reduce the number of request in your site. This can be done by using only one css file instead of many different css files. Similarly is the case with .js
 files. In this way we can minimize the number of request.

2. Reduce the load time. This can be done if we compress the file or even gzip files(If your server support this feature). Secont you can mimize the image
size in bytes. FOr this there are many image optimizer available for free. One I prefer is "http://www.imageoptimizer.net/Pages/Home.aspx" which reduce image
size. The second is "http://refresh-sf.com/yui/" which reduces the css size.

3. There are some plugin available in the wordpress which also helps to increase the site speed. Some of which are "db-cache", "wp css", "hypercache" and
"Supercache".

4. If you are using some custome SQL queries you can also check the time of execution of each query so that if it can be modified you should modify them as
well. Lets take an example which I have taken from my wordpress script.

$x_column_query['Latest News'] = "SELECT DISTINCT posts.* FROM $wpdb->posts `posts`, $wpdb->term_relationships `relationships`, $wpdb->postmeta `meta` WHERE
`posts`.`ID` = `relationships`.`object_id` AND `relationships`.`term_taxonomy_id` IN($x_latest_cat_ids) AND !(`posts`.`ID` IN ($bpids)) AND
`posts`.`post_status` = 'publish' AND `posts`.`post_type` = 'post' $meta_condition ORDER BY `posts`.`post_date` DESC LIMIT $x_extended_limit";


I have replace the above script with the script as below:

$x_column_query['Latest News'] = "SELECT posts.* FROM $wpdb->posts `posts` WHERE `posts`.`ID` IN (SELECT `object_id` FROM $wpdb->term_relationships WHERE
term_taxonomy_id IN(".$x_latest_cat_ids.")) AND `posts`.`ID` IN (SELECT `post_id` FROM $wpdb->postmeta `meta` WHERE ".$meta_condition_one." ) AND
!(`posts`.`ID` IN (".$bpids.")) AND `posts`.`post_status` = 'publish' AND `posts`.`post_type` = 'post'   ORDER BY posts.`post_date` DESC LIMIT
".$x_extended_limit;

And I got very positive result in my query execution time. The only difference is that I have used sub-queries instead of one single query.

5. To check you site speed you can use FireFoz "Yslow plugin" or "Firebug" which gives you detail where the site is slow which part needs optimization to get better speed.

Comment (0)

In continution to my wordpress blog post today I want to share my thoughts related to my experience while exploring the functionality of my plugin. I want to
develop the functionality to delete/trash posts similar to the default wordpress functions does. But when I created my own function to trash post it also
deleted my posts from trash, so I come to realize that when we add action to trash the post it also calls the wordpress trash function that's why on trashing
my post from my own custom function it then call trash fucntion (the default wordpresss function) which completely delete the post as it is already marked
"trashed".

Also I was not sure what add_action I have to use to call the trash/delete post. After some research I found what I actually need to do in my plugin. The
code is given below which solves my problem. Hope it will be beneficial to other users.

add_action('trash_post', 'trash_rows_setup'); //This is used to trash the post

add_action('delete_post', 'delete_rows_setup'); //this is used to delete the post


function trash_rows_setup()
{
    global $wpdb;
    if(is_array($_GET['post']))
    {
                foreach($_GET['post'] as $key =>$value)
        {
            $varPostID = $value;
            $id = $wpdb->get_var("SELECT `ID` FROM $wpdb->posts WHERE `plex_post_type` = 'duplicated" . $varPostID . "'");
            if(trim($id) != '')
            {
                $wpdb->query("UPDATE $wpdb->posts SET `post_status`='trash' WHERE `ID` = '".$id."'");
            }
        }
    }
    else
    {
        $id = $wpdb->get_var("SELECT `ID` FROM $wpdb->posts WHERE `plex_post_type` = 'duplicated" . $_GET['post'] . "'");
        if(trim($id) != '')
        {
            $wpdb->query("UPDATE $wpdb->posts SET `post_status`='trash' WHERE `ID` = '".$id."'");
        }     }
        return true;
}

function delete_rows_setup()
{
    global $wpdb;
    if(is_array($_GET['post']))
    {
        foreach($_GET['post'] as $key =>$value)
        {
            $varPostID = $value;
            $id = $wpdb->get_var("SELECT `ID` FROM $wpdb->posts WHERE `plex_post_type` = 'duplicated" . $varPostID . "'");
            if(trim($id) != '')
            {
                $wpdb->query("DELETE FROM $wpdb->posts WHERE `ID` = '".$id."'");
                $wpdb->query("DELETE FROM $wpdb->postmeta WHERE `post_id` = '".$id."'");
                $wpdb->query("DELETE FROM $wpdb->comments WHERE `comment_post_ID` = '".$id."'");
                            }
        }
    }
    else
    {
        $id = $wpdb->get_var("SELECT `ID` FROM $wpdb->posts WHERE `plex_post_type` = 'duplicated" . $_GET['post'] . "'");
        if(trim($id) != '')
        {
            $wpdb->query("DELETE FROM $wpdb->posts WHERE `ID` = '".$id."'");
            $wpdb->query("DELETE FROM $wpdb->postmeta WHERE `post_id` = '".$id."'");
            $wpdb->query("DELETE FROM $wpdb->comments WHERE `comment_post_ID` = '".$id."'");
        }     }
    return true;
}

Comment (1)

I recently worked on the project related to improve the website speed. When I analyzed the files I found that it used a lot of php code which can easily replaced by mysql. There were a scenario where we sort the record in particular order e.g. 2,0,1 and it was accomplished with the help of PHP code.

When I checked the mysql manual I found it can be done easily using ORDER BY FIELD

For e.g. If you have 3 priorities Low, Normal, High and you want to display High records first and then Normal and then Low. We used below query for that and it worked very well and it improved the website loading time.

Select * from table_name ORDER BY FIELD(priority_record, ‘High’,’Normal’,’Low’);

Comment (0)

MySQL Newsletter
Special Edition: Developing and Managing MySQL Applications mysql-newsletter@sun.com

This is a special edition of the MySQL Newsletter. In addition to the regular MySQL Monthly Newsletter, a MySQL Newsletter Special Edition is issued each quarter that highlights technical information on topics most relevant to MySQL DBAs and developers. This edition is focused on Developing and Managing MySQL Applications with resources to help you get started and manage your MySQL environment more efficiently.

Highlights

- Oracle Magazine: Open for Business - MySQL community wins with better innovation, support, and integration
- Event: MySQL Developer Room at FOSDEM 2011 - Belgium (February 5)
- Event: MySQL at Mobile World Congress - Spain (February 14-17)
- Seminar: Get the Most Out of MySQL - Customer Stories - Italy (February 1)
- Seminar: Improve Performance and Scalability with the Latest from MySQL - EMEA (February 10 & 16)
- Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products (February 10)
- Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials (February 22)
- Live Webinar: MySQL Reference Architectures for Massively Scalable Web Infrastructure (February 24)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA

Developing PHP Applications with MySQL

- Blog: mysqlnd plugins for PHP in practice
- On Demand Webinar: How to Develop Simple PHP Applications for MySQL
- On Demand Webinar: Designing to Scale to 200K Transactions per Second with Open Source: MySQL, Java, curl, PHP

Developing Java Applications with MySQL

- Webcast: MySQL Tips for Java Developers - Expert Interview
- On Demand Webinar: How to Develop Simple Java Applications with MySQL
- On Demand Webinar: Blazing Java Application Performance: Connector/J Performance Gems
- On Demand Webinar: How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish
- On Demand Webinar: Automatic Java Application Multi-Platform Deployment Using MySQL Connector/MXJ
- Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database
- Case Study: Clickability Delivers Web Content Management SaaS Solution using MySQL

Developing MySQL Applications on Windows

- White Paper: A Visual Guide to Installing MySQL on Windows
- On Demand Webinar: How to Develop Simple .NET Applications for MySQL
- On Demand Webinar: Getting Started with MySQL on Windows
- On Demand Webinar: Building MySQL on Windows
- On Demand Webinar: Getting Started Using MySQL as an Embedded Database with Windows Applications
- On Demand Webinar: What's New in MySQL Connector/NET 6.2
- Presentation: MySQL and the ADO.NET Entity Framework
- 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

Managing MySQL Applications

- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: MySQL Enterprise Monitor 2.3: What's New
- White Paper: MySQL Enterprise Monitor: Business Overview
- White Paper: MySQL Cluster Manager
- On Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL
- Demo: MySQL Workbench Demos
- Case Study: Big Fish Games Triples Database Performance with MySQL Query Analyzer

MySQL Training and Certification

- Training: Introduction to MySQL 5.5
- Training: MySQL and PHP - Developing Dynamic Web Applications
- Training: MySQL for Developers
- Certification: Save 20% and Get a Free Certification Retake with MySQL Certification Value Packages

-------------------------------------------------------------------

Highlights

Oracle Magazine: Open for Business - MySQL community wins with better innovation, support, and integration David A. Kelly

Sometimes, relatively small things can make a big impact. Take the case of the MySQL database. First released in 1995 and purchased by Sun in 2008, MySQL has quickly graduated from the realm of hobbyists to the world of business, becoming the leading open source database for many Web applications and an integral part of the LAMP Web application stack.

Read the Magazine Article:
  http://www.oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html


Event: MySQL Developer Room at FOSDEM 2011 Brussels, Belgium - February 5, 2011

FOSDEM is one of the largest gatherings of Open Source Developers and Projects in Europe. In 2011, the event will take place on February 5th and 6th in Brussels, Belgium. We will have a Developer Room titled "MySQL and Friends", which will provide a venue for talks about MySQL and related projects. The MySQL Developer Room will be open on Saturday, February 5th, from 13:00 to 19:00. If you're around, come join us and meet with MySQL experts!

Learn More:
  http://forge.mysql.com/wiki/FOSDEM_2011

View the Sessions and Speakers:
  http://forge.mysql.com/wiki/FOSDEM_2011_Developer_Room


Event: MySQL at Mobile World Congress
Barcelona, Spain - February 14-17, 2011

With more than 49,000 communications industry attendees, Mobile World Congress is where the industry comes together. Join us to learn how MySQL and other Oracle solutions enable innovative services while reducing the cost and complexity of infrastructure software and hardware.

Learn More:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=109912&src=6973382&src=6973382&Act=4


Seminar: Get the Most Out of MySQL - Customer Stories Milan, Italy - February 1, 2011

MySQL is the world's most popular open-source database and many organizations in Italy selected MySQL to power their mission critical applications. In this event you will hear stories from MySQL customers and learn how ContactLab, Buongiorno and Cineca are benefitting from the use of MySQL.

Learn More and Register for this Italian Seminar:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129578&src=7011252&src=7011252&Act=99


Seminar: Improve Performance and Scalability with the Latest from MySQL Paris, France - February 10, 2011 London, UK - February 16, 2011

With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools.

Learn More and Register for the French Seminar:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129864&src=7011252&src=7011252&Act=118

Learn More and Register for the English Seminar:
  http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129696&src=7011252&src=7011252&Act=100


Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products Thursday, February 10, 2011 - 9:00AM PT

With the release of MySQL 5.5, all of the advanced capabilities of MySQL Enterprise Edition are now available to OEMs to be distributed with their commercial products. In this technical webinar, Sr. Product Managers and MySQL experts Mike Frank and Rob Young will review new options for OEMs, which are new or improved in the recently released MySQL version 5.5.

Register for this Webinar:
  http://www.mysql.com/news-and-events/web-seminars/display-605.html?p=newsletter


Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials Tuesday, February 22, 2011 - 9:00AM PT

Join us to learn the essential key steps to administering and maintaining your MySQL database. From command-line utilities to MySQL Workbench to MySQL Enterprise Monitor, we'll show the fundamentals of administering MySQL. Plus, we'll share how to create and execute backup strategies, including tools like MySQL Enterprise Backup for on-line hot backups.

Register for this Webinar:
  http://www.mysql.com/news-and-events/web-seminars/display-608.html?p=newsletter


Live Webinar: MySQL Reference Architectures for Massively Scalable Web Infrastructure Thursday, February 24, 2011 - 9:00AM PT

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. Optimum deployment architectures and topologies are defined based on sizing and availability requirements for each environment. We will also discuss the unique requirements for Large Social Networking applications.

Register for this Webinar:
  http://www.mysql.com/news-and-events/web-seminars/display-606.html?p=newsletter


Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA

Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. You'll also hear about new innovative professional support services offerings aimed at quickly improving the performance of your business-critical MySQL databases and applications.

Register for the Italian Webinar on February 17 at 10:00 CET:
  http://www.mysql.com/news-and-events/web-seminars/display-607.html

Register for the French Webinar on February 28 at 10:00 CET:
  http://www.mysql.com/news-and-events/web-seminars/display-609.html

-------------------------------------------------------------------

Developing PHP Applications with MySQL

Blog: mysqlnd plugins for PHP in practice Johannes Schlüter

If you follow my blog or twitter stream, you might know I've recently been at Barcelona to attend the PHP Barcelona conference. Conferences are great for exchanging ideas, and here is one of the ideas I discussed with Combell's Thijs Feryn. They are a hosting company providing managed MySQL instances to their customers, as such they run multiple MySQL servers and each server serves a few of their customers.

Read this Blog Post:
  http://schlueters.de/blog/archives/146-mysqlnd-plugins-for-PHP-in-practice.html


On Demand Webinar: How to Develop Simple PHP Applications for MySQL

In this technical webinar, MySQL developer Johannes Schlüter will show you the essentials for creating dynamic web content using MySQL and PHP. He will also discuss many of the fundamental elements used when developing PHP applications with MySQL, including the frameworks, APIs, security features, and asynchronous queries.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-575.html


On Demand Webinar: Designing to Scale to 200K Transactions per Second with Open Source: MySQL, Java, curl, PHP

It is possible to build an ad-engine that can serve up more ads than Twitter to an audience larger than Twitter's, using fewer than 10 MySQL servers producing more then 200K Transactions per Second across a Multi-Terabyte store with all open source software. MySQL with InnoDB/myISAM, curl, PHP, and Java are the only components that are necessary for this linearly scaling engine without user-facing downtime.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-475.html

-------------------------------------------------------------------

Developing Java Applications with MySQL

Webcast: MySQL Tips for Java Developers - Expert Interview

MySQL is the world's most popular open-source database, and there are a lot of Java developers who use MySQL databases in their applications. In this Deep Dive, Mark Matthews, architect for Enterprise Tools Team at Oracle, demonstrated some of the techniques that can help Java developers get more out of their applications that use MySQL.

Watch the Webcast:
  http://java.sun.com/developer/media/deepdivemysqljava.jsp


On Demand Webinar: How to Develop Simple Java Applications with MySQL

Java is among the most popular development languages for MySQL applications. In this webinar, Java and MySQL expert Mark Matthews will present the basic knowledge for you to get started developing and deploying simple Java applications with MySQL, including installation pre-requisites and process, options in architecture and frameworks, as well as how to handle transactions.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-591.html


On Demand Webinar: Blazing Java Application Performance: Connector/J Performance Gems

In this session, the author of Connector/J, Mark Matthews, will show you how to wring that last little bit of performance out of your Java applications deployed on MySQL by not using the out-of-the-box configuration. Connector/J has nearly 200 configuration options, many of which affect performance. Mark will show you how to move from generic to customized, illustrating how to set Connector/J options that will deliver the best performance for your specific application.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-460.html


On Demand Webinar: How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish

Join us for this informative technical webinar presented by Arun Gupta, where he will demonstrate how to leverage the latest version of the Netbeans IDE to quickly and easily develop and deploy MySQL and Glassfish backed applications using the JRuby-on-Rails framework.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-305.html


On Demand Webinar: Automatic Java Application Multi-Platform Deployment Using MySQL Connector/MXJ

Connector/MXJ is a Java utility package that makes the MySQL database appear to be a Java-based component. With MySQL Connector/MXJ, you can reduce installation barriers for your end user customers by simply adding an additional parameter to the JDBC connection url which will cause the database to start when the first connection is made.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-423.html


Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database

SonicWALL started using MySQL 5.0 in July 2008, and within just six months of using MySQL, SonicWALL was able to: Lower their cost of goods sold (COGS); Shorten new product time-to-market through the efficiencies they gained in Development, Quality Assurance, Training, and Documentation; and, Reduce the number of trouble tickets they received by over 20%, in addition to other gains.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql_cs_sonicwall.php


Case Study: Clickability Delivers Web Content Management SaaS Solution using MySQL

Clickability is the global leader in on demand Web Content Management, serving over 350 million page views per month for hundreds of customers, including Cisco, NetApp, Philly.com and CNN Interactive. MySQL stores the core application data which is used across multiple applications that include serving 500+ million advertisements and distributing 10+ million emails every month.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql-cs-clickability.php

-------------------------------------------------------------------

Developing MySQL Applications on Windows

White Paper: A Visual Guide to Installing MySQL on Windows

This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language. Its goal is to put in place basic knowledge and building blocks you will need in conjunction with added references to resources as you continue to drill down further into the more advanced features of MySQL.

Read this White Paper:
  http://www.mysql.com/why-mysql/white-papers/visual_guide_to_installing_mysql_windows.php


On Demand Webinar: How to Develop Simple .NET Applications for MySQL

In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET apps.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-568.html


On Demand Webinar: Getting Started with MySQL on Windows

Join us for this informative technical webinar with Mike Frank, Sr Product Manager at Oracle. In this presentation we'll cover the benefits of deploying MySQL on Windows. You will learn the basic "How-To's" of installation, security and configuration. We will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the Query Analyzer.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-416.html


On Demand Webinar: Building MySQL on Windows

In this presentation we'll demonstrate how to setup an environment for building MySQL on Windows from source. While not strictly necessary, installing and running the Windows build system in a virtual machine allows for a single source repository to be shared among multiple flavors of Windows and/or other operating systems.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-455.html


On Demand Webinar: Getting Started Using MySQL as an Embedded Database with Windows Applications

In this presentation we will cover the benefits of deploying MySQL Embedded Database with your Windows applications. You will learn the basic "How-Tos" of installation, security and configuration. You'll also learn how to use MySQL Connector/NET and Connector/ODBC, and how to ensure high availability and fault tolerance for MySQL on Windows.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-490.html


On Demand Webinar: What's New in MySQL Connector/NET 6.2

In this presentation we will explore the benefits of developing Windows applications with MySQL. We will also cover development best practices with Visual Studio and how to get the most from the latest version MySQL Connector/Net.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-446.html


Presentation: MySQL and the ADO.NET Entity Framework

In these presentation slides, Reggie Burnett, MySQL Software Engineer at Oracle explained how to leverage the Microsoft ADO.NET Entity Framework with MySQL. He presented a brief overview of the entity framework, a peek under the hood on how Connector/Net works with the entity framework and demonstrated using MySQL and the Entity Framework together.

View the Presentation:
  http://www.mysql.com/why-mysql/windows/mysql_ado.net_entity_framework.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, 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://www.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://www.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php

-------------------------------------------------------------------

Managing MySQL Applications

White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper 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://www.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


White Paper: MySQL Enterprise Monitor 2.3: What's New

MySQL is proud to announce the new release of MySQL Enterprise Monitor 2.3. This release can be used to monitor MySQL Servers that are part of a MySQL Cluster deployment. MySQL Enterprise Monitor 2.3 also improves general monitoring for MySQL and the Operating System by adding a set of new graphs for monitoring transactions and the new features available in InnoDB 1.1.

Read the English White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php

Read the German White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.de

Read the Italian White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.it

Read the French White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.fr

Try MySQL Enterprise Edition Now:
  http://www.mysql.com/trials/


White Paper: MySQL Enterprise Monitor: Business Overview

The MySQL Enterprise Monitor is designed to scale DBA resources by providing a unified, informed view into the health, security, performance and availability of an entire MySQL server environment. This paper explores the MySQL Enterprise Monitor in detail and explains how it can be leveraged as a "Virtual MySQL DBA" assistant to help over-extended DBAs proactively manage more MySQL servers with less time and effort.

Read the English White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php

Read the German White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.de

Read the Italian White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.it

Read the Japanese White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.ja


White Paper: MySQL Cluster Manager

MySQL Cluster Manager simplifies the creation and management of the MySQL Cluster database by automating common management tasks. As a result, Database Administrators (DBAs) and Systems Administrators are more productive, enabling them to focus on strategic IT initiatives and respond more quickly to changing user requirements.

Read this White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_manager.php


On Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL

Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have the tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Register for this Webinar:
  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-592.html


Demo: MySQL Workbench Demos

Watch these self-running demos to learn how MySQL Workbench can help with Data Modeling, Reverse and Forward Engineering, Change Management and Documentation.

Watch the Demos:
  http://www.mysql.com/products/workbench/demo.html


Case Study: Big Fish Games Triples Database Performance with MySQL Query Analyzer

Big Fish Games is a global leader in the online games industry, with over 25 million unique customer accounts and over 2.5 million visitors per month. MySQL allowed Big Fish Games to quickly grow their business with lower cost and hardware requirements, and has scaled with the company as it has grown into an industry leader. With the MySQL Query Analyzer, Big Fish Games was able to identify and analyze problematic SQL code, and tripled its database performance within three days, rather than weeks.

Read this Case Study:
  http://www.mysql.com/why-mysql/case-studies/mysql_cs_bigfishgames.php

-------------------------------------------------------------------

MySQL Training and Certification

Training: Introduction to MySQL 5.5

This one-day seminar covers all the new features and key enhancements to MySQL 5.5 and the MySQL Enterprise Edition, including Performance, Scalability, Availability and Backups. Instructor lecture is supported by recorded product demonstrations. By attending this course, you learn how to plan your use of the MySQL 5.5 product release more effectively.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D71615GC10


Training: MySQL and PHP - Developing Dynamic Web Applications

Through a hands-on approach, this 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.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D62048GC10&p_org_id=1001&lang=US


Training: MySQL for Developers

This course is the foundation course for developers planning on designing and implementing applications that make use of MySQL. It covers essential SQL statements for data design, querying, and programming.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D61830GC10&p_org_id=1001&lang=US

View the Complete List of MySQL Training Courses:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getsearchpage?page_id=13&p_search_category_id=1488


Certification: Save 20% and Get a Free Certification Retake with MySQL Certification Value Packages

Choose one of the exclusive MySQL packages to get on the fast track to MySQL certifications while saving 20%. Get two Live Virtual Classes to jumpstart your training, and then demonstrate your proficiency using the certification exam vouchers in the package to obtain two certifications. In addition, you will get the exclusive bonus of a free retake with each exam voucher, so you can take the exam a second time if needed at no additional cost.

Learn More:
  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=532&p_org_id=1001&lang=US

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL Community?

Read Oracle's MySQL Blog:
  http://blogs.oracle.com/mysql/

Join MySQL on Facebook:
  http://www.facebook.com/mysql

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://www.mysql.com/contact/

You can unsubscribe from this newsletter online:
  http://www.mysql.com/unsub?email=sanjay.ujina@gmail.com

--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)