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

Review: Simplicity Linux 15.4 alpha

Overall I give it 2 Thumbs Up on speed and layout of OS. If you have a computer with low resources, then this is an OS for you to try. Read more

Eurostat continues to share and use open source

Eurostat, the statistical office of the European Communities, continues to release as open source its ICT solutions. To date, Eurostat has shared 102 solutions on the European Commission’s Joinup platform. The statistical office has been using and sharing open source for more than a decade. Already in 2004 Eurostat’s ICT policy stipulated to consider open source software for all new projects. Read more

Excellent: Android Ecosystem is Low-Margin, Fragmenting

What the figures really show is that Apple is price-gouging its customers, extracting unreasonable levels of profit by virtue of its monopoly. In the world of Android, by contrast, the fierce competition that exists between fungible manufacturers has driven down profit margins to razor-thin levels. Open source, and the level playing field that it creates, is a great way for maximising the benefits to customers, rather than companies. Read more

Open source empowers Sintra health centre

Open source tools used by ACES Sintra include content management system Wordpress, combined with the usual LAMP stack: the MySQL database management system, the Apache web server, Linux for the server host and the PHP web development scripting language. The combination is used for the public website, but also for several internal Intranet project and team sites. The organisation implements Wiki websites, mainly for the IT department but also to maintain a list of frequently asked questions and their answers. Read more