MySQL Master-Master or Master-Slave Replication Error Fix Rumi, January 18, 2013 Scenario Master – Master replication MasterA is a client facing server MasterB is a warm standby server (read only) MasterB restarted abruptly and when instances were braught back up MasterA (it’s slave) was showing the following error: MasterA has the following error in show slave status: Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’ Solution: Slave: stop slave; Master: flush logs Master: show master status; — take note of the master log file and master log position Slave: CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.00000X′, MASTER_LOG_POS=106; Slave: start slave; Read more: http://mysqlpreacher.com/wordpress/2010/12/could-not-find-first-log-file-name-in-binary-log-index-file/#ixzz2ILRnl4XI Src: http://mysqlpreacher.com/wordpress/2010/12/could-not-find-first-log-file-name-in-binary-log-index-file/ Related Administrations Configurations (Linux) MySQL MySQL
Nginx- Allow Directory browsing March 20, 2016 Enabling directory listing in a folder in nginx is simple enough with just an autoindex on;directive inside the location directive. You can also enable sitewide directory listing by putting it in the server block or even enable directory access for all sites by putting it in the http block. An… Read More
Let’s Encrypt service with Pound server February 5, 2018 In order to install Certbot on your server, follow the next steps: (make sure you have “git” installed on your system) $sudo apt-get install git (if not previously installed) $cd /opt $sudo git clone https://github.com/certbot/certbot Running the above commands will download the Certbot latest release from their git repo in… Read More
Permanently add Static Route in Linux September 4, 2020September 4, 2020 Static routing is the process of manually entering the routes to the routing table to reach a particular destination. Basically two commands are used in Linux to add routes. The first command is the old traditional route add and second is the IP route command. Earlier we learned how to… Read More