How to connect master/slave on mysql2

[remaluf-kueski]

I'm having troubles to connect my app with two differents servers with the same Schema using sharding.
I'm working with AWS aurora database with a master/slave on different servers

This is is config

Sequel.single_threaded = false

writer_conn = {
  "username" => "wr_user",
  "password" => "wr_password",
  "host" => "wr_host",
  "port" => 3306,
  "database" => "my_database",
  "adapter" => "mysql2"
}

reader_conn = {
  "username" => "read_user",
  "password" => "read_pass",
  "host" => "read_host",
  "port" => 3306,
  "database" => "my_database",
  "adapter" => "mysql2" 
}

DB =  Sequel.connect(writer_conn,
                                    max_connections: 30,
                                    connection_timeout: 5,
                                    servers: { read_only:  reader_conn })
                                    
DB.extensions :server_block
DB.extensios :arbitrary_servers                                

An I'm testing with the following code

DB.with_server(:read_only) do
  DB[:my_table].where(id: 'id').update(id: 'id')
end

# I'm also try wrapping the query with DB.synchronize do

 # => It might throw and error for read_only server but i got the following error instead: 
 
 #=> Mysql2::Error::ConnectionError: Access denied for user 'wr_user'@'read_host'

It looks like the only overwritten opts is the host. Because is trying to connect with my default connection to the read_only host

[jeremyevans]

Try using symbols instead of strings as keys, and using user instead of username

[remaluf-kueski]

It works! Thanks Jeremy