mariadb cluster setup

:80-g-W 1SH!$ifconfig Virtual network card has come out eth0: 0 Link encap:ethernet : 0C::CC: One: E7 inet addr:192.168. 1.100 bcast:192.168. 1.100 Mask:255.255. 255.255up broadcast RUNNING multicast MTU: Metric:1Ipvsadm-Ln more out of a vipip Virtual Server version1.2.1(size=4096) Prot localaddress:port Scheduler Flags-remoteaddress:port Forward Weight activeconn inactconntcp192.168.1.100: theRR-192.168.1.115: theRoute1 0 0-192.168.1.116: theRoute1

# 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

({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