What are the key improvements in MySQL 5.1, and why are they important for users?
The big one is a performance gain of 15% in overall performance and throughput in benchmark tests. With hundreds of thousands of servers, that's huge, and it enables customers to continue to scale and the ability to handle much larger data sets and applications.
Advanced users are pushing for more scale and throughput. They are asking about power consumption of applications and the power to drive and cool these machines. How will you address these issues?
We have Workbench, a database modeling tool for database administrators or designers. They can visually see the database setup and the relationship between tables and schemas. Falcon Storage Engine will be coming later this year. It's designed for multicore, multithreaded systems for very large Web applications. It will have linear scalability and more CPUs, so it goes faster, which addresses the issue of scalability.
There will be more and more data, and people will want to do more analysis. Data warehousing is huge and growing. Ten years ago, data warehousing was about OLTP [online transaction processing], ERP [enterprise resource management] and CRM [customer relationship management]. These are still important but, it's more and more about Web-based applications, analysis and reporting. MySQL gets used in a lot of hosted environments. It's used by Amazon, Rackspace and many on-demand Software as a Service (SaaS) applications. There's more use of databases, and increasingly databases will be like Facebook: Web-based, running 24/7, and hosted instead of running on premises. How can data center managers adapt to these trends?
Start evaluating best practices for operating systems and Web infrastructure. What are the best practices of Amazon, eBay and Facebook? These principles are applicable to all IT departments. The Web infrastructure and the enterprise infrastructures are converging, and the Web infrastructure will define the enterprise infrastructure for the next 10 years.
Let us know what you think about the story; email Pam Derringer, News Writer .