闲来无事在虚拟要配置了一遍mysql主从复制,做下记录,配置下来还是蛮简单的
环境:2台#CentOS release 6.8 (Final)虚拟机
[mysql-A] yum -y update cat /etc/issue #CentOS release 6.8 (Final) yum install mysql mysql-devel mysql-server #安装mysql服务器 service mysqld start service iptables stop chkconfig iptables off mysql_secure_installation #初始化mysql参数 vi /etc/my.cnf #server-id=1;log-bin=mysql-bin #添加服务器ID&服务器日志 service mysqld restart vi .my.cnf > [Client]user=root password=xxx mysql>CREATE USER 'user'@ 'X.X.X.X' IDENTIFIED BY 'password';#可以创建一个用户专门用来设置成复制账号 grant replication slave on *.* to [email protected]'%' identified by 'passowrd';#赋予“REPLICATION SLAVE”的权限 flush privileges; flush tables with read lock;#防止数据写入 show master status\G; netstat -natp | grep -i established.*mysql mysql -e "SHOW PROCESSLIST" msyql>UNLOCK TABLES;解锁表 [mysql-B] vi /etc/my.cnf > server-id=2 service mysqld restart mysql> change master to -> master_host='MYSQL-A', -> master_port='3306', #如未变更可省略 -> master_user='root', -> master_password='xxx', -> master_log_file='mysql-bin.000001', -> master_log_pos=322; mysql>start slave; mysql>show processlist; show slave status \G; log-bin=mysql-bin
清除mysql主从信息
mysql>slave stop;
mysql>reset slave;
mysql>change master to master_host=’ ‘;
brand cialis pills – viagra 150mg price order sildenafil 50mg sale
order synthroid 75mcg for sale – aristocort brand order plaquenil 400mg without prescription
buy synthroid 150mcg sale – buy clarinex 5mg for sale order plaquenil 400mg sale
order generic ventolin 4mg – academic writing terms dapoxetine 60mg pill
order albuterol 2mg sale – academic writing uk buy dapoxetine 60mg without prescription
erythromycin and acne erythromycin oint
69o4t
xldkx
7sha
order vardenafil generic – order generic levitra 20mg buy clomid 50mg online cheap
levitra pills – methylprednisolone 16 mg for sale buy clomiphene 50mg without prescription
cheap lisinopril 10mg – order lisinopril 2.5mg generic atenolol 100mg cheap
buy lisinopril for sale – metoprolol 50mg for sale buy atenolol 50mg without prescription
buy metformin 1000mg generic – glucophage cheap amlodipine 10mg pill
hhsvc
ynr6y
[url=http://novrazbb.com/#]10hb[/url]
glucophage sale – cost norvasc 5mg norvasc ca
hydroxychloroquine 200mg ca – order generic plaquenil 200mg baricitinib online buy
t3uyr
a5c1t
97pf
generic hydroxychloroquine 400mg – buy baricitinib 2mg pill baricitinib 4mg ca
https://erythromycinn.com/# erythromycin rosacea
lasix 100mg ca – buy doxycycline 200mg online cheap can i buy ivermectin online
order furosemide online – ivermectin 6mg tablets ivermectin 2mg
purchase prednisolone – prednisolone online real viagra pharmacy prescription
buy generic prednisolone – viagra 150mg tablet sildenafil for sale
amoxicillin 250mg oral – buy azithromycin without prescription buy sildenafil without prescription
uses for erythromycin
buy amoxicillin 250mg online cheap – sildenafil 150mg cheap sildenafil 50mg drug
buy deltasone 10mg generic – buy ed pills usa oral isotretinoin 10mg
prednisone 40mg oral – ed pills cheap accutane pills
tadalafil 40mg oral – oral provigil provigil 100mg cheap
purchase cialis pill – buy modafinil 100mg online modafinil 100mg tablet
http://erythromycinn.com/# how to use erythromycin ophthalmic ointment
doxycycline 100mg us – generic doxycycline tadalafil 10mg price
buy doxycycline – cialis brand order cialis pill
ivermectin 9mg – ivermectin 3mg for sale purchase levitra without prescription
ivermectin 12mg oral – buy ivermectin 3mg online vardenafil 10mg without prescription
http://erythromycinn.com/# erythromycin topical gel
cheap amoxicillin 250mg – amoxicillin 1000mg pill vardenafil online order
buy amoxil generic – order levitra pill buy vardenafil generic
purchase modafinil pill purchase provigil online
order modafinil pills order provigil sale
modafinil 100mg cheap provigil 200mg pills
provigil 100mg over the counter
order generic ampicillin 250mg – ciprofloxacin 500mg usa order cialis 10mg online
provigil 100mg generic order modafinil for sale buy provigil for sale
buy ampicillin pills – cheap ampicillin 500mg cialis 20mg generic
provigil sale modafinil sale order modafinil 100mg pill
purchase ceftin pills – buy cefuroxime online cheap cialis online
erythromycin overdose https://erythromycin1m.com/#
modafinil 100mg sale buy provigil 200mg sale
ceftin 500mg price – brand ceftin buy tadalafil 20mg generic
cost provigil 100mg buy provigil pills modafinil 100mg uk
order modafinil pills buy provigil sale provigil buy online
budesonide pill – disulfiram 250mg pills disulfiram 500mg drug
cost modafinil generic modafinil 100mg
cheap rhinocort – budesonide order disulfiram order online
provigil 100mg brand provigil 200mg drug brand provigil 100mg
buy sildenafil 100mg pill – order sildenafil online ivermectin generic
sildenafil us – nolvadex oral ivermectin over the counter canada
order cephalexin without prescription – order cephalexin 125mg erythromycin 500mg drug
cephalexin 125mg sale – order cleocin 150mg generic erythromycin for sale online
buy generic bactrim – overnight delivery for viagra cheap viagra
bactrim pill – sildenafil 100mg us cheap sildenafil generic
augmentin tablet – cialis sales tadalafil price
Kitchen remodeling is a significant investment for any household. However, you gain several long-term benefits as a result. First, kitchen renovations tend to have a significant ROI in the Sarasota area. The average ROI for a minor midrange remodel is about 77%. For a major or gourmet remodel, you are likely to recoup about 50% to 60% of your remodeling costs in potential resale value. Having a clean, updated kitchen is a big draw for prospective home buyers and can make it easier to sell your home in the future. Appliances can be a small or very large portion of your total remodel budget, depending on your preferences. Appliance prices run the gamut from the cost-effective, $5,000 total, to wildly expensive high-end brands, which can easily be over $50,000. The average kitchen renovation in Los Angeles spends $10k-$15k on appliances. Don’t forget to budget for the cost of your contractor installing these appliances, which can range from $1,000-$2,000 depending on the number of appliances. https://lizardlicktowingstore.com/community/profile/altonbeaudoin21/ The state of New Jersey does not offer a contractor license designation. State law does require contractors to register annually with the New Jersey Division of Consumer Affairs. This registration must be prominently displayed on all of the contractors commercial vehicles, places of business, and business related documents, contracts, and correspondence. The registration number must begin with the letters HIC reg.# When you work with a communicative team of designers and contractors, you can reach out and adjust design details to your liking, keeping you in charge of your renovation. With over 10 years of experience renovating residential and commercial properties, we are ready to serve your needs today. We offer a variety of quality building services and have many years of experience to give you confidence that we are your number one choice for your next home project. You will find us to be competitively priced with close attention to the details of each project that we are involved with. We look forward to building lasting relationships and guarantee your satisfaction!
buy generic augmentin 375mg – cialis 5mg over the counter tadalafil 10mg without prescription
prednisolone 20mg price – order gabapentin 800mg pills cialis for women
[url=http://gabapentintab.com/]gabapentin 1000[/url]
cheap prednisolone sale – cialis next day delivery usa cialis coupon cvs
order viagra 100mg pills – sildenafil 100mg generic order sildenafil 100mg pill
There is nothing wrong with Google apps; they run perfectly well, they can communicate seamlessly with each other and you only need just one account to access them all. Google Workspace takes things further. It not only provides apps and inter-app connectivity exclusive to Google Workspace, there are these tiny little attention-to-detail features that make the experience absolutely amazing. Congratulations Google Workspace users, your problem has been solved. I’ve had my Google account for about 5 years now, and currently my Other Contacts group holds just over 6,000 people. Many of these are blank e-mail addresses I’ve communicated with in the past. If you don’t want to manage database this size, then just organize the people you do know into My Contacts. This can then be your go-to folder for contacts since it is this folder that will sync with any paired Android mobile device. https://zonenorwalk.com/forums/profile/donnieball6238/ Most devices let you enable and disable syncing for various apps and features. A possible reason Google Calendar is not syncing is that the calendar sync is disabled on your device. There are many reasons Google Calendar may not sync on your devices. Maybe your phone doesn’t have enough space to store new calendar details. Or maybe you or someone else has disabled the sync feature. We’ll show how to fix these common issues with Google Calendar not syncing. A new calendar event entered on the PC or tablet shows up on all the devices, but a new event added on the phone doesn’t show up on the other two. However, a calendar event deleted on the phone is deleted from the other two. What should I do? Sync iCloud Calendar on Android Phone by One Click! Although Gmail doesn’t have an official desktop app, it still works well with Microsoft Outlook, providing users with the best of both worlds. Here’s what you need to do to sync Outlook Calendar with Gmail:
buy sildenafil 100mg generic – prednisone online order generic vardenafil us
ciprofloxacin drug – oral cipro 1000mg buy cialis 5mg sale
play online casino real money – casino games free editing essays
simvastatin over the counter – order generic valtrex 500mg essays done for you
flomax over the counter – zofran for sale online brand spironolactone
accutane 10mg brand – amoxicillin 250mg cheap buy celecoxib 100mg pills
[url=http://yivermectin.com/]where to buy stromectol online[/url]
buy ed medication – ed symptoms buy prednisone 20mg online
[url=http://viagra50.quest/]viagra in mexico cost[/url]
modafinil 200mg cheap – cialis viagra sales viagra 50mg pill
cialis tablets – Generic cialis online cheap viagra online
Here’s your chance to live like a hobbit! We’re smitten with the adorable tiny houses from Green Magic Homes, which specializes in cozy homes made to look like they’re built into hills. In actuality, once the house is all built out, you can cover the exterior with landscaping like soil, grass, and even trees and shrubs—as long as the roots are not invasive. Prices depend on each specific location and build. Moving into a tiny house does require you to let go of a lot of that “stuff.” But it doesn’t mean that you have to live like a Pioneer. Take a look at the luxurious designs of a Utopia Villas home and you might be surprised to discover that they offer the same quality amenities as any normal sized dwelling. You can still enjoy marble countertops; a warm fireplace; and even a wine rack. Of course every house is unique. That’s the best part of building a tiny house in Iowa – you can design it to match your own interest and style. http://felixqkzo542087.educationalimpactblog.com/31370293/new-townhome-rentals-near-me The MLS® mark and associated logos identify professional services rendered by REALTOR® members of CREA to effect the purchase, sale and lease of real estate as part of a cooperative selling system. In the area? Drop by our Collingwood Office and ask for Christine Smith. The municipality won’t budge on their application until the CA has signed off, but the McIntyres expect to be able to apply for permits in the next couple of months—the plan is to build a 1,600 sq. ft. cottage with two floors and three bedrooms. Barring any hiccups, they hope to get the township’s stamp of approval by early summer. Luckily, the McIntyres never had a firm deadline for when the cottage would be built. “That’s what has made it less stressful—we’re just rolling with it,” says Carolyn. unique parcel of land nicely situated along Springgay road. Flat open parts to build on with nice hardwoods surrounding the property. Perfect property to start your for…
cost doxycycline 200mg – hydroxychloroquine 400mg brand buy chloroquine 250mg for sale
furosemide ca – buy zithromax 500mg for sale buy zithromax sale
buy isotretinoin for sale – amoxil uk cost amoxicillin 250mg
best over the counter ed pills – gnc ed pills prednisone us
order viagra 50mg pill – tadalafil over counter order cialis 10mg online cheap
buy avodart 0.5mg without prescription – cialis mail order us cost cialis 40mg
order topamax 200mg online cheap – buy sumatriptan for sale purchase imitrex sale
buy cialis 40mg for sale – cialis 5mg ca coumadin 2mg brand
order cialis for sale – cialis 40mg for sale purchase sildenafil generic
order furosemide generic – lasix 40mg without prescription sildenafil uk
accutane oral – purchase zithromax without prescription azithromycin 250mg pill
order generic provigil – otc ed pills cheap erectile dysfunction
order tadalafil without prescription – cialis coupon walmart buy tadalafil 10mg sale
[url=http://bestcialistabletorder.quest/]generic cialis nz[/url]
order esomeprazole online – order promethazine 25mg online cheap order phenergan generic
viagra 25mg – order sildenafil without prescription viagra 100mg without prescription
buy viagra 100mg pills – methotrexate 5mg ca buy plavix 75mg online
order colchicine without prescription – colchicine 0.5mg price cheap strattera
order toradol 10mg without prescription – buy ketorolac generic brand baclofen 10mg
[url=http://cialisxpill.com/]where to get generic cialis[/url]
order sildenafil 100mg – sildenafil 100mg usa cost cialis 20mg
buy sildenafil 150mg without prescription – buy lisinopril 10mg generic cyclobenzaprine for sale online
zetia 10mg pills – order celexa 40mg online cheap generic citalopram 40mg
[url=http://arimidexanastrozole.quest/]arimidex australia online[/url]
purchase hydroxyzine pill – rosuvastatin online rosuvastatin tablet
diltiazem for sale – zyloprim 100mg uk cheap acyclovir
cialis usa – cheap cialis 10mg buy cenforce without prescription
buy sildenafil sale – purchase gabapentin online cheap neurontin 100mg for sale
cytotec price – purchase synthroid sale cost levothyroxine
buy clarinex 5mg generic – loratadine 10mg uk aristocort for sale
cheap clomiphene 100mg – clomid 100mg uk buy zyrtec 5mg online cheap
order lyrica 75mg pills – buy lyrica online buy pregabalin 150mg online