book

MariaDB High Performance

by Pierre Mavro

September 2014

Intermediate to advanced

298 pages

6h 13m

English

Packt Publishing

Read now

Unlock full access

Support files, eBooks, discount offers, and moreWhy subscribe?Free access for Packt account holders
What this book covers

Downloading the example codeErrataPiracyQuestions
MariaDB history
DisksSATA magnetic drivesSAS magnetic drivesHybrid drivesSSDsRAID and acceleration cardsRAID cards and levelsFusion-io direct acceleration cardsDisk arraysRAMCPU
C-StatesP-StatesConstructor name optionsPower management optimizationcpufreqcpuidleDisk and filesystem optimizationKernel disks' I/O schedulersPartition alignmentSSD optimizationFilesystem optionsSWAPDedicating hardware with cgroupsManual solutionAutomatic solution using the cgconfig daemonDedicating hardware optimization with NUMA
Slow queries
pt-query-digestpt-stalkpt-summarypt-mysql-summarypt-duplicate-key-checkerpt-index-usage
Resetting statistics
The DNS cache server
Binlogs for transactional cachesBinlogs for nontransactional caches
Understanding the query cacheModifying the query cache
Summarizing your databasesInnoDB/XtraDBPool size and statisticsRedo logsTransaction commits and logsBuffer pool instancesThe flush methodTokuDBInstallationThe flush methodCache sizeTransaction commits and logsTemporary directoryCompressionMyISAMKey buffer
EnginesTypes
How replication worksConfiguring the master nodePreparing the master nodeConfiguring the slave nodeCreating a slaveUsing mysqldumpUsing XtrabackupChecking the slave status
What is GTIDConfiguring the master nodePreparing the master nodeConfiguring a GTID slave nodeCreating a slaveStarting the slaveChecking the slave status
Installing HAProxyConfiguring HAProxyChecking healthTesting the configuration
SQL errorsAnalyzing binlogsGTID – switching a slave to master and recovering
Cascade slavesSpeeding up replication performance for middle slaves
Generating certificatesBuilding your own CABuilding your server certificateBuilding your client certificatesChecking your certificatesConfiguring MariaDB for SSLMaster SSLClient SSL
Dual master replication and risks
HAProxyLearning about the maintenance modeUsing Unix SocketUsing HATopUsing the configuration fileKeepalivedPacemaker or Percona Replication ManagerDRBD
Multimaster slave replicationSetting up a multisource replicationOther options
How Galera Cluster works
InstallationConfiguration filesMariaDB configurationGalera configurationFirst boot
Transfer methodsUsing mysqldumpUsing XtrabackupUsing rsyncDedicating a donor nodeStarting after a complete blackoutConsensus clustering and maintenanceGarb – the quorum solutionPerformance tuningParallel slave threadsGcache size
Read and write nodesLoad balanced architectureWAN replicationDisaster recovery
Paused replicationBreak GaleraSplit-brain
Configuring Spider
Creating replicated shardsSpider HA monitoringRecovering data after server failure
Spider parametersThe bgs modeThe connection recycle modeStatistics tablesRemote SQL logsNumber of shards
Single instance
GraphsLogs
Using mysqldumpCompression
SnapshotRemoving snapshotsRollbackBackup
Full backupIncremental backupRestoring from a full backupRestoring from an incremental backup

Content preview from MariaDB High Performance

Galera Cluster limitations

Galera Cluster has limitations that prevent it from working correctly.

Tip

Do not go live in production if you haven't checked that your application is in compliance with the limitations listed.

The following are the limitations:

Galera Cluster only fully supports InnoDB tables. TokuDB is planned but not yet available and MyISAM is partially supported.
Galera Cluster uses primary keys on all your tables (mandatory) to avoid different query execution orders between all your nodes. If you do not do it on your own, Galera will create one. The delete operation is not supported on the tables without primary keys.
Locking/unlocking tables and lock functions are not supported. They will be ignored if you try to use them.
Galera Cluster ...