(Giuseppe Maxia) I hope you liked the first part of this series of lessons. And I really hope that you have followed the instructions and got your little replication cluster up and working.
Tag: Open Source
Optimizing UPDATE and DELETE statements
(Ronald Bradford) While most people look at performance optimizations for SELECT statements, UPDATE and DELETE statements are often overlooked. These can benefit from the principles of analyzing the Query Execution Plan (QEP). You can only run an EXPLAIN on a SELECT statement, however it’s possible
Using MySQL’s Analysis Tools to Improve Query Performance
(Rob Gravelle) One nice feature added to the EXPLAIN statement in MySQL 4.1 is the EXTENDED keyword which provides you with some helpful additional information on query optimization.
Advanced replication for the masses – Part I – Getting started with Tungsten Replicator
(Giuseppe Maxia) MySQL DBAs and developers: oil your fingers and get ready to experience a new dimension of data replication. I am pleased to announce that Continuent has just released Tungsten Replicator 2.0, an open source data replication engine that can replace MySQL native replication with a se
Five Considerations for MySQL Security and Compliance in the Cloud
(Sean Hull) In our last piece on MySQL deployments in the cloud we hit on areas including disk I/O, backups, security, scalability and network traffic. Now we’ll cover the rest.
Simple lessons in improving scalability
(Ronald Bradford) It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them.
VIEWS on INFORMATION_SCHEMA tables – Useful stuff
(Anders Karlsson) Views in MySQL really has quite a bad reputation, for bad performance mainly, but also there were some stability issues at some point.
Moving Subtrees in Closure Table Hierarchies
(Bill Karwin) Many software developers find they need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. Sometimes it’s tricky to do this in SQL and still run efficient queries against the data.
How to detect if a MySQL server is an active replication slave
(Giuseppe Maxia) Sometimes you know for sure. And sometimes you wonder: Is this server part of a replication system? And, most specifically, is it an active slave?
Using SQL to create SQL (and other usefulness)
(Sarah Novotny) Today, I had a task of modifying a slave to exclude (or if you want to say specifically include) tables. The situation is that this slave need only contain tables used for reporting. The added benefit being that with fewer tables to replicate there will be less replication traffic, l