Posted on

A few seats left in Canberra (22,23,24 Sep) for MySQL DBAs

Are you in Canberra/ACT, and are you an experienced DBA needing to tune InnoDB? Or do you just maintain some MySQL instances on the side and need to know more about proper installation, security and backup/recovery methods?

Well… the upcoming Open Query course days in Canberra still have a few seats left. No, it’s not “nearly full” but it’s not empty either. And yes, I know that Sun/MySQL recently cancelled a DBA training week in Canberra at the last minute (they also scheduled it close to the last minute to begin with 😉 however these Open Query days are definitely going ahead. The topics:

  • Monday 22 September: MySQL Installation, Security and User Management (AUD 475 + GST)
    MySQL Server is easily set up and ready to go within mere minutes, however this does not make it suitable for a production environment in terms of performance, security, and monitoring. Additional configuration of MySQL Server as well as its operating environment is necessary.
  • Tuesday 23 September: MySQL Backup and Recovery (AUD 475 + GST)
    We explore the different methods and tools (some of which you may not be familiar with), when and where to use each, discuss common problems and pitfalls, and provide a good basis for developing processes for keeping your data safe in your own environment.
  • Wednesday 24 September: MySQL InnoDB Performance Tuning (AUD 575 + GST)
    Delving into the vast realm of the InnoDB storage engine, its architecture, diagnostic tools, and performance tuning. InnoDB is the most widely used transactional storage engine in MySQL. In many deployments it is used for many if not all tables. While the default settings make InnoDB functionally usable, it is by no means optimised. The server’s actual utilisation by an application, as well as the physical architecture (such as CPUs/cores and disk I/O) come into play. You may want to change some paths, look at the many other tuning options, and see how queries can be adjusted to take advantage of some of InnoDB’s features.

Secure your seat today!

You can choose individual days. Naturally, the first two days are a must for anybody responsible for administering a MySQL server, while the last day is definitely just for the more advanced. For an overview of all current MySQL-related course topics, see https://openquery.com.au/training/mysql. Open Query also does customer (in-house) courses, and on-site and remote consulting. If you need a helping hand, let us know!

Posted on