![]() ![]() According to MySQL documentation for the greatest possible durability and consistency in a replication setup using InnoDB with transactions … you have to do this. These should be set to “1”, both of them. ĥ) innodb_flush_log_at_trx_commit and sync_binlog The parameter is server-id and should be set in the section. For example, set this to “100” and make sure that you set “101” on your Slave (see later). It has to be unique among all the ids used in the whole replication setup. This is the Master replication server ID. Important gotcha: make sure that the folder/disk has enough space to write the binary logs there. Note that the full path to the binary log file should be given. The parameter is called log_bin and it should exist in the section. Note that if you have enabled skip-networking you need to disable it. ![]() bind-address is a configuration parameter of the section. Don’t forget that this is true for the ‘root’ user too, even if he connects from the local machine.Ģ) Set bind-address to the IP of the machine. Hence, connect to your MySQL server using mysql and set these commands accordingly before proceeding to the following. This is necessary even if the user connects from the machine that MySQL server is installed. The following mysql commands (which can be issued using mysql shell) mysql> grant all on *.* to identified by ‘bar_password’ Īllow the user ‘bar’ to connect to this MySQL server and to all databases from the machine with IP ’10.100.10.55’. All the remote and local machine IPs need to be granted access for the users that access MySQL from these machines. If you do not do that, after the change of the bind address and restarting of your MySQL server, users from remote or local machines will not be able to connect to your server. Since you are about to change the bind address on your MySQL server, you are essentially allowing access to your MySQL server from “remote” machines. In the first phase of the work, the overview of what we did is as follows: Master debian allows incoming connections on 3306 port, the standard MySQL listening port.Slave does not have MySQL installed yet.MySQL does not allow remote connections by default, and that was our case too. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |