Cloud Computing with MySQL and Kettle

In this presentation we will work our way up from simple data loading to complex cloud computing examples.

Content

• Introduction to Kettle (10’)
  • What is BI, What is ETL?
  • Overview of typical use-cases
  • Short demo : load data into MySQL
• Kettle slave servers (4’)
  • What is a Kettle slave server?
  • What can it do?
  • How do you start it?
  • How do you configure it?
• Kettle cluster schemas (4’)
  • What is a Kettle cluster schema?
  • What is the role of the master?
  • How do you configure it?
  • Show small demo of data loading to 5 MySQL databases at once.
• The cloud (10’)
  • What is cloud computing? (Typical examples)
  • Configuring slaves to call home (auto-config schemas)
  • How does it work? (register slave, get list of slaves)
  • Where it makes sense
  • Where it doesn’t make sense
• Cloud examples (15’)
  • Create and administer MySQL databases in parallel. (short sample on 2 or more slaves, depending on the availability of hardware)
  • Load a set of data into a (partitioned) MySQL database table on N hosts to parallelize lookups. (example of database partitioning)
• Questions & closing (2’)