15

Here are more organized queries against the INFORMATION_SCHEMA Sizes By Storage Engine SELECT IFNULL(B.engine, 'Total') "Storage Engine", CONCAT(LPAD(REPLACE(FORMAT(B.DSize / POWER(1024, pw), 3), ',', ''), 17, ' '), ' ', SUBSTR(' KMGTP', pw + 1, 1), 'B') "Data Size", CONCAT(LPAD(REPLACE( FORMAT(B.ISize / POWER(1024, pw), 3), ',', ''), 17, ' '), ...


12

At the time this question was asked, this was not something RDS supported. Subsequently, though, AWS announced point-and-click copy of Amazon RDS DB Snapshots across AWS Regions. To launch an instance from a snapshot in a different region, you have to first copy the snapshot from the region where it was created and stored, into the target region. In the ...


10

Initial Connection You will find that the initial connection includes negotiating the SSL, so since the handshake is high, its a good indicator that something is seriously wrong with the way you have setup the SSL. Google Chrome: Understanding Resource Timing Time it took to establish a connection, including TCP handshakes/retries and negotiating a ...


9

This is a design limitation: The file size must be between 1,000 and 10,000,000 bytes. https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/ServingCompressedFiles.html Compressing files is resource-intensive, so the designers of CloudFront placed an upper bound on the size of files that CloudFront will spend resources compressing on-...


8

I finally found the easy way to get this information directly from Amazon with a couple of clicks. Log into the RDS management dashboard Click on "DB Instances" Click on the instance in which you are interested. That should expand it and show much more info about it. View the "Monitoring" tab. There is a "Free Storage Space" graph:


8

Reading the title of your question, there are two things you can do to speed up the initial connection and SSL/TLS handshake. These work for any connection, not just 3G, so you should use these as best practice anyway. First, use HTTP/2 to serve the site. This requires Apache 2.4.17 or later. Second, configure Apache to use OCSP stapling. This requires ...


6

$10 -- You can't run a website on AWS at this price. The minimal server they offer is a "Micro" instance at $0.02 per hour which is $14.40 per month. Even at slightly over budget you wouldn't want to use a micro instance for a website because the machine is severely limited. It is meant for testing only. As the CPU quota is used up, it may become ...


4

No, Rackspace doesn't have the equivalent of "stopping" an instance. If you delete the server it's gone, including any local backups. You can, however create an image of the server before you delete it. You can then restore the server later by doing a "Create Server From Image...".


4

As a basic start, try checking out Google app engine for hosting this project. Check out the basics of Boto. Then look at using Boto to access cloudwatch data. Build a client that outputs the data you want to the terminal when a function is called. Take the basic appengine tutorial. Then, look up the basics of webapp2 and the Jinja templating enjine. Make ...


4

You should have your website and your database in the same availability zone. It should be faster You are less exposed to the risk of an availability zone going down. When you spread your web server and database between two, your website goes down if either of them goes down. RDS has an option to have a hot spare of the database running in another ...


4

S3 web site hosting is strictly for static content. Nothing stored in S3 is executable by S3, such as PHP scripts. This is by design, and not a configuration issue with your site. You can host a static website on Amazon S3. On a static website, individual web pages include static content. They may also contain client-side scripts. By contrast, a ...


4

My issue was because my CloudFront origin was not in us-east, and when you auto-select your bucket's origin in CloudFront, it doesn't add the location prefix to the url. So make sure you add your s3 location like so: bucketname.s3.ap-east-1.amazonaws.com


4

This has to do with how Cloudflare connects to servers. Although it does serve the client via HTTP2 (or HTTP3), it still connects to the server itself via HTTP1.1. Cloudflare only uses HTTP/1.x between the origin web server and Cloudflare. https://support.cloudflare.com/hc/en-us/articles/200168076-Are-the-HTTP-2-or-SPDY-protocols-supported-between-...


3

I guess, the better, more scalable approach is to find out what system your client is using, and educate that network engineer. But if you really need a static IP to serve for Cloudfront content for your really important client, and if a different subdomain is acceptable to you, you could set up a proxy on your side for him. That said, you will lose the ...


3

I'm afraid I couldn't help you with the complications of setting up a Postfix mailserver, however with regards to your questions about the DNS records: The MX record you have created looks fine, provided that you have checked that (a) you have no other MX records with a priority less than 10, and (b) you have definately also got an A record setup for titan....


3

In my experience, two nameservers are required, and three are sufficient. Four is overkill.


3

There is no secret methodology to be determined here, and no need to do what you are trying to do. You should bid what the machines are worth to you, because you will not pay any more than the market demands. Now, I previously believed Amazon would just charge me for the highest price right above the next lowest competitor automatically ... I'm not sure ...


3

In the case where you have both www and non-www verions of the site readily available (i.e, you are not using 301 redirects from www to non-www or vice versa), yes, both profiles should be created in Google Webmasters Tools (GWT). However, you should also then specify your preferred domain to GWT, so that Google doesn't treat the www and non-www versions as ...


3

If an attacker is able to put themselves between your origin server and CloudFront edge location - it won't be so difficult for the attacker to capture your HTTP traffic and extract your information. Theoretically, it can be done on the side of your ISP. It is called as a "Man-in-the-middle" attack: https://en.wikipedia.org/wiki/Man-in-the-middle_attack If ...


3

Amazon has instructions for deploying WordPress on Elastic Beanstalk. The part that will prevent your problem is the section "Enable WordPress to Store Assets in Amazon S3". You have to install the "W3 Total Cache" plugin in WordPress and configure it to use "Amazon Simple Storage Service S3". When you have done that, plugins and themes will no longer ...


3

This is a limitation in the fundamental design of DNS itself. Adding a CNAME at the apex of a domain is essentially invalid because it leads to an illogical set of consequences. This is why Route 53 created A-Record Aliases -- to work around exactly this issue. Instead of an external referral, like a CNAME does, Alias records are an internal referral -- ...


3

I figured out the issue. When an AWS instance is rebooted, the DNS address changes. As I am using Wordpress, I need to update the siteurl and home url in the MySQL Database for the wordpress site to the new DNS address. In the pictures below for example localhost should be replaced with the DNS address of the instance. When the instance reboots, this will ...


3

I was in the position to try this. I have two AWS accounts: one for personal use and one for work. My work account has several domains using Route 53, including some typo redirects that nobody is going to notice if I mess them up for a little while. I logged into my personal AWS account. I added a hosted zone for a domain that already exists in my ...


3

What you are missing is that the components of the stack are somewhat abstract concepts, so the delineations are not necessarily clean, on the server side. Web servers typically sit in front of server-side language environments, sometimes they talk on sockets or pipes, or sometimes the language interpreter runs inside the web server's process space, and ...


3

These look to me like bots/crawlers running on EC2 instances, rather than anything to do with Cloudfront. AWS publish a list of IP ranges used by Cloudfront here : https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/LocationsOfEdgeServers.html They're probably harvesting content or email addresses, looking for vulnerable apps, open comment ...


2

This fellow says here that there is no penalty on Google SEO just for sharing an IP with another site.


2

I think using it with Lightbox makes chance of download hard. You can read this article: How to create a Video Membership Site with Complete Protection to Your Videos and after the content I found this: Limitting Accessing to Video Content These are for Wordpress but I think you can easily apply for PHP or other web programming language. Note : I ...


2

show table status from mydatabsename; where mydatabasename is your database name. This shows you the metrics Data_length and Index_length per table and other metrics. You would have to total these columns and remember that they are in bytes so you would have to divide by 1024 to get kb and then by 1024 again to get megs and then by 1024 again to get gigs. ...


2

We decided to save all xml files zipped to database and get them from there as soon as a bot asks for a specific XML Sitemap. Here are the theoretical steps: Create XML files with 45.000 urls. (45k according to this post) Save every url to database with information in which XML Sitemap it is in. gzip those files (8mb => 400-600kb) save them to a xml file ...


2

This post describes the exact steps (official AWS documentation) to do this: https://aws.amazon.com/blogs/devops/building-an-amazon-cloudwatch-dashboard-outside-of-the-aws-management-console/ You'll need to use CloudWatch snapshot graphs to achieve the same.


Only top voted, non community-wiki answers of a minimum length are eligible