Configuring Percona Server for use in hosted or multi-tenant environments.

Database Administration
4 April 3:00PM - 3:50PM @ Ballroom A

Experience level: 
50 minutes conference
Percona Server now has several features that allow a server owner to limit the actions of a connected user (even root) and enhances the manageability of a hosted server instance. In this talk I will cover some of the new options and techniques used to manage a server instance within the cloud. These include: - How to use the utility-user functionality to limit access to hosted data and help limit the liability of the hoster while still allowing a certain level of access to manage the server. - How to use the enhanced options modifiers to prevent users from changing critical system variables. - How to use the various options to limit the space utilized by binlog and slow query logs (max-binlog-size, max-binlog-files, max-slowlog-size, and max-slowlog-files). - How to use new space management options to warn and help prevent XtraDB from getting into an unrecoverable state due to ENOSPC. - Discuss some of the research and work being done to help limit runaway UNDO space.


Software Engineer, Percona
I have been developing, supporting and directing software projects for the last 20 years. Prior to joining Percona in April of 2012 I was been mainly focused on Windows enterprise mail server development. Going further back I have been involved with a great variety of other projects including OS/X business apps; Windows and Linux kernel/network stack work focusing on protocol reverse engineering, classification and optimization; embedded micro-controller applications; some old DOS, OS/2, SCO and NeXT work.