PlanetMysql.ru — информация о СУБД MySQL

If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.

Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.

The session discusses:

1. Causes, effect and impact of downtime
2. Methodologies to map applications to HA solution
3. Overview of MySQL HA solutions
4. Operational best practices to ensure business continuity

Thanks to everyone who signed up and attended the webinar I gave this week with Tim Callaghan on Scaling MySQL. For those who missed it and are interested, the video and slides are now posted here.

A brief description of the webinar is also below.

MySQL implementations are often kept relatively small, often just a few hundred GB or less. Anything beyond this quickly leads to painful operational problems such as poor insertion rates, slow queries, hours to days offline for schema changes, prolonged downtime for dump/reload, etc. The promise of scalable MySQL has remained largely unfulfilled, until TokuDB.

TokuDB v5.0 delivers

• Exceptional Agility — Hot Schema Changes allow read/write operations during index creation or column/field addition
• Unmatched Speed — Fractal Tree indexes perform 20x to 80x better on write intensive workloads
• Maximum Scalability — Fractal Tree index performance scales even as the primary index exceeds available RAM

This webinar covers TokuDB v5.0 features, latest performance results, and typical use cases.

 
This version includes support for “SELECT … FOR UPDATE” as well as displaying table “create time” and “last update time” via “SHOW TABLE STATUS”. The release also addresses a number of other bugs and fixes such as “point update” and “replace into” deadlocks. For more details, see the release notes section of the user’s guide, available here. To get the latest version of TokuDB (free for evaluation, development, testing, qualification, experimentation, and POCs ) click here. Starting with this release, we’ve also streamlined the installation process by creating a combined tarball that includes both MySQL and TokuDB.

Note that we’ll be hosting an upcoming webinar on November 15th for those who want to learn more about TokuDB in general as well as the details of version 5.0.6. For details on the webinar, see here.

MySQL implementations are often kept relatively small, often just a few hundred GB or less. Anything beyond this quickly leads to painful operational problems such as poor insertion rates, slow queries, hours to days offline for schema changes, prolonged downtime for dump/reload, etc. The promise of scalable MySQL has remained largely unfulfilled, until TokuDB.

Time: 2PM EST / 11AM PST

REGISTER TODAY

TokuDB v5.0 delivers

• Exceptional Agility — Hot Schema Changes allow read/write operations during index creation or column/field addition
• Unmatched Speed — Fractal Tree indexes are optimized for index insertion performance
• Maximum Scalability — Fractal Tree index performance scales even as the primary index exceeds available RAM

This webinar covers TokuDB v5.0 features, latest performance results, and typical use cases.

About the Presenters

Tim Callaghan is the Director of Technical Services at Tokutek. Mr. Callaghan brings 20 years experience building and administering database applications for commercial and internal usage. At VoltDB, he led the field engineering efforts, was the point contact for all commercial and community customers, and served as Product Manager. Before that, he was the Chief System Architect at CrunchTime Information Systems, building their SaaS restaurant solutions and distributed database offerings for the cruise industry. He also spent 8 years at Investors Bank & Trust (a Boston-based financial services company) as the Director of Database Technologies.

Lawrence Schwartz is the Senior Director of Marketing at Tokutek. Mr. Schwartz has over 15 years of experience in data and information systems as an engineer, marketer, and P&L manager. He has been a featured speaker at Storage Networking World, Data Center World, and the Flash Memory Summit and has been quoted in Wired, Xconomy, and MIT’s Tech Review. He joins Tokutek from E Ink, where he oversaw marketing and product management and led an international integration with PVI, who acquired E Ink in 2009. Before E Ink, he spent 5 years at EMC leading Symmetrix marketing, including the rollout of enterprise SSD systems and virtual provisioning.

There’s a webinar this Wednesday (9 am Pacific; 5 pm UK; 6 pm CET) that explains what’s new in the MySQL Cluster Development Milestone Release – register here for free access.

Join this session to learn about the latest enhancements to the MySQL Cluster database, enabling even more of the latest generation of web, telecoms and embedded applications to take advantage of high write scalability, SQL and NoSQL interfaces and 99.999% availability.

New capabilities include:

•  70x higher JOIN performance for the latest generation of web applications using Adaptive Query Localization, enabling real-time analytics across live data sets
• New NoSQL interface via memcached to further enhance developer flexibility and productivity
• Simplified global scalability with multi-site clusters and enhanced Active/Active replication
• Integration with the MySQL 5.5 release, enabling users to fully exploit the latest capabilities of both the InnoDB and MySQL Cluster storage engines within a single application
• Streamlined cluster provisioning and maintenance

The 2nd Development Milestone Release of MySQL Cluster 7.2.1 was announced at Oracle OpenWorld 2011. This release is now available for download and evaluation under the GPL license. This session will help to get you started with this latest release.

I’ll be presenting a free one-hour webinar on preventing downtime in production MySQL servers, in conjunction with the ODTUG. It is scheduled on Thursday, November 10, 2011 3:00 PM – 4:00 PM EST, and you can register for free.

Here’s an abstract of what you’ll learn:

Everyone wants to prevent database downtime by being proactive, but how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have solved, to better understand what types of problems really occur in production environments. The results are somewhat surprising, and will be detailed in this talk. Most incidents we found were not MySQL-specific and will be familiar to Oracle DBAs as well as MySQL DBAs. This presentation will be valuable for the new or seasoned DBA, as well as to operational managers/directors and CTOs responsible for business critical implementations.

Please register today and I look forward to joining you.

Further Reading:

• Free webinar on MySQL performance this Thursday
• I moved this blog to pairLite with zero downtime, and it was easy
• MySQL: Free Software but not Open Source
• Get a free sample chapter of High Performance MySQL Second Edition
• Why I write Free Software