Database play critical role in Organizations. Without Database business cannot grow and they may face financial problems. Database contain the information about User details, Client details and other crucial information. Govt, Private and other organizations give this responsibility to the Data Base Administrator to handle their confidential Data. Data Base Administrator get paid for this responsibility. In this article we are giving some Important tips and tricks which is very helpful for Data Base Administrator to manage the crucial data with minimum effort.
Organize the Backups and Restoration
Database Administrator should use the protocols which decide how to backup and restore data in appropriate manner. So, in case of emergency or normal situation he/she does not face confusion. This can be done through automation scripting e.g shell, cshell which should be created carefully. For instance, large Database can be compressed in zip form to save the storage memory.
Secure the Data Base
Database may contain important information like Bank A/c detail, Credit or Debit Card detail and Company decision making detail. So, One who are responsible for managing the Data Base should be careful about how to secure the data from external threats as well as internal employees. To do this he or she can use different Database Firewall which is available on Internet Market.
Choose the suitable environment
Environment plays huge role to handle the company data.Suppose the Data Base administrator are not familiar with the environment where Data is stored and secured then How he can improve the Data Base secrecy.
Change the MySql root password
Data Base Administrator must be familiar with the MySQL root and user credentials. Sometimes users are do not know how to change the root user password. Here are following commands to change the root password.
Choose the storage engine according to your requirements and knowledge
Storage engine matter in Managing the Database on MySql. MyISAM is less complicated then InnoDB in many situation. Its all depend on the user who responsible to handle the Data.
Tips & Tricks:
Organize the Backups and Restoration
Database Administrator should use the protocols which decide how to backup and restore data in appropriate manner. So, in case of emergency or normal situation he/she does not face confusion. This can be done through automation scripting e.g shell, cshell which should be created carefully. For instance, large Database can be compressed in zip form to save the storage memory.
Secure the Data Base
Database may contain important information like Bank A/c detail, Credit or Debit Card detail and Company decision making detail. So, One who are responsible for managing the Data Base should be careful about how to secure the data from external threats as well as internal employees. To do this he or she can use different Database Firewall which is available on Internet Market.
Choose the suitable environment
Environment plays huge role to handle the company data.Suppose the Data Base administrator are not familiar with the environment where Data is stored and secured then How he can improve the Data Base secrecy.
Change the MySql root password
Data Base Administrator must be familiar with the MySQL root and user credentials. Sometimes users are do not know how to change the root user password. Here are following commands to change the root password.
-
$mysqladmin -u root password [Type in selected password] /* Run this command on like command line shell to access the database] $mysqladmin -u root -p [type old password]type new password here /* Run this command to change the mysql root password */
Choose the storage engine according to your requirements and knowledge
Storage engine matter in Managing the Database on MySql. MyISAM is less complicated then InnoDB in many situation. Its all depend on the user who responsible to handle the Data.
Comments
Post a Comment