]]> ]]>

Configuring Percona Server with XtraDB for Fast Restarts

InnoDB requires a long time to restart on servers with large amounts of
memory. It can take many hours to warm InnoDB up enough to serve queries
quickly. The database's "working set" of data is not in memory after a restart,
so queries must perform random disk I/O to read pages, and are thus too slow for
production use. Percona Server with XtraDB greatly lowers database warmup time
by quickly restoring the buffer pool to its state before shutdown. This enables
higher uptime, and removes the need for elaborate methods of warming up servers.
It reduces the cost of a server restart, permitting MySQL to scale to
much larger hardware and to be used more flexibly. Percona Server's fast restart
capabilities provide significant operational and cost advantages in scenarios
such as cloud computing, high availability, dynamic scaling, and restores from
backups.

January, 2011


Authors

Baron Schwartz

Baron Schwartz

-

Baron is the lead author of High Performance MySQL and the creator of Maatkit, which later became Percona Toolkit. He is a former Percona consultant and executive.


Vadim Tkachenko

Vadim Tkachenko

Co-Founder, CTO

Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background. Source code patches authored by Vadim have been incorpor



Our MySQL white papers are free and require no registration to download. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>