In this easy step by step tutorial, you will learn how to replicate the contents of MySQL database.
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.Facebook.com/howtechtv - join us on Facebook
https://plus.google.com/103440382717658277879 - our group in Google+
MySQL Replication basically allows the contents of the master database server in MySQL to be replicated to other database servers. In this tutorial we will show you how to set up MySQL replication through phpMyAdmin.
Step#1: Getting Started with Replication
To get started, first of all, log in to your php my admin panel, and then click on the Replication tab on the top.
Step#2: Replication Plan
From there, click on the Configure option, under the Master Replication section.
With that done, the master configuration section will expand, having a list of databases and a replication plan as well.
Step#3: Create new Database
Here, you can either Replicate All databases while ignoring the ones selected, or the other way round, that is, ignore all the databases and replicate the ones which would be selected.
Let's choose the second plan and then select the database named "test" over here. With that done, copy the lines shown below the list. These have to be added in the MySQL "my.ini" file.
Step#4: MY.INI File
Since we are using the XAMPP server, the "my.ini" file can be fetched by clicking on the Config button and choosing the "my.ini" option against the MySQL Module.
Step#5: Setting up MY.INI File
Once the file opens up, navigate to the "log_error" parameter, and just paste the copied lines beneath that. With that done, change the "max allowed packet" size to 16 MB.
Once you are done with that, scroll down the file and comment out the "server-id" parameter with a hash sign.
When you are done with that, save the file and then restart the services of both Mysql and Apache.
Step#6: Master Replication Setup
After that, switch back to your phpMyAdmin page, and hit the F5 key to refresh the panel. With that done, move over to the Replication tab again. There you will find that the Master Replication has been set up successfully. You can click on the Show Master Status option to see its status. Now, click on the Add Slave Replication user option to add a Replication user
Step#7: Creating Replication User
Specify the username and the host, and then click on the Go button. A replication user would be added as a result.
Step#8: Slave Replication Setup
Now open up the Replication tab again, and click on the Configure option under the Slave Replication section. Another page will open up, and from here, copy the Server id which has to be pasted in the "my.ini" file.
So let's open up the "my.ini" file again and locate the "server-id " parameter which we had commented earlier.
Over here, simply paste the Server id copied from the Slave configuration, save the file and restart the MySQL services.
Step#9: Updating Slave Configuration
Now switch back to the Slave Replication page again, and specify the user details which were created before.
With that done, click on the Go button. A message will appear that the Master server had changed successfully.
Step#10: Warning Messages
Now, if you open the Replication tab once more, you will notice two warning messages appearing in the Slave Replication portion. One would be regarding the Slave SQL Thread and the other would be regarding the Slave IO Thread, both of which won't be running.
To resolve these errors, simply click on the Control Slave option, and Start these threads one after another. You will notice that the warning messages would disappear.
Step#11: Verifying Replicated database
Now click on the Databases tab and here you can see that the test database has been replicated successfully. This means that we have setup and configured MySQL replication.
And this is how to set up MySQL replication using phpMyAdmin.
You are doing replication on the same server. Where is the other server? You are editing same my.ini file. Is this master-slave replication or Master-Master replication? Video quality is very good but not helped me out.
A nice video. But not complete. ( Only windows )
Comment from Programster are right. Any new person will get confused.
Following precautions are necessary.
1. If you are running on Linux, edit my.cnf instead of the my.ini ( location - /etc/mysql/my.cnf )
2. In the second instance, you need to insert the server-id on a slave system by editing /etc/mysql/my.cnf
3. Replace ip number instead of localhost.
4. On slave system add following parameter
replicate-wild-do-table=your-db.% (replace your-table with actual database name followed with a period and % sign.
5. Incase you counter any errors like duplicate key etc, on slave system, loging to mysql and give following command.
set global sql_slave_skip_counter = 1;
1:15 For those thinking "WTF why are you commenting out the server id parameter?" Thats because it also gets set in the lines you copy/pasted from phpmyadmin a few seconds ago. Alternatively (and probably better), is you could just update the server-id from the one shown in phpmyadmin.
I love this edgy look! I was so excited that her hair, even as short as it is now, was still able to be put into the fun and trendy dutch pigtail braids! Instead of braiding to the ends, I ended them in close together pigtails at the nape of her neck. After I finished braiding, I tugged on the outsides of the braid gently to loosen them and make them a little messy and fun! Since she doesn’t have enough hair to tie around the elastics, I made sure to use elastics that matched her hair so they blend in as much as possible. You could also cover them with clips or bows! A view from the back of her Dutch pigtail braids! A great braid for short hair is a micro accent braid! My biggest tip for braiding short hair would be to add in small slices of hair rather than big ones. I did a small (micro) braid along a slightly curved deep part for anther cute and edgy look! You could also do another one next to it if you wanted a little more to the look, but I really liked how simple this one was. You can see how the part curves a little better from this view of the back. I ended the braid close to the head with an elastic that matched her hair. For our fourth style, we did a 3/4 french braid! Super simple but also super cute! You could do any type braid! It would also look cute using a Dutch braid or a fishtail braid! I loved the side view of this braid! I will for sure be doing this one next time she goes to gymnastics or swimming, whichever comes first! Our last braid is two four dutch lace braids into two loops in the back. Start off by parting the hair down the middle. On each side of the part, do a dutch lace braid, adding hair in from only the section closest to the part as you braid. Tie the braids together in the back with a small elastic and before you pull the hair all the way through to make a ponytail, leave it in a cute little loop! If the hair is a little bit longer, you could do a tiny bun. Repeat this directly under the braid you just did so you have two rows and two loops.
We will have to be coming up with lots more short hair braids in the future, so be sure to give us a follow over at our newly redesigned blog Abella’s Braids to see more as we do them!
Thanks for reading! See you again this time next month!
love these ideas! My daughter recently cut about 8 inches off her hair and is loving her shorter hair, but I’ve mostly been at a loss of what to do with it! Thanks!
Abella has been begging me for at least a year, probably closer to two years, to cut her hair. I posted a photo on Instagram with a question in the caption. “Abella has been begging me to cut her hair short, do you think I should let her do it?” Almost everyone said “YES!” So thanks to all of the good advice from my followers, we did it…and we haven’t regretted it for a second! I think she looks so cute and it really fits her personality! It’s for sure a lot harder to come up with braids but it’s pushed me to step out of my comfort zone! We wanted to show you that even if you have short hair, there are lots of cute braids you can still do!
This first braid (above) is three ladder braids. Start out with a part deep to one side. On the side with less hair, start out by doing a waterfall braid along the part. Under that one, do another waterfall braid, but incorporate the waterfall pieces from the one above it as you braid. Under that one, do a french braid. Incorporate the waterfall pieces from the second braid as you go. We braided each one to the ends and used elastics that matched her hair to tie them off.