Open Query

Open Query has partnered with the Pythian Group, founded in Canada by Paul Vallee and active around the world providing fractional database infrastructure teams on a linear cost-to-effort basis.

Open Query focuses on training and consulting work, whereas the Pythian Group has its remote DBA offering with around the clock (and around the globe) coverage. A perfect match!

Upcoming course dates

MySQL DBAs - Secure your seat today!
• Mon 22 Sep: MySQL Installation, Security and User Management (AUD 475 + GST)
• Tue 23 Sep: MySQL Backup and Recovery (AUD 475 + GST)
• Wed 24 Sep: MySQL InnoDB Performance Tuning (AUD 575 + GST)

MySQL HA - Next upcoming in Melbourne (October)

Upcoming course days

MySQL DBAs - NOW CLOSED (contact us for custom requests)

MySQL Developers - Secure your seat today!
Book now for $50 discount (per training day, per person)
• Mon 3 Nov: MySQL Optimisation by Design (AUD 475)
• Tue 4 Nov: MySQL Storage Engine Optimisation (AUD 475)

Upcoming course days

MySQL DBAs - Secure your seat today!
Book now for $50 discount (per training module, per person)
• Mon 15 Sep: MySQL Installation, Security and User Management (AUD 475 + GST)
• Tue 16 Sep: MySQL Backup and Recovery (AUD 475 + GST)
• Wed 17 Sep: MySQL InnoDB Performance Tuning (AUD 575 + GST)

MySQL Developers - Secure your seat today!

Drizzle is described as a "Lightweight SQL Database for Cloud and Web". The project is about building a database designed for the typical Web usage patterns for a database. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL.

1. Reliable.
2. Fast and scaleable for modern architecture.
3. Simple design for ease of Install and Management.

Looking at Drizzle

MySQL 5.0 Upgrade and Advanced Features
(AUD 575 + GST)

MySQL 5.0 contains a range of new advanced features including Stored Procedures and Functions, Cursors, Views, Triggers, INFORMATION SCHEMA, but also changes like precision math, strict mode, and optimisations.

The day provides an overview of all these topics, exercises for stored procedures with dynamic queries, cursors, and other related features, as well as discussion of relevant upgrade issues such as the important differences in join precedence and column types.

OpenQuery offers remote and on-site consulting to meet your MySQL needs. Key areas include:

• Schema and query design, performance analysis and tuning
• Problem analysis and resolution
• Database Audits based on configurations, security and server performance
• Design of MySQL Replication and clustering scenarios
• Guidance on migration from/to other databases
• We also hold Workshops & Training around Australia and New Zealand

Pricing