opensubscriber
   Find in this group all groups
 
Unknown more information…

n : newsletter@mysql.com 28 September 2007 • 1:26PM -0400

MySQL Newsletter: September 2007
by MySQL AB

REPLY TO AUTHOR
 
REPLY TO GROUP



MySQL Newsletter
September 2007
newsletter@mysq...

Articles in this newsletter:

Highlights
- New MySQL Enterprise Replication Monitor
- MySQL European Customer Conferences (October)
- MySQL Conference & Expo 2008 - Call for Participation is Open
- 30 Day Trials for MySQL Enterprise with Monitoring Services
- MySQL for OEMs, ISVs & VARs: Industry Spotlight
- MySQL is Hiring

New Product Releases
- MySQL Community Server 6.0.2 (Alpha - Falcon Preview)
- MySQL Connector/ODBC 5.1.0 (Alpha)

Hints & Tips
- White Paper: MySQL Cluster Evaluation Guide
- White Paper: High Performance Database Solutions for Multiplay Service Architectures
- Article: A Primer on Falcon Tablespaces
- Article: How MySQL Treats Security Vulnerabilities
- Article: Using MySQL with PDO
- PlanetMySQL Blog: Tips for MySQL Newbies
- PlanetMySQL Blog: My Take on the Enterprise Monitor
- PlanetMySQL Blog: Baby Steps Into Stored Procedures
- PlanetMySQL Blog: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization

Events
- Live Web Seminar: What's New in the MySQL Enterprise Fall 2007 Release? (October)

Training, Consulting & Certification
- Consulting: MySQL Performance Tuning & Optimization (3+ Days)
- Training: MySQL 5.0 for Database Administrators (5 days)

Partner Corner
- Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.

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

Highlights

New MySQL Enterprise Replication Monitor: Fall 2007 Release

MySQL is proud to announce the Fall 2007 Release of the MySQL Enterprise Monitor making it easier for DBAs to manage MySQL Replication in scale-out environments. The following is a partial list of new features in the Fall 2007 Release:

- Replication Monitor
- Replication Topology Auto Detection and Grouping
- New Advisor Rules for Replication, Performance & Administration
- New Graphs

Learn What's New:
  http://www.mysql.com/products/enterprise/whats_new.html
Download the White Paper:
  http://www.mysql.com/products/enterprise/whitepapers/mysql-wp-enterprise-fall-whatsnew.php


Conference: MySQL European Customer Conferences 2007 (October)
London, Munich, Paris

An annual event, the MySQL European Customer Conferences offer you the opportunity to:

- Learn about MySQL Enterprise and the unique monitoring capabilities
- Learn best practices to get the most out of MySQL
- Network with fellow European customers and discover how they are leveraging MySQL
- Meet with MySQL European executives, engineers, consultants and MySQL partners

Learn More:
  http://www.mysql.com/news-and-events/events/emea-conference-2007/

Register now, there are only a few days left:
London, October 16:
  http://www.registrationline.co.uk/mysql/event224/reg.asp
Munich, October 18:
  http://www.registrationline.co.uk/mysql/event225/reg.asp
Paris, October 23:
  http://www.registrationline.co.uk/mysql/event226/reg.asp


MySQL Conference & Expo 2008 - Call for Participation is Open

The 2008 MySQL Conference & Expo brings over 1,600 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. Take an active role in shaping the future of MySQL and related open source technologies by leading sessions and tutorials at the 2008 MySQL Conference & Expo.

Submit Your Proposal (Deadline October 30th):
  http://en.oreilly.com/mysql2008/public/cfp/2


30 Day Trials for MySQL Enterprise with Monitoring Services

You can experience the power of the MySQL Enterprise Monitor at no charge for 30 days. This Service continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. It is like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more.

Register for the Trial:
  http://www.mysql.com/ent-trial-reg-2007/


MySQL for OEMs, ISVs & VARs: Industry Spotlight

Hundreds of Original Equipment Manufacturers (OEMs), Independent Software Vendors (ISVs) and Value Added Resellers (VARs) across multiple industries rely on MySQL for their success. Here are examples of industries and customer case studies that have adopted MySQL.

Learn More:
  http://www.mysql.com/why-mysql/oem-isv-corner/industry.html


MySQL is Hiring

Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 300 employees in 25 countries. We have openings for the following positions:

- Support Engineers
- Senior Software Developer - Storage Engines
- Senior Software Developer - Replication
- Senior Software Developer - Online Backup
- QA Engineers
- Training Course Developer
- And More ...

Apply Now:
  http://www.mysql.com/jobs/

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

New Product Releases  

New Release of MySQL Community Server 6.0.2 (Alpha - Falcon Preview)

Falcon is a Storage Engine for the MySQL database server. The Falcon Storage Engine has been designed with modern database requirements in mind, and particularly for use within high-volume web serving or other environment that requires high performance, while still supporting the transactional and logging functionality required in this environment. It's currently released within a special alpha build of MySQL and will be updated regularly during the alpha process. The following is a partial list of enhancements and changes:

- 64-bit Windows support
- Support for tablespaces
- New performance settings, falcon_log_windows, falcon_index_chill_threshold, and falcon_record_chill_threshold.
- The Falcon record cache parameters have been altered. The falcon_max_record_memory and falcon_min_record_memory are no longer supported.

View the complete list of changes:
  http://dev.mysql.com/doc/falcon/en/news-falcon-6-0-2.html
Download Now:
  http://dev.mysql.com/downloads/mysql/6.0.html


New Release of MySQL Connector/ODBC 5.1.0 (Alpha)

MySQL Connector/ODBC 5.1.0-alpha, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the first of the new 5.1 series and is suitable for use with any MySQL server version since MySQL 4.1, including MySQL 5.0, 5.1, and 6.0. (It will not work with 4.0 or earlier releases.) The following is a partial list of changes:

- Added support for SQL_C_WCHAR.
- Added support for Unicode functions (SQLConnectW, etc).
- Added descriptor support (SQLGetDescField, SQLGetDescRec, etc)

View complete list of changes:
  http://lists.mysql.com/announce/483
Download Now:
  http://dev.mysql.com/downloads/connector/odbc/5.1.html

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

Hints & Tips

White Paper: MySQL Cluster Evaluation Guide
Designing, Evaluating and Benchmarking MySQL Cluster

In this whitepaper learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We explore hardware, networking and software requirements. Work through basic functional testing and evaluation best practices.

Download the White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php


White Paper: High Performance Database Solutions for Multiplay Service Architectures

What are multiplay services and what do they mean from an architectural perspective? Service oriented architectures for multiplay entail challenging database requirements. How can they deliver the necessary performance while maintaining the flexibility to support new features? This article answers these questions and explains how intelligent database design and tuning can improve performance many times over, using the high performance MySQL Cluster relational database as an example.

Download the White Paper:
  http://www.mysql.com/why-mysql/white-papers/mysql_wp_ipl_multiplay.php


Article: A Primer on Falcon Tablespaces

Each storage engine has its own set of characteristics, some of which are shared with other storage engines, but some of which are unique to a particular engine. The Falcon transactional storage engine uses the concept of user-defined tablespaces that are more in line with what one would find in Oracle (tablespaces) or SQL Server (filegroups). Let's take a quick look at how tablespaces are used within Falcon and what you can and can't do with them.

Read the Article:
  http://dev.mysql.com/tech-resources/articles/primer_on_falcon_tablespaces.html


Article: How MySQL Treats Security Vulnerabilities

The phrase "security vulnerability" gives most of us the creeps. We are afraid of them. Looking at them rationally, they share a trait with other bugs: All are a pain, but some are a bigger pain than others. And instead of trying to avoid the evil by not talking about it, let's take a look at MySQL's security vulnerability track record over the years, and explain the rationale behind our actions using actual cases from past years.

Read the Article:
  http://dev.mysql.com/tech-resources/articles/security_vulnerabilities.html


Article: Using MySQL with PDO

PDO is a PHP extension providing a data-access abstraction layer that can be used with a variety of databases. This gives you the flexibility of changing the database backend without having to alter your access methods. Even if you use MySQL exclusively, PDO can provide advantages; you can use the same data-access methods regardless of the MySQL version.

Read the Article:
  http://dev.mysql.com/tech-resources/articles/mysql-pdo.html  


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 MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://www.planetmysql.org
Submit Your Blog Feed:
  http://www.planetmysql.org/newfeed.php


PlanetMySQL Blog: Tips for MySQL Newbies
Ben Krug

Are you a brand-newbie to MySQL? Coming from another database (or databases)? If so, here are some concepts to read up on right away to ease your confusion down the road. These are the top things I wish someone had told me about before I did anything else with MySQL.

Read the PlanetMySQL Blogpost:
  http://oracle2mysql.wordpress.com/2007/09/25/tips-for-mysql-newbies/


PlanetMySQL Blog: My Take on the Enterprise Monitor
Colin Charles

MySQL has had this Enterprise Monitor around for a while. It wasn't until this week that I actually tried it (besides, it wasn't until the UC-J that it was re-launched with new features), and found some time to play with it. And I was blown away.

Read the PlanetMySQL Blogpost:
  http://www.bytebot.net/blog/archives/2007/09/22/my-take-on-the-enterprise-monitor


PlanetMySQL Blog: Baby Steps into Stored Procedures
Tim Soderstrom

Recently I have been taking a serious look at stored procedures in MySQL and, in particular, how I might go about implementing them in my website and, in particular, where they could be used and why. At present, I have really only gotten my feet wet with using stored procedures, but I think that is enough to make some conclusions that I thought might be helpful to others that are starting to look at stored procedures as well.

Read the PlanetMySQL Blog Post:
  http://www.moocowproductions.org/blog/details.php?postid=284


Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
Peter Zaitsev

A typical query for reporting applications is to find the top X values. If you analyze Web Site logs you would look at most popular web pages or search engine keywords which bring you most of the traffic. If you're looking at ecommerce reporting you may be interested in best selling product or top sales people. This information may often need simple select query, however what if you would like to show percents not just absolute value?

Read the PlanetMySQL Blog Post:
  http://www.mysqlperformanceblog.com/2007/09/17/using-group-by-with-rollup-for-reporting-performance-optimization/

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

Events

What's New in the MySQL Enterprise Fall 2007 Release
Tuesday, October 16, 2007 (Americas)
Thursday, October 18, 2007 (EMEA)
Thursday, October 25, 2007 (Germany)

The MySQL Enterprise 2007 Fall Update is designed to ease common pain points for those using MySQL Replication to scale-out on MySQL. In this new web seminar you'll learn and see how the MySQL Enterprise Fall 2007 Release provides:

- Auto detection and grouping of all of your MySQL Replication topologies
- Real-time monitoring of all your Master-Slave servers for performance and latency issues
- Replication Advisors that identify and advise you on correcting Master/Slave sync, latency and configuration issues before they become costly outages
- Security Advisors that proactively scan your MySQL servers for any unplanned security related change, identify hard to find loopholes and advice you on optimal security settings per MySQL best practices
- Performance Advisors that monitor your MySQL servers over time and pinpoint and identify variable settings (optimization of caching, hit ratios, etc) that you can tune to keep them running at peak performance at all times

Register for this Webinar (AMER):
  http://www.mysql.com/news-and-events/web-seminars/display-53.html
Register for this Webinar (EMEA):
  http://www.mysql.com/news-and-events/web-seminars/display-56.html
Register for this Webinar (German):
  http://www.mysql.com/news-and-events/web-seminars/display-64.html

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

Training, Consulting and Certification

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

Now is the best time to schedule your Performance Tuning & Optimization engagement to ensure your applications will perform and scale for the holiday shopping season. MySQL also offers High Availability consulting engagements so you don't experience downtime during the busiest shopping days of the year.

Schedule your Schedule Your Engagement Now:
  http://www.mysql.com/consulting/packaged/performance.html


Training: MySQL 5.0 for Database Administrators (5 Days)
Madrid, Milan, San Diego, Phoenix, New York, Toronto and more.

- Is your MySQL database secure?
- Do your users have the correct privileges and access rights?
- Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
- Do you want to save time using features like Stored Procedures, Triggers and Views?
- Do you want to utilize the new enterprise features of MySQL 5.0?

Register Now for an Upcoming Date:
  http://www.mysql.com/training/workshops/mysql_dba.html

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

Partners

Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.

If you market a MySQL-based software application or hardware solution to end users, you can increase your business by advertising your product(s) in our Solutions Catalog. Join hundreds of existing partners and let millions of MySQL users find your solution by becoming a partner. All it takes is a few minutes to understand the program, and your company and product information.

Sign up and become MySQL's newest partner:
  http://solutions.mysql.com/partners

The MySQL Team


About the Newsletter

You can send us queries and give us feedback online.
  http://www.mysql.com/company/contact/

You can unsubscribe from this newsletter online:
  http://www.mysql.com/unsub?email=subscriber@open...

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

--
Copyright (c) 2007 MySQL AB. All rights reserved.
You are free to distribute this newsletter, as long as you don't make any changes.

Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

opensubscriber is not affiliated with the authors of this message nor responsible for its content.