Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Server \ Set up MySQL master and slave servers under Ubuntu 14.04     - Install DB2 V10 and Data Studio V3 under Linux (Ubuntu) environment (Database)

- RedHat Linux 7 build yum source server (Server)

- How to troubleshoot error java.lang.NoSuchMethodError (Programming)

- An example of troubleshooting of embedded Linux OpenWRT (Linux)

- Oracle table space rename and delete table space (Database)

- Use SVN to automatically deploy code under Apache (Server)

- Oracle local user login authentication fails ORA-01031 insufficient privileges (Database)

- CentOS7 install MySQL5.6.22 (Linux)

- CentOS 6.5 boot automatically mount the hard drive (Linux)

- Linux ldconfig command (Linux)

- How to use the ftp tool to transfer files between Windows and Linux (Linux)

- MySQL fuzzy query: LIKE and REGEXP pattern mode (Database)

- How to test your MongoDB application upgrade? (Database)

- MySQL / MariaDB database master-slave replication (Database)

- Ubuntu 15.04 installation MATE 1.10 (Linux)

- Install Linux Mint 17: 20 things to do (Linux)

- CentOS yum source deployment (Linux)

- How to use Evernote in the Linux command line (Linux)

- Ubuntu mysql stop fail to solve the problem (Database)

- Linux text processing tool of sed (Linux)

 
         
  Set up MySQL master and slave servers under Ubuntu 14.04
     
  Add Date : 2018-11-21      
         
         
         
  MySQL master-slave replication is asynchronous, sub-master / slave, there is a thread in the master terminal IO, IO and Sql threads exist at slave.

The most important place to build the environment that will mysql binary logging feature is turned on, the details I have not noticed in the course of the ride, fucked me for a long time.

surroundings:

My two virtual machines are using bridged mode of access is not recommended nat. First two virtual machines to set a fixed ip address, and your physical machine ip address within a segment, so it is similar to your virtual machine a LAN physical work.
Set a fixed ip address:

$ Sudo vim / etc / network / interfaces

as follows:

# Interfaces (5) file used by ifup (8) and ifdown (8)

auto lo

iface lo inet loopback

auto eth0

iface eth0 inet static

address 192.168.1.252

netmask 255.255.255.0

gateway 192.168.1.1

$ Sudo /etc/init.d/networking restart

I address to each virtual machine is set to: 192.168.1.251 192.168.1.252 Gateway IP: 192.168.1.1

After setting, first ping each other in a virtual machine, you must ensure that can pass.

Environment is ready, you can start, I did not take the rpm mode, install mysql under ubuntu direct online is very convenient, eliminating a lot of steps.

$ Sudo apt-get install mysql-server

After the default installation automatically open, so use netstat -tap | grep mysql mysql service to see if it exists

After the query is running under mysql status, service mysql status, similarly, there are other commands, service mysql start / stop / restart.

If the following message appears, it means success.

mysql start / running, process 1199

Before landing at /etc/mysql/my.cnf first comment out the bind-address, because the default can only access this machine.

Landing mysql

mysql -u root -p

grant replication slave, reload, super on *. * to slave @ 192.168.1.152 identified by '1234'

Then another Ubuntu remote testing

mysql -u slave -h 192.168.1.151 -p

Preparatory work is ready, now start the configuration:

On the master 192.168.1.251 machine to modify my.cnf, remember the following configuration information must be added to the [mysqld] module, on file elsewhere will lead to master configuration failure.

server-id = 1

log_bin = / var / log / mysql / mysql-bin.log

binlog_do_db = student

binlog_ignore_db = mysql

Under restart mysql

sudo /etc/init.d/mysql restart

If you failed in the restart process, it is recommended to look at the next my.cnf log-error log files have to correspond to the location of the error, and cat facie error message

After entering the master's mysql, first look at the binary function is on.

show variables like 'log%'

If it is not turned off on behalf of, or return to the check the next my.cnf file, whether in [mysqld] piece medium. Whether the file path

show master status; you have to be able to see the corresponding file position information, which at the time of the slave set to use.

And finally to the next salve 192.168.1.252 /etc/mysql/my.cnf configuration:

server-id = 2

log_bin = / var / log / mysql / mysql-bin.log

replicate_do_db = student

Under restart mysql

sudo /etc/init.d/mysql restart

slave enter mysql:

stop slave

Then log configuration settings from a master copy

change master to master_host = '192.168.1.151', master_user = 'slave', master_password = '1234',

master_log_file = 'log.000004', master_log_pos = 94;

log_file log_pos is in the master show master status information see the file position.

start slave;

show slave status G

Find Slave_IO_Running / Slave_SQL_Running information appears, we are YES is successful.

If there is a NO, or view the log-error log file, it would be more clear description out.
     
         
         
         
  More:      
 
- Linux virtual machines to solve end MySQL database can not remote access (Database)
- Boost - Memory Management - smart pointers (Programming)
- ISO image to use offline upgrade Ubuntu (Linux)
- JVM garbage collector and memory allocation strategy (Programming)
- JavaScript in null undefined summary (Linux)
- Linux network monitoring strategy (Linux)
- Linux System Getting Started Tutorial: How to automatically set the JAVA_HOME environment variable on Linux (Linux)
- Zabbix Agent (Server)
- ld.so.conf.d profile (Linux)
- Oracle 11R2 Grid Infrastructure execute root.sh script rootcrs.pl execution failed treatment (Database)
- CentOS 6.6 compile and install phpMyAdmin configuration PostgreSQL9.4.1 (Database)
- Android Studio simple setup (Linux)
- Use virt-manager to create and manage virtual machines (Linux)
- Ubuntu simple method to track multiple time zones (Linux)
- Let you Fun Ubuntu desktop eleven weapon (Linux)
- CentOS 6.x and CentOS7 installation RPMforge (Linux)
- Ubuntu 14.04 Solution login interface infinite loop (Linux)
- Linux CentOS configuration SVN + SVN hook (Server)
- Ubuntu program using the Sound Recorder (Linux)
- Linux installation notes under GAMIT (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.