…setup MySQL replication, you define the global variable server_id, this value must be unique for each host… any automatic failover during the process because high availability tools like mmm can cause failover … wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events…
Post: Meet Percona Team at OSCON
July 11, 2012 By 1 Comment
… week. I will be talking about Optimizing MySQL Configuration and host a BOF on MySQL Sharding Replication and Clustering if you’re interested… services in Node.js and Perl and about Running a high performance LAMP stack on a $20 Virtual server. We’re also…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
…high margin in the price) as well as high performance in general and stable performance under high…host. (Note: It was not tested by Percona engineers, but taken from vendor’s specification) Now to most interesting part – performance…performance (important in question for log related activity in MySQL…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit workloads that have high concurrency. Typical OLTP workloads…to horizontally partitioned data sets by running queries against each host in parallel, with the added feature of supporting aggregation. Then…
Post: Living with backups
November 6, 2008 By 28 Comments
…, so the price may actually be rather high. And the more effectively the server resources … -f – mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysql…are still chances for performance problems to happen on the working instance of MySQL. Such danger may …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… traditional database background. > Things are different with MySQL. Good design will help dictate how many …using tens of thousands > of tables per host and archiving great performance by doing so. > Using multiple … table?” An index that has very high cardinality (as high as the number of rows in …
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…mysql, with this patch applied (we compile mysql from source ourselves anyway, so this is still a fair performance…us, because we have short bursts of very high load, long periods of quite low load, …use Time::Local; use DBI(); # Setup who your DB host host, and a hash of copnnection passwords. # You …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…just simple queries or simple transactions but high concurrency with complex transactions as well — …come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step… service that can be used to host rapidly scalable NDB clusters (commence with …
Comment: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… to create an optimised single-server hosting solution for it that my employer…database: 1) Opcode caching. It’s highly modularised code. That’s great in … APC for very easy and large performance boosts. 2) Switching to the OurDelta… was dealing with don’t have MySQL 5.1.xx available natively, and…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that … disabled by simply setting long_query_time MySQL variable vale high enough). So what can be done when … 127.0.0.1) is used as a MySQL host, this will not work since all traffic goes …
