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

Dual-screen Android PoS device supports EMV

Poynt launched a portable, Android-based PoS device with 7- and 4.3-inch touchscreens, plus WiFi, BLE, 4G, NFC, and EMV, plus a printer and card scanner. Point-of-Sale (PoS) devices have increasingly gone portable, such as the Linux-based USAT ePort G10. Now a startup called Poynt, formed by former Google Wallet and PayPal executive Osama Bedier, has unveiled one of the most advanced — and coolest looking — mobile terminals yet with its Poynt Smart Terminal. The device features both merchant- and customer-facing touchscreens, both with higher resolution than typical PoS devices, and offers a wide variety of wireless and imaging payment technologies. Read more

today's howtos

Leftovers: Software

Leftovers: Gaming