MySQL MiniConf

This is a rough dump of notes taken at the linux.conf.au MySql MiniConf on Tuesday (29 Jan 2008). Feel free to edit any inaccuracies.

Upcoming MySQL Things

-- Stewart Smith -- MySQL

in development (in 6.0 or beyond)

Maria

new storage engine - crash safe MyISAM first on recovery rollback, transactions in next release forge.mysql.com/wiki/Maria_Preview

Faster Joins

batch up key lookups 3-35 * speed improvement

Semi Sync replication

Google patch Waits for a slave before transaction completes Ensures the data has been replicated

nb Statement based replication

• SQL statments -> binlog -> runs on master and slave

Row based replication

• row statments instead of SQL statements

Mixed mode

• magic

Falcon

new storage engine, 6.0.4, Falcon beta (yet another) new transactional engine optimised for typical web app use, (caches in RAM) not good for huge dataset tablespace commands to split indexes on different datafiles

Foreign Keys

between engines

MySQL WorkBench

beta gui for designing schemas reverse engineer Linux version later this year

Online Backup

vs. hotcopy (warm copy) SQL command "backup" stream of everything consistant

MySQL Cluster

carrier grade edition

MySQL Proxy

between client and server scripts

MySQL support

-- Trent Loyd

Mysql: show global variables; show status; show innodb status; show global status like '%tmp%';

Linux: iostat vmstat

sars/sarcheck collectd

max_heap_table_size tmp_table_size

heap buffer size ???

http://lathiat.net/talks

navicard

Database High Availability

-- Oliver Hookins, Anchor

DRBD - replication of disk

2 masters 3 slaves

Heartbeat2

/etc/ha.d/ha.cf mcast eth0 ip port 1 0

/etc/ha.d/*

multiple links for heartbeats?

/var/lib/heartbeat/crm/cib.xml

Linux Virtual Server (LVS) built in the kernel for load-balancing ldirectord is a wrapper round ipvsadm and LVS

monitoring

Nagios & NRPE

check_proc for heartbeat

lvs-helper if slave is bad it will reject packets to slave

http://shipyard.com.au