MySQL Server Managed HostingMySQL Server Managed Hosting


NeoSpire is SAS70 certified
Bookmark and Share

MySQL Hosting Overview

NeoSpire has supported the world’s most popular open-source database platform since 1999. Our expert administrators were some of the first to provide highly available MySQL solutions making this product a welcome addition to the inventory of options for mission-critical applications.

 

Mission Critical Managed Hosting means never suffering unplanned downtime. NeoSpire manages some of the most serious business applications supported by MySQL, and our experts can design and deploy the most appropriate high-availability solution based upon your technical and business requirements.

 

Sample Solutions

 

MySQL Circular Replication
MySQL Clustering
 
 
 

 

MySQL Circular Replication


Pro

  • Read/Write capabilities to all database nodes
  • Full-text searches and all other normal features are compatible

Con

  • Data is replicated between systems asynchronously
  • Transactions are not ACID compliant across the cluster

Description:


With MySQL replication as SQL statements are executed on the master server, MySQL records them in a binary log. The slave server in turn continually checks the master's binary log for any changes. If it finds a change, it makes the same change locally through use of a relay logging system.

 

Circular replication is configured by also instructing the master server to monitor the binary log of the slave, that way changes on either database server are replicated to the other.


 

 

MySQL Clustering


Pro

  • A true, clustered solution maintaining transactional ACID compliance
  • No shared storage required

Con

  • The database is in-memory only, often requiring a significant amount of RAM
  • Some normal features are not available, such as full-text searches, referential integrity, and transaction isolation levels higher than READ COMMITTED

Description


MySQL Clustering is a synchronous replication using a two-phase commit mechanism in order to guarantee transactional safety across multiple database servers. Clustering is conducted over a network link and does not require any shared components.

 

Every NeoSpire-managed MySQL solution includes:

 

  • Initial system design and consultation by our MySQL experts
  • Server installation and hardening
  • Advanced monitoring of SQL availability and performance
  • Custom monitoring of your unique application attributes
  • Proactive management and issue resolution
  • Ongoing security management including:
    • Patching
    • User Management
    • Database Permission Controls
    • Audit Support

 

Backups are a critical part of any solution. NeoSpire has deployed a leading backup solution for all customers that provides incredible data integrity assurances. All MySQL solutions backed up by NeoSpire have:

 

  • Online MySQL backups
  • Minimum four weeks of historical data with secure off-site storage
  • Daily differential and weekly full backups

 

 

Request a Quote