Difference between revisions of "MariaDB"
(→Links) |
(→Links) |
||
| Line 38: | Line 38: | ||
==Links== | ==Links== | ||
* https://www.percona.com/doc/percona-toolkit/2.2/index.html | * https://www.percona.com/doc/percona-toolkit/2.2/index.html | ||
| + | ** Generic: | ||
** [https://www.percona.com/doc/percona-toolkit/2.2/pt-heartbeat.html pt-heartbeat - Monitor MySQL replication delay.] | ** [https://www.percona.com/doc/percona-toolkit/2.2/pt-heartbeat.html pt-heartbeat - Monitor MySQL replication delay.] | ||
| − | |||
** [https://www.percona.com/doc/percona-toolkit/2.2/pt-index-usage.html pt-index-usage - Read queries from a log and analyze how they use indexes.] | ** [https://www.percona.com/doc/percona-toolkit/2.2/pt-index-usage.html pt-index-usage - Read queries from a log and analyze how they use indexes.] | ||
| + | ** [https://www.percona.com/doc/percona-toolkit/2.2/pt-variable-advisor.html pt-variable-advisor - Analyze MySQL variables and advise on possible problems] | ||
| + | ** Migration: | ||
| + | ** [https://www.percona.com/doc/percona-toolkit/2.2/pt-upgrade.html https://www.percona.com/doc/percona-toolkit/2.2/pt-upgrade.html] | ||
| + | ** [https://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html pt-table-checksum] | ||
| + | ** [https://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html pt-table-sync - Synchronize MySQL table data efficiently.] | ||
Revision as of 18:42, 12 June 2016
Contents
ToDo
Infrastruktur
- PT er netværket daisychained : Server-rack -> krydsfelt 1. sal -> krydsfelt stue -> serverrum stue
- Er der Gbit link i samtlige led ?
- INGEN Ups på switce i krydsfelter
- Ingen failover link - ingen Spanning Tree
- Risiko for split-brain scenarios ?
PHP/MySQL med failover
- Alle der udvikler PHP til info SKAL læse
Monitorering
Følgende targets skal sættes i nagios for alle 3 nodes
- Galera cync
- Intel SSD
- SW Raid
- MySQL connection
- free space:
- root partition
- /mnt/data
- CPU forbrug
Ting at være obs på
- LOAD DATA INFILE - forventer lokale filer
- LOAD DATA LOCAL INFILE er implicit IGNORE, så der kommer ingen fejl hvis at der er fejl i datafilen
Ting der skal undersøges
Links
- https://www.percona.com/doc/percona-toolkit/2.2/index.html
- Generic:
- pt-heartbeat - Monitor MySQL replication delay.
- pt-index-usage - Read queries from a log and analyze how they use indexes.
- pt-variable-advisor - Analyze MySQL variables and advise on possible problems
- Migration:
- https://www.percona.com/doc/percona-toolkit/2.2/pt-upgrade.html
- pt-table-checksum
- pt-table-sync - Synchronize MySQL table data efficiently.
