MySQL master-slave replication and read-write separation
catalogue
1, MySQL master-slave replication
1. Principle of master-slave replication
1. Replication types supported by MySQL
2. Working principle of MySQL master-slave replication
3.MySOL master-slave replication delay
4. Role of replication
2. Specific operation
1. Main server 192.168.68.200
2. From server 192.168.68.30
3. From serve ...
Posted by pella.d on Sun, 05 Dec 2021 05:04:57 -0800
Thread combat analysis of locating abnormal consumption under linux
preface:
I shared an article before Linux development coredump file analysis and actual combat sharing Today, let's share a practical article.
In our embedded linux development process, we often use multi process and multi thread development. In the process of multithreading, we may encounter that a thread occupies cpu for a long time, resulti ...
Posted by ted_chou12 on Sun, 05 Dec 2021 04:02:27 -0800
LVS / ipsadm mode and basic use
LVS
Article catalogDocker builds a simple LVS - dz45693 - blog Park (cnblogs.com)
Linux Virtual Server, Linux Virtual Server, mainly realizes soft load scheduling
1, Introduction
1.1 three working modes of LVS
NAT - network address translation NAT (Network Address Translation) refers to Network Address Translation. The requested data p ...
Posted by ParkerPHP on Sun, 05 Dec 2021 01:23:10 -0800
Linux Mysql advanced statement
catalogue
Linux Mysql advanced statement
1, SQL advanced statement
Import file to database
select
distinct
where
And and Or or
in
between
like wildcard
order by
function
Aggregate function
replace
concat
substr
group by
having
alias
join query
inner join
...
Posted by IchBin on Sun, 05 Dec 2021 01:11:11 -0800
Use of completion quantity in linux 3.10
The completion quantity is designed based on the waiting queue, so it is obviously impossible to use the completion quantity in the interrupt context.
struct completion {
unsigned int done;
wait_queue_head_t wait;
};
Let's take a classic example of using completion quantity:
struct kthread_create_info
{
/* Information passed to k ...
Posted by jasraj on Sat, 04 Dec 2021 20:18:44 -0800
Linux multiprocess programming three -- process communication
1, Process communication foundation
1. What is process communication
A process is an independent resource allocation unit. Resources between different processes (processes mentioned here usually refer to user processes) are independent and have no association. Resources of another process cannot be accessed directly in one process. However, pro ...
Posted by arsitek on Sat, 04 Dec 2021 16:39:28 -0800
Linux system software installation
preface
After we purchase a ECs, we usually need to install some common software. This article will introduce the common installation methods and configurations of some softwareBefore installing the software, we need to do some preparatory workFirst, check whether the yum source is available. If the following figure appears, it indicates ...
Posted by imekul on Sat, 04 Dec 2021 12:45:50 -0800
How does.NET Core configure TLS Cipher?
Preface
Not long ago, I published a post about TLS protocol configuration that I have drilled through. After verification by a third-party partner, there are unsafe Suites for this TLS protocol and we need to solve them quickly, so we will start to work on this article! Third-party partners are demanding on platform security, and we have issued ...
Posted by brij_theinvader on Sat, 04 Dec 2021 09:05:12 -0800
ansible -- Usage and common modules
1. Install ansible package
[root@centos8 ~]yum -y install ansible
2. Modify profile
###Purpose: to cancel the error (yes/no) that occurs every time you connect to the remote host
[root@centos8 ~]#vim /etc/ssh/ssh_config
#Modify the following line
StrictHostKeyChecking no
perhaps
[root@centos8 ~]#vim /etc/ansible/ansible.cfg
Uncomment the ...
Posted by galayman on Fri, 03 Dec 2021 22:26:28 -0800
Postfix and Dovecot of linux mail system
Introduction to mail system
The e-mail system completes the transmission of e-mail based on the e-mail protocol. The common E-mail protocols are as follows
1. Simple Mail Transfer Protocol (SMTP): it is used to send and relay e-mail, occupying 25/TCP port of the server 2. Post office protocol version 3 (POP3): used to store e-mail to the ...
Posted by Maskeeper on Fri, 03 Dec 2021 21:34:01 -0800