ProxySQL official file translation

20_Mirroring Note: during the writing time of the article from April 201904 to may 201905, subsequent official updates in github were not written ~~Mirroringbe careful:1) Its rules can be changed at any time;2) It does not support prepare statements; 1, Extensions to MySQL query rules Modify MySQL query rules table and add 2 columns:1) mirror_ ...

Posted on Tue, 28 Apr 2020 04:27:53 -0700 by Hebbs

Query Log for ProxySQL Official Translation_u 08_ProxySQL Configuration

Query Log for 08_ProxySQL Configuration Note: Subsequent official updates to github were not written between 201904 and 201905~~ 1. Query Logging ProxySQL can record the query statements that pass through it (all statements, collectively referred to here as queries).Logs are configured with query rules, which allow logging to become broader or ...

Posted on Mon, 27 Apr 2020 10:34:31 -0700 by PhilVaz

gorm series - create record and field defaults

Catalog Gorm create record and field defaults Establish Default Using pointer to save zero value into database Using Scanner/Valuer interface to store zero value into database Gorm create record and field defaults CRUD usually refers to the operation of adding, deleting, modifying and querying the database Establish package main import ( ...

Posted on Mon, 27 Apr 2020 08:46:32 -0700 by Vasko

gorm series - query

Catalog Gorm query General query where condition Normal SQL query Touch & map query Not condition Or condition Inline conditions Additional Query options FirstOrInit Attrs Assign FirstOrCreate Attrs Assign Advanced query Subquery Select field sort Number deviation Total Group & Having Connect Pluck scanning Chain opera ...

Posted on Mon, 27 Apr 2020 02:44:21 -0700 by jklanka

Sleuth link tracking of Spring Cloud series

With the popularity of microservice architecture, services are divided according to different dimensions. A request often involves multiple services. Internet applications are built on different sets of software modules, which may be developed by different teams, implemented by different programming languages, distributed in thousands of server ...

Posted on Sun, 26 Apr 2020 19:13:01 -0700 by clodagh2000

Elasticsearch series - data modeling practice

outline This paper introduces the characteristics of data modeling by different technical components in the background of practical cases, introduces the advantages and disadvantages of common joint query in the background of ES, and finally introduces the use of the file system word breaker path ﹣ hierarchy and nested objects. Data model comp ...

Posted on Fri, 24 Apr 2020 18:05:00 -0700 by markdr

Data sharing of Swoole multiprocess through Swoole\Table

Third party storage media Previously, we introduced the Process and Process\Pool modules based on Swoole to realize multi Process management in PHP. However, in the multi Process mode, processes are isolated from each other and cannot share data and variables. Even global or super global variables defined through global are only valid in their ...

Posted on Fri, 24 Apr 2020 05:42:16 -0700 by slewis1959

[open source]. NETCORE. Netframework xamarin uses ORM FreeSql to access MySql/Mariadb

1. Create project We use the console type project to test the insertion, deletion, update, query and other functions, create a console project, and use the command: dotnet new console dotnet add package FreeSql.Provider.MySql dotnet add package FreeSql.Repository 2. Create a solid model using System; using FreeSql.DataAnnotations; publ ...

Posted on Wed, 22 Apr 2020 07:05:10 -0700 by talltorp

Wayne - 360 open source multi tenant K8S management platform (introduction and installation)

Wayne is what I learned by brushing the article inadvertently. After simple use, I found that it can solve many current problems. For the reason of promoting the company's containerization process, I chose to start using Wayne. At present, all environments are in use. With the help of the official introduction Wayne is a general, Web-based Kub ...

Posted on Tue, 21 Apr 2020 19:06:35 -0700 by ROCKINDANO

MySQL installation tutorial of Docker series

MySQL installation tutorial of Docker series With the previous basic tutorial Common command operation manual of Docker series After that, this blog records a mysql installation tutorial mysql image query command docker search mysql Several key parameters are explained as follows: INDEX docker.io is the official website of docker NAME the NA ...

Posted on Tue, 21 Apr 2020 08:40:31 -0700 by mark_c