Language Selection

English French German Italian Portuguese Spanish

Tips for tackling MySQL 5.0

Filed under
HowTos

Testing, testing, testing. IT pros have been checking out the new MySQL 5.0 open source database since its recent release its commercial parent, MySQL AB. Some of those IT pros put our resident MySQL expert, Mike Hillyer, to the test, too. In this tip, he answers users' questions about the ins and outs of choosing, testing and using MySQL 5.0, an open source relational database management system.

Wondering why Hillyer is our go-to guy for MySQL? Well, he holds the MySQL Professional Certification and is the top ranked MySQL expert at Experts-Exchange.com. He's also the webmaster of VBMySQL.com, a site for Windows users of MySQL, and and works on the MySQL AB documentation team.

Can you offer some step-by-step and "watch out!" tips for evaluating MySQL 5.0?

Mike Hillyer: I would recommend installing MySQL 5.0 on a separate machine and trying it with your existing applications. Run as many tests as you can and see if everything runs smoothly. If you do not encounter any errors you, then you can bring MySQL 5.0 into your production systems.

There really should not be things to watch out for, in the sense of bugs or incompatibilities, but you can always watch the change logs and look for entries that are marked "Incompatible Change."

What hardware would be best for evaluating MySQL 5.0?

Full Story.

More in Tux Machines

The Internet Without Connection, Free Endless OS For Emerging Markets

There are four billion people on the planet without PCs or access to affordable personal computers. That figure should surely be tempered with some contextualization i.e. not everybody actually wants to have an Internet connection and many traditional, native or bucolic ways of live do still exist on the planet. Regardless, there are a batch of global initiatives in existence which seek to give computer access to every man, woman and especially child. Endless OS is one such project. The free operating system has been designed explicitly to work in the expensive or restrictive Internet data conditions that often exist in emerging markets where fabulously affordable broadband has yet to arrive. The software itself is built to provide useful information and educational content, with or without an Internet connection. Read more