从percona.com看到的，MYSQL
DBA知识体系需要了解的东西非常多,真能搞定全部的就是世界级的了，备忘下！
Database Servers
-
MySQL Server – Versions 4.x, 5.0, 5.1,
& 5.5 -
MySQL Server – Community & Enterprise
Editions -
Percona Server – Percona’s
builds of MySQL 5.0 with performance patches -
MariaDB – backward compatible, drop-in
replacement branch of the MySQL Database Server. -
MySQL Cluster –
Versions 6.x, 7.x -
Drizzle – Re-engineered fork of MySQL designed for
cloud computing
Storage Engines
-
MyISAM –
Traditional storage engine with Table Locks and no transactions support -
InnoDB – Native, Plug-In,
& Embedded versions -
XtraDB – Percona’s enhanced
transactional engine based on Innodb -
Blackhole –
Non-writable engine used in special replication-related situations -
Federated –
Disperses tables across multiple servers -
Falcon – In memory engine (no longer
under active development) -
SphinxSE – Full
text search engine -
Maria – Transactional engine by Monty Program
Ab, derived from MyISAM - PBXT – Transactional engine by Primebase
-
TokuDB – Storage engine that increases performance
with fractal indexing technology
MySQL High Availability
-
Pacemaker – scalable cluster resource
manager - Heartbeat – High availability node monitor
- DRBD – Block based replication by Linbit
- Schooner MySQL Enterprise with Active Cluster
- HA Proxy- Load balancer
Performance Enhancements Strategies
- memcached – In-memory caching
-
MySQL Proxy – Load balancing, failover,
query filtering & analysis utility
MySQL Replication & Backup
-
XtraBackup – Open-source
non-blocking backup tool for InnoDB and XtraDB data -
InnoDB Hot Backup – Oracle’s
proprietary backup utility -
mysqldump, mysqlhotcopy –
Official MySQL tools - MyLVMBackup – Backup scripts
- Zmanda – Commercial backup manager
-
Statement
Based & Row Based replication commands -
Tungsten – Commercial
replication manager
MySQL Utilities & Other
-
Maatkit – Suite of 20+ utilities for developers
& DBAs - innotop – MySQL internals monitor
- mysqlsla – General log analyzer
-
mysqlreport – Makes readable SHOW STATUS
output -
MySQL Connectors – ODBC, J, Net, MXJ, C++, C, PHP
native driver -
MySQL Workbench – GUI
based integrated development environment -
MySQL GUI Tools Bundle – Administrator, Query
Browsers, Migration
Toolkit -
MySQL Command Line Tools – mysqlbinlog, myisamchk, mysqld_multi,
etc. -
phpMyAdmin – Browser based
DBA tool -
SQLyog – GUI based integrated development
environment -
Stored Procedures, Triggers, Full
Text Search, Views,
& UDFs
Hardware & Software Environment
- Storage: RAID, SAN, NAS, SSD & Virtualization
-
Switches, Firewalls, Load
Balancers, Remote Management - Web Servers: Apache, Tomcat, Lighttpd, Squid, Varnish
- Version Control: Subversion, Mercurial, Bazaar, Bitkeeper
- DNS: Bind, VPN, IPSEC, IPFW, IPTables, PFSense, UltraDNS, PowerDNS, DjbDNS
- Debugging: Strace, Oprofile, Dtrace, GDB, Valgrind, KCachegrind
- Mail: Postfix, Sendmail, Qmail, Exim, Cyrus
- Monitoring: Nagios, MONyog, Cacti
- Languages: PHP, Perl, Ruby, Python, Java, Erlang
- PHP: Xcache, APC, eAccelerator
- Frameworks: Rails, Drupal, WordPress, phpBB
- Filesystems: ext3, ZFS, XFS
http://blog.netoearth.com/html/201202/%e4%bd%9c%e4%b8%ba%e4%b8%80%e4%b8%aamysql-dba%e9%9c%80%e8%a6%81%e4%ba%86%e8%a7%a3%e7%9a%84%e7%9f%a5%e8%af%86.htm相关文章: