Archive

Posts Tagged ‘Java & MySql’

MySql Installation & Configuration

September 1, 2009 1 comment

 

 

At the time of this post, the current release is MySQL 5.1 – Generally Available (GA) release for production use and is the recommended version, though MySQL 5.4 is available to download as Beta release. When preparing to use MySQL, you should decide the version to go ahead with. After deciding which version to install, you can choose a distribution format. Releases are available in binary or source format.

The first decision to make is whether you want to use a production (stable) release or a development release.

  • MySQL 5.4 is the current development release series.
  • MySQL 5.1 is the current General Availability (Production) release series. New releases are issued for bugfixes only; no new features are being added that could affect stability.
  • MySQL 5.0 is the previous stable (production-quality) release series.
  • MySQL 4.1, 4.0, and 3.23 are old stable (production-quality) release series. MySQL 4.1 is now at the end of the product lifecycle. Active development and support for these versions has ended.

If you are beginning to use MySQL for the first time or trying to port it to some system for which there is no binary distribution, go with the General Availability release series. Currently, this is MySQL 5.1.

After choosing which version of MySQL to install, you should decide whether to use a binary distribution, or a source distribution. In most cases, you should probably use a binary distribution.

Binary distributions contain a setup program that installs everything you need so that you can start the server im-mediately. Another binary distribution format contains an archive that you simply unpack in the installation location and then con-figure yourself. The source distribution contains all the code and support files for building the executables using the Visual Studio compiler system.

New MySQL users can use the Binary distributions (which contains the MySQL Installation Wizard and MySQL Configuration Wizard) to install MySQL. These are designed to install and configure MySQL in such a way that new users can immediately get started using MySQL.

 

 

Pre-Requisites:

Please note that not all platforms are equally suitable for running MySQL, and that not all platforms on which MySQL is known to run are officially supported by Sun Microsystems, Inc. AIX 4.x / 5.x, FreeBSD 5.x, HP-UX 11.x, Linux, Mac OS X, Solaris 2.8, Windows 2000, Windows XP, Windows Vista, Windows Server 2003, and Windows Server 2008 are the platforms supported.

 

  

Download Instructions: Read more…

MySQL Tips for Java Developers With Mark Matthews.

  

MySQL Server is available as free software under the GNU General Public License (GPL). Its most often the first choice for small scale projects. Even established free software projects which require a full-featured database management system use MySql, such as WordPress, hence establishing the reliability of the server.

Lot of us here have our share of experiences with Java & MySql. Database transactions are always the most expensive processes (in terms of resource consumption) in any industry application. Its beneficial to dish out tips and tricks about database connectivity for any java developer. The following interview throws some more light on this significant subject. Read more…