….sql Create the new target database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig... issues) with SQL rather than needing to import from a remote server. This can allow for more targeted restores, easier comparison, and allow remote users to compare on a live system without needed to…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… instances? A: It depends. Most MySQL tools can connect to remote hosts and will work with Amazon RDS but others (like… manager, with the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally Available) stable release… implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… client libraries. The only change between runs is on the remote server (stop/start memcached, stop/start plugin). As expected, there… of warmup time to application Cost of disk space on database server Now, there are definitely other NoSQL options for persistent…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… or implementing changes on production which when can benefit from remote followups to validate changes and provide further advice. Multi day… implement changes and millions of other things. Second – waiting on database (or other) operations to complete – backup, restore, ALTER TABLE, load…
Comment: Onsite and Remote - getting best of both worlds
July 3, 2009 By 1 Comment
… states that Pythian does “remote database management”, we actually do both onsite and remote work. I think of a database as a garden — the… landscaping (and maybe even doing it) and planting, and the remote work is great for weeding, mowing the lawn, watering the… communication is good, even the bigger projects can be done remotely.
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… we dump schemas: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…’ is used in order to synchronize updated contents of a remote database object with the file and the device.†Let’s… what’s going on: /* Synchronize updated contents of a hash database object with the file and the device. */ bool tchdbsync(TCHDB… is tchdbmemsync. /* Synchronize updating contents on memory of a hash database object. */ bool tchdbmemsync(TCHDB *hdb, bool phys){ assert(hdb); if…
Comment: Database problems in MySQL/PHP Applications
August 13, 2006 By 13 Comments
… realize that this is *within the database system only*. ie, if you only go to the database once, then go ahead, run as many queries as you want. If a system is being developed with a *remote* database… and only go across the network and back to the database once.
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… accessed by other programs. CDC applications exist for many commercial databases but until recently this type of software was not available… identify rows that have changed Triggers to capture changes synchronously Database log reading to capture the changes asynchronously The first method… overhead than triggers and change data capture may be done remotely and asynchronously. Binary log based CDC The CDC tool included…
