What are all the possible keys for database.yml

Question

I just found that reconnect: true configuration parameter is possible in database.yml file. What other configuration options are there? Is there a complete link for all parameters?

Known key examples:

 default: &default adapter: mysql2 encoding: utf8 pool: 5 username: foo password: bar reconnect: true socket: /var/sock/thing.sock development: <<: *default database: app_development 

Answer 1

I don't think there is any place that just lists them, but I checked ActiveRecord ConnectionAdapaters. Keep in mind that the parameters change the database you are using, but this was indicated in the MySQL connection adapter.

Options List for MySQL

 :host - Defaults to "localhost". :port - Defaults to 3306. :socket - Defaults to "/tmp/mysql.sock". :username - Defaults to "root" :password - Defaults to nothing. :database - The name of the database. No default, must be provided. :encoding - (Optional) Sets the client encoding by executing "SET NAMES <encoding>" after connection. :reconnect - Defaults to false (See MySQL documentation: http://dev.mysql.com/doc/refman/5.7/en/auto-reconnect.html). :strict - Defaults to true. Enable STRICT_ALL_TABLES. (See MySQL documentation: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html) :variables - (Optional) A hash session variables to send as SET @@SESSION.key = value on each database connection. Use the value +:default+ to set a variable to its DEFAULT value. (See MySQL documentation: http://dev.mysql.com/doc/refman/5.7/en/set-statement.html). :sslca - Necessary to use MySQL with an SSL connection. :sslkey - Necessary to use MySQL with an SSL connection. :sslcert - Necessary to use MySQL with an SSL connection. :sslcapath - Necessary to use MySQL with an SSL connection. :sslcipher - Necessary to use MySQL with an SSL connection. 

Github adapters for Rails ActiveRecord, https://github.com/rails/rails/tree/master/activerecord/lib/active_record/connection_adapters