…a database great, but if there is a better solution we want to suggest it. It’s our goal to…replication…limit and fell over dead. It’s interesting to see the number of transactions that occur with a…a comma delimited string to represent the row.  Mysql was running with 256M allocated to…
Page: Consulting for MySQL
July 31, 2006 By
…to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to…
Post: Announcing Drizzle Day, Fri 13th April 2012
February 8, 2012 By Leave a Comment
…replication techniques (such as crash safe replication, multi-sourced replication and being able to consume the replication stream in your application), AlsoSQL (a HTTP interface to a relational database…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
…to be a services company, pure and simple. The value we provide to customers is our depth of knowledge about how to…to provide an open-source database server that delivers improved performance and functionality to…MySQL and open-source software, including Oracle, and look forward to a…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…a typical master-slave replication with ROW based binary log file. The application connects to the database using persistent connection technique to…a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing it to…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…a customer recently who needed to reduce their database size on disk quickly without a…a master, or just a slave somewhere (just be careful not to break replication!). mysql…to see my indexes: mysql> select * from all_indexes limit…
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
…a traditional replication setup because cluster nodes are not like traditional replicas. In this post I demonstrate how to…mysql…database and table. So far there are no differences, but we’ll run it again with a difference on one node to…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
…good understanding on how much space…a lot of scattered modifications. Now back to our question of space requirements for MySQL…space. Second, limit batch activities -…to setup replication for large database with little no – connect USB hard drive place LVM snapshot on it and you can copy your database…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
…a constant in the MySQL world that available QA tools often leave something to be desired. The randgen is a literal wonder-tool for database…limitations. Enter the flexible, adaptable, and expressive answer: dbqp. One of my demos at the dev meeting was showing how…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… this is good because recovering database servers is not fully automated …particular if you use MySQL Replication for HA) the switch to the new server …yet another reasons to avoid the “server zoo” and have limited set of…to spend a lot of money on the server which will be where sitting doing idle. How…
