MySQL Newsletter October 2008
Articles in this newsletter:
- MySQL European Customer Conference 2008 - Paris
- MySQL Conference & Expo 2009 - Last Chance to Submit a Proposal
- MySQL University - Training on MySQL Development & Internals
- White Paper: Web 2.0 Lessons for Communications Service Providers
- Live Webinar: Using Microsoft ADO.NET Entity Framework with MySQL
- Case Study: KACE Deliver Mission-Critical Systems Management Solution
- Sun Startup Essentials - Get Your Startup off the Ground Fast
- Documentation: Browsing the MySQL Documentation by Topic
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Online Backup - Encryption
- PlanetMySQL Blog: A Bunch of Great Strategies for Using Memcached and MySQL Better Together
- PlanetMySQL Blog: MySQL Multi-Master - Single-Slave - Replication
- PlanetMySQL Blog: Success with OpenSolaris + ZFS + MySQL in production!
- PlanetMySQL Blog: Been too long in coming, more MySQL SSD benchmarks!
- PlanetMySQL Blog: Test application for MySQL High Availability (HA) Set-up
- PlanetMySQL Blog: Upgrade from MySQL Cluster 6.2 to 6.3
- PlanetMySQL Blog: Preparing for Open SQL Camp
- Live Webinar: Better Performance, Development, and Installation with MySQL Embedded Server (October 21)
- Live Webinar: Troubleshooting Performance Issues and Managing Backup/Recovery with MySQL Enterprise and Zmanda Recovery Manager (November 19)
Paris, November 19
A day packed with technical sessions, customer experiences and all round MySQL goodness! You will be able to learn, improve your skills and network with other MySQL users.
Whatever your experience with MySQL, the MySQL conference will help you can get the most out of MySQL technology, and from the company now behind it, Sun Microsystems.
Don't miss this once a year opportunity!
Register Now » (http://www.mysql.fr/news-and-events/european-conferences/2008/)
The MySQL Conference & Expo 2009, April 20-23, 2009 in Santa Clara, CA, brings over 2,000 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 next MySQL Conference & Expo.
MySQL University is a no cost training program for Sun Database Group Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are run via voice stream and IRC feedback channel and usually last for one hour. Topics include MySQL Optimizer, Using Memcached with MySQL, Low-level locking in mysqld and InnoDB and much more.
In this two part whitepaper we compare the approaches and attitudes of the Web 2.0 industry and the Communications industry, as well as outline the changes that the Communications Service Providers and Telecom Equipment Manufacturers must embrace if they want to stay competitive and relevant in the new converged marketplace.
Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_web20fortelco.php)
Tuesday, November 4, 2008 - 10:00am PST
In this new web seminar you'll learn about the new Entity Framework and how you can access these and other benefits with MySQL:
- Develop your application against SQL Server and then switch it to MySQL with zero code changes
- Optimize your database schema without requiring any code changes in your application
- Use LinQ syntax for type safety in your applications
KACE is the leading systems management appliance company whose award-winning KBOX family of appliances provide PC and Server Lifecycle Management for mid-sized organizations. KACE uses MySQL in all of its appliances to provide the same ease-of-use, comprehensive capabilities, and low cost that its customers rely on their KBOX products to deliver.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/kace-relies-on-mysql-to-deliver-management-solution/)
Sun Startup Essentials is an exclusive program designed to help startups get their business off the ground. If your company has been in business less than 6 years and has fewer than 150 employees, we can offer you the following benefits:
- VC Connect, which gives you the opportunity to connect with interested investors
- Deeply discounted servers certified for Linux, Windows, and Solaris OS
- No cost technical advice on hardware and OS from Sun engineers
- No cost web-based training on Solaris OS and GlassFish application server
- Special pricing on MySQL Enterprise Gold and MySQL Enterprise Unlimited
Thanks again for the input and contributions we received since the last alpha build. We have incorporated fixes for building on other distros, cleaned up the source code and prepared a Ubuntu-repository for easy installing via apt package management. Note that we currently only offer i386 binary packages, if you need a package for some other architecture, please build it from sources.
On the MySQL documentation team, we've been discussing how to split it into easier to digest portions. But a real split doesn't seem the best thing to do, so we've decided to make use of our Arbitrary Docs System that allows to create arbitrarily compiled documents from the MySQL Manual. That system, called Arby for short, was written by MC Brown, and creates "dynamic" excerpts from our documentation sources, rather than static copies, thus those excerpts are always as up to date as the complete Manual.
On the MySQL Documentation Library page we've added a table with documents that serve the information needs of specific target groups, such as database administrators or developers.
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.
A new addition inside the new "MySQL Online Backup" feature is encryption. Australian Senior Software Engineer Stewart Smith has already mentioned it a few months ago in his blog. There's a preview that you can download on the online backup pages. Probably it will be part of MySQL-6.0 source downloads soon. I've extract some paragraphs from what I wrote in a non-public worklog task, WL#4271.
MySQL hosted two excellent webinars (referenced below) on the subject of how to deploy and use memcached. The star of the show, other than MySQL of course, is Farhan Mashraqi of Fotolog.
One of the features that make MySQL so great is its easy replication set-up. If you are experienced and know-how to do it, it takes you about 15 minutes to set-up a slave. From time to time some customers are asking for the other way: Many masters replicating to one slave (which is also called multi-source replication).
There's remarkably little information online about using MySQL on ZFS, successfully or not, so I did what any enterprising geek would do: Built a box, threw some data on it, and tossed it into production to see if it would sink or swim.
I presented these at an internal MySQL professional services meeting about a month ago - its mostly a hodge podge of various benchmarks - but enjoy! The big difference in these benchmarks vs the other benchmarks is I am testing on the memoright GT drive, which is supposed to be one of the fastest SLC drives out their currently. Lets get right too it.
When I set-up a MySQL HA environment for customers I usually do some final fail over tests after configuring the whole beast. To check if the application behaves like expected I always run my little test application (test.sh) from the server(s) where the customers application runs. It displays "graphically" how the application behaves and you can show to the customer immediately what is going on...
Is it possible to upgrade from MySQL Cluster 6.2 to MySQL Cluster 6.3? Of course! Can it be done online? Sure! Here is how!
The Open SQL Camp will take place in Charlottesville, VA, USA, on November 14, 15, and 16. Attendees are requested to register in the event's Wiki, and if you are interested in presenting something, there is a mailing list to discuss your intended topics.
Tuesday, October 21, 2008 - 10:00am PST
In this technical webinar you will learn how to shorten your commercial application's development time, improve its performance, and eliminate the need for any customer database installations with MySQL Embedded Server.
We will cover the following topics:
- Cross-platform development for Windows, Linux, Solaris, and Mac
- Integration with Java, .Net, and other languages
- Choosing a MySQL storage engine
- Silently installing the MySQL server and clients with your application
- Designing and modeling a database using MySQL Workbench
Live Webinar: Troubleshooting Performance Issues and Managing Backup/Recovery with MySQL Enterprise and Zmanda Recovery Manager
Wednesday, November 19, 2008 - 10:00 am PST
Are you experiencing pain points around diagnosing and fixing performance problems related to poorly performing SQL code? Do you have a data backup and recovery plan that ensures data availability and integrity in case of accidental data loss or destruction?
Join Rob Young, Senior MySQL Enterprise Product Manager and TK Krishnamurthy, Vice President, Services, Support and Operations from Zmanda as they discuss the benefits of using MySQL Enterprise - including the new Query Analyzer - and backup/recovery with Zmanda Recovery Manager for MySQL to keep your MySQL systems high performing and safeguarded.
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)
Paris, Cupertino, London, Singapore
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)
Tuesday, October 28, 2008 - 11:00am PST
This webinar session is designed to help IBM i application developers learn:
- How the DB2R Storage Engine for MySQL opens data to RPG and DB2 Web Query.
- How to bring information from your IBM i applications to the web with PHP.
- To deploy open source applications on i with PHP and MySQL.
- To leverage open source applications while simplifying data management.
To Register, click on the "Enroll Now" for "IBM Power of i Webcast Series". Select the second series called "The Power of Open Development Tools and Applications"