MySQL DBA Responsibilities

Overview of DBA duties Server startup/shutdown Mastering the mysqladmin administrative client Using the mysql interactive client User account maintenance Log file maintenance Database backup/copying Hardware tuning Multiple server setups Software updates and upgrades File system security Server security Repair and maintenance Crash recovery Preventive maintenance Understanding the mysqld server daemon Performance analysis Obtaining and Installing…

How to reset MySQL root password

1. Stop mysql service shell> /etc/init.d/mysql stop 2. Start to MySQL server without password. shell> mysqld_safe –skip-grant-tables & 3. Connect to mysql server using mysql client. shell> mysql -u root Welcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 107Server version: 5.1.49-1ubuntu8.1 (Ubuntu)Type ‘help;’ or ‘h’ for help. Type…

How to secure MySQL server

OS level Security: Never run the MySQL server as the linux ‘root’ user. Always create the separate user for MySQL and start/stop MySQL server with it. If the data directories are located under $mysql_home/data dir then make sure that directory and all subdirectories should have only read and write privileges for the mysql user. Always…

MySQL Server Performance Tips

MySQL Server Performance Tips: Do regular maintenance of MyISAM tables with analyze and optimize commands. Choose better backup policy for DBs. It completely depends on which storage engine we are using. Always try compress static data so can save the space and no need to take backup often. Check MySQL memory utilization before set any…

How to install Drupal 7.0 on Ubuntu 10.04

Drupal is a free and robust content-management system which runs on LAMP(Linux, Apache, MySQL and PHP) server. PostgreSQL and MariaDB are also compatible with with Drupal. Before start Drupal 7.0 installation, we have to install following packages related to LAMP. Here, I’m imagine that Ubuntu 10.04 is already installed 🙂 – A web server. Apache…

Tools for MySQL Database

There are many tools available for MySQL DB. Some of them are really helpful for performing different kind of tasks for MySQL database. Like for database administration, we can use MySQL Enterprise Monitor (which is coming with MySQL Enterprise version and it is paid version too). http://www.mysql.com/products/enterprise/monitor.html In the Open source technology, one of the…