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

Red Hat News

OSS: Blockchain, Innersource, SQL and Clang

  • Banks are turning to open source for blockchain, says Google engineer
    Banks have historically developed all software in-house and maintained a fierce secrecy around their code, but more recently they’ve embraced open-source. They’re likely to use open source for one of the most hotly tipped technologies out there – blockchain.
  • Innersource: How to leverage open source in the enterprise
    Companies of varying sizes across many industries are implementing innersource programs to drive greater levels of development collaboration and reuse. They ultimately seek to increase innovation; reduce time to market; grow, retain, and attract talent; and of course, delight their customers. In this article, I'll introduce innersource and some of its key facets and examine some of the problems that it can help solve. I'll also discuss some components of an innersource program, including metrics.
  • Reflection on trip to Kiel
    On Sunday, I flew home from my trip to Kiel, Germany. I was there for the Kieler Open Source und LinuxTage, September 15 and 16. It was a great conference! I wanted to share a few details while they are still fresh in my mind: I gave a plenary keynote presentation about FreeDOS! I'll admit I was a little concerned that people wouldn't find "DOS" an interesting topic in 2017, but everyone was really engaged. I got a lot of questions—so many that we had to wrap up before I could answer all the questions.
  • A quick tour of MySQL 8.0 roles
    This year at the Percona Live Open Source Database Conference in Dublin, I'll be discussing a new feature introduced in MySQL 8.0: roles. This is a new security and administrative feature that allows database administrators to simplify user management and increases the security of multi-user environments. In database administration, users are granted privileges to access schemas, tables, or columns, depending on the business needs. When many different users require authorization for different sets of privileges, administrators have to repeat the process of granting privileges several times. This is both tedious and error-prone. Using roles, administrators can define sets of privileges for a user category, and then the user authorization becomes a single statement operation. Roles have been on the MySQL community's wish list for a long time. I remember several third-party solutions that tried to implement roles as a hack on top of the existing privileges granting system. I created my own solution many years ago when I had to administer a large set of users with different levels of access. Since then, anytime a new project promised to ease the roles problem, I gave it a try. None of them truly delivered a secure solution, until now.
  • MyDiamo Expands Open Source Database Encryption Offerings to Include PostgreSQL
  • Clang-Refactor Tool Lands In Clang Codebase
    The clang-refactor tool is now living within the LLVM Clang SVN/Git codebase.

Games: Ostriv, Back to Bed, EVERSPACE, Hiveswap: Act 1

Openwashing and Microsoft FUD