[SequoiaDB] Tech | SequoiaDB SQL instance high available load balancing practice

1 Preface   In the application program, the IP address and port number of the database connected by the application configuration are fixed. When the server of the IP address is down, it needs to manually change the IP address to switch the database server. At the same time, when the application receives thousands of concurrent http requests ...

Posted on Tue, 24 Mar 2020 09:00:20 -0700 by vomitbomb

mariadb (data password management, user authorization, backup)

1. Database password management: Data password management; database password cracking. Experimental background When deleting the original mariadb database, please note that when deleting the service, the data will remain in the / var/lib/mysql / directory, and all files need to be deleted. a. Data password management mysqladmin -uroot -plee ...

Posted on Tue, 24 Mar 2020 07:40:30 -0700 by tonga

Python - MySQL of Python operation database

Python - MySQL of Python operation database (1) 1, About MySQL: MySQL is a relational database management system, developed by MySQLAB company in Sweden, which is a product of Oracle. MySQL is one of the most popular relational database management systems. In WEB applications, MySQL is the best RDBMS(Relational Database Management System, One o ...

Posted on Tue, 24 Mar 2020 06:00:01 -0700 by imurkid

mysql flash (update from time to time)

At the interview stage, you will basically ask some questions about mysql, and the specific advanced theory will be gradually supplemented later, but it is inevitable to brush the questions, and we will directly deliver the goods below Create / drop table and index series Create table CREATE TABLE if not exists `test_date` ( `id` int(11) N ...

Posted on Tue, 24 Mar 2020 03:51:47 -0700 by H4mm3r3r

Java Multithread concurrent 09 -- how to realize data sharing between threads and within threads

This article will bring you Java blocking queue related only. Pay attention to my official account "Java face code" to learn more about Java knowledge. Data sharing between threads The main way of multithreading communication in Java is to share memory. There are two main concerns of shared memory: visibility and order atomicity. Ja ...

Posted on Mon, 23 Mar 2020 05:48:08 -0700 by turkman

Three layer code annotation

U level namespace LoginUI { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnLogin_Click(object sender, EventArgs e) { //Obtain the account and password entered by the user and assign it to userName,password ...

Posted on Sun, 22 Mar 2020 08:56:49 -0700 by Zyxist

MySQL Data Backup and Restore

Accidents involving database deletion are now common, and the need for data backup is an extremely important task in enterprise data management.There are also many scenarios and methods for data backup and recovery, and several of the main tools in this series will be demonstrated through cases. This series will start with logical backup and re ...

Posted on Sat, 21 Mar 2020 19:44:50 -0700 by cobalt30

Prometheus monitoring series best practices

Prometheus is the second project graduated from CNCF after kubernetes. I also like this open-source monitoring platform for finding and predicting alarms through data indicators very much. Official words are not enough. According to the introduction of the official website, it has the following functions, but some brief summaries are not neces ...

Posted on Sat, 21 Mar 2020 10:40:50 -0700 by sarabjit

Spring boot uses mybatis plus form to update null value

Background of problem Use mybatis plus for database interaction. The default setting is to enable null without updating. After adding data, edit the page to clear the field value (date type, int type, in order to avoid the default value passing in, all model s are initialized to null with the packing type). Null value cannot be updated to the d ...

Posted on Sat, 21 Mar 2020 07:12:50 -0700 by kevin99

Install mysql8 on win10 and configure master-slave replication

Recently, I am studying spring boot, and I want to organize a blog about spring boot integrating mybatis and configuring the master-slave database. However, mysql master-slave database is not configured on the computer win10 system. So it took a few days to get it right. Record it here. The first step is to install two mysql8 on win10. I found ...

Posted on Sat, 21 Mar 2020 05:44:02 -0700 by elbowgrease