postgresql cluster setup

# Priority change after script execution: 5 means priority +5;-5 is priority-5}Vrrp_instance Vi_a {State MASTER # Lord This value is master, from top to backupInterface eth0VIRTUAL_ROUTER_ID 50 # This value must be consistent between master and slavePriority 100Advert_int 1Authentication {# Authentication two parameter values, master and slave must also be consistentAuth_type PASSAuth_pass Yiban}Track_script {Chk_http_port}virtual_ipaddress {192.168.78.220}}5 Start keepalivedEnsure network upti

[program:anuoapc]command=dotnet AnuoApc.Web.dll; Command directory=/root/aspnetcore/anuoapc/to run the program; The directory autorestart=true the command execution; If the program quits unexpectedly automatically restarts the Stderr_logfile=/var/log/anuoapc.err.log; Error log file Stdout_logfile=/var/log/anuoapc.out.log; Output log file environment=aspnetcore_environment=production; Process environment variable User=root; The user identity of the process execution stopsignal=int6. Copy the fil

({addshard: "shardtwo.mongodb.local:27018", Name: "Shardtwo"}) >>db.runcommand ({addshard: "shardthree.mongodb.local:27018", Name: "Shardthree"})As far as possible, the Shard server avoids the change of IP address of the server in the way of domain name resolution4. Start the Shard and add the slice key to the database>>db.runcommand ({"enablesharding": "Mc_visit"}) >>db.runcommand ({"Shardcollection": "MC_VISIT.MC _visit "," key ": {" Visitdate ":-1," Virus ": 1}})5, no data in the case of mod

.png " alt= "Wkiol1vartur2iezaalcbilsdlw740.jpg"/>See the above information, congratulations, Master-slave has been built successfully.9. TestingCreate a database in mastermysql> CREATE DATABASE Leedb;Viewing the database in slavemysql> show databases;You can see that the leedb in master has been automatically synced to slave. All possible future database changes in masterwill automatically sync to the slave. Of course, MySQL can filter the database or the data table to synchronize, you can choo

can also directly on the left to choose a source you think fast, I prefer 163.com.Problem:Parsing host mirrors.163.com ... Failed: unknown name or service. Wget: Unable to resolve host address "mirrors.163.com"Workaround: Log in Root Enter/etc/resolv.confVim/etc/resolv.conf Modify content below (change DNS address to Google Domain name server)NameServer 8.8.8.8NameServer 8.8.4.4 Problem:Workaround:/etc/ssh//etc/ssh/permitrootlogin prohibit - Permitrootlogin y