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

Hot information

1. China Institute of Information and Communication issued the White Paper on the Development of Cloud Computing (2020), authoritatively interpreting six new trends.

[abstract] on July 29th, the 2020 trusted Cloud Conference opened online. The China Academy of Information and Communications issued the White Paper on the Development of Cloud Computing (2020). The white paper reveals that based on the long-term observation and research of the cloud computing market, the China Institute of Information and Communication has summarized six key words and important trends behind the development of cloud computing in 2020.

2. GoldenDB helps CITIC Bank "Lingyun" system successfully put into production to achieve a "new financial engine".

[abstract] recently, ZTE Corporation and CITIC Bank jointly announced that GoldenDB distributed database has successfully completed the production of CITIC Bank's "Lingyun" system and has been running steadily since it was put into production for nearly three months, comprehensively verifying the safety and reliability of GoldenDB as a domestic financial-level transactional distributed database, and consolidating CITIC Bank's leading strength in the digital transformation of the domestic financial industry.

3. China Mobile conducts large-scale collection of domestic databases for the first time to welcome the 5G era.

[abstract] on July 15, 2020, China Mobile announced the bid winning announcement of the joint innovation project of OLTP independent controllable database, which is expected to purchase 1500 sets of databases and services. Nanjing University General Motors, National people's Congress Jincang, Aliyun, Wanli Open Source and ZTE are on the list. China Mobile's demand for pure localization of database services reflects China Mobile's determination to promote the independent control of the database, and is also an important signal for the industry to launch a large-scale and omni-directional landing.

4. Half a year review of the database: calm abroad, strong momentum at home!

[abstract] on the 1st of each month, we will rank the database of the month in which the ink wheel is released. This article will make a brief review of the development of domestic databases in the past half a year through some figures and some news events in the ranking of Motian wheel database. The scores of Oracle, MySQL and SQL Server, which have occupied the top three for a long time, have declined, while the three open source databases, PostgreSQL, MongoDB and Redis, have grown slightly, and almost all domestic database products have shown a trend of growth.

Selected articles

1, Mo Tianlun half a year technical hot article selection, learning database, domestic open source business all in one net!

[abstract] this article selects the technical hot articles of Mo Tianlun in the first half of the year (2020.1.1-2020.6.30) to see what everyone is concerned about. I hope it will be helpful to you. Analysis of 1.Oracle basic data type storage format-- RAW type 2. Fault diagnosis analysis of database server host restart 3. Blackmail virus appeared in many hospitals during the epidemic. I suggest you investigate and rectify it.

2. Record the failure caused by begin backup

[abstract] received customer feedback, a set of 19C CDB database, storage replacement HBA card, can not get up, OPEN prompt the need for media recovery. ORA-10873 is reported here, and it is later determined that begin backup has been done for a certain tablespace. The final solution is that bbed modifies the checkpoint information on the file header, and then applies the archive in recent days to the latest status, open resetlogs, and finally 0 data loss recovery.

3. 3 points for attention in MySQL8.0 installation and deployment

[abstract] this paper collates the three most typical problems in the installation and deployment of MySQL8.0 and their solutions. Error message encountered when ssl is turned on ERROR 1045 (28000); in MySQL 8.0, caching_sha2_password is the default authentication plug-in, not mysql_native_password; case-sensitive. The table name is stored as a given size and comparison is case-sensitive.

Daily Management: Oracle Network (5)

[abstract] this paper mainly describes the network service model: proprietary mode and sharing mode. Proprietary service mode: each client process corresponds to a server process; shared service mode: a small server process pool can serve a large number of clients. Also shared related: SGA and PGA, scenarios where you can't use a shared server, cross-library access, exercises.

Practical information document

1. White Paper on Cloud Management Services (2020) .pdf

[abstract] this white paper, issued by the Open Source Industry Alliance of Cloud Computing, first gives the connotation of cloud management services, and combs the development status of cloud management services from the aspects of key elements, major service providers and products, and market conditions. then it summarizes the development characteristics of cloud management services, and introduces the application practice of cloud management services in typical industries, and finally puts forward the future development trend of cloud management services.

2. "ORACLE-based SQL optimization from a SQL"-Ding Jun. pdf

[summary] this document shares content brief introduction: start with a very slow SQL; quickly interpret the execution plan; look at the root causes of SQL inefficiency from the execution plan; statistics and cardinality; explore performance killer filter; logic rewriting let SQL take off; two tools to improve the efficiency of difficult SQL optimization; Roadmap;SQL Turning best practices for SQL Turning thinking.

3. "introduction to database service connection layer-easy whale" .pdf

[abstract] EsgynDB is a mature RDBMS product, this document sharing will focus on the design principle and operation and maintenance of the database connection service layer. For operation and maintenance engineers, this sharing will also introduce common problem analysis and troubleshooting skills to improve the efficiency of operation and maintenance.

4. Open source database security management .pdf

[abstract] this article shares the following contents: Overview of data security system, database security technical framework, database security operation standards, database security planning process, MySQL security operation and maintenance (introduction of audit process, operation flow, backup and recovery process, system system, common open source database security settings).

Check out more previous issues [Database Weekly]

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.