Percona Toolkit version : percona-toolkit-3.2.0-1.el7.x86_64
MySQL version : Percona-Server-server-57-5.7.40-43.1.el7.x86_64
I have noticed that the --dry-run won’t show you the replica detection part(not sure if it is a bug in this version). I have created dsns table and added entries for the replicas.
I am facing another issue now, I can see that the tool has found 2 slaves but it won’t proceed ahead and gives another error :
I checked the source code and I see :
- For Perl, I have the following message from the Master Server : Package perl-DBD-MySQL-4.023-6.el7.x86_64 already installed and latest version
- For Character Set I have the following in the database :
utf8 UTF-8 Unicode utf8_general_ci 3 - Connection string does have Host, Database and Port :
pt-online-schema-change --alter “ADD COLUMN sample decimal(18,9) NOT NULL DEFAULT ‘0.000000000’” \
–alter-foreign-keys-method=auto
D=avon,t=excel
–host=va-db-replica-015
–port=3306
–max-load=Threads_running=30
–check-slave-lag=50
–recursion-method=dsn=D=avon,t=dsns
–max-lag=50
–critical-load=Threads_running=50
–chunk-size=10000
–progress percentage,1
–execute
–user=ptosc
–password=‘xxxxx’
- User does have required privileges.
Still not sure why am I getting this : Cannot connect to MySQL: DBI connect(‘;host=50;port=3306;mysql_read_default_group=client’,‘ptosc’,…) failed: Can’t connect to MySQL server on ‘50’ (110) at /bin/pt-online-schema-change line 2345.
Show full processlist from the Master does show the replica :
9 repl 10.xx.xx.x:47654 Binlog Dump 13738 Master has sent all binlog to slave; waiting for more updates 13737974 0 0
Show slave hosts does shows the replica:
121 va-db-staging-002@xxx 3306 577 bf3ab07b-a2f1-11ef-8145-002590fdeb10
Can someone please help in debugging this please? How do I fix this : Cannot connect to MySQL: DBI connect(‘;host=50;port=3306;mysql_read_default_group=client’,‘ptosc’,…) failed: Can’t connect to MySQL server on ‘50’ (110) at /bin/pt-online-schema-change line 2345.
Thank you in advance.