On 7th last month, LeadsLeap main database server was down for about 12 hours.<\/p>\n\n\n\n
As it was the main database, everything was down, including page, tracker, SendSteed and LeadsLeap main site.<\/p>\n\n\n\n
It was the worst outage in LeadsLeap history.<\/p>\n\n\n\n
I kept pestering the host support. That was the only thing I could do.<\/p>\n\n\n\n
In the end, the culprit was a connection issue at the data center. It had nothing to do with our server.<\/p>\n\n\n\n
This incident made me fully understand this proverb, “A chain is only as strong as its weakest link<\/em><\/strong>“.<\/p>\n\n\n\n So I set out to find a better alternative.<\/p>\n\n\n\n My ideal solution is to have 2 different database servers, in different data centers, hosted by different companies.<\/p>\n\n\n\n The two databases will auto-sync.<\/p>\n\n\n\n If one database is down, another database will take over immediately.<\/p>\n\n\n\n Today, I am pleased to announce that LeadsLeap auto-switch database system is now launched.<\/p>\n\n\n\n Our database is hosted in 2 different servers, one in the East of US, another in the West. So the chance of both servers or data centers failing is near zero, unless someone bombs the entire US!<\/p>\n\n\n\n We have just completed the migration process today.<\/p>\n\n\n\n If you experience anything unusual, please let me know.<\/p>\n\n\n\n Bear with me if you experience any teething issue, and make sure you report all issues to me.<\/p>\n\n\n\n The last incident had haunted me for nearly a month.<\/p>\n\n\n\n Now, I can sleep better.<\/p>\n\n\n\n That doesn’t mean LeadsLeap system is infallible. Things can still fail at other levels. But database is the heart of everything, and I’m quite confident to say that our database is now infallible.<\/p>\n","protected":false},"excerpt":{"rendered":" On 7th last month, LeadsLeap main database server was down for about 12 hours. As it was the main database, everything was down, including page, tracker, SendSteed and LeadsLeap main site. It was the worst outage in LeadsLeap history. I kept pestering the host support. That was the only thing I could do. In the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/posts\/1688"}],"collection":[{"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/comments?post=1688"}],"version-history":[{"count":1,"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/posts\/1688\/revisions"}],"predecessor-version":[{"id":1689,"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/posts\/1688\/revisions\/1689"}],"wp:attachment":[{"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/media?parent=1688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/categories?post=1688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leadsleap.com\/blog\/wp-json\/wp\/v2\/tags?post=1688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}My ideal solution…<\/h2>\n\n\n\n
Wish comes true…<\/h2>\n\n\n\n
Now I can sleep better at night…<\/h2>\n\n\n\n