Search code examples
mysqlruby-on-railsrubyruby-on-rails-3percona

Is Percona backwards compatible with MySQL? The Ruby on Rails Case

I'm starting a Ruby on Rails project and I'm interested in using Percona as my DBMS. I've read that Percona is fully compatible with MySQL tooling

I wonder if I can use Ruby on Rails tooling with Percona (using the MySQL support)?

Solution

  • As long as you have the mysql client libraries you should be able to build the mysql gem which is the interface rails (through active record) uses to interact with mysql.

    You may have to pass the percona mysql_config when building the gem like so:

    gem install mysql -- --with-mysql-config=/usr/local/percona-xtradb/bin/mysql_config

    If you are using the mysql2 gem you "shouldn't" need to do this (I think)