Email: inbox [at] sysadmin.lk
LinkedIn: https://www.linkedin.com/in/prabatht
Facebook: https://www.facebook.com/prabath.hinoize
Related Articles
How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
This is the full step-by-step procedure to resync a master-slave replication from scratch: At the master: And copy the values of the result of the last command somewhere. Without closing the connection to the client (because it would release the read lock) issue the command to get a dump of the master: Now you can release the […]
Installing the Free G729 Codec for Asterisk
This tutorial will let you install the G729 Codec on an Asterisk installation in under 5 minutes. Navigate to the codecs directory: cd /usr/lib/asterisk/modules Download the codec Codecs are provided as binary .so files, you can find the archive at http://asterisk.hosting.lv/#bin Take care of the following when picking up one of the files, they depend […]
MySQL Master-Master Replication
Create MySQL user CREATE USER ‘droaming’@’localhost’ IDENTIFIED BY ‘DroamG.123’; CREATE USER ‘droaming’@’%’ IDENTIFIED BY ‘DroamG.123’; Drop Mysql User DROP USER ‘droaming’@’localhost’; DROP USER ‘droaming’@’%’; Create Mysql Database and grant permission CREATE DATABASE droaming; GRANT ALL ON droaming.* TO ‘droaming’@’localhost’; View MySQL users SELECT User, Host, Password FROM mysql.user; MySQL Master-Master Replication SERVER 01 [mysqld] datadir=/var/lib/mysql […]