Special Edition: MySQL on Windows
This is a special edition of the MySQL Newsletter. In addition to the regular MySQL Monthly Newsletter, a MySQL Newsletter Special Edition is issued each quarter that highlights technical information on topics most relevant to MySQL DBAs and developers. This edition is focused on developing and using MySQL on Microsoft Windows, the number one development platform for MySQL.
Highlights
- Event: MySQL Community Reception - Santa Clara, California (April 13)
- Event: Oracle OpenWorld 2011 - Register by April 1 to save $700
- Event: MySQL on Windows Online Forum
- Seminar: Improve Performance and Scalability with the Latest from MySQL - EMEA (May 10, 12 & 19)
- Press Release: Oracle Enhances MySQL Enterprise Edition
- MySQL TCO Savings Calculator
- Live Webinar: What's New in Managing MySQL Cluster - German (April 6)
- Live Webinar: MySQL Relational Database Management - EMEA (April 7)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Chinese (April 22)
White Papers
- MySQL on Windows, Why, Where and How
- A Guide to Securing MySQL on Windows
- A Practical Guide to Migrating From Microsoft SQL Server to MySQL
- A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL
- MySQL Workbench: A Data Modeling Guide for Developers and DBAs
Blog Posts
- MySQL Workbench: Manage MySQL on Windows Servers the Windows Way
- MySQL 5.5: InnoDB Performance Improvements on Windows
- MySQL Connector/C++: Guide on building a Windows client using Visual Studio
- Download, install, configure, run and test MySQL Cluster in under 15 minutes
- Running MySQL Cluster over multiple Windows servers
On Demand Webinars
- Why and How LiveTime Software Provides Microsoft SQL Server to MySQL Migration for its Customers
- Running MySQL Embedded Server Securely on Windows
- TechCast Live: MySQL 5.5 Does Windows
Case Studies
- SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database
- Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator
- CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
MySQL Training and Consulting
- Training: New MySQL Training Course - Introduction to MySQL 5.5
- Training: MySQL for Database Administrators Course Now Available with Self-Study CD
- Training: Sharpen your MySQL Skills on Windows
- Consulting: MySQL Consulting Services
-------------------------------------------------------------------
Highlights
Event: MySQL Community Reception - Santa Clara, California
April 13, 2011 - 6:00PM PT
Join the MySQL Team on April 13, 2011, as we celebrate the health and growth of the MySQL community. Whether you are a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in the MySQL technology, you're all invited to Oracle's MySQL Community Reception.
RSVP for the MySQL Community Reception:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=131495&src=7011089&src=7011089&Act=10
Event: Oracle OpenWorld 2011 - Register by April 1 to save $700
Oracle OpenWorld 2011 will be held October 2-6, 2011 at the Moscone Center in San Francisco. This year Oracle again welcomes the MySQL community and has added a dedicated MySQL track, in addition to a number of user group activities on Sunday, October 2. Register now for Super Saver pricing and get $700 off the OpenWorld registration!
Learn More:
http://www.oracle.com/us/openworld/registration-173440.html
Event: MySQL on Windows Online Forum
Would you like to reduce your database TCO on Microsoft Windows by up to 90% while increasing manageability and flexibility? Did you know that Windows is the #1 MySQL development platform? Join us for the "MySQL on Windows Online Forum" and discover how you can win with MySQL on Windows!
Register for the On-Demand Webinar "MySQL on Windows: It Just Keeps Getting Better!":
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-620.html
Register for the On-Demand Webinar "Modeling to Performance Tuning: MySQL Visual Tools for Developers & DBAs":
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-621.html
Register for the On-Demand Webinar "Implementing MySQL High Availability Solutions on Windows":
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-622.html
Register for the On-Demand Webinar "Customer Story: SonicWall":
http://www.mysql.com/news-and-events/on-demand-webinars/display-od-623.html
Seminar: Improve Performance and Scalability with the Latest from MySQL - EMEA
May 10, 12 & 19
With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. Various MySQL reference architectures for highly scalable web infrastructures will also be presented in the seminar.
Register for the Seminar in Berlin, Germany, on May 10:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=131061&src=7011252&src=7011252&Act=147
Register for the Seminar in Munich, Germany, on May 12:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=131062&src=7011252&src=7011252&Act=148
Register for the Seminar in Rome, Italy, on May 19:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=132241&src=7011252&src=7011252&Act=183
Press Release: Oracle Enhances MySQL Enterprise Edition
MySQL Enterprise Edition is a comprehensive subscription offering that includes MySQL Database plus monitoring, backup and design tools, with 24x7, worldwide customer support. Recent integration with MyOracle Support allows MySQL customers to access the same support infrastructure used for Oracle Database customers. Joint MySQL and Oracle customers can experience faster problem resolution by using a common technical support interface.
Read the Press Release:
http://www.oracle.com/us/corporate/press/339030
Try the MySQL Enterprise Edition:
http://www.mysql.com/trials/
MySQL TCO Savings Calculator
Do you know that you can save up to 90% on database TCO using MySQL compared to Microsoft SQL Server? Customize the TCO Savings Calculator with your system configuration and see the difference for yourself!
Customize the TCO Savings Calculator Now:
http://www.mysql.com/tcosavings/
Live Webinar: What's New in Managing MySQL Cluster - German
Wednesday, April 6, 2011 - 15:00 CET
In this webinar, we will present an overview of the three latest enhancements to provisioning, monitoring and managing MySQL Cluster - collectively serving to lower costs, enhance agility and reduce the risk of downtime caused by manual configuration errors.
Register for this German Webinar:
http://www.mysql.com/news-and-events/web-seminars/display-618.html
Live Webinar: MySQL Relational Database Management - EMEA
Thursday, April 7, 2011 - 12:15PM CET
In this Webinar, Angeliki Korovesi will give you a brief introduction to MySQL and its contribution to the open source community. She will discuss the different features and services of MySQL and explain the importance of MySQL, as well as how it can be used. Join us for an hour-long introduction into Architecture, Management, High Availability, Backup and Recovery and other things you should know about MySQL.
This series of free 1-hour lunchtime webinars is brought to you courtesy of Oracle University.
Register for this Webinar:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=132300&src=7026556&src=7026556&Act=111
Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Chinese
Friday, April 22, 2011 - 14:00 China Time
Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have the tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.
Register for this Chinese Webinar:
http://www.mysql.com/news-and-events/web-seminars/display-619.html
-------------------------------------------------------------------
White Papers
MySQL on Windows, Why, Where and How
Why is the world's most popular open source database so popular on Windows? What are the applications for which one should consider MySQL on Microsoft's platform? How should Windows shops relying on Microsoft databases get going with MySQL? Those are the questions we aim to answer in this guide.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_on_windows_wwh.php
A Guide to Securing MySQL on Windows
This guide recaps some of the best practices for securing MySQL on Windows, and walk you through understanding the MySQL security model, post-installation, as well as securing user accounts and replication.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_securing_windows.php
ISVs and OEMs, Read the White Paper "A Guide to Securing MySQL as an Embedded Database on Windows":
http://mysql.com/why-mysql/white-papers/wp_oem_SecureMySQLOnWindows.php
A Practical Guide to Migrating From Microsoft SQL Server to MySQL
This paper provides insight into what is needed for considering a move from SQL Server to MySQL, and presents a number of options that help make the transition easy. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a manager or a seasoned DBA, you will find the needed answers to questions that revolve around migrating to the world's most popular open source database - MySQL.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysql.php
ISVs and OEMs, Read the White Paper "A Guide to Migrating Your Products from Microsoft SQL Server to MySQL Embedded":
http://www.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysqlembedded.php
A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL
In this paper we will visually show you how to connect MySQL into some of the existing tools that the SQL Server DBA will already be familiar with. Specifically in this paper we will look at how configure connectivity to MySQL with your existing reporting infrastructure based on SQL Server 2008 Reporting Services.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_MSReporting_Services.php
MySQL Workbench: A Data Modeling Guide for Developers and DBAs
This paper looks at various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php
View the MySQL Workbench Demos:
http://www.mysql.com/products/workbench/demo.html
-------------------------------------------------------------------
Blog Posts
MySQL Workbench: Manage MySQL on Windows Servers the Windows Way
Mike Lischke
The MySQL team has been continuously improving its products on the Windows platform. Along this line, we've responded to a request from our users of Workbench on Windows - to provide remote access to Windows Servers using Windows management methods - as an alternative to SSH.
Read this Blog Post:
http://wb.mysql.com/?p=892
MySQL 5.5: InnoDB Performance Improvements on Windows
Calvin Sun
At MySQL, we know our users want Performance, Scalability, Reliability, and Availability, regardless of the platform they choose to deploy. We have always had excellent benchmarks on Linux, and with MySQL 5.5, we are also working hard on improving performance on Windows.
Read this Blog Post:
http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-performance-improvements-on-windows/
Download MySQL 5.5 GA Release Now:
http://www.mysql.com/downloads/mysql/
MySQL Connector/C++: Guide on building a Windows client using Visual Studio
Ulf Wendel
This is a tutorial on how to compile a command line client using the MySQL Driver for C++ with Visual Studio.
Read this Blog Post:
http://blog.ulf-wendel.de/?p=215
Download, install, configure, run and test MySQL Cluster in under 15 minutes
Andrew Morgan
A series of quick-start guides are now available to get you up and running with MySQL Cluster in as little time as possible. They are available for LINUX/Mac OS X, Windows and Solaris.
Read this Blog Post:
http://www.clusterdb.com/mysql/download-install-configure-run-and-test-mysql-cluster-in-under-15-minutes/
Running MySQL Cluster over multiple Windows servers
Andrew Morgan
Following from the earlier article on running MySQL Cluster on a single Windows host, this one looks at installing and running over multiple Windows machines.
Read this Blog Post:
http://www.clusterdb.com/mysql-cluster/running-mysql-cluster-over-multiple-servers/
-------------------------------------------------------------------
On Demand Webinars
Why and How LiveTime Software Provides Microsoft SQL Server to MySQL Migration for its Customers
LiveTime has been providing ITIL Service Management and Help Desk products to global 2000 companies for more than 8 years and has recently witnessed significant interest from customers in migrating from SQL Server to MySQL. In this webinar you will learn why LiveTime decided to offer a free migration service for its customers as well as optimizations and performance characteristics.
Download this On-Demand Webinar (the Webex player is required to playback the recording):
http://mysql.com/news-and-events/on-demand-webinars/display-od-466.html
Running MySQL Embedded Database Securely on Windows
In this technical webinar, we will show you how to install and configure MySQL Embedded Database to run securely on Windows. Windows is the most popular platform for MySQL ISV and OEM customers, making Windows security an especially relevant and important topic.
View this On-Demand Webinar:
http://mysql.com/news-and-events/on-demand-webinars/display-od-546.html
TechCast Live: MySQL 5.5 Does Windows
Did you know that Windows is the #1 development platform for MySQL? Product Manager Mike Frank explains why, and also tells us why MySQL 5.5 offers the best performance on Windows yet.
Watch this Webcast:
http://medianetwork.oracle.com/media/show/16147
-------------------------------------------------------------------
Case Studies
SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database
SonicWALL started using MySQL 5.0 in July 2008 and within just six months of using MySQL, SonicWALL was able to: Lower their cost of goods sold (COGS); Shorten new product time-to-market through the efficiencies they gained in Development, Quality Assurance, Training, and Documentation; and, Reduce the number of trouble tickets they received by over 20%, in addition to other gains.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_sonicwall.php
Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator
The Bank of Finland acts as Finland's central bank, national monetary authority, and member of the European System of Central Banks and the Eurosystem. The BoF developed a MySQL based versatile Payment and Settlement System Simulator for making payments and settlement system simulations. Running on Windows, the application has been widely adopted by Central Bank Economists Worldwide.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_bankoffinland.php
CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Database, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php
-------------------------------------------------------------------
MySQL Training and Certification
Training: New MySQL Training Course - Introduction to MySQL 5.5
This one-day seminar covers all the new features and other key enhancements to MySQL 5.5 and the MySQL Enterprise Edition, including Performance, Scalability, Availability and Backups. Instructor lecture is supported by live demos as necessary. By attending this course, you learn how to plan your use of the MySQL 5.5 product release more effectively.
Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D71615GC10
Training: MySQL for Database Administrators Course Now Available with Self-Study CD
The MySQL for Database Administrators course is the foundation course for database administrators and developers who want to use this powerful database. In this course you will learn how to secure users privileges, set resource limitations, and access controls. Now with the self-study CD where lessons are presented using the latest multimedia and instructional design methods, you can enjoy the flexibility to learn anytime, anywhere at your convenience.
Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D71901
Training: Sharpen your MySQL Skills on Windows
Wondering how to run MySQL on Windows? Take our training courses to find out. Oracle University offers MySQL training courses tailored for different needs, so no matter you're a beginner or an experienced user, a DBA or a developer, you can find a course that meets your training goal.
Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=402&p_nl=JMSQ
Consulting: MySQL Consulting Services
MySQL Consulting can help you deliver better results from IT investments - increasing operational efficiencies, driving down costs, and securing vital data. Whether you are starting a new project or need to optimize an existing MySQL application, our MySQL consultants will provide you with the knowledge, tools, and expertise to get your project going in the right direction.
Learn More:
http://www.mysql.com/consulting
-------------------------------------------------------------------
Want to receive the latest MySQL updates and interact with the MySQL Community?
Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/
Join MySQL on Facebook:
http://www.facebook.com/mysql
Follow MySQL on Twitter:
http://twitter.com/mysql
-------------------------------------------------------------------
About the Newsletter
You can send us queries and give us feedback online.
http://www.mysql.com/contact/?topic=newsletter
You can unsubscribe from this newsletter online:
http://www.mysql.com/unsub?email=johandontmessup@gmail.com
--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.
NEW Pulse 2011 Content Portal
