… of the IO operation. Innodb access the data from the remote scsi device bypass the iscsi protocal and the network is…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… Percona we provide services both Onsite – visiting the customers and Remote – logging in to their systems or communicating via email,phone… application redesign, for performance review or for starting long term Remote DBA or support relationships. They can be done with little… or implementing changes on production which when can benefit from remote followups to validate changes and provide further advice. Multi day…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… or considered less risky, while remote consulting would work great. Interesting enough in many cases Remote Consulting turns more efficient than onsite… now. Time managing is complicated. I already described benefits of Remote Consulting for customers, but these benefits cause a lot of… per day, 40 billable hours per week, when you work remotely especially on small projects and keeping chaos of rescheduling in…
Comment: Onsite and Remote - getting best of both worlds
July 3, 2009 By 1 Comment
….pythian.com states that Pythian does “remote database management”, we actually do both onsite and remote work. I think of a database… 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: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
…, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks… log backups. The wrapper script below will connect to the remote server specified in the config and ensure mysqlbinlog utility is… $LASTFILE echo “Starting live binlog backup” $MBL –raw –read-from-remote-server –stop-never –host $MYSQLHOST –port $MYSQLPORT -u $MYSQLUSER -p…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… TERM EXIT touch $TMP/$LOCKFILE # run the tcpdump & write to remote file and sleep for a bit tcpdump -i eth0 -s…=$! sleep $SLEEPTIME kill $PID # set trap to be sure both remote files are removed trap ‘ssh $REMOTEHOST — “rm -f $TMP/$TMPfile…/$RESfile $RESfile # email $RESfile using your preferred transport # clean up remote and local files. ssh $REMOTEHOST — “rm -f $TMP/$TMPfile $TMP…
Comment: Cache Performance Comparison
May 21, 2008 By 73 Comments
Hey, why you compare local caches (the same machine) with remote-caches (in the network). I mean you test is excellent… you can’t compare this two different cache-types. The remote-cache is always slower! But when you save the cache… is very, very slow (too many requests) than is the remote – machine a lot of quicklier with the same cache-save…
Post: A note about Pythian
April 17, 2008 By 4 Comments
… competing businesses this is indeed only somewhat. Pythian focuses on Remote DBA with long term commitments while we do a lot… and only starting to get into 24/7 Support and Remote DBA offerings, We also do a lot of Architecture Design… few places in the world though some people also work remotely. This is probably another thing which enterprise customers would appreciate…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… overhead than triggers and change data capture may be done remotely and asynchronously. Binary log based CDC The CDC tool included…. It is possible to read from and/or write to remote servers, but this example uses the local machine which is…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…. Although an HA solution can be built remotely through a KVM over IP and adequate remote power management, an on site intervention…
