[Sqlgrey-users] Configuration check and db_dsn

[Alex <mys...@gm...>]

Hi guys,

I've just rebuilt my sqlgrey setup on three fedora systems, and hoped
someone could help me verify I've done it correctly. I've set it up to
use mariadb replication with one master server (also a slave) and two
separate slaves. The database is successfully being syncd with the two
slave systems.

I'd like to have it configured such that each slave writes only to the master.

I tried specifying db_host to be the name of the master server, but it
never seemed to connect to it. It was only after configuring db_dsn
explicitly did it appear to connect properly, according to the mariadb
general query log.

Is there any way to have sqlgrey explicitly record the name of the
host to which it's writing for every update?

Below is the config from one of the slaves. Can I ask you to check to
make sure it's configured the way it should be, given my description
above?

loglevel = 3
log_override = whitelist:1,grey:3,spam:2
reconnect_delay = 5
awl_age = 31
group_domain_level = 10
db_type = mysql
db_name = sqlgrey
db_host = ns1.example.com;mysql_connect_timeout=1
db_port = default
db_user = sqlgrey
db_pass = mypass
db_cleanup_hostname=ns1.example.com
db_dsn = DBI:mysql:database=sqlgrey;host=ns1.example.com;port=3306
db_cleandelay = 1800
clean_method = sync
db_cluster = off
read_hosts=ns1.example.com
prepend = 1

Thanks,
Alex