mysql dba转型,对MySQL DBA的一些思考

1. MySQL DBA mysqlops

2. MySQL MySQL DBADBA DBA MySQL 3. MYSQL MySQL 4. SQL ServerOracleDB2 WindowsSQL Server PostgreSQL NoSQLLicense 5. MYSQL MySQL MySQL MySQL MySQLGPL MySQL MySQL MySQL MySQL DBA 6. MYSQL MySQL MySQL MySQLJOIN MySQL Global IndexMyISAMMySQL AB MySQL MySQL AB MySQL AB 7. MYSQL 8. DBA DBA--DBADBAMySQL DBA -- DBA DBA SQLMySQL DBA SQL DBA -- MySQL DBA + 9. DBA DBA 10. DBA 11. DBA SQL SQL 12. MYSQL MySQLDDLDMLSQLJOINa) ()I/Ob) JOINI/Oc) JOINd) () (continue) 13. MYSQL MyISAMInnoDBMEMORY DDL DML SELECT MySQLInnoDB READ UNCOMMITED READ COMMITED REPEATABLE READ SERIALIZABLE MySQLBUG List->->->->->-> 14. MYSQLa) STATEMENT ROW MIXEDa) READ UNCOMMITEDREAD COMMITEDREPEATABLE READSERIALIZABLEtransaction-isolation = read-committedbinlog-format = mixedtransaction-isolation = repeatabled-readbinlog-format = mixed 15. MYSQL InnoDB 16. MYSQL SELECT M.columnname,N.* columnname..FROM left_table MLEFT JOIN right_table N ON M. columnname_join=N. columnname_join AND N. columnname=XXXWHERE M.columnname=XXX AND M...a) ONM. columnname_join=N. columnname_join left_tableright_table right_tableNULLb) ONright_table. columnname=XXXright_table NULLc) WHERESELECT M.columnname,N.* columnname..FROM left_table M LEFT JOIN right_table NON M. columnname_join=N. columnname_join AND N. columnname=XXX AND M.columnname=XXX ; 17. MYSQL 18. MySQL SQL DBA DBA20% DBA 19. 20. &