- 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
- 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)
- Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.
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
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
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.
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.
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.
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.
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)
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.
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.
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.
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.
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.
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.
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.
PlanetMySQL Blog: My Take on the Enterprise Monitor
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.
PlanetMySQL Blog: Baby Steps into Stored Procedures
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.
Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
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?
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
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.
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?
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.