Categories
Azure

Handle replication errors on Azure Database for MySQL flexible server

At work we have just recently started moving our data to Azure Cloud. We still have the old on-premise setup running, with databases and web servers.

To make the move to Azure Cloud, I have used a lot of time prepping the terraform scripts to handle our servers, but I have only recently been able to make a copy of the current database (with a whopping 1.7TB of data) and copy it to the cloud.

It took a few days to insert the data into Azure MySQL, so after getting a replication error today, I was not ready to drop the replica database, to insert a fresh dump.

Continue reading

Categories
MySQL Server

Problems connecting to unix:///var/mysql/mysql.sock

In a previous post I talked about MySQL 5.5 and Mac OSX. In this post I’ll go through fixing the problems with PHP and connecting to your local mysql install, using “localhost”. The problems began a while back, with lots of errors in my apache error log saying: [error] [client ::1] PHP Warning: mysql_connect(): [2002] No such […]

Continue reading