Date
| Document |
Change Type |
Category |
Notes |
04/05/2012
| |
New |
MySQL |
How to configure the various replication configurations, master/slave, master/multi-slave, master/relay, master/master and circular |
03/05/2012
| |
New |
MySQL |
I discuss horizontal, vertical, range, list, hash and key partitioning, i also have a section on merge tables |
02/05/2012
| |
New |
MySQL |
I discuss what makes up a user account, access control lists, how to reset the root password and debugging user account problems. |
29/04/2012
| |
New |
MySQL |
I cover backing up and recovery in this section using tools like mysqldump, select into outfile, mk-parallel-backup, snapshotting, mysqlhotcopy. I also explain how to perform point-in-time recovery using mysqlbinlog. |
27/04/2012
| |
New |
MySQL |
This section covers caching within the MySQL server, how to enable, tune and monitor it |
26/04/2012
| |
New |
MySQL |
A section on tuning the MySQL during the build phase |
20/04/2012
| |
New |
MySQL |
I cover how transactions work within MySQL and the isolation levels, I also look at locking and deadlocks. |
28/03/2012
| |
New |
MySQL |
A brief section on MySQL views, creating , altering and dropping |
22/03/2012
| |
New |
MySQL |
I explain how to use triggers, stored procedures, stored functions and events |
19/03/2012
| |
New |
MySQL |
I cover the different index types that MySQL uses, and explain why we use indexes |
13/03/2012
| |
New |
MySQL |
I explain the various data types and creating tables, I also discuss how to optimize the table and a number of maintenance tasks regarding tables |
29/02/2012
| |
New |
MySQL |
I cover the MySQL deviations and extensions from the standard SQL |
21/02/2012
| |
New |
MySQL |
This is a introduction into MySQL covering the storage engines and how to access MySQL |
12/11/2011
| |
New |
Oracle |
A cheatsheet for Data Guard, covering the common area's and commands used. |
12/11/2011
| |
New |
Oracle |
Lastly in the Data Guard series a troubleshooting guide regarding common problems with Data Guard. |
