MySQL from getting started to mastering the video course "Salary Essentials"

From the zero-based learning MYSQL/MARIADB database, to add points to our Linux operations, every successful man has a support behind her, and every NB has a MySQL support behind the architecture.

1, mysql/mariadb numberIntroduction to Library Introduction This set of courses will be with you to learn MySQL mainstream database, for our operation and maintenance technology add points, let us better maintain the site inside our enterprise. MySQL is a small open-source relational database management system, the developer of the Swedish MySQL AB, currently belonging to the Oracle company, MySQL is widely used in small and medium-sized web sites on the Internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database. 2. MySQL database daily operation Command as an OPS SA, how much do we need to know about MySQL? We should learn from the early stage, the best way is to toss, as the saying people do not toss the youth, the same MySQL also need we continue to practice, so as to deepen our impression, deep buried in our minds. Through this course of learning, we can master the most classic MySQL command in the enterprise inside the operation, really do it. 3, MySQL database backup script writing we use the previous part of the study, today to backup MySQL, write an automated backup script, in our real environment, MySQL database is very important, the data is the survival of the enterprise, all of us to do a backup mechanism, regular backup of our MySQL data, This course will work with you to write a MySQL backup script. 4. mysql Setup UTF-8 Ultimate method and password hack in the MySQL database, we inserted the Chinese usually encountered a variety of garbled problems, how to solve it? How to completely eliminate the problem of character garbled, this course will be with you to practical operation. Describes how to modify the MySQL character set to UTF-8. At the same time this course also explains how to crack password, if our server database password forgotten how to do it, how to find back, this lesson will give everyone the answer. Let everyone know more about MySQL. 5. Use MySQL to build WordPress and Discuz forum under Linux Linux+apache+mysql/mariadb+perl/php/python A group of open-source software that is often used to build dynamic Web sites or servers is itself a separate program, but because it is often used together, it has a higher degree of compatibility, Together make up a powerful Web application platform. With the booming of the open source, the three pillars has been developed with the development of Java EE and. NET commercial software, and the software-developed project has a low cost of investment in software and is therefore of concern to the entire IT community. 6. MySQL Remote Tools management and import This course will bring you a new tool that allows us to better manage our MySQL database in our daily business operations and better manage our MySQL database through a graphical interface. We can make the data to be added and checked, to carry out various operations, at the same time can import and export various forms of file format, good backup. 7, using xtrabackup backup and restore MySQL data one This course will introduce you to a very popular tool xtrabackup, which backs up big data in the enterprise and is more efficient and reliable. We will be fully learning how this tool compares with mysqldump tools in the enterprise, while simulating real cases such as backup, delete, and recovery. 8. Use Xtrabackup to back up and restore MySQL data two every one of us in the operation of the work in time to pay attention to the site data backup, especially to pay attention to the database backup. That now has the problem, if our database data on hundred g, or even on the T level, if to back up, today I only give you a copy of the Hundred G data, oh, T-level if you have the opportunity to contact, of course, that level of backup method may have other new ways oh. 9, MySQL database master-slave principle detailed MySQL Database master-slave replication in the enterprise is the most use of a structure, you can say with the database company, as long as a little size will use MySQL master-slave architecture, all we need to understand the principle of master and slave, and be able to master the entire process. A timely resolution of any failures, quickly recover our database. MySQL master-slave synchronization is actually an asynchronous replication process, in order to achieve replication first need to open the Bin-log log on master, the entire process needs to open 3 threads, respectively, the master open IO thread, slave open IO thread and SQL thread. 10. mysql Database master-slave architecture configuration MySQL Database master-slave replication in the enterprise is the most use of a structure, you can say with the database company, as long as a little size will use MySQL master-slave architecture, all we need to understand the principle of master and slave, and be able to master the entire process. A timely resolution of any failures, quickly recover our database. This course will work with you to practice MySQL master-slave architecture of the real environment, so that we can more proficient understanding of MySQL master and slave architecture original   11, simulated MySQL master-slave failure and data recovery MySQL Database master-slave replication in the enterprise is the most use of a structure, you can say with the database company, as long as a little size will use MySQL master-slave architecture, all we need to understand the principle of master and slave, and be able to master the entire process. A timely resolution of any failures, quickly recover our database. This course will be followed by a variety of cases to simulate the MySQL master-slave architecture in the enterprise's various error solutions, really let us learn how to solve problems, the application of knowledge to practice. 12. Use Binlog log to recover MySQL data quickly Bin-log is to back up data by recording binary files and then recovering data from a binary file to a certain time period or to an operation point. To put it simply, Bin-log is the process of logging SQL statements, just like normal log. However, it is only binary storage, and normal logs are stored in decimal. 13, MySQL engine MyISAM and InnoDB explanation The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method, which has indexed sequential access methods, It is a standard way to store records and files. Not transactional security, and foreign keys are not supported, and if you perform a large number of select, MyISAM is more appropriate. 14. MySQL database index and slow query explanation The MySQL index is used to quickly look for records with specific values, and all MySQL indexes are saved as B-trees. If there is no index, MySQL must start scanning all records of the entire table from the first record until it finds a record that meets the requirements. The higher the number of records in the table, the higher the cost of this operation. 15, MySQL database efficient optimization analysis MySQL optimization is a very important work, and is a long-term work, there was once a DBA predecessors said: MySQL optimization, three-point configuration optimization, seven-point optimization of SQL statements. MySQL optimization: generally divided into configuration optimization, SQL statement optimization, table structure optimization, index optimization, and configuration optimization: generally include the system kernel optimization, MySQL itself configuration file optimization. 16. mysql efficient architecture read/write separation configuration with the increasing number of visits, based on the original MySQL master-slave architecture, all operations are done in the Lord, which will inevitably cause the main server pressure is very large, so in order to reduce the master read and write, we need to read and write, separate the architecture is: The Lord is responsible for writing, from the reading, so separate, Will put a lot of pressure on the primary server. Through this class, we can operate the enterprise MySQL master-slave separation architecture. 17. Mysql+keepalived High-availability architecture after MySQL master-slave configuration is complete, then configure the Keepalived service, mainly for MySQL fault automatic switching. So what is it about keepalived,keepalived? Keepalived is a software similar to the Layer3, 4 & 7 switch, which is what we normally call the 3rd, 4th, and 7th layers of exchange. 18. Mysql+drbd+keepalived High-availability architecture

DRBD (Distributedreplicatedblockdevice) is an open-source software that synchronizes and mirrors data directly on the remote server at the block device level, similar to RAID1 data mirroring, usually in conjunction with keepalived, Heartbeat and other HA software to achieve high availability.

MySQL from getting started to mastering the video course "Salary Essentials"