Master Slave

ocalle905's profile image ocalle905 posted 2 years ago in General Permalink

Hi, I started using HSLQL and wanna know if it possible to do a Master Slave into the options tools or any suggest are wellcomed. I have one server as main and another in other host as slave.

Thanks!

Osvaldo

ansgar's profile image ansgar posted 2 years ago Permalink

Yes, MySQL and MariaDB supports a master/slave configuration. You need to alter the my.ini/my.cnf file on both servers, basically in such a way:

[mysqld]
log-bin=mysql-bin
server-id=1

But you will need to dive deeper into the topic: https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-howto-masterbaseconfig.html

ocalle905's profile image ocalle905 posted 2 years ago Permalink

Many Thanks

Please login to leave a reply, or register at first.