Recently I’ve started working locally due to the PHPStorm IDE. In order to work locally, I invested in MAMP Pro to make use of their GUI interface for configuring vhosts. I also like to use MySQL Workbench for my database work, unfortunately these 2 items never seemed to work together for me before.
@lig will be talking about mysql 5.5 and scalability this session She is Senior Technical Support Engineer for MySQL. We…
We will be covering
- semi-synchronous replication
- performance schema
- more partitioning options
- InnoDB – LOTS of InnoDB (performance and scalability improvements)
In 5.5 InnoDB will be the default!!! WOOT.
Default replication is asynchronous. Meaning master writes to binary log and the slave connects and “pulls” contents of the binary log. Bad thing is if the master crashes, there’s no guarantee that a slave has all committed transanction.
Simi-Synchronous Replication is an alternative to asynchronous replication. Midway point between asynchronous and fully syncronous. Master only waits for a slave to receive an event. Don’t have to wait for slaves to actually commit.
Performance schema tracks at an extremely low level. Just like Information schema, tables are views or temporary tables. Activation doesn’t cause any change in server behavior. This is designed for advanced users.
Think of SIGNAL as an exception, a way to “return” an error. You get exception-handling logic for stored procedures, stored functions, triggers,events and db apps.
RESIGNAL lets you pass error information up. Think of it as a catch. Requres an active handler to execute. Lets you program on your PHP side to catch that very specific handling.
I recently ran into a situation where I needed to add a foreign key to a table. This seems easy…
In most cases, when doing an insert statement I use SET to increase readability. It is also nice because I…
How to find out if a specific column exists: SHOW COLUMNS FROM TableName WHERE Field LIKE (‘ColName’)