… HA as MySQL gets anyway) for international users and systems, not just a little PHP site in Dubuque. The “night-time trough” is no longer a luxury for a lot of the client base of MySQL. 2. LVM… for their storage hardware to support a method of database backup used solely because a working solution isn’t available from…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… implementation (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability with MMM or… waiting on database (or other) operations to complete – backup, restore, ALTER TABLE, load testing – all of…work which needs to be done at night hours. Remote work however also needs …
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… ? Often performance problems happen only Sometimes….. for example nightly when you do a backup or at 15 minutes off hour when you… hardware upgrade and it also can be done easily. Is MySQL, Queries, Architecture optimized well enough ? Do not advice hardware upgrade… 4 Core systems to 8 Core reduced performance for many MySQL systems even though hardware itself was superior. There are surely…
Comment: Why you can't rely on a replica for disaster recovery
August 1, 2010 By 25 Comments
… we have a dedicated backup slave, which we then turn off replication and take a dump of nightly. We’ve been toying… of estimated manner. But until they add that feature to MySQL proper, it’s not really reliable.
Comment: Master-Master or Master with Many Slaves
April 9, 2007 By 7 Comments
… Many applications level of Master-Master reliability is enough + backup of course. Second I’m not really arguing … having 10+ slaves replicating 500GB database. Regarding good night sleep, well it depends a lot on number … so many times I think it is not MySQL related at all. “Sure… but this is a …
