MySQL Utilities: Scaling MySQL with Python
by Nitin Mehta (speaking)
Objective
Attendees will learn about MySQL Utilities (written in Python) to manage and scale MySQL databases. Several utilities also enable to automate tasks which otherwise require lot of configuration/manual intervention.
Description
MySQL Utilities allow a non-DBA to <b>automate routine tasks</b> and make the MySQL databases scale with the least possibility of error. A more advanced user / DBA can use and extend these utilities to manage <b> large databases </b>for growing requirements and scale these with minimal inputs using <b>database layer sharding</b>.
Requirements
MySQL Utilities requires Python 2.6+.
MySQL Utilities requires MySQL Connector/Python GA release (version > 1.0.8) for connecting to MySQL. If you do not have Connector/Python installed, see the download section for Connector/Python to <u><a href="http://dev.mysql.com/downloads/connector/python/"> download </a></u> the appropriate repository.
Speaker bio
Nitin is employed with Oracle India as a Principal Pre-Sales Consultant helping customers to design and improve the databases.
Nitin has been using MySQL since release 3.23 and has been instrumental in designing and configuring some of the largest databases on MySQL in India. He is also a certified Database professional and does a lot of scripting and automation in his free time.
Links
- http://osidays.com/osidays/speaker-lineup/nitin-mehta/
- http://in.linkedin.com/in/nitinmht/
- mysqlbits.blogspot.com