tutorial de mysql workbecnch

Video: Building a MySQL Slave and Keeping it in Sync At the Boston MySQL User Group Sheeri Cabral presented on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies. This link contains the slides and the videos

Author's announcement that the MySQL Bible, for beginner and intermediate MySQL DBA's, is available. The book is suitable for those completely new to databases, or those that are familiar with another RDBMS (such as Oracle or Microsoft SQL Server) and want to learn how MySQL works.

sar-sql name change, state of the software and road map.

This article shows you how to use MySQL Proxy to capture queries that cause errors.

This article will show you how to set up MySQL Proxy as a service on Windows. This will allow you to use "net start proxy" to start the proxy, and "net stop proxy" to stop the proxy.

This article describes the benefits of InfiniDB, which is a storage engine for MySQL that allows for data warehousing and database analytics.

An introduction on how to use XtraBackup to perform hot backups of MySQL

Mark Callaghan discusses the implications of using FLUSH TABLES WITH READ LOCK and what this command actually does.

Do you need MySQL High-Availability? How to determine which MySQL High-Availability solution is best?

OpenLDAP includes a driver that allows it to store and access data held in MySQL Cluster. It uses the NDB-API to access the database and so the performance is extremely good. One of the great things about the solution is that it lets you simultaneously access the same data through both LDAP and SQL (or the NDB-API or any of the MySQL connectors). This article gives an example of how this can be done.

A quick look at some strong points between InnoDB Hot Backup and Xtrabackup

Shlomi shows a real world scenario where the naive approach to monitoring fails spectacularly.

In my old post there is a bug when run in MySQL 5.1.30 and old, because the status variable Queries was added in MySQL 5.1.31. So i change to choose between Queries and Questions status variables, and I think the Queries represent more accurate result.

Sheeri explains, in practice, how to synchronize schemas using MySQL Workbench

Sheeri explains why turning on the query cache without thinking about the consequences is bad but also why simple benchmarks proving 'the query cache is bad' may be skewed

Maximize your strengths, minimize your weaknesses. You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative benefits. In one context it can be seen as ineffective, or even detrimental to your performance, however it’s course grain nature makes it both trivial to disable dynamically (SET GLOBAL query_cache_size=0;), and also easy to get basic statistics on current performance (SHOW GLOBAL STATUS LIKE ‘QCache%’;) to determine effectiveness and action appropriately.

Mark Callaghan tests the query cache. "The query cache has had an interesting history with MySQL. I don't have much experience with it. I might want to use it in the future so I enabled it during a run of sysbench readonly on an 8-core server. The results are fascinating."

Informative post about backup and restore procedures, disaster recovery plans and load balancing tips.

Install isolated side-by-side MySQL instances right the first time with this time-saving virtual manager. Jeremy Zawodny tests MySQL Sandbox with a thorough description.