We are maintaining a huge MySQL database server which having more than 3TB data. It’s very had for us to backup, move and restore those databases from one host to another or once network to another due to size constrains. Moreover any of these activities would be involved lots of time and work precision during […]
One of the clients complaints me that they are getting warning on the email those sent to Gmail.com domain. They are using 25 smtp port to send email using sql based mail server. So anybody in between the network can tap the email content since it been send through non-encrypted emails.
So my plan […]
We are using Oracle MySQL community 5.7 version which does not have capability of auditing user activities. There will be some option to audit the MySQL statements by enabling General log ( for whole sql activity) and Slow log ( to identify the culprit sql which slow down the system.
Neither of above does not […]
Yesterday I was doing a task to fecilitate another Glassfish instance on the same IP but on using different port. I have modified all the ports those are mentioned specifically in domain.xml file. But yo u remember, I have another Glassfish server installed on the same hosting using default port values. While I’m verifying the […]
At some time, you would ask to restore a particular table from a full backup. So you have to follow the below steps. 1. Request backup team to provide the backup 2. Decompress the backup. 3. Move the file to target server. 4. Restore entire backup which take long time based of the volume. 5. […]
WE all are developing jave application for various area as it is one of the secure and non-hackle platform. So it’s consider is most secured programming platform to choose. Here One of our servers went heavily loaded and we did not find any specific reasons to happen this. At the same time observed the CPU […]