(turn) Linux operations will be MySQL enterprise face question

Linux operations must be MySQL Enterprise face questionsOld boy education operation and maintenance class all students MySQL will be enterprise face test

The most practical, the most meticulous, the most landing training base, the old boy education for many years in the domestic average employment wages the highest!

The importance of the database is the most important in all technologies (understanding the principle, and can be clearly expressed in the interview), directly determine the salary of the OPS staff!

All the questions should give a professional solution, not the kind of general solution of the water.

Interview Question 001: What is MySQL multi-instance, how to configure MySQL multi-instance?

Interview Question 002: How to enhance the security of MySQL data, please give a feasible idea?

Interview Question 003: The Enterprise MySQL root password forgot how to solve, multi-instance password forgot how to solve?

Interview Questions 004:mysql Library authorized Oldboy User Management BBS Library all tables, 172.16.1.0 entire network segment access, password is 123456, please give detailed command (no less than 2 methods)?

What is the difference between an interview question 005:delete from Test and a truncate table test?

How is the SQL statement for the interview question 006:mysql optimized? Tip: Pay attention to the height and width of the question

Interview question 007: The website opens slowly, please give the troubleshooting method, if is because the database is slow, how to troubleshoot and solve, please analyze and example? Tip: Pay attention to the height and width of the question

Interview question 008:mysql How to solve the sleep thread too much?

Interview question 009:key_buffer_size parameter function, how to modify this parameter does not restart the database can take effect?

Interview question 010:What is the working mode of MySQL Binlog? What are the characteristics of each enterprise, how to choose?

Interview 011: The operation of the database was mistakenly executed a deleted SQL statement, how do you fully recover the lost data? Tip: Pay attention to the height, width and actual combat of the problem.

Interview question 012: in the Enterprise mysqldump Backup uses the-a-b parameter, how does the Single form library restore at this time?

Interview question 013: detailed MySQL master-slave synchronization principle and configuration Master-slave complete steps.

Interview 014: Production scenes are not locked in the main library, do not operate at night, how to easily batch creation from the library during the day? Tip: Pay attention to the height and width of the question

What are the reasons for the synchronization delay of the interview question 015:mysql? How to solve? Tip: Use the experience of the production case framework to answer.

Interview 016: How to design a backup solution for the MySQL cluster architecture of enterprise production? How did you do it?

How your database is backed up (please answer the 200 server-scale enterprise database backup solution)
Tip: Pay attention to the height and width of the question

Interview question 017:mysql master-slave replication failure how to solve? How do I monitor master-slave replication failures? Tip: Pay attention to the height and width of the question


Interview question 018:mysql How to realize two-way mutual main from copy a<==>b?


Interview question 019:mysql How to achieve cascade synchronization a-->b-->c?


Interview questions 020:mysql how the database can be read/write separated, how your company is implemented (please answer 200 servers above the size of the Enterprise database solution)


Interview 021: Production scenarios, a master more from the environment, from the library down, how do you recover?

Interview 022: Production scenarios, one master more from the environment, the main library down, how do you recover (similar to the MHA high availability principle), note: Height and width

Interview 023: What are the transactions of the database and what are the characteristics of the transaction?

Interview 024: Explain what the acid in the database means?

What are the commonly used engines for interview questions 025:mysql? How do I bulk change the engine of a table in the enterprise?

Interview question 026:What are the characteristics and differences between the MyISAM and the Innodb database engine, and how is the Enterprise selected ?

Interview 027: How to adjust the character set of MySQL database in the production line, for example: change from UTF8 to GBK, please give complete steps.

Interview 028: Please describe the MySQL Chinese data garbled behind the principle, and work on how to prevent database data garbled?


Interview question 029: How to optimize the production of MySQL in the enterprise?

Interview questions 030:mysql clusters and high-availability scenarios, what scenarios have you used to reproduce the scenario? Tip: Pay attention to the height and width of the question

Interview 031: You maintain the Enterprise MySQL service architecture can say?

Face question 032: How to divide the database and batch recovery (oral script implementation process)? This topic has video to share for free, find a consultant to get.  

Face question 033: If the database Main library is self-oldboy, the statement, how to recover data, please give detailed procedures, and design to avoid accidental deletion of the scheme (has been used mysqldump did a full preparation, And the Binlog log is turned on). Tip: Pay attention to the height, width and actual combat of the problem.

Face question 034:  If the database main library is self-update  oldboy set name= ' Gongli '; statement, how to recover data, please give a detailed procedure, and designed to circumvent the accidental deletion of the scheme (has been used xtrabackup made full standby (200g+ data), and a number of incremental backup, and opened the Binlog log). Tip: Pay attention to the height, width and actual combat of the problem.

Answers to the above questions: see http://user.qzone.qq.com/49000448/blog/1415696007 Course

=================== the following sections have free video tutorials to provide ==================
Below the basics of MySQL Foundation, but also the entry must be content, add old boy education customer service get qq:41117397 41117483 70271111 80042789 or join the official group Inquiry 08 Group 384467551 07 Group 145178854(marked 51CTO) ==================================================================================

█ Exam questions: Old boys Education 12th MySQL must be basic command inspection

(Requirements: Each of the two students a group, a verbal test, a on-machine Combat Answer every 5 A group entitled, after completion of transposition)

1. Log in to the database.

2. View the database version and what the current logged-on user is.

3. Create a database Oldboyfor the GBK character Set and view the complete statement of the built library.

4. Create user Oldboyso that it can manage database Oldboy.

5. See what permissions the user Oldboy has created.

6. See which users are in the current database.

7. Enter the oldboy database

8. Create a innodb engine character set for GBK table test, field ID and namevarchar (+), View the build table structure and SQL statements.

9. Insert a piece of data 1,oldboy

BULK Insert Data 2, old boy,3,etiantian. The requirement of Chinese cannot be garbled.

Query All the records that were inserted, and query for records with the name Oldboy . A record with a query ID greater than 1 .

Oldboy Change the name of the data ID equal to 1 to oldgirl.

Insert the Age field before the field name , type tinyint (2).

back up the Oldboy Library and MySQL Library.

Delete all data from the table and view.

Delete the table test and Oldboy database and view

The 17.Linux command line recovers the data deleted above.

Modify the GBK character set to UTF8(optional, note that the problem has a trap).

19.MySQL Password lost, how to find the actual combat?

MySQL in the Chinese data garbled principle and how to prevent garbled? (optional).

set the ID column as the primary key and create a normal index on the Name field.

Insert the phone number field (Shouji)after the field name , type char (one).

2 records inserted on all fields (self-setting data)

Create a normal index on the phone field for the first 8 characters.

View information such as index and index type created.

Delete the index of Name,Shouji column.

set up a federated index on the first 6 characters of the Name column and the first 8 characters of the phone column.

Check the phone number starts with 135 , the record with the name Oldboy (this record is inserted in advance).

Query the execution plan for the above statement (whether to use a federated index, etc.).
30. Change the engine of the test table to MyISAM.

(turn) Linux operations will be MySQL enterprise face question