mysql dba certification

Tags: database mysql DBA Management ServerOriginal: http://www.techxue.com/techxue-11898-1.htmlToday, the responsiveness of Web applications is one of the keys to success. It interacts with users, users of the site's views, and even the Google site rankings have an inseparable relationship. Database performance is one of the most important factors in response speed, and in the event of an error, all program

number of records, of which: *-S indicates the sorting method. c, t, l, and r are sorted by the number of records, time, query time, and number of returned records, ac, at, al, and ar indicate reverse descriptions; *-T indicates the top n, that is, the number of previous data records returned; *-G, followed by a regular expression matching mode, which is case insensitive; For example /Path/mysqldumpslow-s r-t 10/database/mysql/slow-log You can obta

Tags: blog http using os strong data AR ArtAs a MySQL DBA, you must have the following qualities:First, physical fitnessThe DBA must receive and process various alarms, whether at noon or at three o'clock in the morning, into deep sleep. Received the alarm need to immediately enter the emergency state, find the computer, connected network, quickly locate the caus

synchronization Configuration2. Mysql dual master Configuration3. Configure high-availability databases for Mysql dual master + cluster database + keepalivedClientAs a DBA, do not use various GUI tools. mysql comes with the command line client, which is your best weapon.Optional1.

MySQL databases can be said to be one of the most common and common databases for DBAs. The wide application of MySQL also adds more people to the ranks of them. The following are some of the most common and frequently used MySQL Databases summarized by the old MySQL DBA! I.

MySQL databases can be said to be one of the most common and common databases for DBAs. The wide application of MySQL also adds more people to the ranks of them. The following are some of the most common and frequently used MySQL Databases summarized by the old MySQL DBA! I.

The MySQL database is one of the most common and commonly used databases of DBAs, and the extensive application of MySQL has also allowed more people to join in learning it. Here are some of the most common and commonly used experiences and techniques shared by the MySQL DBA, which is summarized by old

database 6.1 Delete database LinzhongniaoThe boss of the company at 10 o'clock in the morning, the DELETE database statement was executed. And then, like all the others, I wanted to delete a library that was useless. mysql> drop database linzhongniao; Query OK, 1 row affected (0.11 sec)6.2 Checking for damage resultsLinzhongniao Library is missing. mysql> show databases; +--------------------+ | Database

Xtrabackup------ Necessary tools for MySQL DBA Note: 1) Documents Reference http://www.percona.com/docs/wiki/percona-xtrabackup:start 2) mysql version 5.1.50 or later. 1. Introduction and installation of Xtrabackup 1. Xtrabackup is an open-source project of percona. It supports hot backup of innodb, XtraDB, and MyISAM (locks tables). It can be seen as a free alte

The CREATE DATABASE statement creates a DB with the specified name on the MySQL instance, and when the created database itself exists and does not specify an if NOT EXISTS clause, the statement creating the database will error. The created database creates a directory of its own files in the same directory as the data file, which is used to contain the table files that are created later. Of course, you can also create a folder in the data directory th

Today after work received a database monitoring sent by the alarm message, the contents are as follows:Server monitoring System DBA monitor V1.0-------------------------------------------------------Alarm server: **************Alarm Host Name: **************:3306-------------------------------------------------------Alarm time: 2017-10-20-11:10:03-------------------------------------------------------Alarm content:materid-185:

Tags: payment method must be secure root federated contains DBA development languageFirst, what is MySQL? MySQL is a relational database management system, where relational databases store data in different tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility.MySQL is open source, so you don't h

logs before the failure.The main need to master: Mysqlhotcopy and Manual hot backup method.The load data infile is the fastest way to load a database.41) How to handle table corruption of the MyISAM storage engineA. Repair with MYISAMCHK-R tablenameB. Checking the table for damage by first using the check table nameUse the repair table name to fix the tableThere's a little bit behind .... To be continued, in fact my exclusive lock and shared lock There is still confused Ah, and the master and s

database:Create DATABASE IF not EXISTS hncu CHARACTER SET UTF8; 2. Create a table:Use Hncu;CREATE TABLE IF not EXISTS stud (ID int,Name varchar (30),Age int); 3. Change the table structure (set constraints)DESC Stud; View table StructureALTER TABLE stud drop column age;ALTER TABLE stud add column age int; 4. Delete a table, delete a databasedrop table stud;Drop database Hncu; Ii. DML (Data manipulation language, manipulation Language)Mainly refers to the deletion and modification of data: Selec

Label:L009-oldboy-mysql-dba-lesson09 mysql> Grant Replication salve,replication client on * .'Repl_user'@'10.0.0.%'identified by'Testpassword'; Mysql>flush privileges;

| 24 | java |+----+-----------+-----+-------+3 rows in set (0.02 sec)mysql> delete from student where name=‘lisi‘;Query OK, 1 row affected (0.01 sec)mysql> select * from student;+----+-----------+-----+-------+| id | name | age | dept |+----+-----------+-----+-------+| 1 | zbf666| 29 | linux || 4 | woshishei | 24 | java |+----+-----------+-----+-------+2 rows in set (0.00 sec)(3) You can also dele

/mysql.sock B. Configuring sync parameters from Library change mastermysql> CHANGE MASTER TO -> MASTER_HOST=‘192.168.1.115‘, 主库的IP -> MASTER_PORT=3306, 主库的端口，从库端口可以和主库不同 -> MASTER_USER=‘rep‘,主库上建立的用于复制的用户rep -> MASTER_PASSWORD=‘123456‘, 这里是rep的密码 -> MASTER_LOG_FILE=‘mysql-bin.000036‘,这里是show master status;查看到的二进制日志文件名称注意不能有空格。 -> MASTER_LOG_POS=335;这里也是show master status时看到的二进制日志偏移量注意不能多空格。C. Turn on the sync switch from the library to view the sync

Label:L013-oldboy-mysql-dba-lesson13 V:f eqn= "sum 0 0 @1" > /v:f>

First, the command line modeMySQL [(none)]> show databases; #未选择数据库前，显示（none）表示在数据库跟路径下+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || viewtest |+--------------------+5 rows in set (0.02 sec)MySQL [(none)]> use viewtest; Database changedMySQL [viewtest]>

one.Application scenarios and differences of Heartbeat and keepalived(1) for the general web, DB, load Balancing (nginx,haproxy), and so on, heartbeat and keepalived can be achieved.(2) LVs load Balancing and keepalived combination, although heartbeat can also invoke a script with ipvsadm command to start and stop the LVS load balancer, but heartbeat itself does not have the RS check function, This flaw can be remedied by Idircetord plugins.(3) High-availability services that require data synch