Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Master Slave

ocalle905's profile image ocalle905 posted 2 months 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 months 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 months ago Permalink

Many Thanks

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.