September 1, 2014

Development plans

We gathered together our ideas of MySQL improvements on this page http://www.percona.com/percona-lab/dev-plan.html
and we are going to implement some of them.
My favorite one is – make InnoDB files .ibd (one created with –innodb-file-per-table=1) movable from one server to another, however it is sort of challenging.
Probably next one patch we want to integrate is Google’s smp-fix or Yasufumi’s rw-locks (we are going to test both before)

On this page http://www.percona.com/percona-lab.html you can find links to our current binaries and patches.

About Vadim Tkachenko

Vadim leads Percona's development group, which produces Percona Clould Tools, the Percona Server, Percona XraDB Cluster and Percona XtraBackup. He is an expert in solid-state storage, and has helped many hardware and software providers succeed in the MySQL market.

Comments

  1. Actually we’re really needing the ability to move InnoDB tables too…

    We wrote our own partitioning code in our distributed DB land… it supports shards and partitions (on partition per day).

    The problem is when we need to bring up a new DB server in a shard. We need to copy all the previous partitions.

    They’re immutable so we should be able to copy them from a currently running version of InnoDB to another box.

    It might be possible to do this for a DB server which was an original clone for the current server but I need to test it. I’m not sure what happens when InnoDB has been running for a while.

    We actually migrated BACK to MyISAM (ug) because of this feature. (that and we saved 2x on disk space)

    Kevin

  2. Adam says:

    Personally I think this is awesome addition, and could be integrated into your set of patches as well:

    http://jcole.us/blog/archives/2007/02/08/progress-in-mysql-process-list/

  3. Vadim says:

    Adam,

    We played with progress in processlist, but often it shows misleading information, so we decided to not include it yet.

  4. Nils says:

    I’m currently trying out the new Ebay Heap Engine, I’ve managed to get the patch to work with 5.0.68, few rejects which I think I fixed. I’m by far no expert, so next step would be to check the changes between the original patched version and the new version to see what exactly caused the rejects, doesn’t seem to be a big deal though.

    Maybe you can write something about the actual process of creating a customized MySQL (is there something like that already out?) while you’re at it ;)

  5. Vadim says:

    Nils,

    That would be interesting to test.
    Before including in release we need to check if there is no stability and performance problems.

    About process – yeah, I have such idea, will try to write :)

Speak Your Mind

*