Shulou(Shulou.com)06/01 Report--

Today (2017-8-27) start to rewrite the technology blog and do a brief review. It has been ten years since I graduated in 2007. At the beginning, I was engaged in other industries, with software development as a sideline. Later, he came to Jinan to engage in professional software development and moved to Qingdao for 11 years. Roughly speaking, it has been the seventh year since I came to Qingdao, and I have worked in an environmental protection company, Hisense network technology and a smart city company. And then came to the current company, and officially started the operation and maintenance work.

Because the leader wants us to have multiple skills, and I am a developer, database optimization and even automatic operation and maintenance in operation and maintenance are all part of the work. In relational database, Oracle, as the leader of the industry, has no doubt in terms of performance and reliability. (Hisense uses oracle database) there is little difference in performance between MySQL and SqlServer, but because mysql supports the Linux platform at the earliest, openness is better. At the same time, there are several molding solutions for setting up a high-availability data center on Mysql. Therefore, in terms of cost and other considerations, Mysql is second only to Oracle database in relational database, while SqlServer condescends to explore the flower.

Due to extensiveness and familiarity, I initially wrote articles on Mysql design, deployment, operation and maintenance and automation, and wrote a series of articles on Mysql Cluster deployment and operation and maintenance when there was plenty of time.

The following is the progress plan of the article:

Mysql series-database design (expected to be completed in 2017-9-24)

Mysql Series-Database Design (1)-usage scenario of Relational Database

Mysql series-- database design (2)-- three paradigms of database design: lead out

Mysql series-- database design (3)-- three paradigms of database design: details

Mysql Series-- Database Design (4)-- example explanation

Mysql series-database operation and maintenance (expected to be completed from 2017 to 10-30)

Mysql series-- database operation and maintenance (1)-- introduction and installation of database version (details of chown and chmod)

Mysql series-- database operation and maintenance (2)-- database opening and closing (details on Kill)

Mysql series-- database operation and maintenance (3)-- several key parameters for the performance of the database (why the parameters do not take effect after setting)

Mysql series-- database operation and maintenance (4)-- simple monitoring database

Mysql series-- database operation and maintenance (5)-- selection of remote tools and SSH tools (gossip)

Mysql series-Mysql Cluster operation and maintenance (time schedule to be determined)

Mysql series-- Mysql Cluster operation and maintenance-- Mysql Cluster theory explanation

Mysql series-- Mysql Cluster operation and maintenance-- Mysql Cluster installation

Mysql series-- Mysql Cluster operation and maintenance-- Mysql Cluster parameter configuration

Other series are expected (schedule to be determined)

NoSql series

Ceph series

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.