Supporting successful services on the web means scaling your back-end databases across multiple dimensions. This blog focuses on scaling access methods to your data using SQL and/or NoSQL interfaces.

In Part 1 of the blog series , I discussed scaling database performance using auto-sharding and active/active geographic replication in MySQL Cluster to enable applications to scale both within and across data centers.  

In Part 2, I discussed the need to scale operational agility to keep pace with demand, which includes being able to add capacity and performance to the database, and to evolve the schema – all without downtime.

So in this blog I want …

It's very cool!

The early bird registration for Oracle OpenWorld has been extended to August 12. Sign up now to save $500 with the early bird rate, plus an extra $500 discount using the code "MYSQL11", which adds up to $1,000 savings in total compared to the on-site rate!

Don't miss this (extended) opportunity to attend the 40+ MySQL sessions and meet with the MySQL experts face to face. You can find all the MySQL talks at Oracle OpenWorld in the Content Catalog by selecting "MySQL" under the "Database Stream". Highlights include:

• MySQL - The State of the Dolphin, by Tomas Ulin
• Advanced MySQL Replication Architectures, by Lars Thalmann and Luis Soares
• NoSQL Access to MySQL - The Best of Both Worlds, by Andrew Morgan and …

On today's show, Google is upset that its competitors are using a giant portfolio of patents to attack Android. Never mind that Google could have joined in the purchase of said portfolio or, more importantly, that it's got the clout and cash to lead a fight against software patents in the first place. Good try, though! Also, our government prepares for the next war on terror--cyber-terror--and will HBO Go ever go a la carte? We hope so!

A while ago I started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t add anything to this discussion, I got sidetracked, and then time passed, and I no longer think it’s a good idea to publish those blog posts in the format I was planning. Instead, I want to write an overview of these two approaches to hosting MySQL in the Amazon cloud.

In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what you can get on physical hardware, even low-to-medium sized servers. It’s not that it’s terrible (in most cases), but it’s not always great. There are specific use cases in which it’s perfectly acceptable and even good, but the range of cases isn’t as broad as what you can push your …

The final videos from Open DB Camp back in May in Sardinia, Italy are now online.  The full matrix of sessions, videos and slides can be found on the schedule page.

Hands on JDBC by Sandro Pinna - video

"MySQL Plugins, What are They? How you can use them to do wonders" by Sergei Golubchek of MariaDB - video

The State of Open Source Databases by Kaj Arnö of SkySQL - video

Coming soon, videos from …

Next week I will give a free IOUG webinar on Securing MySQL on Wednesday, August 10, 2011 from 11:00 AM - 12:00 PM CDT (17:00 GMT):

Securing MySQL is extremely important, but often is not done properly. I will explain the different ways to secure MySQL. In addition to securing users and privileges, file permissions and encrypted connectivity will be discussed. The MySQL server options that contribute to MySQL security will be pointed out, along with tips for eliminating unsecure external scripts. For those who want more auditing capabilities, this session will explain how to see all login attempts (successful and not) and how to lock out accounts with repeated failed logins. The session will conclude with guidelines about how to create security policies for your organization.

To register for …

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

Nice ! I liked it
In windows… below CMD would help.

**********************************
REM Batch file start…
@ECHO OFF
..\processkiller.exe –kill –force mysqld*.exe >nul 2>&1
REM Above can be done with any other tools or may be manually.

ECHO USE `mysql`; >reset_root.sql
ECHO. >>reset_root.sql
ECHO INSERT IGNORE INTO `user` VALUES (‘localhost’, ‘root’, ”, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ”, ”, ”, ”, 0, 0, 0, 0); >>reset_root.sql
ECHO REPLACE INTO `user` VALUES (‘localhost’, ‘root’, ”, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, …

As the dog days of summer set in and temperatures rise, this year’s O’Reilly OSCON conference in Portland, OR offered the open source community a brief respite from the heat. However, if you’re thinking the event lacked sizzle, think again. The energy, the discussions and the opportunities to collaborate, plus the chance to learn from/ interact with customers and potential customers, made OSCON one of the highlights of July.

While I’ve attended previous OSCON conferences while at MySQL AB, this was the first time I’ve attended as the CEO of SkySQL. My new role provided a different perspective, as well as new kinds of opportunities to interact with the open source community. There were plenty of terrific, formal presentations and Birds of a Feather (BOF) sessions, however, those from MySQL, MariaDB and Drizzle were especially noteworthy and informative. Here were a few high points:

MySQL MHA – It was amazing to …