Progent's Application Experts

MySQL DBA and Development Support
MySQL is the most popular open source relational database management system (RDBMS) and is available from Oracle in the free downloadable Community Edition or as a licensed and fully supported commercial product in Oracle's Standard, Enterprise, or Cluster editions. MySQL supports all major operating systems including Windows, Linux, UNIX, and Mac OS X and is used in many high-profile web applications such as Facebook, Google, Twitter, YouTube, and Wikipedia.

Progent can provide affordable online access to an Oracle-certified MySQL DBA, developer, or data architect to help businesses of any size to design, develop, and administer database applications built on MySQL. Progent can also help you to create or enhance your network environment to support MySQL in order to create a robust solution that features high performance, easy scalability, and full security and compliance. Progent has experience helping businesses migrate efficiently from an Oracle database or other RDBMS platform to MySQL. In addition, Progent's Microsoft-certified Windows consultants can help you configure, provision, and manage MySQL on a Windows Server 2008 R2 cluster for enterprise-class availability and performance.

Editions of MySQL Available from Oracle
Oracle offers several editions of MySQL ranging from the free entry-level Community Edition to the commercial MySQL Cluster Edition with real-time performance and 99.999% availability. Progent's MySQL consultants can help you select, configure, and manage an edition of MySQL that aligns best with the special requirements of your business. Major versions of MySQL available from Oracle include:

MySQL Community Edition
Offered by Oracle as a free download but without production support, MySQL Community Edition is an ACID compliant open-source RDBMS with features that include full commit, rollback, crash recovery, and row-level locking. Users can seamlessly upgrade to commercial, fully supported editions of MySQL for additional capabilities such as advanced backup, monitoring, and administration.

MySQL Standard Edition
MySQL Standard Edition is a commercial, fully supported, open-source version of MySQL that offers significant enhancements for Online Transaction Processing (OLTP) through the inclusion of Oracle's InnoDB transactional storage engine. The Standard Edition also improves performance, expandability, and data integration with MySQL Replication. The commercial version of MySQL Workbench included with the Standard Edition provides an integrated environment to streamline MySQL database development, design, and administration.

MySQL Enterprise Edition
MySQL Enterprise Edition is a commercial, fully supported version of MySQL that offers a comprehensive set of advanced features and management tools including MySQL Enterprise Backup with hot backup support, MySQL Enterprise High Availability with Windows Failover Clustering, MySQL Enterprise Scalability for handling increasing query and data loads, MySQL Enterprise Security for integrating MySQL with existing security infrastructures including PAM and Windows Active Directory, and MySQL Enterprise Monitor and Query Analyzer for continuously monitoring your databases and alerting you proactively to potential problems.

MySQL Cluster Edition
MySQL Cluster Edition is a commercial, fully supported RDBMS platform that combines world-class availability and real-time performance with the flexibility of open-source software. MySQL Cluster's distributed architecture eliminates single point failures to achieve 99.999% availability. Predictable millisecond response times allow MySQL Cluster to handle high-volume transaction processing applications while meeting strict SLAs. MySQL Cluster also provides linear database scalability to handle unpredictable workloads by providing support for in-memory and disk-based data, automatic data partitioning with load balancing, and the ability to add nodes to a running cluster with zero downtime. MySQL Cluster Manager simplifies the task of creating and managing databases, and support for multiple data access methods makes it easy to integrate MySQL Cluster with a wide variety of applications.

Progent's Support Services for MySQL
Progent's online RDBMS experts can provide a range of affordable services to help companies maximize the business value of MySQL technology. Progent's experience delivering online consulting and technical support services saves money by eliminating travel-related costs and also improves productivity by finishing IT projects faster than is possible with onsite services. Consulting services available from Progent for MySQL environments cover database administration, application development, and migration support.

Database Administration
Progent can provide the services a MySQL DBA consultant to assist with any level of MySQL database administration. Areas of expertise offered by Progent for MySQL database administration include:

• Installing MySQL and setting up server configuration files
• Set up and administer user privileges, access controls, and resource restrictions
• Install appropriate MySQL Connectors
• Select and configure a storage engines such as InnoDB, MyISAM, MySQL Cluster, Memory, etc.
• Use MySQL Partitioning to design an efficient partitioning strategy and create partitioning tables
• Simplify change management and documentation
• Deploy SSL and SSH for secure server connections and remote access
• Streamline table maintenance
• Define views and set view privileges
• Manage the MySQL Binary Log
• Set up, monitor, and troubleshoot MySQL Replication and Synchronization
• Create and implement backup and restore solutions and disaster recovery plans
• Optimize performance tuning
• Assist with software updates
• Select third-party tools for data design and ETL, DBA, job management, and monitoring
• Provide custom online training for IT staff MySQL clients

Application Development
Progent can provide the services of a MySQL developer to help create or maintain data-driven applications in areas such as dynamic, high-traffic web sites, Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP), or business intelligence (BI). Progent can also help you take advantage of MySQL's full-text searching and scale-out capabilities to create data warehousing solutions. Progent's software developers can help you build MySQL applications for Linux environments with PHP, Perl, and Java or integrate MySQL with Visual Studio to create .NET applications with Microsoft C# or VBA. In addition, Progent can help you tune your applications for higher performance or more efficient use of resources, troubleshoot existing applications, or evaluate and modify your applications to enhance security and compliance. Progent's Power BI consultants can help you connect to MySQL databases to create business analytics visualizations for Power BI reports and dashboards.

Migration Support
Progent can help you migrate database environments and applications to MySQL from other RDBMS platforms including Oracle. Progent can help you perform the analysis, planning, porting, testing, and deployment tasks required for a smooth migration your database application to MySQL. Progent can provide assistance at any stage of the migration cycle or help you manage your entire migration project. Progent can also help you move to a new operating system environment such as the latest release of Windows and can set up your application servers to support your ported MySQL database by implementing clustering, virtualization, or distributed multi-site servers.

Other IT Services Offered by Progent
Windows Integration and Support
Microsoft Windows is the leading development platform for MySQL and, according to Oracle, outranks any version of Linux as the most popular environment for MySQL deployments. MySQL version 5.5 and later have been certified for Windows Server Failover Clustering (WSFC) and delivers five times higher throughput on Windows than earlier releases of MySQL. Progent's Microsoft-certified consultants can provide comprehensive Windows Server 2008 R2 expertise and can help you create and maintain a secure, high-availability Windows environment to support mission-critical business applications powered by the MySQL database.

Network Infrastructure Design and Troubleshooting
Progent's Cisco-certified CCIE network engineers, Juniper Networks consultants, and other IT infrastructure specialists can help you design, deploy, and troubleshoot a cost-effective network architecture that delivers high levels of performance, availability, and security to support your MySQL environment. Progent can help you design, enhance, or maintain an in-house data center, provide colocation support and migration assistance for off-site data centers, or host your MySQL application at a world-class data center.

Security and Compliance
Progent's network security engineers have been certified by top information security organizations including CISSP, ISSAP, CISA, GIAC, CISM, and CRISC. Progent can provide comprehensive security evaluation and mitigation services for your MySQL environment and can help you plan and configure security appliances including routers, switches, and VPN gateways, define and enforce security policies that reflect industry leading practices, and recover from security attacks.

Disaster Recovery/Business Continuity Planning
Progent's disaster recovery experts can help you develop, implement, test, and document a disaster recovery plan that maximizes network availability in case of a catastrophic network breakdown resulting from a natural disaster, malicious attack, equipment failure, or human error. Progent can also provide the services of a business continuity consultant who can help you create a high-level business continuity strategy that address all aspects of your business to help you keep critical operations functioning after wide-scale disasters such as earthquakes, hurricanes, floods, or pandemics that create logistical problems that extend beyond information technology issues.

Other RDBMS Platforms Supported by Progent
Progent's team of online consultants offer database administration and application development services for the most popular RDBMS platforms used in small and mid-size businesses. In addition to MySQL expertise, Progent's database DBA and software development services include:

• Microsoft SQL Server Support
• Oracle DBA Services
• Microsoft Access Application Development