… IBM. Directly attached storage is more simple to use than SAN, MySQL is more simple to use than Oracle or DB2, PHP… the team. In many MySQL Projects there are not even dedicated MySQL people and Web developers simply use MySQL as they fit suitable…. Someone could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no…
Post: SimCity outages, traffic control and Thread Pool for MySQL
March 16, 2013 By 16 Comments
… a few examples of how Thread Pool for MySQL and Percona Server for MySQL can help to prevent such incidents. Users of… in such cases. Basically SimCity users faced the same situation San Francisco Bay Area commuters face every day — traffic gridlock, probably… by limiting the amount of working threads inside MySQL. So Thread Pool for MySQL does not improve the performance magically by itself…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… replication (not common, but does happen) You lose your entire SAN and all your DB servers were located there. Let’s… Remote DBA? We have these major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6… retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… scale sites. As response to these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query… even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or SAN based HA architectures all have their limits… see as response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… systems. Veritas File System can do it for Solaris. Most SAN systems would work as well. What is really needed is… later mounted same as original file system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot…) Extract/Copy database to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… CTO and President at Schooner, who makes a high-performance MySQL software appliance. (It used to be hardware-only, if you….) His session will be about benchmarks of replication alternatives for MySQL. Hasn’t this been done before, and is it really… we’ll sell every ticket we have. It happened in San Francisco and it could happen again here, even with the…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some simple… should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads… to ease hardware evaluation for things which are important for MySQL. To prepare small 128MB single file working set we can…
Post: European and North American Training Schedule Announced
August 13, 2012 By 2 Comments
… dates for Europe are: Live Virtual Training: Developer Training for MySQL Begins Monday, August 27, 2012 , 9am – 11am, Greenwich Mean Time… Monday, August 20, 2012 Live Virtual Training: Developer Training for MySQL Begins Monday, August 20, 2012 , 9am – 11am, Pacific Time Portland… 24, 2012 Houston, Texas, USA Begins Monday, October 1, 2012 San Diego, California, USA Begins Monday, October 22, 2012 Minneapolis, Minnesota…
Post: Percona Live London: CFP, Registration, Sponsorships Open
August 8, 2011 By Leave a Comment
The first two Percona Live MySQL conferences in San Francisco and New York were sold-to-capacity events with … currently working on finalizing and publishing the schedule for this MySQL conference and will have it online as soon as we… wasting time trying to figure out what’s wrong when MySQL doesn’t perform or behave well. We all look forward…
Post: Percona Live: Venu Anuganti; early bird registration expires tomorrow
January 25, 2011 By Leave a Comment
… announcing Venu Anuganti as a guest speaker to Percona Live: San Francisco. Venu works as a Data architect, evaluating and implementing… worked as a database kernel engineer at companies like SolidDB, MySQL, ANTs Data Server and Yahoo! Venu will be presenting on the “Role of MySQL in Analytics, Warehouse and Large Data At Scale”, where he…
