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

Summary

In this chapter, we've seen how to set up a synchronous replication with Galera Cluster. This is an advanced step in classical/GTID replications. You can now start to build scalable solutions and some usages.

In the next chapter, we'll see another scaling solution with Spider, also called sharding.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Migrating to MariaDB: Toward an Open Source Database Solution

William Wood

MariaDb Essentials

Emilien Kenler

Working with Advanced Docker Operations

Randall Smith

OpenStack: Building a Cloud Environment

Alok Shrivastwa, Sunil Sarat, Kevin Jackson, Cody Bunch, Egle Sigler, Tony Campbell

Publisher Resources

ISBN: 9781783981601Supplemental Content