Category: AWS
-
Migrating WordPress from Lightsail to S3 + CloudFront
After almost a decade of running MannanLive.com on WordPress via Amazon Lightsail, I finally decided to pull the plug and move everything to a simpler, static setup using Amazon S3 and CloudFront. Why the change? A few reasons, really. First, while Lightsail is pretty affordable at $5 USD a month, the cost adds up –…
-
Serverless Backup Magic: Exporting Aurora Snapshots to S3
Automating Daily Database Backups from Aurora to S3 with AWS CloudFormation Running a successful business like RosterPortal.com.au since 2007, I’ve always relied on MS SQL Server for database management. Our daily text exports to S3 have been an invaluable part of our backup strategy. Now, as we migrate to Babelfish Aurora PostgreSQL, we’re faced with new challenges, one of which is…
-
AWS CodeCommit – Update Workflow Tool on Commit
If you use a workflow tool such as Trello, Assembla or Jira to help manage software development and are also using Git for your source control, you will often want to automatically update or add a comment to cards whenever a new commit is made. Luckily, you can do this easily if you are using…
-
Accessing SQL Server in AWS Lambda – Part 3
This is Part 3 on a series detailing everything you need to get going on your serverless architecture whilst using your existing SQL Server database. View the source on GitHub or checkout Parts 1 & 2 if you haven’t already. Step 6: Handlers We haven’t done anything related to AWS Lambda so no wonder you…
-
Accessing SQL Server in AWS Lambda – Part 2
This is Part 2 in a series describing how to get Microsoft SQL Server and AWS Lambda playing nicely together. You can find Part 1 here. If you already know how to use java SQL to connect to a database, you can skip these steps and move onto Part 3. Otherwise if you work better…
-
Accessing SQL Server in AWS Lambda – Part 1
AWS Lambda is great, but I had many difficulties finding a way to connect into my RDS SQL Server instance. I started with Python and ODBC (both pyodbc and pypyodbc), but ran into so many issues with missing libraries (LD_LIBRARY_PATH of death). I turned to Java, but I think SQL Server and Java are a…
-
C# AWS CORS Upload full example
AWS CORS allows your users to upload files directly to an AWS bucket securely. There are many benefits to storing files on S3 rather than on your local web server storage, such as life-cycle management, cost and allowing horizontal scaling. If you already upload users files to S3 then CORS removes the need for your…
-
CloudFormation public EC2 instance example using existing VPC & Subnets
For my extracurricular business I have a test server that I can deploy any changes I make to it and test them in the most production like environment I can muster. As it is hosted on AWS, I can easily create & destroy it so I only pay for when it is being used, not…
-
AWS Sydney Summit
The CTO of Amazon Web Services delivered the keynote speech of the AWS Sydney Summit. I personally thought it was mostly a glorified sales pitch but the parts where representatives from other companies that have migrated to the cloud, like NAB bank, were quite interesting. NAB picked their public facing website, refined their dev-ops process,…
-
AWS S3 Command Line Bucket File Upload in C#
I generate full-size backups of my database every night, but they just collect dust on my production server taking up space. Not only that, but if I lost the server, the backups would be gone to, so I wanted to investigate some options. I have recently moved my servers and database to Amazon Web Services…