Mar
5

Mysql Database administration tutorial

MySQL!  A well known and most popular open source database system needs no introduction to any programmer. MySQL database administration skills are often required by number of programmers and web application developers. This tutorial is targeted for application developers who either wants to improve their administration skills in MySQL or to optimize MySQL database to improve performance of application. This is also targeted to novice MySQL database administrators who wants to improve their knowledge or fill knowledge gaps. It is not the purpose of this tutorial to serve as documentation or complete reference. Please refer MySQL website for complete reference and documentation.

Here is the complete list of topics that are covered in this tutorial.

  • Installation
  • Things to do after installation
  • MySQL start up scripts
  • User management
  • Storage Engines
  • MySQL client and utility Programs
  • Server variables
  • Server Logs
  • Backup and recovery
  • Multiple MySQL installations on single computer
  • Optimization
  • Buffering and caching
  • MySQL default databases (information schema, MySQL)
  • Replication
  • Conclusion

Me?

Hi there, I am Kiran Ambati. I am mysql database administrator and php programmer from  Hyderabad. I have developed many good looking websites and  functional web applications. I am a strong believer in open source.

It was couple years ago i first developed my first website ,ever since that day web developing has been my hobby and passion.