Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 102 10 Older Entries

Displaying posts with tag: cloud computing (reset)

Oracle Announces Paid MySQL Add-ons
+0 Vote Up -0Vote Down
 Oracle starts charging for MySQL Add-ons

Exciting news, Oracle just announced commercial MySQL extensions that they'll be offering paid extensions to the core MySQL free product.

To be sure, this has raised waves of concern among the community, but on the whole I suspect it will be a good thing for MySQL.  This brings more commercial addons to the table, which only increases the options for customers.  Many will continue to use the core database product only, and avoid license hassles while others will surely embark on a hybrid approach if it solves their everyday business problems.

Speaking of licensing, back in May, Amazon announced that it's RDS or Relational Database Service would now offer Oracle as an option.

  [Read more...]
Top 3 Questions From Clients
+0 Vote Up -0Vote Down

1. This page or area of the website is very slow, why?

There are a lot of components that make up modern internet websites, and a lot of places to get stuck in the mud.  Website performance starts with the browser, what caching it is doing, their bandwidth to your server, what the webserver is doing (caching or not and how), if the webserver has sufficient memory, and then what the application code is doing and lastly how it is interacting with the backend database.

With all this complexity, it's no wonder so many sites struggle.  Typically these types of analysis start with some load testing, to stress test your setup, so you can watch for leaks.  Then

  [Read more...]
Specialty Technology Consultant – New York Scalability Consultant – MySQL & EC2 Scalability
+0 Vote Up -0Vote Down

Amazon EC2 and cloud computing offer great promise for startups to ramp up their online presence quickly.  Navigate those challenges with an strong partner.  We bring 20 years experience to the table with each new client.

  • Scaling Web Applications
  • MySQL High Availability in Amazon EC2
  • Amazon Multi-AZ Deployments
  • Amazon RDS Deployments
  • Migrating to Amazon EC2
  • Migrating to MySQL
  • Managing Backups and Disaster Recovery in the Cloud
  • Horizontal Scalability of MySQL on EC2
  • Horizontal Scalability on Cloud Hosted Servers
  • Evaluating Cloud Providers
  • Evaluating MySQL
  [Read more...]
Open Source Enables the Cloud
+0 Vote Up -0Vote Down

With the fast growth of virtualized data centers, and companies like Google, Amazon and Facebook, it's easy to forget how much is built on open-source components, aka commodity software.  In a very real way open-source has enabled the huge explosion of commodity hardware, the fast growth of the internet itself, and now the further acceleration through cloud services, cloud infrastructure, and virtualization of data centers.

Your typical internet stack and application now stands on the shoulders of tens of thousands of open source developers and projects.  Let's look at a few of them.

1. Operating System - Linux

The commodity hardware craze would never have happened without the help of an open-source operating system to run on it.  Linux is an old story now, nonetheless everything else stands on it's shoulders.

2. Multi-purpose

  [Read more...]
8 Questions to ask an AWS Expert
+0 Vote Up -0Vote Down

If you're headhunting a cloud computing expert, specifically someone who knows Amazon Web Services (AWS) and EC2, you'll want to have a battery of questions to ask them to assess their knowledge.  As with any technical interview focus on concepts and big picture.  As the 37Signals folks like to say "hire for attitude, train for skill".  Absolutely!

1. Explain Elastic Block Storage?  What type of performance can you expect?  How do you back it up?  How do you improve performance?

EBS is a virtualized SAN or storage area network.  That means it is RAID storage to start with so it's redundant and fault tolerant.  If disks die in that RAID you don't lose data.  Great!  It is also virtualized, so you can provision and allocate storage, and attach it to your server with various API

  [Read more...]
Resilient Services – Resilient Infrastructure – Site Reliability Engineer
+0 Vote Up -0Vote Down

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

7 Ways to Troubleshoot MySQL
+0 Vote Up -0Vote Down

MySQL databases are great work horses of the internet.  They back tons of modern websites, from blogs and checkout carts, to huge sites like Facebook.  But these technologies don't run themselves.  When you're faced with a system that is slowing down, you'll need the right tools to diagnose and troubleshoot the problem.  MySQL has a huge community following and that means scores of great tools for your toolbox. Here are 7 ways to troubleshoot MySQL.

1. Use innotop

Innotop is a great tool for MySQL which despite the name monitors MySQL generally as well as InnoDB usage.  It's fairly easy to install, just download the perl script. Be sure to include a [client] section to your local users .my.cnf file (you have one don't you?).  Inside that section, place one line with "user=xyz" and one line with "password=abc".

If you're concerned that

  [Read more...]
5 Ways to Avoid EC2 Outages
+0 Vote Up -0Vote Down

1. Backup outside of the Cloud

Some of the high profile companies affected by Amazon's April 2011 outage could have recovered had they kept a backup of their entire site outside of the cloud.  With any hosting provider, managed traditional data center or cloud provider, alternate backups are always a good idea.  A MySQL logical backup and/or incremental backup can be copied regularly offsite or to an alternate cloud provider.  That's real insurance!

2. Use alternate regions and availability zones

  [Read more...]
MySQL Consulting – MySQL Services – MySQL Expert
+0 Vote Up -0Vote Down

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
  [Read more...]
3 Ways to Boost Cloud Scalability
+0 Vote Up -0Vote Down

Deploying in the Amazon cloud is touted as a great way to achieve high scalability while paying only for the computing power you use. How do you get the best scalability from the technology?

1. Use Auto-scaling

Auto-scaling is a unique feature of cloud computing and Amazon's EC2 offering. Setup a load balancer and a couple of webservers for your application as you normally would. Design your webserver based on a template AMI that you'll reuse over and over. Then setup auto-scaling and set thresholds based on the traffic you forecast. When a threshold is passed, AWS will spinup a new instance of your webserver, and roll it into the load balancer pool

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 102 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.