… two identical physical boxes with at least 4 NIC ports. Why 4? Two of those NICs …-backup or LACP (depending on your switching infrastructure). In essence, you’re looking for two of everything…in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, …
Post: Living with backups
November 6, 2008 By 28 Comments
… is physical memory installed on the server – it’s not difficult to have a database of such size…the way of the database work so much. ionice -c3 /root/backup-tools/tar … ionice -c2 -n7 /root/backup-tools/… problems to happen on the working instance of MySQL. Such danger may for example come from …
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well as… on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only way practical at this point for databases of decent…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…you don’t need high concurrency from your MySQL database. When you do, the limitations on the …many companies 
OK, end of tangent. However, if you are careful with your physical and logical design, …nice for making replicas and backups, for example. I could name a bunch of other nice properties, …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… share same physical drives …MySQL if you’re looking for durable transactions the log write latency is triple important compared to other database systems. MySQL…of MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…(2.5″ SAS disks, 15K RPMS) and 32GB of physical RAM, but restricted on kernel level to …backup. Actually I would say backup is only partially the problem of storage engine. The biggest problem is that MySQL…where logs are 80% of total database size. Also there is the problem of being able to run …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…of a database server. In term of write capacity here are you choices. Write capacity MySQL…, backups, migration to production and post migration monitoring. Of…physical access to the servers is the preferred way, especially for the most complex solutions. Proof of concept Migration to Production MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… move on to the MySQL server. I mean, let’s just assume the physical hardware and the …s up with the database. The first step is to find out what MySQL instances are on the …such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all of which we can frequently…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… we don’t have a backup or the backup restore process doesn’t work….: http://dev.mysql.com/doc/refman/5.5/en/innodb-physical-record.html You… salaries.recovery you can find lot of deleted rows, not only rows deleted … is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery…
Post: Small things are better
October 8, 2006 By 15 Comments
… but still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or… recovered from backup but in certain cases you may need to reimport whole database – if corruption … virtual servers even if you work with physical one in the beginning. Different accounts with …
