Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Physical/logical architecture WeSQL
- Server files and startup scripts Server configuration MySQL My.cnf Basic parameters Server log files Query log Slow query log Error log
Management
- User Accounts My Privileges and SecuritySQL Backup and Restore - Mysqldump vs. Mysqldump Percona Backup Database maintenance
Schema optimization
- InnoDB: specific presentation - disadvantages advantages, what is it really different from MyISAM - when to use what? How to choose primary keys (when spatial, when b-tree etc.)? Fulltext search on InnoDB engine (<5.6 only MyISAM possible, above 5.6 MyISAM+InnoDB)
MySQL Query Cache
- Why, for what queries, what value, is it worth it to be large?
Performance testing, identifying performance issues
- What to test – depending on the results we want to get Solving performance problems (slow queries, waits, performance tools etc.)
Data sharding (horizontal and vertical)
- Differences, costs, limitations
Schema optimization
Indexing
- Indexes on very large tables Primary keys (when submitted, on what fields)
Data types
- Tricks in choosing data types, correct use of field types (int/float, time, geolocation) - benefits, limitations Is a primary key other than int acceptable and equally efficient? Should every table have a primary key? Transactions - when to use and when not - advantages and disadvantages.
Optimization of the operating system and hardware usage
- The most important parameters in my.cnf
Optimization at the application level
- Optimization tools Scripts that analyze settings and display hints
Database replication
- Replications, clusters - how to achieve high availability? Replication setup (ROW/PAGE, troubleshooting, rebuild, monitoring/diagnosing the replication process
MySQL Proxy vs. HAProxy
- Principle of operation, reliability(?), advantages and disadvantages
MySQL Cluster
- How it works Configuration Efficiency Security
Cache
- Cache MySQL, temporary tables Is it worth moving relationships to databases or is it better to keep them in the code? Subqueries & joins - whether to use, how to optimize?
Explain as an aid in query testing
- Using indexes to build queries Query profiling - what tools, how to do it effectively? Visual design tools - is it worth using or rather simplifying structures?
Good practices and naming conventions - keys, columns, indexes, tables
Building optimal table structures
- Triggers: good practices when it comes to keeping logic in procedures and triggers - how to manage, how to test, when it pays to use? Design patterns and anti-patterns
Is it worth switching to MariaDB?
Management tools
- MySQL Workbench
- Navicat
- Heidi SQL
14 Hours
Testimonials (5)
Profesjonalizm i wiedza prowadzącego
Jan - SoftSystem
Course - Zaawansowana administracja MySQL
Dobrze zorganizowane środowisko techniczne, które w szybki sposób mogło być stawiane od nowa.
Barbara Filipczyńska
Course - Zaawansowana administracja MySQL
Elastyczność, możliwość szybkiego wyjaśniania wątpliwości
Rafał MIszczak - EXENCE SA; ArjoHuntleigh Polska Sp. z o.o.; it-wawrzyniak Piotr Wawrzyniak
Course - Zaawansowana administracja MySQL
rzeczowe odpowiedzi, szeroki zakres wiedzy
Łukasz Piechowiak
Course - Zaawansowana administracja MySQL
dostępna pomoc podczas ćwiczeń, odpowiedź na każde pytanie i starania aby rozwiązać każdy problem
