Made schema based MySQL2 adapter the default

Updated the MySQL2 adapter to use the schema based version by default
even when `use_schema` is disabled.

Using the connection based adapter is causing abandoned connections
with the current mysql2 gem.

NOTE: I also updated the specs to rspec3 style.