![]() # This will be passed to all mysql clients # -print-defaults to see which it would actually understand and use. # Run program with -help to get a list of available options and with # One can use all long options that the program supports. # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, # The MySQL database server configuration file. On master server, /etc/mysql/my.cnf contains: # MySQL version is 5.5.31 on every machine, for both client and server software. ![]() +-+Ĭ is a rented VPS on its own instead maps the IP to my home modem. | +->| MySQL-client can reach master from here | | | | +->| MySQL-client can reach master from here | | | | | +-+ | +-+ | | MySQL-client cannot reach master from here | | | MySQL master |->| NAT |-+->| OpenVZ |-+->| MySQL slave host | | ![]() The same exact command executed from two other generic machines works OK and successfully connects to the master DB. The replication itself works flawlessly, but the problem is that a mysql-client launched from the "slave" machine cannot connect to the master: mysql -h -u hwcharts -pvery-long-pass hwchartsĮRROR 2003 (HY000): Can't connect to MySQL server on '' (111) A MySQL server is located at it is the master of a basic master-slave replication which replicates toward, located on a different physical machine which virtualizes (OpenVZ) the VM where the slave runs in.
0 Comments
Leave a Reply. |