View the complete list of changes »
Download Now »
New Release of MySQL GUI Tools for 5.0 Release 17 (Windows)
We are pleased to announce a new maintenance release of the GUI Tools Bundle. This is a Windows-only release and contains a number of bug fixes. MySQL GUI Tools for 5.0 is a bundled package including MySQL GUI tools for the MySQL 4.1/5.0/5.1 server. It consists of the following products:
MySQL Administrator 1.2.17 GA
MySQL Query Browser 1.2.17 GA
MySQL Migration Toolkit 1.1.17 GA
and offers a complete set of graphical tools to configure, manage and work with the MySQL Server.
Read the Documentation »
Download Now »
New Release of MySQL Connector/Net 6.0 (Alpha)
MySQL Connector/Net 6.0.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment. We had three major goals with this release. Speed, Entity Framework support, and a better Visual Studio experience. I'm happy to report that we have met all three.
Download Now »
New Release of MySQL Connector/C++ 1.0.3 (Alpha)
A new version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.0.3alpha. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server. The 1.0.3alpha is a bug fix release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed.
View the complete list of changes »
Read the Documentation »
Download Now »
Hints & Tips
Article: How FriendFeed uses MySQL to store schema-less data
Bret Taylor
We use MySQL for storing all of the data in FriendFeed. Our database has grown a lot as our user base has grown. We now store over 250 million entries and a bunch of other data, from comments and "likes" to friend lists.
Read this Article »
Article: Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
Ernest Bonat, Ph.D
Error handling implementation in Windows database applications is a must for any Application Developer today. The main idea of error handling is to avoid application crashes by finding out the occurred errors and fixing them. Different programming languages have different ways of implementing error handling. Microsoft Visual Basic .NET (VB.NET) is the most common programming language for developing windows database applications today.
Read this Article »
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 about MySQL, including technical tips and best practices.
Visit PlanetMySQL »
Submit Your Blog Feed »
PlanetMySQL Blog: Reflections on MySQL Enterprise Monitor
Simon Mudd
Merlin is MySQL's Enterprise Monitor, a system designed to monitor a number of MySQL database servers and provide useful feedback to the DBAs as to how they are running and what things may require attention.
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: Database Sharding at Netlog, with MySQL and PHP
Jurriaan Persyn
This article accompanies the slides from a presentation on database sharding. Sharding is a technique used for horizontal scaling of databases we are using at Netlog. If you're interested in high performance, scalability, MySQL, php, caching, partitioning, Sphinx, federation or Netlog, read on ...
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: MySQL Magazine - Winter 2009 Released
Keith Murphy
This is one of the largest issues so far. In addition, it has some of the best content we have ever had. The articles are all in-depth with some exciting new information.
Read the PlanetMySQL BlogPost »
Read the MySQL Magazine Winter 2009 Issue »
PlanetMySQL Blog: MySQL University Needs You!
Martin 'MC' Brown
MySQL University keeps rolling along. We've had some fantastic sessions just recently (not including my own, of course!), such as Lenz's presentation of backing up MySQL with filesystem snapshots, Allan Packer's presentation on the optimization of MySQL and, going back a little further, David Van Couvering and Petr Pisl's talk on using PHP and MySQL within Netbeans.
We've got some good topics coming up, but we need more!!
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: How to Move Your Web Server With No Downtime
Jonathan Levin
How do you move your web servers to another location with no downtime? The answer: the magic of MySQL Master-Master Replication.
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: How To Set Up MySQL Database Replication On Fedora 10
Falko Timme
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: My Favorite New Feature of MySQL 5.1: Less InnoDB Locking
Harrison Fisk
MySQL 5.1 has a lot of nice new features, partitioning, event scheduler, dynamic logging, etc... Most of these require changing some application code or design logic to make use of them. However, there is a few new features that almost every user of InnoDB can take advantage of right away and that is the ability to set MySQL so that less locking is required for many statements in InnoDB. There are a few changes which make this possible.
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: Bencher - a benchmarking utility for MySQL Cluster
Johan Andersson
Bencher is a test program that allows you to benchmark requests on MySQL Cluster. I have used this utility for a lot of customers, because it lets me specify a simple query that I want to benchmark on the command line, implement more complex use cases, implement NDBAPI requests, and I don't have to reinvent the wheel every time.
Read the PlanetMySQL BlogPost »
PlanetMySQL Blog: Date handling in MySQL
Henrik Ingo
With dates, just as in many other cases, MySQL is very flexible in how you can input data. But one thing is that, between the multitudes of formats that are allowed, MySQL does not by default allow you to enter a non-existant date, e.g. "31st of February 2009". I know some other DB products allow that - they then store it as a correct date automatically (3rd of March 2009). This is mentioned at the end of the above manual page. It can be enabled with an SQL_MODE setting and I have attached a lengthy example about that separately below.
Read the PlanetMySQL BlogPost »
Spotlight: Database Migration to MySQL
Article: Migrating from Microsoft SQL Server or Access to MySQL
Mike Hillyer
One of the more common themes present on the various MySQL forums and mailing lists is that of data migration. Typically requests are made by users of Microsoft Access and Microsoft SQL Server who are looking to migrate their data (and client applications) to a MySQL database. Developers often ask for tools that can be used to convert an Access database to MySQL (or convert an Microsoft SQL database to MySQL), without realizing that there is more to migrating an application to MySQL than simply converting data.
Read the Article »
White Paper: A Practical Guide to Migrate from Oracle to MySQL
This paper provides insight into what is needed for considering a move from Oracle 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 the White Paper »
Presentation: Migrating from PostgreSQL to MySQL at Cocolog, Japan's Largest Blog Community
Naoto Yokoyama, Kenji Hirohama, Lisa Phillips, Garth Webb
In MySQL Conference & Expo 2008, NIFTY Corporation discussed their experiences with MySQL and how they changed the configuration in TypePad to meet the Japanese market's requirement, such as more availability, more cell phone support, and so on.
Migration from PostgreSQL to MySQL, administration, optimization, and maintenance are also covered. Through this session, the audience will recognize how to deal with scenarios when the number of servers grows quickly from six to three hundred, and also learn about real-life security and administration best practices.
View the Presentation »
PlanetMySQL Blog: Moving data from Microsoft SQL server to MySQL
Haidong Ji |
发表于 2009-3-19 09:37:58
发表于 2009-3-19 10:36:31