Softwr

Web Development · head to head

MySQL vs Packer

MySQL logo

MySQL

Web Development

The world's most popular open source database

From
Free
Rated
-
Full reviewWebsite
P

Packer

Cloud & Infrastructure

Build automated machine images

From
Free
Rated
-
Full reviewWebsite

The short version

  • Each has a real cost: MySQL hot online backup is not in the free Community Server; MySQL Enterprise Backup is a paid Enterprise Edition component; Packer packer 1.10.0 and later is licensed under the Business Source License 1.1 with IBM Corporation as licensor, not an OSI open source licence
  • They diverge on capability: MySQL covers ACID compliance, Packer covers Image building.

Where they differ

Only the attributes on which MySQL and Packer actually diverge.

Attributes where MySQL and Packer differ
AttributeMySQLPacker
Pricing modelfreemiumopen-source
PlatformsWindows, Macos, Linux, UnixLinux, Windows, Mac
CategoryWeb DevelopmentCloud & Infrastructure
Founded19952013

Identical on both: starting price (Free), free tier (Yes), user rating (Not yet rated).

What each one covers

Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.

Only in MySQL

  • ACID compliance
  • SQL support
  • Multi-version concurrency control
  • Replication
  • Partitioning
  • Stored procedures
  • Triggers
  • Views

Only in Packer

  • Image building
  • Multi-platform support
  • Provisioners
  • Builders
  • Post-processors
  • Variables
  • Data sources
  • Validation

Both cover

  • Access control

What people use each for

The jobs each tool is most often brought in to do.

MySQL

  • Web application backendnot Packer
  • E-commerce platformsnot Packer
  • Content management systemsnot Packer
  • Data warehousingnot Packer
  • Business applicationsnot Packer

Packer

  • Building identical machine images for multiple clouds from one templatenot MySQL
  • Baking golden AMIs and VM images into a CI pipelinenot MySQL
  • Creating immutable infrastructure artifacts consumed by Terraformnot MySQL

Where each one falls short

Documented limitations, not opinions. Every one is a constraint you would hit in normal use.

MySQL

  • Hot online backup is not in the free Community Server; MySQL Enterprise Backup is a paid Enterprise Edition component
  • Transparent Data Encryption, data masking and de-identification are Enterprise Edition only
  • MySQL Enterprise Firewall, which guards against SQL injection, and MySQL Enterprise Audit are both paid components
  • External authentication against PAM or Windows Active Directory requires MySQL Enterprise Authentication
  • The thread pool ships as MySQL Enterprise Scalability rather than in the community build

Packer

  • Packer 1.10.0 and later is licensed under the Business Source License 1.1 with IBM Corporation as licensor, not an OSI open source licence
  • The Additional Use Grant forbids offering Packer to third parties on a hosted or embedded basis in a paid product that competes with IBM's paid versions of Packer
  • Each version converts to the MPL 2.0 Change License only four years after that version is first published, and the Change Date is set separately per version
  • Alternative licensing for uses outside the grant must be arranged with the licensor rather than taken under the public licence

Pricing, plan by plan

MySQL

Free
  • Community EditionFree
    • Open source license
    • Full SQL support
    • InnoDB storage engine
  • Standard Edition$2000/year
    • Commercial license
    • Oracle Premier Support
    • MySQL Enterprise backup
  • Enterprise Edition$5000/year
    • Advanced security
    • MySQL Enterprise Monitor
    • High Availability

Packer

Free
  • Open SourceFree
    • Multi-platform image building
    • Template-driven
    • Provisioner support

Which should you pick?

Choose MySQL if

  • You need acid compliance.
  • You want to start without paying.
  • You work on Windows, Macos, Linux, Unix.
  • You also want sql support.
MySQL review

Choose Packer if

  • You need image building.
  • You want to start without paying.
  • You work on Linux, Windows, Mac.
  • You also want multi-platform support.
Packer review

Questions people ask

Is MySQL or Packer better?
Neither clearly leads. MySQL starts at Free and Packer at Free, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
Which is cheaper, MySQL or Packer?
MySQL starts at Free and Packer at Free.
Does MySQL or Packer run on more platforms?
MySQL runs on Windows, Macos, Linux, Unix. Packer runs on Linux, Windows, Mac.
Can I use MySQL for free?
Both have a free tier, so you can try either at no cost before committing.
What is MySQL best used for?
MySQL is most often used for web application backend, e-commerce platforms, content management systems, data warehousing. Of those, web application backend and e-commerce platforms are not what Packer is typically brought in for.
What can MySQL do that Packer cannot?
MySQL covers ACID compliance, SQL support, Multi-version concurrency control, Replication. Packer covers Image building, Multi-platform support, Provisioners, Builders. Both handle Access control.
ShareXLinkedInRedditWhatsAppEmail

Related pages

More on MySQL

More on Packer

Keep looking

Other head to heads