Control Web Panel
WebPanel => MySQL => Topic started by: lolite on November 24, 2017, 02:18:22 AM
-
hello how to replicate database from server 1 to server 2?
how to setting server-id, log_bin etc. for setting master slave replication in centos web panel ?
-
Have you checked these articles?
https://tecadmin.net/how-to-set-up-mysql-master-slave-replication/
http://www.hackthesec.co.in/2016/01/mysql-replication-in-5-minutes.html
-
Have you checked these articles?
https://tecadmin.net/how-to-set-up-mysql-master-slave-replication/
http://www.hackthesec.co.in/2016/01/mysql-replication-in-5-minutes.html
I know that, this thread is very old.
I don't know if its for cwp or because I don't know. I try some differents configs, and I can't.
I wan't replicate 2 database from one same server, the tutos of this post are very old, other more newers....I can't configure this,.
Some help about this?
Recards.
-
Have you checked these articles?
https://tecadmin.net/how-to-set-up-mysql-master-slave-replication/
http://www.hackthesec.co.in/2016/01/mysql-replication-in-5-minutes.html
I know that, this thread is very old.
I don't know if its for cwp or because I don't know. I try some differents configs, and I can't.
I wan't replicate 2 database from one same server, the tutos of this post are very old, other more newers....I can't configure this,.
Some help about this?
Recards.
where you stuck ?
-
Have you checked these articles?
https://tecadmin.net/how-to-set-up-mysql-master-slave-replication/
http://www.hackthesec.co.in/2016/01/mysql-replication-in-5-minutes.html
I know that, this thread is very old.
I don't know if its for cwp or because I don't know. I try some differents configs, and I can't.
I wan't replicate 2 database from one same server, the tutos of this post are very old, other more newers....I can't configure this,.
Some help about this?
Recards.
where you stuck ?
I have followed several google guides, one of the links above is from a long time ago, so I considered it better to look for more current ones.
I have seen that from phpmyadmin it could be done, but it does not work for me, then I will try again, when the user is added it gives a permissions error (all this from phpmyadmin).
I had to revert everything, luckily, I had a backup of the db before I started, but even so, it did not restore it, it said that the tables of the current database were empty.
Also luckily, I had a snapshoot of the vps, I rolled it back and then restored the database backup.
Right now I'm at 0 point, I did a lot of testing but I had to revert everything when, for some reason, the database crashed (the master).
Then I will start the process again and indicate where I stay.
Thanks and best regards.
-
hire a system-admin for better lookup and setup, as i don't know why it is not working for you and where you stuck
-
hire a system-admin for better lookup and setup, as i don't know why it is not working for you and where you stuck
As soon as I replicate the error, I expose it here.
I have the error when I configure everything through phpmyadmin, it has its usefulness, so I did it there.
(I did it in other ways too but I was at the point that something had happened and I had to reverse everything.)
At the moment I'm going to prepare a vps for this, if it goes wrong, nothing happens there, because the other day I did it in a production one.
I will indicate step by step what has been done and with screenshots.
I think I can do it myself, I can't specify where I stayed because I made the mistake of doing it in one in production, as soon as I saw that the database was corrupt (and it was because of my mistake to delete some indexes that I shouldn't have deleted) The rush began and I had to reset everything.
I will use the replica with the phpmyadmin tool that it offers, but for example, phpmyadmin does not tell us when to execute START SLAVE, but I will do it that way.
I will expose, point by point, this time if, reached the error I will be able to stop because it will not be in a database in production, it will be its replica but in a test environment.