Showing entries 1 to 3
Displaying posts with tag: ec2 scalability (reset)
Resilient Services – Resilient Infrastructure – Site Reliability Engineer

Modern internet infrastructure are complex.  Components and services are prone to failure.  Resiliency involves building redundancy, best practices and processes into your architecture to make you able to bend and not break.

  • Migrating to cloud service providers
  • Rearchitecting and refactoring applications to scale
  • Scaling the database tier - MySQL and Oracle
  • Building redundancy into every layer
  • Deploying object caches - memcache
  • Deploying page caches - varnish
  • Migrating to Innodb - transactional storage engine
  • Infrastructure design
  • Infrastructure automation
  • Disaster Recovery
  • Business Continuity with cloud deployments

Call or Skype us in New York City +1-212-533-6828

MySQL Consulting – MySQL Services – MySQL Expert

Call or SKYPE us in New York City: +1-212-533-6828

MySQL in the Cloud

  • Deploying MySQL in the Cloud
  • Cloud Security considerations for databases
  • Deploying in multiple Availability Zones
  • Deploying in multiple regions
  • Deploying MySQL with multi-az
  • Horizontal scalability in the cloud
  • MySQL spinup scripts
  • Deploying Amazon RDS
  • Evaluating RDS
  • Evaluating MySQL in the cloud
  • EBS Performance considerations
  • Tuning MySQL parameters in the cloud
  • Backup types & options
  • Mitigating against cloud server failure
  • Vertical scalability & MySQL on EC2

MySQL Consulting and Services

  • Backup & recovery
  • MySQL master master replication
  • MySQL replication & horizontal scaling …
[Read more]
5 Ways to Boost MySQL Scalability

There are a lot of scalability challenges we see with clients over and over. The list could easily include 20, 50 or even 100 items, but we shortened it down to the biggest five issues we see.

1. Tune those queries

By far the biggest bang for your buck is query optimization. Queries can be functionally correct and meet business requirements without being stress tested for high traffic and high load. This is why we often see clients with growing pains, and scalability challenges as their site becomes more popular. This also makes sense. It wouldn't necessarily be a good use of time to tune a query for some page off in a remote corner of your site, that didn't receive real-world traffic. So some amount of reactive tuning is common and appropriate.

Enable the slow query log and watch it. Use …

[Read more]
Showing entries 1 to 3