Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql config slave

[mysqld]

binlog_format     = ROW
log_bin           = binlog #The slave is going to copy all of the changes that are registered in the log.
expire_logs_days  = 10
server_id         = 1 #number must be unique and cannot match any other server-id in your replication group
log_slave_updates = 1
binlog_do_db      = databasename #You can include more than one database by repeating this line for all of the databases.
Comment

PREVIOUS NEXT
Code Example
Sql :: get all databases and their tables without primary key mysql 
Sql :: 165001709 
Sql :: how to add column in oracle 
Sql :: why we have to set the password for my sql server 
Sql :: compute age mysql 
Sql :: sql dcl queries 
Sql :: kimball data warehouse sql calendar 
Sql :: a query to determine the version of a database 
Sql :: sql query wordpress export post 
Sql :: proc sql not in working 
Sql :: default order by in mysql 
Sql :: difference between on and where in sql 
Sql :: sql gap missing values 
Sql :: SQL Multiplication Operator 
Sql :: sql server convert string list integers list 
Sql :: sqlite display data in separated columns 
Sql :: sql interview query questions 
Sql :: remove record from table sql 
Sql :: SQL AND, OR and NOT Operators 
Sql :: oracle connection 
Sql :: add mysql database to power bi web 
Sql :: add column in sql server ubuntu 
Sql :: sql query tags 
Sql :: sql alchemy get last n elements 
Sql :: denormalise SQL command 
Sql :: sql grant 
Sql :: least orders 
Sql :: concat string is null postgresql 
Sql :: join 
Sql :: how to check if sql query is correct online 
ADD CONTENT
Topic
Content
Source link
Name
4+5 =