MySQL Newsletter May 2008
Articles in this newsletter:
- Sun Introduces MySQL Tech Support for Amazon EC2
- Try and Buy MySQL on Sun Systems
- Webinar: Memcached and MySQL
- White Paper: Database Development for Carrier Grade Systems
- Gartner Report: Combining Sun and MySQL
- MySQL Jobs
- Article: MySQL Workbench for Database Change Management
- Article: Why You Want to be Good at Data Modeling
- White Paper: Optimizing MySQL on Sun X64 Servers & Storage
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL 6.0 Feature #2: Online Backup
- PlanetMySQL Blog: MySQL Proxy: Replicating into Memcached
- PlanetMySQL Blog: Useful ways of using Views
- PlanetMySQL Blog: Getting Hibernate and MySQL's "ON DUPLICATE KEY UPDATE" Feature to Play Nice Together...
- PlanetMySQL Blog: Scaling SugarCRM with MySQL on Sun's Coolthreads Server
- Live Webinar: Enabling Enterprise 2.0 with MySQL (May 29th)
- Live Webinar: MySQL Consulting - Your Fast Track to Better Performance, Availability and Scalability (June 3rd)
- Live Webinar: How MySQL Enables Web 2.0 for Government (June 11th)
- Zmanda: New version 2.2 of Zmanda Recovery Manager for MySQL
- Live Webinar: Simple, Fast and Flexible Data Warehousing with Infobright (German)
- Live Webinar: Turbo Charging MySQL Reporting and Data Warehousing with Kickfire
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.
Learn More » (http://www.mysql.com/products/enterprise/ec2.html)
MySQL is a natural fit for Sun's award-winning Sun Fire x64 servers or SPARC Enterprise servers with CoolThreads technology. Sun's modular storage systems provide effective, efficient data storage and protection for high growth MySQL environments.
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.
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.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_cge_business_db_dev.php)
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 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/)
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.
MySQL Connector/Net 5.1.6 a new version of the all-managed .NET driver for MySQL has been released. This is a minor release involving mainly bug fixes. Changes include:
- Fixed problem where parameters lists were not showing when you tried to alter a routine in server explorer. (bug #34359)
- Fixed a problem in procedure cache where it was possible to get into a race condition and cause a memory leak (bug #34338)
- Fixed problem where attempting to use an isolation level other than the default with a transaction scope would use the default instead (bug #34448)
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.
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.
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.
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.
Alexander Nozdrin, Chuck Bell, Lars Thalmann, Peter Gulutzan, Rafal Somla
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.
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.
Here are a few ways I found Views to be useful for me:
- Data Cleansing
- Decision Making
- Displaying parts of many-column tables
- Fashioning your data
PlanetMySQL Blog: Getting Hibernate and MySQL's "ON DUPLICATE KEY UPDATE" Feature to Play Nice Together...
MySQL has a handy feature, that allows you to turn an INSERT into an UPDATE if a unique or primary key duplication is detected:
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.
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.
Live Webinar: MySQL Consulting - Your Fast Track to Better Performance, Availability and Scalability
Tuesday, June 03, 2008 - 10:00am PST
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.
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.
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)
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)
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.
Monday, June 9 - 16:00 CET
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.
Wednesday, June 18, 2008 - 10:00am PST
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.