Programmer Group

ProxySQL cluster Experimental environment informationMySQL master-slave information IP 1 role 188.188.0.68 Node1 188.188.0.69 Node2 188.188.0.70 Node3 ProxySQL service node IP 1 role 188.188.0.68 Node 68 188.188.0.71 Node 71 ProxySQL version: 2.0.3-29-g00f26d5 1, ProxySQL service installation Install the same version of P ...

MGR multi main mode configuration load balancing Experimental environment informationMySQL master-slave information IP role 188.188.0.68 Node1 188.188.0.69 Node2 188.188.0.70 Node3 ProxySQL version: 2.0.3-29-g00f26d5 >>>Server and user configuration<<< 1. Add backend database server Admin> SELECT * FROM mysql_s ...

14_ProxySQL_Configuration Note: during the writing time of the article from April 201904 to may 201905, subsequent official updates in github were not written ~~How to configure proxysql in the simplest way This simple HOWTO describes how to configure some components of ProxySQL step by step. Note, however, that this is not a complet ...

1. Generate the wlfullclient.jar required by the data source wlfullclient.jar generation method Enter weblogic's installation directory For example E:\tools\weblogic\wls12213\wlserver\server\lib  Operation java -jar wljarbuilder.jar You can generate the wlfullclient.jar file 2. weblogic configuration data source Basical ...

In this lesson, we mainly introduce the entry program of Flink and the implementation of SQL form. In the last lesson, we have explained Flink's common application scenarios and architecture model design. In this lesson, we will start from a simple WordCount case and implement it in SQL mode at the same time, laying a solid foundation for the l ...

Too much data is being generated every day. Although sometimes we can use tools such as Rapids or parallelism to manage big data, Spark is a good tool if you use TB level data. Although this article explains how to use RDD and basic Dataframe operations, I missed a lot when using PySpark Dataframes. Only when I need more functions can I read an ...

background In the high concurrency scenario of the Internet, there will be a lot of requests, but the database connection pool is relatively small, or the CPU pressure and processing logic need to be reduced. It is necessary to change a single query to batch query multiple and return. For example, in Alipay, query "personal information&quo ...

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 ...

Someone said,'Python can do everything from nurturing sisters to dressing up x, except it can't have children!Anything will do!" Download video?I use Python; Play a jump?I jumped to 4999 with Python; Sister?Still using Python; Grab red bags for train tickets?Yes, it's Python. Even if I'm sorting out files, I'll use Python... Here are so ...

Introduction to L1 cache In the process of application running, it is possible for us to execute multiple SQL queries with the same query conditions in a database session. MyBatis provides the scenario of optimizing the first level cache. If the SQL statements are the same, the first level cache will be hit first, so as to avoid directly queryi ...