Achieving PCI compliance can be a difficult and expensive process. This session will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy them.
In this session, I will talk about tough DBA tasks - how to automate failover under non-trivial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sharding). If you have spent too much time for these tasks, this session will help your DBA life easier.
Production schema changes are painful but unavoidable. This session will tell you how to
minimize (or totally eliminate) downtime during schema changes with master-master setup or by using "shadow" tables.
Session will focus on pros and cons of each approach and describe most common use cases.
Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL security and schema optimizations.
Too much for just one session, in Part 2 we continue with learning the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time.
openark-kit is a tool set of scripts which fills in some gaps in daily MySQL maintenance work. Some scripts make for automation of routine work; others introduce new functionality to the MySQL server. This session introduces concepts and usage of the openark-kit.
This talk shows how to use Percona Server together with XtraBackup to make important operational tasks easy.
Site failures can blow your business out of the water unless you have a disaster recovery site already setup, tested, and ready to go. This talk presents a cookbook approach for setting up and managing MySQL DR. Standard architectures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works.
phpMyAdmin is a well-known PHP application for managing MySQL database. What's wrong with it? It is big, slow and it misses support for many advanced features like stored procedures or triggers.
Its free alternative Adminer provides user-friendly interface, requires no setup, is lightning fast and highly customizable. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
Security is becoming more important than ever, and as such, it should be a high concern for MySQL users. In this session we will cover important MySQL security practices, with a focus on configuring and using SSL with MySQL. Although sometimes overlooked, data in transit is vulnerable and should be secured. The use of SSL/TLS provides us with a tool to help protect peace of mind and data security.
This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatkit tools. It includes tools such as an I/O profiler, a bottleneck analysis tool, and tools to quickly summarize a system's configuration and status.