Oracle Virtualization and Cloud Consulting
view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Getting rid of huge ibdata file, no dump required, part II

This post continues Getting rid of huge ibdata file, no dump required, part I, where I describe way of converting your single-tablespace InnoDB database into a file-per-table one, without the pain of exporting and importing everything at once.

In previous part we put aside the issue of foreign keys. We address this issue now.

Why I’m not an ACM member

I took a course on engineering ethics as part of my degree in computer science, and decided that it was very important for me to formally ascribe to a recognized code of conduct. This is not just a principle, but also an important legal matter in today’s litigious atmosphere. Court cases have literally been defended by engineers pointing to a code of ethics as their guidelines for actions and decisions.

MySQL 5.6 Replication – webinar replay

MySQL 5.6 Replication - Global Transaction IDs

Secure passwords being insecure

If you follow the general advices to create secure password the following ones seem to be secure, right?

  • s11P$||!sh&2
  • pr0&!!ke0
  • 3kj39|!381
  • The answer to the question is, “it depends on how you use them:)

    MySQL Cluster 7.1.22 is available for download

    The binary version for MySQL Cluster 7.1,21 has now been made available at https://www.mysql.com/downloads/cluster/7.1.html#downloads (GPL version) or

    Announcing Percona Server 5.1.63-13.4

    Percona is glad to announce the release of Percona Server 5.1.63-13.4 on May 24th, 2012 (Downloads are available from Percona Server 5.1.63-13.4 downloads and from the Percona Software Repositories).

    Webinar – Migrating to Percona XtraDB Cluster

    Whenever I learn about a new technology, I typically want to know the major administrative touch points more than I want to know exhaustive detail about every configuration option.  Give me the gist, show me enough to started, and give me a link to the manual.

    Binary log file size matters (sometimes)

    I used to think one should never look at max_binlog_size, however last year I had a couple of interesting cases which showed that sometimes it may be very important variable to tune properly. I meant to write about it earlier but never really had a chance to do it. I have it now!

    Percona Live MySQL Conference 2012 Prize Winners and Percona Live New York 2012

    I’m pleased to announce a variety of prize winners associated with the Percona Live MySQL Conference and Expo 2012. The following people won prizes in the pre-conference registration promotion:

    Kindle Fire Winners:

    Tatiana B., Etsy, United States
    Tom H., Cloudtree, United States
    Loren A., HearSayCorp, United States

    view counter