(Dave Stokes) This blog entry is on a step that many DBAs either skip, ignore, or do not know about. My last entry was on some install tricks and this time I want to cover where to put the various pieces of a MySQL server if you are looking to maximize performance. George Trujillo covered this for O
Tag: Open Source
Avoid clear text passwords in MySQL logging.
(Daniël van Eeden) What happens when you use the PASSWORD() function to insert a password hash into a table?
The Other Reason You Need Unique Server_ids in MySQL Replication
(Ike Walker) I recently encountered an error when two slave databases were using the same server_id value. I know having unique server_ids across all MySQL databases in a given replication topology is a best practice, but I’m not sure I understand exactly why MySQL is trying to enforce uniqueness in
MySQL Replication with Global Transaction Identifiers – Step-by-Step Install and Addition of Slaves – Part Two
(Tony Darnell) This post is part two of MySQL Replication with Global Transaction Identifiers – Step-by-Step Install and Addition of Slaves. In this post, I will be showing you how to use the MySQL Utility Script mysqlreplicate to create a new replication slave off a master database.
MySQL 5.6: Testing innodb_read_only with multiple instances
(Craig Sylvester) There are many good things in the upcoming MySQL 5.6 release. One thing that caught my eye early on was the ability to start the server with InnoDB set to a read only mode.
New EXPLAIN Features in MySQL 5.6 – FORMAT=JSON actually adds more information!
(Sheeri K. Cabral) When I heard that MySQL 5.6 was implementing EXPLAIN for writes (INSERT,UPDATE,DELETE,REPLACE), I was pretty excited. Then I heard that MySQL 5.6 also was implementing a JSON format for EXPLAIN and my thought was “I do not care about that!”
Reducing Contention with Foreign Key Locks
(Simon Riggs) PostgreSQL’s Foreign Key support underpins our ability to enforce data quality in the database.
Change management of database scripts
(Hayesha Somarathne) In this post I’m going to discuss the strategy used by our team to manage the changes taking place in the database. Most of the time we as developers mainly focus on implementing the feature and put less effort on manage the database changes.
Fun with the MySQL pager command
(Stephane Combaudon) Last time I wrote about a few tips that can make you more efficient when using the command line on Unix. Today I want to focus more on pager.
MySQL Replication with Global Transaction Identifiers – Step-by-Step Install and Addition of Slaves – Part One
(Tony Darnell) One of my favorite features of MySQL is replication. Replication provides you with the ability to have MySQL automatically copy data from one MySQL instance to another. There are many benefits to using replication, but I just like having an extra copy of my data on another server in c