MySQL Newsletter August 2007
Articles in this newsletter:
Highlights
- ISV Workshop: Eliminate 90% of Your Embedded Database Costs
- ISV Workshop: Performance Tuning for Embedded Databases
- 30 Day Trials for MySQL Enterprise with Monitoring Services
- Case Study: Zappos Uses MySQL to Power its Growth
- Conference: MySQL Users Conference Japan 2007
- Conference: MySQL European Customer Conferences 2007
- MySQL is Hiring
New Product Releases
Hints & Tips
- Documentation: MySQL Proxy
- Article: Self Joins vs. User Variables
- Article: How to write a successful patch
- Interview with David Axmark, Co-Founder of MySQL AB
- 35 Cool Things You Can Do using the MySQL Monitoring & Advisory Service
- White Paper: MySQL: Embedded Database for ISVs
- White Paper: MySQL Cluster Evaluation Guide
- White Paper: ATCA and MySQL Cluster Carrier Grade Edition
- PlanetMySQL Blog Posts
Events
- Live Web Seminar: Designing Enterprise Data Warehousing with MySQL (September 6)
- Live Web Seminar: MySQL for Software as a Service (SaaS) and Managed Hosting Providers (September 12)
- Live Web Seminar: ZipRealty Goes Open Source for Business Intelligence and Data Warehousing (September 25)
Training, Consulting & Certification
- Training: MySQL 5.0 for Developers (5 Days)
- Training: MySQL 5.0 for Database Administrators (5 days)
Partner Corner
- Zmanda Launches Zmanda Management Console for MySQL Backup
- Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.
Highlights
ISV Workshop: Eliminate 90% of Your Embedded Database Costs
September 18, Washington D.C.
September 19, Boston
This is your opportunity to learn why more than 700 OEMs (Original Equipment Manufacturers) and ISVs (Independent Software Vendors) including Adobe, Symantec, Sage and Zimbra have chosen to build their commercial products on MySQL Embedded Server. We will explore some of the most common obstacles encountered on the road to product success and show you how MySQL can help reduce COGS (Cost of Goods Sold) by 90% over Oracle and Microsoft SQL Server.
Register Today » (http://www.mysql.com/oemseminar/)
MySQL ISV Workshop: Performance Tuning for Embedded Databases
September 18, Washington D.C.
September 19, Boston
This is your opportunity to learn from the experts how to tune and optimize your MySQL Embedded Server that ships in your commercial product. This "ISV Workshop" is designed to provide expert insight and best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance.
Register Today » (http://www.mysql.com/isvperftuning/)
30 Day Trials for MySQL Enterprise with Monitoring Services
You can experience the power of the MySQL Monitoring and Advisory Service 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/)
Case Study: Zappos Uses MySQL to Power its Growth
Since its founding in 1999, Zappos has grown to 1,000 employees - and its website now carries over 1,000 brand name shoes, over 150,000 styles, and nearly 3 million products in stock and ready for immediate shipment. MySQL also recently helped Zappos.com achieve the #1 rating as the most-available Internet Retailer.
Download the Case Study » (http://www.mysql.com/why-mysql/scaleout/zappos.html)
Conference: MySQL Users Conference Japan 2007
September 11-12, 2007
MySQL AB will hold its first ever MySQL users conference in Asia. There will be more than 30 sessions covering popular topics including performance tuning, high availability, real-world case studies and MySQL 5.1 new features. If you are interested in becoming a sponsor or exhibitor at this conference, please contact ucj2007@mysql.com
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 before August 31st and receive an early bird discount!
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 5.0.45
This is a new release with new features and some additional bug fixes. The following is a partial list of changes:
- CREATE TABLE LIKE did not require any privileges on the source table and was not isolated from alteration by other connections. (Bugs #25578 and #23667)
- It is no longer possible to use a view to gain update privileges for tables in other databases. (Bug#27878)
- It is no longer possible for a user to gain privileges by calling a stored routine that was declared using SQL SECURITY INVOKER. (Bug#27337)
View the complete list of changes »
New Release of MySQL Connector/ODBC 3.51.19 (GA)
MySQL Connector/ODBC 3.51.19, a new version of the ODBC driver for the MySQL database system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version including MySQL 4.1, 5.0, or 5.1. The following is a partial list of changes:
- Added FLAG_MULTI_STATEMENTS to allow issuing queries that contain multiple statements. Also added to the setup GUI. (Bug #7445)
- Removed support for the TRACE and TRACEFILE DSN options. The standard ODBC logging should be used.
- Added support for SQL_ATTR_ROW_BIND_OFFSET_PTR in normal cursors. (Bug #6741)
- Added SSL options to the GUI setup dialog.
View complete list of changes »
Hints & Tips
Documentation: MySQL Proxy
The MySQL Proxy is an application that communicates over the network using the MySQL Network Protocol and provides communication between MySQL servers and MySQL clients. MySQL Proxy is available for MySQL servers 4.1 and higher and is documented in the MySQL Reference Manuals.
Article: Follow Up on Rolling Sums - Self Joins vs. User Variables
Damien Seguy had an interesting observation on my use of self joins for generating rolling sums. What about using a user variable to make the rolling sum from the beginning? Something simple enough like this:
Article: How to Write a Successful Patch
Submitting patches to Open Source code doesn't come naturally to everyone. It is not easy, since it requires coding skills that the average user does not have. Moreover, code patches require a fair amount of additional documentation, without which the patch itself is virtually useless. These notes will walk you through the requirements of a good patch for MySQL server and perhaps other projects.
Interview with David Axmark, Co-Founder of MySQL AB
David Axmark co-founded MySQL AB together with Michael "Monty" Widenius and Allan Larsson in 1995. Today, he is a member of the MySQL Community Relations team and has an advisory role in the MySQL Management. He travels all across the globe to advocate for MySQL and Open Source Software.
35 Cool Things You Can Do using the MySQL Monitoring & Advisory Service
The MySQL Monitoring and Advisory Service provides developers, DBAs, and SysAdmins with a "Virtual DBA Assistant" to enforce MySQL recommended best practices. Here is a list of 35 cool things you can do with the product that cover monitoring, administration, replication, security and performance.
Read More » (http://www.mysql.com/products/enterprise/benefits.html)
Download a Trail Version » (http://www.mysql.com/ent-trial-reg-2007/)
White Paper: MySQL: Embedded Database for ISVs
Over 700 ISVs embed MySQL including Adobe, Cisco, Motorola, Symantec, Suzuki and Zimbra. This paper explores these benefits in detail and showcases why MySQL is the ideal choice for OEM's and ISV's when it comes to selecting an embedded database for their application.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_embedded.php)
White Paper: MySQL Cluster Evaluation Guide
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: ATCA and MySQL Cluster Carrier Grade Edition
The Advanced Telecom Computing Architecture hardware standard, also known as AdvancedTCA® is the telecom industry's first specification for carrier-grade equipment which enables the integration of highly available computing power and switched fabric networking components. In this paper we explore how MySQL Cluster Carrier Grade Edition is well positioned to take advantage of this open, multi-vendor standard.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_scaleout_cge.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 MySQL, including technical tips and best practices.
PlanetMySQL Blog: MySQL Proxy learns R/W Splitting
Jan Kneschke
The trunk version of the MySQL Proxy 0.6.0 just learned about changing back-ends within running connection. It is now up to lua-script to decide which backend shall be used to send requests too.
We wrote a complete tutorial which covers everything from:
- Building and maintaining a connection pool with high and low water marks
- Transparent authentication (no extra auth against the proxy)
- Deciding on Query Level which backend to use
And implement a transparent read/write splitter which sends all non-transactional Queries to the slaves and the rest to the master.
Read the PlanetMySQL Blogpost »
PlanetMySQL Blog: Experience lags adoption: Why Oracle and SQL DBAs probably want to learn MySQL
Paul Vallee, The Pythian Group
There's an interesting dynamic going on right now in the DBA world. MySQL's growth and installed base, as a function of its size three or five years ago, is perhaps five if not ten times larger than it was.
Read the PlanetMySQL Blogpost »
PlanetMySQL Blog: Database replication lag
Dries Buytaert
As explained in an earlier blog post, we recently started using MySQL master-slave replication on drupal.org in order to provide the scalability necessary to accommodate our growing demands. With one or more replicas of our database, we can instruct Drupal to distribute or load balance the SQL workload among different database servers.
Read the PlanetMySQL Blog Post »
PlanetMySQL Blog: scale-out: notes on sharding, unique keys, foreign keys...
Ben Krug
adapt.com uses sharding to scale out. In my talk on moving to MySQL, I mentioned a few design issues we had to become aware of before we rolled out a sharded database environment. I promised to give more details, so here they are ...
Read the PlanetMySQL Blog Post »
Events
Live Web Seminar: Designing Enterprise Data Warehousing with MySQL
Thursday, September 06, 2007
In this live Webinar, you will learn:
- The five main data warehousing use cases of the present and future as identified by Gartner Group
- The key challenge facing those implementing data warehouse infrastructures
- The technical strategy behind MySQL's data warehousing initiative
- How the MySQL storage engine architecture uniquely meets the key use cases identified by Gartner
- How data warehouse designers can intelligently scale their business intelligence infrastructure
- How MySQL offers the lowest total cost of ownership in the area of data warehousing
Live Web Seminar: MySQL for Software as a Service and Managed Hosting Providers
Wednesday, September 12, 2007
This Webinar will explore some of the most common obstacles encountered on the road to product success, especially as related to embedded technologies. We'll examine the impact of market, competitive, cost-of-goods-sold, technology, and support factors. In each case, we'll demonstrate how embedding a proven, market-leading database such as MySQL can go a long way toward building a solid technology foundation while concurrently helping to mitigate risk.
Live Web Seminar: ZipRealty Goes Open Source for Business Intelligence and Data Warehousing
Tuesday, September 25, 2007
Learn why ZipRealty, a national real estate brokerage, chose MySQL and Pentaho Business Intelligence, to help them better measure and optimize agent performance, customer satisfaction and marketing ROI.
Training, Consulting and Certification
Training: MySQL 5.0 for Developers (5 Days)
Madrid, Toulouse, Phoenix, Singapore and more
- Do you want to learn how to develop database applications on MySQL?
- Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
- Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
Attend any MySQL for Developers class before September 30th and get a free copy of O'Reilly's book, "MySQL Cookbook" by Paul DuBois.
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dev.html)
Training: MySQL 5.0 for Database Administrators (5 Days)
Tokyo, Melbourne, Sacramento, Paris 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?
Attend any MySQL for Database Administrators class before September 30th and get a free copy of Robert Schneider's book, "MySQL Database Design and Tuning".
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)
Partners
Zmanda Launches Zmanda Management Console for MySQL Backup
Zmanda has launched its Zmanda Management Console for MySQL Backup. Zmanda Management Console, which enhances the popular open source Zmanda Recovery Manager (ZRM), is a powerful and secure browser-based GUI designed to simplify backup and recovery of MySQL. ZRM with the Zmanda Management Console dramatically reduces the workload.
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
© 2010, Oracle Corporation and/or its affiliates