MySQL Introduction
MySQL Overview
MySQL Enterprise Product
MySQL Website
MySQL Introduction
MySQL Overview
MySQL Enterprise Product
MySQL Website
MySQL Overview
• MySQL is a database management system
Since computers are very good at handling large amounts of data,
database management systems play a central role in computing, as
standalone utilities, or as parts of other applications
• MySQL databases are relational
A relational database stores data in separate tables rather than
putting all the data in one big storeroom
• MySQL software is Open Source
Open Source means that it is possible for anyone to use and
modify the software.
• The MySQL Database Server is very fast,
reliable, scalable, and easy to use
MySQL Server can run comfortably on a desktop or laptop,
alongside your other applications, web servers, and so on, requiring
little or no attention.
• A large amount of contributed MySQL software
is available
MySQL Server has a practical set of features developed in close
cooperation with our users
MySQL History
Who Are They ?
Nice to have, but .... (1)
Web site main source of new orders, DataMart
feeding and back-ended by many data
sources, used by entire organization
for daily operations
Inflection point when “nice to have”
user/dependeence
becomes mission-critical
Web site generating most new orders,
Exec team added as BI users,
Accounting data added to DataMart
IT creates Web site and
DataMart for Sales dept.
to register/track/report orders, renewals
1 year 2 year 3 year n year
Nice to have, but .... (2)
“We need help!”
Spend money, save time, mitigate risk
1 minute of downtime = Lost $
user/dependeence
“I’ll hire more DBAs!”
Spend more time, save less money, more risk
“I’ll fix it myself”
Spend time, save money, some risk
1 year 2 year 3 year n year
Tough Questions
…performance issues?
…Replication synch issues?
…expensive, slow queries?
…security policies, change?
Where/When/How to Tune?
…Developers productive?
…servers down?
..version of MySQL to run?
…will systems scale? …can I recover?
MySQL Introduction
MySQL Overview
MySQL Enterprise Product
MySQL Website
MySQL Enterprise
MySQL Enterprise MySQL Enterprise
Backup Monitor/Query Analyzer
MySQL Enterprise
High Availability MySQL Workbench
MySQL Enterprise Oracle Product
Scalability Certifications
MySQL Enterprise Oracle Premier
Lifetime Support
Security
MySQL Enterprise - MySQL Database
Support for common
development
languages/platforms
Efficient multi-
threaded session
handling
Full DML, DDL
parsing, cost
based optimizer,
caching of queries
and result sets
Flexible Storage
Engine options for
application specific
storage needs
Flexible logging and physical storage options
MySQL Enterprise - MySQL Database
InnoDB - Transactional by Default
• Default Storage Engine for MySQL 5.5 and above
• ACID-compliant transactions, MVCC
• Row-level locking
• Two phase commit
• Efficient indexing
• Fast DDL operations
• Table compression
• Automatic crash recovery
• Referential integrity
• Online backup
• More
MySQL Enterprise - MySQL HA
MySQL Enterprise - Security
• PAM (Pluggable Authentication Modules)
• Access external authentication methods
• Standard interface (Unix, LDAP, others)
• proxied and non-proxied users
• Windows
• Access native Windows services
• Authenticate users already logged into
Windows (Windows Active Directory)
MySQL Enterprise - Security PAM
MySQL Enterprise - Security Win
MySQL Enterprise - Backup
Full Backup
Proses fullbackup ini melakukan backup pada semua data yang berada pada
datadir MySQL dan juga data-data yang menyimpan data engine InnoDB
(ibdata, iblogfile, dll.).
mysqlbackup --user=[user] --password=[password] --port=[port] --backup-
dir=[lokasi direktori backup] backup-and-apply-log
Incremental Backup
Proses Incremental backup hanya melakukan backup sesuai dengan data
terakhir yang dibackup
mysqlbackup --user=[user] --password=[pass] --port=[port] --incremental --
incremental-base=dir:[lokasi_direktori_fullbackup] --incremental-backup-
dir=[lokasi_direktori_untuk_incremental] --with-timestamp backup
MySQL Enterprise - Backup
Hasil backup yang ter-create identik dengan data (datadir) asli MySQL Server.
Data yang ter-create antara lain:
Ket:
*Backup-my.cnf : backup konfigurasi dari server yang di backup.
*Datadir : direktori yang menyimpan backup datadir dari server yang di
backup dengan data yang identik dengan datadir asli.
*Meta : direktori yang menyimpan file-file konfigurasi backup.
MEM - MySQL Enterprise Monitoring
MEM - Dashboard
MEM - Advisors
MEM - Event
MEM - Graphic
MEM - Query Analyzer
MEM - Replication
MySQL Introduction
MySQL Overview
MySQL Enterprise Product
MySQL Website
MySQL Support
QA - DISCUSSION ?
