MySQL Support

MySQL is the world's most popular open source database. MySQL Database Server is very fast, reliable, scalable, and easy to use.
Many of the world's largest and fastest growing organizations including Facebook, Google, Twitter rely on MySQL, powering their high volume transactions and business-critical systems.
MySQL supports different storage engines for different business needs and can be deployed in different OS like Linux, MAC, Windows etc.
MySQL provides high availability with the help of Replication and Clustering solutions. MySQL has different forks now in market namely MariaDB, Percona. Egolem provides support & Consulting for all of them.

Services

• 24x7x365 Monitoring.
• Install, Upgrade and configuration of MySQL
• Automated MySQL backup / snapshots.
  • SQL Backup
  • LVM
  • MySQL Enterprise Backup (MEB)
  • Percona XtraDB Backup
  Note: Backup can be moved to different server / storage / Cloud (AWS S3, Amazon Glacier, Google bucket)
• Configuration changes / DB Tunings.
• Query optimization.
  • Index creation.
  • Query rewriting.
• Storage engine suggestions according to the business needs.
  • MyISAM
  • InnoDB
  • RocksDB
  • MERGE
  • CSV
  • SPIDER
  • Blackhole
  • Connect
  • Memory
• Analytics support
  • MariaDB Columnstore
  • ClickHouse
• Auto Archival / Schedule Maintenance
  • Moving old data to same / different server.
  • Purge data with / without backup.
  • SQL execution.
  • Architecture based archival without replication delays.
  NOTE: Archival will be carried out on chunks and will be scheduled to run only on the scheduled window.
• Migration of different RDBMS (Oracle / SQL Server / PostgreSQL / DB2 ) to MySQL / MariaDB / Percona.
• Migration of data from Data Center to Cloud and vise-versa.
  • AWS RDS.
  • AWS EC2.
  • AWS Aurora.
  • Google SQL (CloudSQL).
  • Google Cloud Platform (GCP).
  • Microsoft Azure VM.
• Architecture review and changes.
  • Structural / schema review.
  • Data type review and suggestions.
  • Application review w.r.t database.
  • Review the queries and rewrite.
  • Privilege review and harden the security.
  • High Availability solution.
    • Master - Slave.
    • Multi master
    • Multi source replication
    • MySQL Group Replication.
    • Clustering solutions
      • MySQL NDB cluster.
      • MariaDB Galera Cluster.
      • Percona XtraDB Cluster.
• Software Load Balancers.
  • ProxySQL
  • MariaDB Maxscale
  • HAProxy
• MISC
  • Replicate data from MySQL to AWS Redshift.
  • Replicate data from MySQL to other RDBMS.
  • Replicate data from MySQL to search engines.