Last_SQL_Error: Error Table is marked as crashed and should be repaired

30. September 2016 MySQL, SysAdmin 0
Last_SQL_Error: Error Table is marked as crashed and should be repaired
Today we had an issue with our Master-Master replication. Master2 was throwing the below error and the replication was stopped Last_SQL_Errno: 145 Last_SQL_Error: Error 'Table './exampledb/exampletable' is marked as crashed and should be repaired' on query. Default database: 'livewbmy_db'. Query: 'INSERT INTO `exampletable` (`challenge`, `response`, `hashkey`, `expiration`) VALUES ('XBUL', 'xbul', 'a9e0f4e3dxxxxxccccccc0c8f8f1', '2016-09-29 21:10:03')' Since its ...

Got fatal error 1236 from master – MySQL – Broken Master – Master Replication

29. September 2016 MySQL, SysAdmin 0
Got fatal error 1236 from master – MySQL – Broken Master – Master Replication
Scenario You have a MySQL Master-Master replication setup, Lets say Master1 (LIVE) and Master2 (DR Warm Standby) Master2 server has been restarted for some reason. Now Master1 LIVE (the slave of DR) slave status is stopped with the below error. Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not ...

How to install native BASH on Windows 10 – Not a VM ;)

18. September 2016 SysAdmin 0
How to install native BASH on Windows 10 – Not a VM ;)
Native Bash is available now in Windows 10 as Windows 10’s Anniversary Update . Lets see how we can install it. Enable Developer mode in Windows 10 from settings >> Home, or search for Developer Mode from the Windows Menu. Now enable Windows Subsystem For Linux Users from the Turn Windows features on or off menu. Once the installation ...

httpd.service: main process exited kill: cannot find process “”

15. September 2016 CentOS, RHEL, SysAdmin 1
httpd.service: main process exited kill: cannot find process “”
Today apache was stuck with the below error and it was not starting at all. Sep 15 06:18:24 server.example.com systemd[1]: Starting The Apache HTTP Server... Sep 15 06:18:24 server.example.com httpd[15037]: [Thu Sep 15 06:18:24.591424 2016] [so:warn] [pid 15037] AH01574: module ruid2_module is alread...skipping Sep 15 06:18:33 server.example.com systemd[1]: httpd.service: main process exited, code=exited, status=1/FAILURE Sep 15 06:18:33 ...

How to set custom DNS on CentOS7 AWS

30. August 2016 AWS, CentOS 0
How to set custom DNS on CentOS7 AWS
There may be scenarios, when you need to use a custom DNS server for your Instances. So if you are deploying your application on an CentOS 7 on AWS, lets see how can set a custom DNS server such as 8.8.8.8 and 8.8.4.4 Edit the following file, vim /etc/sysconfig/network-scripts/ifcfg-eth0 change the line PEERDNS="yes" to PEERDNS="no" Now, Edit the ...

EC2 Ubuntu – Allow SSH root login with Password

16. August 2016 AWS 0
EC2 Ubuntu – Allow SSH root login with Password
Amazon AWS doesn’t allow root access by default on the OS level. Even though this is for recommended for security purpose, you may need to enable it for some high level operations such as conversion to OVA or VMware etc. Environment Amazon EC2 Ubuntu 10.X (Should work with other linux versions too) How to Open ...