Mysql replication BD

0

my problem is the following create a replica of a database in mysql, but when I do the incersion to my master server from Worbench or phpmyadmin if the data is updated in the slave. My surprise is that when I insert from a program only they see in the master server and in the slave, no data is updated.

SLAVE

Slave_IO_State  = waiting for master to send event  
Master_Host    =   172.16.30.253
Master_User    = mantenimiento
Master_Port     =3306
Connect_Retry = 60
Master_Log_File=  mysql-bin.000001
Read_Master_Log_Pos= 3266
Relay_Log_File = MANTTO-PC-relay-bin.000002
Relay_Log_Pos = 1987
Relay_Master_Log_File = mysql-bin.000001
Slave_IO_Running =yes
Slave_SQL_Running =yes
Replicate_Do_DB =
Replicate_Ignore_DB
Replicate_Do_Table
Replicate_Ignore_Table
Replicate_Wild_Do_Table
Replicate_Wild_Ignore_Table
Last_Errno =0
Last_Error   =0
Skip_Counter=0
Exec_Master_Log_Pos =3266
Relay_Log_Space =2198
Until_Condition = none 
Until_Log_File
Until_Log_Pos
Master_SSL_Allowed =no
Master_SSL_CA_File
Master_SSL_CA_Path

MASTER

File = mysql-bin.000001
Position = 3266
Binlog_Do_DB = servicios
Binlog_Ignore_DB
    
asked by Juan de DIos Puente Anguiano 05.07.2016 в 20:43
source

0 answers