Tag: mysql

Backup to AWS S3 Bucket

Backup to AWS S3 Bucket

While this is not an uncommon thing to do, I couldn’t find a straight forward example for both databases and file directories. So of course, I had to write my own (albeit based on a database only script from mittsh). For the TLDR; just go to https://github.com/mikemcmurray/backup-to-s3 It’s written in python using the ubiquitous boto3 and …

+ Read More

MySQL Fails to Update on Ubuntu

MySQL Fails to Update on Ubuntu

So your Ubuntu server doesn’t want to upgrade MySQL using apt-get and fails with the following error? mysql_upgrade: Got error: 1045: Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES) while connecting to the MySQL server Upgrade process encountered error and will not continue. Thankfully the fix should be fairly easy to carry out. For some reason …

+ Read More

MySQL Replication on Ubuntu with DRBD

MySQL Replication on Ubuntu with DRBD

I’ve been looking around for some easy and open-source ways to handle database replication for a handful of small but important MySQL databases. A few options were viable but usually included too many config changes for things like creating a new database. DRDB on a Linux server seems to be one of the fastest and …

+ Read More

Installing a Windows Dev Box

Installing a Windows Dev Box

In the interest of saving this for future reference, here’s is a general how-to for installing a Windows based Web development server. The reason for running up a Windows server as opposed to the typical LAMP alternative on Windows was due to frustration. The older Ubuntu server I had just made it very difficult to …

+ Read More