November 25, 2009
Replication consists of following 3 parts….
The basic steps to set up replication are…
Here are few assumptions….
Master IP Address: 192.168.1.215
Slave IP Address: Â 192.168.1.203
Replication User: replication
User Password: slave
The I/O Slave Thread (it runs on Slave Server) makes a TCP/IP connection to the master. Thats why we need to create an user account on Master Server with proper privileges.
Now run the following query on Master to create a Slave account….
mysql>Â GRANT REPLICATION SLAVE ON *.* TO ‘replication‘@’192.168.1.203’ IDENTIFIED BY ‘slave’;
Now edit my.cnf file on Master accordingly.
server-idÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = 1
log-binÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = mysql-bin
log-bin-indexÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â = mysql-log-bin.index
relay-logÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = mysql-relay-bin
relay-log-indexÂ Â Â Â Â Â Â Â Â Â Â Â = mysql-relay-bin.index
expire_logs_daysÂ Â Â Â Â Â Â Â = 10
max_binlog_sizeÂ Â Â Â Â Â Â Â Â = 100M
binlog_do_dbÂ Â Â Â Â Â Â Â Â Â Â Â Â Â = [Database Name to be Replicated]
binlog_ignore_dbÂ Â Â Â Â Â Â Â = [Database Name not to be Replicated]
#binlog_ignore_dbÂ Â Â Â Â Â = [Database Name not to be Replicated] (for more than one data base which is not supposed to be replicated)
datadirÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = /var/lib/mysql
tmpdirÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = /tmp
Now restart Master mysql server and run the following query…
mysql>Â SHOW MASTER STATUS;
Now edit my.cnf file on Slave accordingly…..
server_idÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â = 2
master_hostÂ Â Â Â Â Â Â Â Â Â Â = 192.168.1.215
master_userÂ Â Â Â Â Â Â Â Â Â Â = replication
master_passwordÂ Â = slave
master_portÂ Â Â Â Â Â Â Â Â Â Â = 3306
relay_logÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â = mysql-relay-bin
relay-log-indexÂ Â Â Â Â Â = mysql-relay-bin.index
We can set the value for master_host, master_user and master_password using mysql query. So it is better to avoid setting those valuesÂ directly from configuration file.
If master is having data already, insert the data from master server to slave server database or each of the databases.
Copy master database back up inside slave server and runÂ the following command on slave….
mysql -u[username] -p[password] [database name] < directory_path/[database.sql]
Now Restart Mysql Slave server andÂ run following query to synchronize master and slave….
mysql> CHANGE MASTER TO MASTER_HOST=’192.168.1.215′, MASTER_USER=’replication’, MASTER_PASSWORD=’slave’, MASTER_LOG_FILE=’mysql-bin.000004′, MASTER_LOG_POS=570;
Note: MASTER_LOG_FILE and MASTER_LOG_POS values have been taken from the result of SHOW MASTER STATUS
If a Slave is already running on your Slave Server,Â Mysql Server will throw a error like…
ERROR 1198 (HY000): This operation cannot be performed with a running slave; run STOP SLAVE first
mysql> STOP SLAVE;
AndÂ run the query for CHANGING MASTER again.
If it shows an error like..
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
mysql> RESET SLAVE;
AndÂ run the query for CHANGING MASTER again.
Finally start slave on slave server using..
mysql> START SLAVE;
mysql> SHOW SLAVE STATUS\G
Congrats! Mysql Master-Slave Replication has been set up 🙂
Also we will be able to see the Replication Threads in the process list on both the Master and the Slave.
So simply run…
mysql> SHOW PROCESSLIST.
I love this posts . Post more and thanks to all the mistress!
I just think that this post was mind blowing , please add more mistress posts and I will be back all the time lol!
Hey Blogger, Next month I’ll be starting my expat blog about making money while traveling. I will be working as a “professional” blogger and freelance writer, and probably teach a little English as well. My blog will be an adventure and I hope anyone interested in long term travel will subscribe. It will be fun (A Broad Abroad) so please subscribe to me.
See me on Facebook http://www.facebook.com/people/Pearl-Perras/100001813539215
I used to be very happy to find this web-site.I wished to thanks for your time for this wonderful read!! I undoubtedly having fun with every little bit of it and I have you bookmarked to take a look at new stuff you blog post.
Please let me know if you’re looking for a author for your weblog. You have some really great posts and I believe I would be a good asset. If you ever want to take some of the load off, I’d really like to write some content for your blog in exchange for a link back to mine. Please blast me an email if interested. Cheers!
My wife and i were quite lucky when Albert could conclude his preliminary research via the ideas he made from your web site. It’s not at all simplistic just to be handing out points that many some people might have been trying to sell. We discover we have you to be grateful to because of that. These illustrations you made, the easy website navigation, the relationships you can assist to promote – it is most fantastic, and it’s really helping our son in addition to the family do think that theme is satisfying, which is certainly highly indispensable. Many thanks for everything!
Good idea of article. I’m from Czech Republik I read many publication about it. I wondered idea of article is quite best and impresive to think about this article and future. Kind regards from Slovakia.
You might be so great, gentleman! I are unable to trust I missed this blog site for so prolonged. It can be just superb things all spherical. Your style and design, gentleman…also impressive! I are unable to wait around to study what you’ve got bought future. I really like every little thing that you might be declaring and want alot more, a great deal more, Much more! Retain this up, guy! It is really just as well excellent.
Hey, i’ve been browsing this blog page for any despite the fact that and also have a issue, perhaps you possibly can benefit… it is really how do i include your feed to my rss reader as i would like to adhere to you. Many thanks.
I have to grab the skill set to thanking you have to your practiced rules Ive many times valued options a web page. We’re eager for this start related with these classes get to know and comprehensive research could not seems to be extensive with no need of throwing out to the site your blog post. Considerably more than simply is from a aid to a number, I am grateful to assist and of what I’ve got learnt from this level.
Have fun on vacation girly!!! Xoxoxo
This is my very first occasion i view at this point. I found lots of fascinating fill in your site specifically the piece. From the tons of comments on your items, I suppose I m not the only one using each of the satisfaction in this article! sustain the nice operate.
Required to compose you a tiny note to finally thank you very much but once more for your private splendid strategies you’ve got discussed above. It truly is strangely open-handed with individuals like you to supply publicly all that several individuals would have marketed as an electronic book to produce some bucks for their own finish, primarily now which you could possibly have tried it in case you ever wanted. These inspiring concepts likewise acted like a fantastic method to know that the rest have exactly the same dreams genuinely like my individual own to see a entire lot a lot more concerning this difficulty. Iâ€™m positive you’ll find thousands of a lot more enjoyable times inside the future for many who check out your weblog.
It’s actually a great and useful piece of info. I am glad that you shared this useful information with us. Please keep us up to date like this. Thanks for sharing.
Hello are using WordPress for your site platform? I’m new to the blog world but I’m trying to get started and set up my own. Do you require any coding knowledge to make your own blog? Any help would be really appreciated!
Thanks for your whole labor on this blog. My niece enjoys conducting research and it’s obvious why. All of us hear all relating to the lively medium you render important steps through the blog and in addition encourage response from website visitors about this area so our child is without question becoming educated a lot. Take advantage of the remaining portion of the year. You’re doing a glorious job.
I’m impressed, I have to say. Really not often do I encounter a blog that’s both educative and entertaining, and let me inform you, you might have hit the nail on the head. Your thought is excellent; the issue is something that not enough persons are talking intelligently about. I’m very pleased that I stumbled across this in my search for one thing regarding this.
I am usually to blogging and i actually appreciate your content. The article has really peaks my interest. I am going to bookmark your website and preserve checking for brand new information.
I don’t know if this will help you guys but this is what fixed it for me: I had the Firebug addon installed. At work, disabling Firebug for the following sites prevents the problem:
Aw, this was a really nice post. In concept I want to put in writing like this moreover – taking time and precise effort to make an excellent article… but what can I say… I procrastinate alot and not at all seem to get something done.
A great word of admiration for the journalist.The art of doing content is very useful. I’ve got to value your precise groundwork of this topic.
Surprisingly revealing many thanks, I do think your readers may well want further blog posts such as this carry on the excellent function.
Very effectively written information. Will probably be useful to anybody who usess it, including myself. Keep up the good work – for positive i will take a look at extra posts.
This is the sort of website I love to see! Concisely written, it’s nifty!
Wow, superb blog structure! How lengthy have you been blogging for? you make blogging look easy. The overall glance of your site is magnificent, as smartly as the content material!
Hello.This article was really interesting, especially since I was investigating for thoughts on this subject last Tuesday.
Hi! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My website looks weird when viewing from my iphone 4. I’m trying to find a template or plugin that might be able to resolve this problem. If you have any recommendations, please share. Cheers!
Somebody essentially help to make severely posts I would state. That is the very first time I frequented your web page and to this point? I amazed with the research you made to create this actual post amazing. Fantastic process!
Fantastic story! Right until a calendar year ago I owned and raced a further of your 122S racers, a 1968, affectionatley identified as “Greta” just after yet another famous Swedish Redhead, originally built circa 1970 in Edmonton, originally being a rally car, that’s been rallied and raced fairly continuously given that then. I and my friends modified Greta to entire 1969 SCCA B Sedan specs which made listed here incredibly competitive towards all however the fastest 510s 2002s and Alfas. Greta has been pictured sveral situations in Victory Lane and her history chronicled during the Volvo Club of BC Newsletters. Very good luck on racing this famous Volvo!
I basically had to thank you very a great deal once once again. I’m not certain what I could possibly have followed inside the absence from the type of ideas contributed by you concerning my theme. It truly was a frightful difficulty for me, nevertheless finding out the very professional manner you resolved the issue forced me to jump over joy. Now i’m thankful for the function and even hope that you might be aware of an awesome job you’re accomplishing training folks these days thru your blog post. I know that you’ve never got to know any of us.
I have recently started a web site, the information you offer on this web site has helped me greatly. Thanks for all of your time & work.
I’d need to test with you here. Which is not one thing I often do! I enjoy studying a post that can make folks think. Also, thanks for allowing me to comment!
I have learned many important things through your post. I’d also like to mention that there can be situation in which you will obtain a loan and never need a co-signer such as a Government Student Aid Loan. However, if you are getting a borrowing arrangement through a classic creditor then you need to be willing to have a cosigner ready to enable you to. The lenders can base any decision on a few components but the greatest will be your credit worthiness. There are some loan companies that will furthermore look at your work history and make up your mind based on that but in most cases it will hinge on your rating.
I just like the valuable information you supply on your articles. I will bookmark your blog and take a look at once more here regularly. I’m reasonably certain I’ll learn many new stuff right here! Best of luck for the following!
I have realized that over the course of developing a relationship with real estate managers, you’ll be able to get them to understand that, in every real estate purchase, a percentage is paid. In the end, FSBO sellers will not “save” the commission rate. Rather, they struggle to win the commission through doing a great agent’s occupation. In accomplishing this, they commit their money as well as time to perform, as best they can, the obligations of an adviser. Those responsibilities include displaying the home by means of marketing, showing the home to all buyers, making a sense of buyer urgency in order to prompt an offer, arranging home inspections, dealing with qualification assessments with the loan company, supervising repairs, and facilitating the closing of the deal.
With havin so much written content do you ever run into any problems of plagorism or copyright infringement? My site has a lot of exclusive content I’ve either authored myself or outsourced but it seems a lot of it is popping it up all over the internet without my permission. Do you know any techniques to help prevent content from being stolen? I’d certainly appreciate it.
I believe that avoiding processed foods may be the first step to help lose weight. They can taste very good, but processed foods have very little nutritional value, making you consume more just to have enough strength to get over the day. If you’re constantly eating these foods, transferring to grain and other complex carbohydrates will help you to have more vigor while consuming less. Interesting blog post.
I’ve been absent for a while, but now I remember why I used to love this site. Thank you, I’ll try and check back more frequently. How frequently you update your website?
After examine a couple of of the weblog posts on your website now, and I actually like your approach of blogging. I bookmarked it to my bookmark web site checklist and will be checking again soon. Pls take a look at my web page as well and let me know what you think.
Thanks for your article on this blog site. From my personal experience, periodically softening upward a photograph may well provide the professional photographer with an amount of an inspired flare. Often times however, the soft cloud isn’t what precisely you had under consideration and can often times spoil an otherwise good image, especially if you thinking about enlarging the item.
Does your website have a contact page? I’m having a tough time locating it but, I’d like to shoot you an email. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it improve over time.
Hiya, I am really glad I have found this information. Nowadays bloggers publish just about gossips and net and this is actually frustrating. A good blog with exciting content, this is what I need. Thank you for keeping this web site, I’ll be visiting it. Do you do newsletters? Cant find it.
There are certainly a whole lot of particulars like that to take into consideration. That is a nice point to convey up. I provide the ideas above as basic inspiration however clearly there are questions just like the one you convey up the place an important thing will probably be working in sincere good faith. I don?t know if best practices have emerged round things like that, but I’m positive that your job is clearly recognized as a fair game. Both boys and girls feel the affect of just a moment’s pleasure, for the remainder of their lives.
I have really learned result-oriented things from a blog post. One other thing I have seen is that normally, FSBO sellers can reject a person. Remember, they can prefer to never use your providers. But if anyone maintain a gentle, professional connection, offering guide and staying in contact for four to five weeks, you will usually be able to win a discussion. From there, a house listing follows. Cheers
I appreciate, lead to I discovered exactly what I was looking for. You have ended my 4 day lengthy hunt! God Bless you man. Have a great day. Bye
I have been exploring for a bit for any high-quality articles or blog posts on this sort of area . Exploring in Yahoo I at last stumbled upon this site. Reading this information So i am happy to convey that I’ve a very good uncanny feeling I discovered exactly what I needed. I most certainly will make certain to don’t forget this website and give it a look regularly.
I have realized that online degree is getting well-known because obtaining your college degree online has developed into a popular option for many people. Many people have not had a chance to attend an established college or university yet seek the elevated earning potential and career advancement that a Bachelors Degree offers. Still people might have a degree in one training but want to pursue anything they now develop an interest in.
At this time it looks like BlogEngine is the top blogging platform available right now. (from what I’ve read) Is that what you are using on your blog?
Another thing I’ve really noticed is always that for many people, less-than-perfect credit is the response to circumstances past their control. For instance they may be really saddled having an illness and as a consequence they have excessive bills going to collections. It could be due to a occupation loss and the inability to go to work. Sometimes breakup can really send the money in the wrong direction. Thanks sharing your notions on this website.
I have been reading out some of your stories and i must say clever stuff. I will definitely bookmark your website.
Through my examination, shopping for gadgets online may be easily expensive, but there are some guidelines that you can use to help you get the best products. There are usually ways to locate discount offers that could help make one to buy the best electronic devices products at the cheapest prices. Good blog post.
Thank you for this article. I’d also like to state that it can often be hard while you are in school and starting out to initiate a long credit history. There are many pupils who are simply just trying to live and have a good or beneficial credit history is often a difficult element to have.
F*ckin’ awesome issues here. I’m very happy to peer your article. Thanks so much and i’m looking forward to contact you. Will you please drop me a mail?
I have learned some new points from your website about pc’s. Another thing I’ve always imagined is that computer systems have become a product that each home must have for some reasons. They offer convenient ways in which to organize homes, pay bills, go shopping, study, hear music and even watch television shows. An innovative method to complete these tasks is with a notebook computer. These pc’s are portable ones, small, effective and lightweight.
Thanks for your valuable post. Through the years, I have been able to understand that the particular symptoms of mesothelioma cancer are caused by the particular build up associated fluid involving the lining of your lung and the upper body cavity. The sickness may start from the chest spot and multiply to other parts of the body. Other symptoms of pleural mesothelioma cancer include weight-loss, severe inhaling trouble, temperature, difficulty ingesting, and infection of the neck and face areas. It should be noted that some people existing with the disease do not experience every serious signs at all.
These days of austerity and also relative anxiousness about running into debt, most people balk about the idea of employing a credit card in order to make acquisition of merchandise or perhaps pay for a trip, preferring, instead just to rely on the particular tried as well as trusted approach to making transaction – raw cash. However, if you possess cash there to make the purchase in whole, then, paradoxically, that is the best time for them to use the credit card for several good reasons.
Good write-up, I’m regular visitor of one’s website, maintain up the nice operate, and It is going to be a regular visitor for a long time.
Excellent items from you, man. I’ve bear in mind your stuff previous to and you’re simply too wonderful. I actually like what you have acquired right here, really like what you are stating and the way in which you assert it. You make it enjoyable and you still take care of to keep it smart. I can not wait to learn far more from you. This is really a wonderful website.
You made some decent factors there. I seemed on the web for the problem and found most individuals will go along with together with your website.
I imagine this website has got some fantastically sunny information for all. “Variety is the soul of pleasure.” by Aphra Behn.
Itˇ¦s really a great and helpful piece of info. I am glad that you simply shared this helpful info with us. Please stay us up to date like this. Thanks for sharing.
I have learn some good stuff here. Definitely price bookmarking for revisiting. I wonder how so much effort you put to make any such fantastic informative web site.
It’s perfect time to make some plans for the future and it is time to be happy. I have read this post and if I could I wish to suggest you few interesting things or tips. Perhaps you can write next articles referring to this article. I wish to read even more things about it!
I intended to draft you the little bit of word to help say thank you over again with your pleasing guidelines you have featured on this website. It’s certainly incredibly open-handed of you to convey extensively all that a few individuals might have advertised as an electronic book to make some money on their own, even more so seeing that you might have tried it in case you wanted. These suggestions likewise acted to be a good way to know that the rest have a similar dream much like my own to realize a lot more around this problem. I believe there are lots of more enjoyable times up front for those who scan your site.
Wow! This can be one particular of the most useful blogs We have ever arrive across on this subject. Basically Excellent. I am also a specialist in this topic so I can understand your hard work.
Thanks a lot for the helpful article. It is also my opinion that mesothelioma cancer has an extremely long latency phase, which means that signs and symptoms of the disease might not exactly emerge until finally 30 to 50 years after the original exposure to asbestos fiber. Pleural mesothelioma, that’s the most common form and has an effect on the area across the lungs, will cause shortness of breath, chest muscles pains, and a persistent cough, which may produce coughing up body.
Simply desire to say your article is as surprising. The clarity in your post is simply nice and i could assume you are an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please continue the gratifying work.
Hello! This post could not be written any better! Reading this post reminds me of my old room mate! He always kept chatting about this. I will forward this article to him. Pretty sure he will have a good read. Many thanks for sharing!
Simply wanna input on few general things, The website style is perfect, the subject material is rattling great : D.
of course like your website however you need to take a look at the spelling on quite a few of your posts. A number of them are rife with spelling problems and I in finding it very troublesome to tell the reality nevertheless I will certainly come back again.
I have seen that intelligent real estate agents everywhere are getting set to FSBO Advertising. They are noticing that it’s not just placing a sign post in the front yard. It’s really in relation to building interactions with these vendors who at some time will become purchasers. So, if you give your time and efforts to assisting these vendors go it alone – the “Law of Reciprocity” kicks in. Good blog post.
It’s the best time to make a few plans for the future and it’s time to be happy. I’ve learn this put up and if I may I desire to suggest you some attention-grabbing things or tips. Perhaps you could write next articles regarding this article. I wish to read more things about it!
One thing I’d like to say is the fact that before getting more personal computer memory, take a look at the machine into which it could well be installed. In case the machine is running Windows XP, for instance, the memory threshold is 3.25GB. Adding over this would easily constitute any waste. Make sure that one’s motherboard can handle an upgrade quantity, as well. Thanks for your blog post.
Hey just wanted to give you a quick heads up. The words in your content seem to be running off the screen in Safari. I’m not sure if this is a formatting issue or something to do with web browser compatibility but I thought I’d post to let you know. The style and design look great though! Hope you get the issue solved soon. Thanks
Thanks for the ideas you have shared here. Something else I would like to say is that pc memory requirements generally go up along with other breakthroughs in the technological innovation. For instance, if new generations of processor chips are made in the market, there is certainly usually a similar increase in the dimensions preferences of all laptop memory in addition to hard drive space. This is because the software program operated through these processor chips will inevitably rise in power to take advantage of the new technological know-how.
I have noticed that online diploma is getting preferred because getting your degree online has become a popular selection for many people. Many people have certainly not had a chance to attend a traditional college or university yet seek the increased earning possibilities and a better job that a Bachelors Degree affords. Still other people might have a qualification in one discipline but want to pursue some thing they already have an interest in.
At this time, withal , the promise of a peaceful Arab Springtime appears to be giving way to the reality of a long, trigger happy summer as authoritarians across the Middle East and North Africa draw a line in the sand and fight to keep ascendency of their lands .
Hello my friend! I wish to say that this article is awesome, nice written and include approximately all important infos. I’d like to see more posts like this.
I have been browsing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my view, if all site owners and bloggers made good content as you did, the web will be a lot more useful than ever before.
I have not checked in here for a while because I thought it was getting boring, but the last few posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂
Admiring the dedication you put into your site and detailed information you present. It’s great to come across a blog every once in a while that isn’t the same outdated rehashed information. Fantastic read! I’ve saved your site and I’m adding your RSS feeds to my Google account.
I’m usually to running a blog and i really respect your content. The article has actually peaks my interest. I’m going to bookmark your web site and preserve checking for brand new information.
If you’re stagnant on the fence: grab your favorite headphones, supervisor down to a Best Purchase and solicit to advertise them into a Zune then an iPod and distinguish which one sounds enhanced to you, and which interface makes you smile added. Next you’ll get which is acceptably for you.
Throughout this grand pattern of things you’ll secure a B- for effort. Where exactly you misplaced us was on your details. You know, as the maxim goes, details make or break the argument.. And it could not be more correct at this point. Having said that, let me inform you just what did do the job. The writing is rather engaging which is most likely why I am making an effort in order to opine. I do not make it a regular habit of doing that. Next, while I can notice the leaps in reasoning you come up with, I am not sure of just how you appear to unite the details which inturn help to make the conclusion. For the moment I will subscribe to your point but hope in the near future you actually connect the dots better.