Feedback

Close

Cancel

Already a member?  Login

Latest Stories

Feb 05 Sun

Managing MySQL with Percona Toolkit by Frédéric Descamps

(SUMMARY) Frédéric Descamps of Percona . Percona Toolkit is Maatkit & Aspersa combined. Opensource and the tools are very useful for a DBA. You need Perl, DBI, DBD::mysql, Term::ReadKey. Most tools are written in Perl, and whatever is in Bash is being...
2/5/2012 9:58 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

Replication features of 2011 by Sergey Petrunia

(SUMMARY) Sergey Petrunia of the  MariaDB project & Monty Program . MySQL 5.5 GA at the end of 2010. MariaDB 5.3 RC towards the end of 2011 (beta in June 2011). MySQL 5.5 is merged to Percona Server 5.5 which included semi-sync replication, slave fsync...
2/5/2012 8:32 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

MySQL Creatively in a Sandbox by Giuseppe Maxia

(SUMMARY) Giuseppe Maxia of Continuent and long time creator of MySQL Sandbox . Only works on Unix-like servers. Works with MySQL, Percona & MariaDB servers. MySQL server has the data directory, the port and the socket you can t share these. To use it:...
2/5/2012 7:57 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

Optimizing your InnoDB buffer pool usage by Steve Hardy

(SUMMARY) Steve Hardy of Zarafa . Work that has been done to make Zarafa better. Why do you optimise your buffer pool? To decrease your I/O load. How can you do it? Buy more RAM, page compression, less (smaller) data, rearrange data. MariaDB or Percona Server...
2/5/2012 7:29 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

Practical MySQL Indexing guidelines by Stéphane Combaudon

(SUMMARY) Stéphane Combaudon of Dailymotion. Index: separate data structure to speed up SELECTs. Think of index in a book. In MySQL, key=index. Consider that indexes are trees. InnoDB s clustered index data is stored with the Primary Key (PK) so PK lookups are...
2/5/2012 7:01 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

MySQL synchronous replication in practice with Galera by Oli Sennhauser

(SUMMARY) Oli Sennhauser of FromDual . Synchronous multi-master replication with the Galera plugin. Your application connects to the load balancer and it redirects read/write traffic to the various MySQL Galera nodes. Tested a setup with 17 SQL nodes and you...
2/5/2012 6:30 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

Optimising SQL applications by using client side tools by Mark Riddoch

(SUMMARY) Mark Riddoch of SkySQL . This was a talk about the future in general. What people would like. Etc. Not about something that exists yet, hence the sparse notes. Trace statements are good for the why . You move on to the debugger, but what is a useful...
2/5/2012 5:54 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

MySQL Cluster by Ralf Gebhardt

(SUMMARY) Ralf Gebhardt of SkySQL . Cluster: shared nothing architecture (no single point of failure), synchronous replication between nodes, ACID transactions, row level locking. In-memory storage (some data can be stored on disk, but indexes must be...
2/5/2012 5:25 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

Building simple & complex replication clusters with Tungsten Replicator by Giuseppe Maxia

(SUMMARY) Giuseppe Maxia of Continuent . MySQL replication is single threaded. Multi-master replication is complex with MySQL. Circular replication works but is very fragile. Once you ve achieved the feat, how do you avoid conflicts? The lack of global...
2/5/2012 5:01 AM   Colin Charles   Like   Read   Share


Feb 05 Sun

How to offload MySQL server with Sphinx by Vladimir Fedorkov

(SUMMARY) Vladimir Fedorkov of Sphinx . Presentation started out with a very nice presentation of candies to all the audience members. What is Sphinx? Another (C++) daemon on your boxes. Can be queried via API (PHP, Python, etc.) or MySQL-compatible protocol...
2/5/2012 4:29 AM   Colin Charles   Like   Read   Share


NEW! Sunday Magazine

Your news, every week in a magazine!
View on computer or iPad. Click above to read now.

Sections

Content is continually updated throughout the day. Articles are provided by third party sources who are responsible for their content.
Site © Copyright 2007-2012, BubbleLife Media LLC Privacy Policy Terms of Use
Sunday, February 05, 2012 9:02 PM
Powered by BubbleCommunities 0.10.4413.27815.64
BUBBLELIFE® is a registered trademark and BUBBLELIFE MEDIA™, BUBBLECOMMUNITIES™ and NEIGHBORHOOD BRANDS™ are trademarks of BubbleLife Media LLC. Unauthorized use is prohibited.