Programmer Group

13. Clickhouse support for proxysql configuration Note: during the writing time of the article from April 201904 to may 201905, subsequent official updates in github were not written ~~ClickHouse Support 1, Preface ProxySQL support for ClickHouse is still in the experimental phase and may change. 1. How to enable support for ...

Preface For a long time, the mastery of linux is the state of half bucket of water. Usually, you can load something from yum and rely on a bunch of things as a result. Then you can load something from the source code. You only know make and make install. What's behind it is unclear and it's inconvenient to unload. These days, I need to write ...

Spring cloud Alibaba Chapter 12, upgrade, service registration and configuration center Nacos 1, Why spring cloud Alibaba 1. Why With the micro service framework of spring cloud, why do you want to use the framework of spring cloud alibaba? The most important reason is spring Almost all components in the cloud use Netflix products, and ...

System Library _03_stats Library for 09_ProxySQL Configuration Note: Subsequent official updates to github were not written between 201904 and 201905~~Statistics] Stats library [The stats database] This database contains indicators for data collection of ProxySQL's internal capabilities.Here, you'll find information about how often certain cou ...

background Before that, Lao Huang wrote an article "ASP.NET Core combines with Nacos to complete configuration management and service discovery", which briefly introduced how to connect. NET Core programs to Nacos. In the previous SDK, more open APIs of Nacos were encapsulated and service registration and discovery were encapsulated. ...

Common error reporting functions ##1. floor() Get database mysql> select count(*),(concat( 0x3a,database(), 0x3a,floor(rand()*2))) name from information_schema.tables group by name; Get table name mysql> select count(*),concat(0x3a,0x3a,(select table_name from information_schema.tables where table_schema=database() limit 3,1), ...

1, Date and time functions 1. Function to get the current dateIt's the same. It's different CURDATE(): used to get the current date of the systemCurrent "date() is used by the system to get the current date mysql> select CURDATE(),CURRENT_DATE(); 2. Get function of current time CURTIME(): used to get the current time of the system ...

In the last few interviews, I encountered the problem of left-right connection. I will review it here. Let's show the results of the left and right connections in the following two tables Left connection and right connection Employee table: mysql> select * from employ; +-----------+------+------+ | name | id | sal | +----------- ...

2020-03-29 20:00:27   1, Error message Recently, the project implementation colleagues upgraded the system and changed a field of test.test tab. The SQL statement is as follows: ALTER TABLE TEST.TEST_TAB_T1 MODIFY BXXX VARCHAR(200); After the system upgrade of the project, the MySQL master-slave synchronization er ...

One view atlas and the use of routing Using the view set ViewSet, you can place a series of logically related actions into a class: list() provides a set of data retrieve() provides a single data create() create data update() to save the data Destroy() delete data The ViewSet view set class no longer implements methods su ...