Set Up Master Slave Replication In Mysql

[cmh]

Hello. Can you help me with auto mirroring?

Master: cmh (tomy)

Slave: mcmh (ricky).

After read, please mask servers.

Edited December 13, 2017 by cmh

[wolstech]

You can't do this because you're actually violating our terms of service by having two accounts without permission. Please delete one of the two accounts instead or provide a reason why you think you need two accounts. If you are unaware, you can host more than one website on a single account by using the add on domain feature. Please note that disk space is NOT a valid reason for two accounts.

 

I would recommend keeping the tommy account.

 

If one of the accounts is not deleted within 24 hours, both will be suspended until you decide which one you want to keep.

[cmh]

https://www.helionet.org/index/topic/29691-solved-tommy-down/?do=findComment&comment=134302

My mirror used only When Tommy is down (MySQl)

From post bellow, I thought that can create mirror.

 

Unfortunately, the tomy are often unavailable for about an hour. So I'm trying to solve this problem. When the volume is unavailable, the data is taken from Ricky.

 

You can make sure that these are simple rare requests. I do not overload the system

Edited December 13, 2017 by cmh

[wolstech]

I'll escalate this for you just because I've never had someone ask for two accounts with the intended purpose being downtime mitigation. We usually recommend CloudFlare for this purpose.

[cmh]

May CloudFlare Help with MySql?

The decision that I deleted the account is the final one?

Or i need to wait for KryDos (I'm sorry if the nickname is not correct)

[wolstech]

Wait for Krydos.

 

CF will not help with MySQL, but then we don't usually have issues with MySQL either. It's always Apache that goes down (because it has to restart for new domains and accounts), and CF will help with Apache so long as the content is not dynamic (e.g. a forum).

[Krydos]

You really think all this effort is needed to squeeze out another half a percent of uptime?

[cmh]

I did not have any more ideas, I tried all the options, but now I think the problem was that as a server I used Domain, not IP.

In addition, I added CF. Let's see how it will help me. My main problem is that I could not Connect to MySql when the site Was down.

You can give me a little more time to understand how this affects me? Then I'll write about the results and / or delete the mirror.

[Krydos]

My main problem is that I could not Connect to MySql when the site Was down.

When was Tommy down?

[cmh]

12.12.2017 at 09:40 Pm (utc+1)

09.12.2017 at 08:13 pm (utc:1)

It was then, that I had a problem

Fortunately, it was a few minutes.

It was also 04:12:2017 At ~6PM (As I was told it was., A few hours, but I did not check.)

I apologize for the translation.

[wolstech]

12/12/17 @ 8:13PM UTC+1 was a DDoS or HE connectivity issue that was beyond our control. All servers went down at the same time, so a second server won't help there: http://heliohost.grd.net.pl/monitor/archive/?2017-12-12

 

12/9/17 @ 9:40PM UTC+1: No outage at that time, but there was a prolonged outage earlier in the day on Tommy, related to an unknown issue that caused excessive load and its fix which involved rebooting the server: http://heliohost.grd.net.pl/monitor/archive/?2017-12-09 This one may have benefited from a second server.

 

12/4/17 @ 6PM UTC+1: There were actually two events that day, both were user-induced load spikes and the server worked as designed by suspending the users and returning to normal operation within minutes. http://heliohost.grd.net.pl/monitor/archive/?2017-12-04 Both users have since posted here on the forums and we helped address their load issues (one was a website that got hit by a botnet, the other was malfunctioning WordPress).