The open-source xtrabackup tool from Percona brings much needed hot backup functionality to MySQL deployments. In this database journal article we discuss logical, cold, and hot backups, then explain how to use xtrabackup on your MyISAM, InnoDB, and XtraDB tables to create at-the-ready backups. We then take you through the step-by-step process to restore them, and even the process of point-in-time recovery too.
Posts Tagged mysql
DBJ – MySQL Character Sets
Oct 15
In our latest article at Database Journal we talk about Character Sets in MySQL. What are they? How do they affect searching? How do they affect data that is inserted or updated? How can I set and control the for an application or globally in my database? And what pre-tell is collation? We answer all these questions and more.
DBJ: MySQL Benchmarking
Oct 12
Benchmarking is liking running your system through it’s paces. You don’t know how fast your software and hardware are until you’ve put some pressure on them. Benchmarking tools allow you to do just that. We use sysbench to look at the operating system and mysqlslap to run queries in the MySQL database.
Multi-master MySQL, with the MMM management software brings a whole host of new features, and manageability to your MySQL deployments. Run backups, alter tables, perform upgrades all without slowing down your production users.
Read more at Database Journal – Using Multi-master MySQL To Get A Leg Up On Database Performance
If you’re new to the MySQL DBA role, you’ll be excited to learn about the Maatkit toolset. It provides a whole host of valuable functionality and fills many of the DBAs day-to-day needs.
I recently presented a webcast hosted by O’Reilly and Webex. In it I take you on a step-by-step installation of DRBD and MySQL. I start by using Sun’s Virtualbox to create to virtual machines running CentOS. I then explain how to configure them with virtual external drives to use for DRBD. I next configure the network interfaces to support routed packets into and out of the boxes. Then I install various packages with yum, configure drbd and finally install MySQL as the last step. You can follow along at the command line and do it yourself on a Windows, Mac or Linux box.