Author Topic: how to replicate the database  (Read 17799 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
how to replicate the database
« 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 ?

Offline
**
https://www.24x7servermanagement.com/
Server Management, Server Security, Server Monitoring.
India's Leading Managed Service Provider !!

Offline
**
Re: how to replicate the database
« Reply #2 on: December 27, 2020, 06:52:05 PM »
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.

Offline
*****
Re: how to replicate the database
« Reply #3 on: December 29, 2020, 07:55:38 AM »
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 ?

Offline
**
Re: how to replicate the database
« Reply #4 on: December 29, 2020, 10:57:21 AM »
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.

Offline
*****
Re: how to replicate the database
« Reply #5 on: December 29, 2020, 03:16:53 PM »
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

Offline
**
Re: how to replicate the database
« Reply #6 on: December 29, 2020, 11:07:01 PM »
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.