Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ Set up MySQL master and slave servers under Ubuntu 14.04     - Explore Android SQLite3 multithreading (Programming)

- C ++ hash function (Programming)

- Binary tree to the next node (Programming)

- Ubuntu install video conversion tool Selene (Linux)

- Each catalog Detailed Linux (Linux)

- Ubuntu UFW firewall settings Introduction (Linux)

- OpenStack / Dev stack with neutron on Ubuntu 14.04 (Server)

- Installation and use GAMIT / GLOBK Software (Linux)

- Linux / Unix system-level IO (Linux)

- Kafka cluster deployment (Server)

- Root of AVL Tree- achieve balanced search trees AVL tree (Programming)

- CentOS install Redis (Database)

- Construction of Android and iOS apps use Jenkins Automation (Programming)

- CentOS network configuration 7, and set the host name and IP-bound problems (Linux)

- Install Apache streaming media services on CentOS 6.4 (Server)

- Linux crontab (Linux)

- Linux package management operations Basic entry (Linux)

- Linux operating system buffer overflow attacks Countermeasures (Linux)

- Thinking in Java study notes - Generics (Programming)

- Linux suffered SYN flood attack setting (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.


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




$ Sudo /etc/init.d/networking restart

I address to each virtual machine is set to: Gateway IP:

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 @ identified by '1234'

Then another Ubuntu remote testing

mysql -u slave -h -p

Preparatory work is ready, now start the configuration:

On the master 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 /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 = '', 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.
- Linux, Apache Web site security settings (Linux)
- CentOS 6.5 upgrade to CentOS 7 (Linux)
- Oracle 11G using DG Broker create DataGuard (Database)
- Embedded Linux to solve the problem in the time zone (Linux)
- Mount and unloading disks under Linux (Linux)
- CentOS system Amoeba + MySQL Master-slave configuration (Database)
- How to modify the Emacs Major Mode Shortcuts (Linux)
- Detailed driver compiled into the Linux kernel (Programming)
- Linux using TCP-Wrapper Service Management (Linux)
- How Bluetooth turned off by default in Ubuntu 14.04 (Linux)
- Vim (Linux)
- Steps to build MPICH2 development environment on CentOS 6.4 (Linux)
- Oracle () trunc function usage (Database)
- Upgrade to Node V4 seven reasons (Programming)
- Partition and file system under Linux (Linux)
- Linux device driver development small example --LED lights (Programming)
- Getting Started with Linux system to learn: How do I know which processes are running on the CPU core (Linux)
- Nmcli based network management command-line tool (Linux)
- The official release method to upgrade to Ubuntu 15.04 (Linux)
- C ++ complex class of operator overloading (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.