Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Server \ Set up MySQL master and slave servers under Ubuntu 14.04     - Linux system boot process ARM platforms (Linux)

- The Hill sorting algorithm (Programming)

- Quagga use authentication on strengthening BGP session security (Linux)

- Oracle 11.2.0.3 and MySQL5.6 DDL comparison (Database)

- When should I use Angular 2 (Programming)

- Actual SSH port forwarding (Linux)

- Row-level security and application-level solutions for the new features of PostgreSQL9.5 (Database)

- Oracle 11g new features and associated SQL TUNING (Database)

- ORA-00020: No more process state objects available (Database)

- Java framework for parallel study - ForkJoin (Programming)

- Java study notes: String (Programming)

- Graphics of Java Tools (Programming)

- RedHat Linux 6 desktop installation (Linux)

- RHEL5 multipath configuration (Linux)

- How to Create a file can not be changed under Linux (Linux)

- Ubuntu iptables prevent IP attacks (Linux)

- Unix system security configuration (Linux)

- To create and manage virtual machines on Ubuntu Redhat (Linux)

- Monitoring Linux System 7 command-line tool (Linux)

- Using IntelliJ IDEA Import Spark Spark latest source code and compile the source code (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:      
 
- The basic method RHEL6 (CentOS6) used in the source package compiled RPM: Upgrade OpenSSH articles (Linux)
- CentOS 6 rapid deployment of Java applications (Linux)
- Node.JS different ways to install under Ubuntu 15.04 (Linux)
- Oracle 11g RMAN cross-platform transfer table space (Database)
- Linux network cut package is not fully defragment (Linux)
- Locale files under Ubuntu (Linux)
- MyCAT easy entry (Database)
- How to clean up your Ubuntu 14.10 / 14.04 / 13.10 system (Linux)
- Compile and install LNMP under CentOS 6.5 (Server)
- Ubuntu install Tonido private cloud services (Server)
- Linux common network tools: traceroute routing of scanned (Linux)
- Getting jQuery - progress bar (Programming)
- Linux Kernel 4.2 Installation Instructions (Linux)
- TNS-03505 name could not be resolved (Database)
- Cryptography development environment to build under Ubuntu (Linux)
- RHEL7.0 environment Linux kernel upgrade (Linux)
- Without Visual Studio .NET Windows application development (Programming)
- ORA-01000 Solution (Database)
- Python Django model within the class meta Detailed (Programming)
- CentOS5 installation Nodejs (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.