Highlights

Sun Introduces MySQL Tech Support for Amazon EC2

The MySQL Enterprise for Amazon EC2 subscription is a comprehensive offering of database software and production support to deliver applications on Amazon EC2 with optimal performance, reliability, security, and uptime. For the first time, organizations can now cost-effectively deliver database driven web-scale computing in the "cloud", fully backed by the MySQL database experts at Sun.

Webinar: Memcached and MySQL

Thursday, May 29, 10:00am PST

Join us for this informative technical webinar where we will show you how to leverage memcached, the open source distributed memory caching system, to increase the performance and scalability of MySQL driven websites and applications. Memcached gurus Frank Mashraqi of Fotolog and Monty Taylor of Sun Microsystems will dive into the technical aspects of designing and implementing memcached using real world examples.

White Paper: Database Driven Development for Carrier Grade Systems

Over the last several years, NEPs and CSPs have been replacing their proprietary databases, which were expensive to extend and maintain, with third-party databases, which reduce development, maintenance, integration and running costs. MySQL Cluster CGE provides a complete set of carrier grade features that platform developers can leverage, thus reducing develop time and time to market.

Gartner Report: Combining Sun and MySQL

We pose the fundamental and crucial questions about understanding the motivation and market impact of the acquisition of MySQL by Sun Microsystems. MySQL fits Sun's strategy and ambition to deliver a top-to-bottom open-source stack. MySQL has a huge installed base, much of which uses the database in high-volume Web servers.

MySQL Jobs

MySQL is the world's most popular open source database software. As part of Sun Microsystems' software group, MySQL is a global organization with over 400 workers in 25 countries. We are looking for talented professionals in engineering, sales, marketing, professional services, and support that will contribute to our products' strong momentum and share in our success! We have openings for the following positions:

Technical Writer

Support Engineers

Senior Software Engineer, Online Backup

QA Engineers

Senior Instructors (Ireland)

Senior Consultants (USA, EMEA)

Sales Representatives

And Many More ...

Apply Now » (http://www.mysql.com/jobs/)

New Product Releases

New Release of MySQL Workbench 5.0.21 (GA)

The MySQL Developer Tools team is working hard to constantly improve Workbench in terms of stability and handling. 4 bugs have been fixed since the last release 04/15/2008. For this release we focused on improving stability of our application. There are still remaining minor issues we are about to fix. Also keep posting any issue that you encounter while working with our product.

Hints & Tips

Article: MySQL Workbench for Database Change Management

Robin Schumacher

Managing database change is an incredibly important discipline that very few database professionals overtly talk or worry about until they're in the thick of things with a particular database - moving it from development to production, making changes to a newly installed production database, or implementing an updated version of the database (new tables, modifications to existing objects, etc.) in a SaaS application. It's at that point where change management becomes very important because if you don't do things right the first time, you can make a royal mess of things and even (in a small number of cases) reach the point of no return where you've completely torched your database.

Article: Why You Want to be Good at Data Modeling

Robin Schumacher

To be really successful at working with databases, there are many different disciplines to become proficient in - things like disaster recovery, security management, data integration, and more. But there are less than a handful of things you want to be really good at; becoming super-skilled in them will help you enormously in your database career. And believe it or not, one of these key areas is data modeling and its kissing cousin, physical database design.

White Paper: Optimizing MySQL on Sun X64 Servers & Storage

Optimizing MySQL Server takes planning and understanding of the application running on the database, the service level agreements (SLAs) required, and the type of I/O needed for the application. However, MySQL Server can be used for a wide variety applications and data types, and one size does not fit all for optimization parameters and settings.

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 6.0 Feature #2: Online Backup

BACKUP DATABASE copies all data and metadata in one or more MySQL databases, into an "image file". RESTORE reads an image file and rewrites all the data and metadata in one or more MySQL databases. So if you lose a database, you can recover all of it as of the time of the last BACKUP DATABASE statement.And then you can re-run the statements in MySQL's binary log to recover "from the time of the last BACKUP DATABASE statement", "to the time that the database loss occurred". In other words ... Careful Use of Online Backup will protect from database loss.

PlanetMySQL Blog: MySQL Proxy: Replicating into Memcached

Jan Kneschke

If you use replication with MySQL and memcache at the same time you have the problem to make sure that the memcached and the slave are in sync. If you announce the memcached to mark a entry as dirty and let it update the value from the slave BEFORE it is updated, you fetch a old value.

A common usage pattern for this is "lazy initialization" of a row in a database, which is exactly what my team was using it for yesterday to solve a problem in the backend for version 2.0 of the MySQL Enterprise Monitor.

Shows how to install and configure SugarCRM on Solaris Operating Sytem to achieve under 2 second response times for more than 90% of requests accessed by 900 concurrent users on Sun's Coolthreads Server. A detailed account of MySQL, Apache and PHP tuning is also provided to reproduce these results.

Events

Live Webinar: Enabling Enterprise 2.0 with MySQL

Thursday, May 29, 2008 - 15:00 CET

Join us for this informative webinar where we will explore how open source Web 2.0 technologies, applications and architectures leveraging MySQL Enterprise can help enable information access across an enterprise's entire technology spectrum, through a network of tightly and loosely integrated applications, services and devices.

In this Webinar you will learn how MySQL's Certified Consultants use industry best practices and proven methodologies to improve performance up to 10x, implement cost-effective high-availability solutions, architect solutions to meet your exact requirements, and much more. Josh Chamas, Director of MySQL Professional Services will share with you real-world examples of how MySQL has designed, scaled and tuned MySQL applications for some of the world's fastest growing companies.

Live Webinar: How MySQL Enables Web 2.0 for Government

Wednesday, June 11, 2008 - 11:00am PST

Faced with mandates for improved efficiency, greater convenience, and better access to public services, government agencies are accelerating its use of internet technology as a platform for exchanging information and conducting its business. Web 2.0 technologies such as online communities, wikis, blogs, and the like are being used broadly by agencies to push information over the internet; facilitate communications between agencies and constituents; conduct transactions; and expedite governance. A core competency for participants in this revolution is database management. Join Red Hat and MySQL for this interactive web seminar on how MySQL Enterprise is enabling the technologies that are transforming government.

Training, Consulting, and Certification

Consulting: MySQL Developer (4+ Days)

A dedicated MySQL certified consultant will work closely with your team to:

Analyze your current database application

Analyze your database requirements

Identify potential issues and limitations

Benchmark, load test, and optimize critical SQL queries

Help them implement best practices and recommend tools for developing your database infrastructure.

Learn More » (http://www.mysql.com/consulting/packaged/dev.html)

Training: MySQL High Availability (3 Days)

Milan, Tokyo, Hamburg, Boston, Frankfurt, London

This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/mysql_5_ha.html)

Partners

Zmanda: New version 2.2 of Zmanda Recovery Manager for MySQL introduces Continuous Data Protection for MySQL

The new version 2.2 of Zmanda Recovery Manager (ZRM) enables Continuous Data Protection (CDP) for MySQL by using Linux LVM, Veritas VxFS, Microsoft VSS, Solaris ZFS and NetApp snapshots in conjunction with MySQL transaction logs. When doing a recovery to a particular point in time, ZRM reads data from the snapshot and then replays MySQL transaction log from that point forward.

In today's fast moving business environment, it is clear that Business Intelligence (BI) is a mandatory part of any company's decision making environment. The question then becomes how to build this environment in a cost-effective way that keeps up with ever-changing business requirements, new and large numbers of users, all forms of analytics, and increasing volumes of data.

Sun/MySQL and Kickfire are teaming up to change all that, bringing unheard of speed, scalability and cost-efficiencies to MySQL for data warehousing and reporting. Having twice announced world record-breaking performance and price-performance on industry standard data warehousing benchmarks, the companies will discuss the Kickfire Database Appliance for MySQL and how it can help supercharge your business.