… which will allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded pair you’ll… described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… on Data Virtualization for Databases meaning using a single set of datafiles that support multiple copies of the source database. Would be interested if someone wanted to contribute on the MySQL side. Interesting that…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
…summary of 451 Research’s database survey by viewing the research report “451 Research database survey points to MySQL gravitational tug of war… Kortney could not have succeeded without the support of our multiple service vendors including Ireland Presentations, Carleson Production Group, Tricord, …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…always obvious how they will affect your database workload. For example: Transaction commit takes … MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… mean you can’t modify data on multiple cluster nodes simultaneously. You can. It …
Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
…first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability … can also combine compression and encryption, each using multiple CPU cores. One advantage of encrypting your backups…the place where you store your backups. Our databases hold a variety of information, some of which…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… important baseline that offers the best response times (MySQL server does not use multiple threads to execute query in parallel at this… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel replication but these apply only to some use cases. Many database maintenance operations…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… uses a separate service for a message queue, not MySQL at all. E.g. ActiveMQ, RabbitMQ, Resque, etc. All… the MQ in lieu of writing directly to the database. Sometime later (asynchronously), a worker app would read items … how useful it is to update the same row multiple times in a single transaction…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… multiple databases Honestly I do not see application using one database per table that often. I however often see applications using multiple databases…is frequently told by people with traditional database background. Things are different with MySQL. There are many successful applications, using…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… post I got number number of comments saying if MySQL would not have multiple storage engine interface it would not allow people… want your database operation to be ? Visiting customers I see 2 very distinct groups of MySQL Users Users what want cool database This…. Because of them MySQL got popularity and market position it has today. Users what want boring database What database did Marten Mickos sell…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all databases are architected this way; some have multiple processes that communicate…
