basic Knowledge
1.mysql compilation installation
2.mysql 3rd party Storage Engine Installation configuration method
3.mysql mainstream storage engine (Myisam/innodb/memory) features
4. String encoding knowledge
5.MySQL user account Management
6. Data backup/Data in export
7.mysql supported basic data Types
8. library/table/field/index creation/modification/deletion
9. Basic SQL Syntax: select/ Insert/update/delete, master the most basic grammar can, what inner join,left join understanding on the line MySQL application scenarios are mostly high concurrent access/business logic is simple, join/subqueries/views/triggers are basically not
10.sql aggregation query: Group by/having
11. How to optimize queries with explain analysis
12. Common SQL Optimization Tips
a). Select xx from YYY limited ...,
B). Order B Y random
C). Select COUNT (*) from
13. Various show xxx instructions, about 20 kinds, each try to use the
14.show VARIABLES, about 240 items, read by article, can be printed out on the wall
Advanced Actions
1.Mysql master-Slave synchronization configuration
2.Mysql Dual master configuration
3.Mysql dual master+ Concou +keepalived Configuring a highly Available database
client
as a DBA, be sure not to use a variety of GUI tools, MySQL comes with command line client is your best weapon
optional
1.mysql partition configuration, Because there are too many restrictions, the actual sub-table is the program to do
2. High performance MySQL
a). Drizzle
B). MariaDB
C). Handlersocket, blow the play, the actual work is also very difficult to use, because performance is never a problem, all the use of a variety of "Kit Kat Kinky Technology" project, is bound to be a sinkhole, the people are happy to hear the products are honest use of the simplest simple technology implementation
OK, after 20 days of learning, you will be competent for the mainstream Internet company MySQL DBA work
Spit a groove, I recruited a lot of Dba,mysql DBA's work knowledge that's all, other DBAs are similar, look at the operation again you learned, basically no IQ. The so-called billions of users of the vast amount of computing, which is just an experience, you are on the scene you will have. The DBA is just a "watchdog" role: something can be called to find someone, an accident someone can be fined, nothing on the side to cool off.
The internet makes the cost of acquiring knowledge more and more low, the database more and more like a common software, you have seen the browser, office needs to be operated by someone?
So, the DBA is not a career that can carry dreams, if young people want to develop in the technology field, want to "change the world", honestly write code when programmers go
Mysql DBA Tutorial Learn video sharing2015, to a learning journey anytime, anywhere
Start my career MySQL learning Tour
Can't miss the journey I've won
Willful is to ask, ask
Who's your group chat buddy
I'm the master of Learning
Teacher Online answer and ask
Career Introduction--Database basics and installing MySQL
MySQL Course Introduction
Instructor Interview
Gain insight into what a database is
MySQL stands out from thousands of databases
Choose which version of MySQL to learn
Build an experimental environment for learning MySQL
Familiarize yourself with the MySQL environment in advance
Install MySQL under the official Yum source under Linux
Linux under the official source package installation of MySQL and source code installation parameters of the instructions
Linux under the official source package installation of MySQL and source code installation parameters of the instructions
Build a custom MySQL RPM package based on the official source RPM package under Linux
Intermediate Pilot--mysql Index
The concept of an index
Creation and deletion of indexes
Index Performance Test
Advanced Guide--mysql Replication
About MySQL Replication
The principle of MySQL replication
1-what kind of company need to use MySQL?
Gain insight into what a database is
MySQL stands out from thousands of databases
2-Build an experimental environment for learning MySQL
Choose which version of MySQL to learn
Build an experimental environment for learning MySQL
Familiarize yourself with the MySQL environment in advance
Install MySQL under the official Yum source under Linux
Linux under the official source package installation of MySQL and source code installation parameters of the instructions
Linux under the official source package installation of MySQL and source code installation parameters of the instructions
Build a custom MySQL RPM package based on the official source RPM package under Linux
3-mysql How to ensure the consistency of the company's multi-user access and data
Understanding the architecture of MySQL
concurrency control for MySQL
Introduction to MySQL Lock
4-How to choose the right data type storage to meet your company's different business needs
MySQL data type
How to store a type with decimals
MySQL date and Time type usage
MySQL String type
MySQL Other string types
How to choose the right data type to store different data
5-How to meet different business needs of the company
Operation of the database
6-How to create a table for your company's business
What is a database three-paradigm
How to manage a MySQL table
How to add a constraint when creating a table
Uniqueness constraints and the use of default constraints
How to modify a data table
7-How to manage company business data
MySQL Data manipulation
8-How to speed up the retrieval of company business data
The concept of an index
Creation and deletion of indexes
Index Performance Test
9-How to quickly locate the company business data you want to query
Multi-condition query of MySQL single-table query
A group query of MySQL single-table query
Querying using Aggregate functions
10-mysql Multi-table query to implement different business queries of the company
MySQL Multi-table query
MySQL multi-table Query sub-query
11-How to use views to protect data security and reduce the complexity of SQL statements
MySQL View introduction
Basic operation of MySQL view
12-How to use triggers to reduce the workload of DBAs
The role of MySQL triggers
Create a simple trigger
To create a multiline execution statement trigger
Creating a trigger with while and repeat statements
Application of 13-operator in MySQL
Use of the MySQL operator
14-Functions help you simplify complex SQL
Use of common MySQL functions
MySQL process functions and custom functions
15-teaches you how to use stored procedures
MySQL Stored procedures Overview
How to write the definition of stored procedures and variables
MySQL stored procedure Loop statement
16-Create a single user for each application in the company
MySQL's permissions mechanism
Create users and how to authorize them
MySQL Permissions and password management
17-Keep your database in your fingertips
MySQL error log and common query log
MySQL Slow query log
MySQL binary log
MySQL binary log Application demo case
18-Backup to ensure company data is foolproof
MySQL Data backup Recovery overview
Install and use the MySQL Backup tool for the Community edition
MySQL-based backup of LVM snapshots
Case demonstration based on LVM backup data
Introduction to Mylvmbackup Tools
Third-party backup tool xtrabackup for full backup and recovery
Third-party backup tool xtrabackup for incremental backup and recovery
Third-party backup tool Innobackupex backup case
Backup tool mysqlbackup in enterprise MySQL for full backup and recovery
Backup tool mysqlbackup in enterprise MySQL for incremental backup and recovery
Enterprise MySQL Backup tool mysqlbackup for single file backup and recovery
A case of making and recovering a single file backup
How to revert to the most effective data after data loss
Data recovery and repair technology of 19-mysql
MyISAM storage engine and repair of corrupted or missing. frm files
Repairing a data table with the MYISAMCHK command
Implementation of MySQL Data deletion recovery without backup
InnoDB Storage Engine Detailed
Repair of InnoDB tablespace file corruption
Data Recovery case
20-mysql Replication realization of database fault automatic failover
About MySQL Replication
The principle of MySQL replication
MySQL Replication Solution Introduction
The construction of MSS
MySQL Replication based on Gtids
Why use Gtids-based MySQL Replication
How to improve replication performance
Replication capacity and Error logs
Replication Monitoring and automatic failover
Replication for automatic failover
Replication introduction and configuration of the dual master
21-How to get more and more data traffic is no longer a burden
MySQL Read and write Separation technology overview
Amoeba for read-write separation
Authorizing amoeba to access MySQL
MySQL read-Write Separation Technology summary
22-High availability to achieve the normal and stable operation of the company's services
MySQL High Availability overview
MySQL High Availability overview
How to implement MySQL high availability technology
Installation of pacemaker and Corosync
Configuration of Pacemaker and Corosync
MySQL High-availability recovery Demo
MySQL High-availability failure Demo
Implementation of dual-machine ha based on keepalived
Configuring Keepalived-based, dual-machine ha
A case of double-machine ha fault detection based on keepalived
23-How to improve the fault tolerance and high performance of the company database
MySQL Cluster overview
Automatic deployment of MySQL cluster
Configuration of MySQL Cluster
How to manage nodes for a MySQL cluster
MySQL Cluster third-party remedy method
24-sandbox for fast deployment of MySQL
MySQL Shahe technology Introduction
Quickly deploy a single MySQL instance using MySQL Shahe
Rapid deployment of replication environments using MySQL Shahe
25-How to optimize your company's MySQL database
Overview of ways to improve MySQL performance
Optimization of hardware
The impact of network configuration and operating system on MySQL performance
How to properly deploy MySQL and the use of MySQL performance analysis tools
MySQL configuration file optimization
How to evaluate MySQL's use of memory
Configuration of the InnoDB
Configuration of the InnoDB
MySQL SQL Optimization Overview
How to confirm a low-efficiency query
Use of MySQL SQL Basic Analysis command
Example of index optimization
Single-column index optimization
Fair use of Union INDEX
Use of multi-column indexes
Optimizing SQL statements with query hints
Application of 26-mysql partition
What is a table partition
Different types of partitions and cases
Sub-partitioning applications
Management and maintenance of partitions
The role of 27-mysql in the design of website architecture
The core of MySQL architecture design
Design of database architecture for small web site
Design of database architecture for medium Web site
Medium Web Site Database schema considerations
Design of database architecture for large web sites
Design of database architecture for super-large web site
28-mysql+key Value Database schema design
Mysql+key Value Key Database
Introduction and application of memcached and Redis
Implementation of memcached based on the official MySQL plugin
memcached Syntax Explanation
Adding a table to the memcached cache case
Construction and use of 29-percona
Construction and use of Percona
30-mysql Enterprise Monitor
MySQL Enterprise Monitor Introduction
MySQL Enterprise Monitor Installation configuration
Use of MySQL Enterprise Monitor
Despite the emergence of a database, the Oracle database in the RDBMS domain is still a coasting, and what is the advantage of it now? The Oracle database tutorials collected in this article will take you to the complete overview of Oracle Database performance optimization, disaster recovery backup for Oracle databases, and the daily work of Oracle DBA.
Oracle Tutorial Introductory article
Mysql dba 20-day Crash tutorial, dba outline
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
