+1 -1 +7
Vote on this proposal

MySQL Utilities: Scaling MySQL with Python

by Nitin Mehta (speaking)

Section
Workshops
Technical level
Intermediate

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.