MySQL Cluster is a technology that helps you achieve the highest standards when it comes to high availability and performance. MySQL Cluster was originally designed to suit the needs of large telecommunication companies and had very high performance and availability standards incorporated into its architecture. MySQL Cluster uses shared-nothing architecture, which eliminates single point of failure and can deliver 99.999% availability. MySQL Cluster automatically shards data across multiple servers and allows performance to be scaled to millions of queries per second. MySQL Cluster was designed to run on commodity hardware, but it also delivers impressive results on modern enterprise-grade servers. MySQL Cluster is a very powerful, but intricate technology, requiring a high level of expertise and attention to every detail to be implemented properly. Pythian’s MySQL Cluster experts can help you evaluate, design, and implement a MySQL Cluster solution or audit and tune your existing solution to bring your database infrastructure to a new level.
MySQL Galera Cluster
MySQL Galera Cluster is a relatively new third-party MySQL clustering solution. It provides unique features which are not available in standard MySQL replication, such as synchronous master-master replication, automatic management of removing failed nodes, adding new nodes to the cluster, and parallel row-level replication. These features allow you to build scalable, high-availability clusters without sacrificing full MySQL compatibility. Pythian can provide deep technical expertise to help you evaluate MySQL Galera Cluster and make sure it’s the right fit for your project.
MySQL High Availability Solutions
MySQL is the world’s most popular open-source database, powering some of the largest social networks and web-based businesses. High availability is one of the most critical business requirements when it comes to your database infrastructure, but it is also hard to achieve since MySQL doesn’t provide any out-of-the-box high availability solutions. To build a resilient MySQL infrastructure, you need to carefully evaluate requirements, like cold cluster or hot cluster, automated or manual failover. Pythian’s experts can help you choose the right components for your MySQL high availability solution. We have developed many highly available infrastructures to customers all over the world using proven open-source technologies like Linux-Heartbeat, Red Hat Cluster, MHA and others.
MySQL Tungsten Replication
MySQL Tungsten Replication is a third-party, open-source advanced replication solution. Tungsten implements a Java-based replication layer which replaces standard MySQL replication. This technology provides many advanced replication features, including parallel replication, global transaction ID, multi-master replication, Oracle to MySQL and MySQL to Oracle replication. While you can continue using the same MySQL distribution without any compatibility issues, adding a new layer to your infrastructure can introduce risks and increase complexity. Pythian experts can help you mitigate these risks by taking care of all the technical complexities and implementation details, so your database infrastructure is highly available and performs at its peak.
Microsoft SQL Server
AlwaysOn Availability Group
The AlwaysOn Availability Group feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. It takes database mirroring to a whole new level by allowing groups of databases to failover as a single unit. It can have up to four extra copies of databases configured with either synchronous or asynchronous replicas. It further maximizes performance and IT investments by offloading backups and read-only workloads from the primary replica to the standby replicas. Pythian’s SQL Server experts are always on the cutting edge of new technologies and can help you plan, design, and implement AlwaysOn Availability Group as part of your organization’s upgrade strategy to SQL Server 2012.
Microsoft SQL Server Clustering
SQL Server clustering is a high-availability native Microsoft technology that allows entire database servers to be redundant in every aspect. When serious issues occur, the entire database instance fails over to the other server. The fail over is completely automated and can also be manually initiated, which is very convenient for any databases that need high availability. Clustering is one of many high availability options available. Pythian’s expert DBAs can help you decide if clustering is right for you, and help you architect and implement the best solution to meet your needs and fit your budget.
Microsoft SQL Server Database Mirroring
SQL Server Database Mirroring is a high-availability solution introduced in SQL Server 2005. It increases availability and protection of a database, especially during maintenance and upgrades. It provides redundancy and failover capabilities at the database level and is a relatively cheaper and easier alternative to failover clustering. Pythian’s SQL Server experts can work with you on defining your high availability requirements and evaluate whether or not database mirroring would be a right fit for your highly critical databases—including planning, implementing, and maintaining your database mirroring infrastructure. Once the solution is up and running, our proprietary monitoring tool is configured to watch for any potential issues. Problems get immediately addressed by our team of SQL Server DBAs working round-the-clock for you, so that your organization can focus on what you do best.
Microsoft SQL Server Integration Services
SQL Server Integration Services (SSIS) is a technology included with most versions of SQL Server. It can be used to do any combination of the following: load data into a database, manipulate data, and transfer data between servers and files. SSIS is also able to move data between different types of databases. SSIS is optimized for data manipulation and replaced Data Transformation Services (DTS). Pythian’s expert DBAs can help you create new SSIS packages, tune your existing packages, or audit your setup to allow you to easily move packages between development, test, and production environments.
Microsoft SQL Server Log Shipping
SQL Server Log Shipping is a disaster recovery feature, which was introduced to the SQL Server 2000 Enterprise Edition and is now available in SQL Server 2005 Standard Edition. The technology allows the transaction logs to be automatically shipped and applied to other database servers. It’s very reliable and is often used to copy data to disparate servers. The advantage of log shipping over replication is that you don’t need to define a primary key on tables and virtually any database can be log shipped.
Microsoft SQL Server to Oracle Replication
SQL Server supports heterogeneous replication for both transactional and snapshot replications. This feature enables you to use SQL Server replication even when there are different types of databases within your environment. A typical replication setup consists of a publisher, distributor, and at least one subscriber. Heterogeneous replication works basically the same way, except you substitute a database other than SQL Server in the role of publisher or subscriber. Pythian’s SQL Server experts can leverage the expertise of the Oracle team and vice versa in order to provide top-notch support throughout the planning, set up, maintenance, and troubleshooting phases of the Oracle-to-SQL Server and SQL Server-to-Oracle replication.
Microsoft SQL Server Replication
Microsoft SQL Server replication is a technology that allows you to synchronize data and even database objects between databases and, once in place, is completely automated. There are many different types of replication, depending on the version of SQL Server you are using. This is an excellent technology commonly used to synchronize production and reporting environments. It prevents analysts from slowing down the production environments and allows them to further aggregate the data. Another popular use is merge replication, which is designed to keep databases located in branch or point-of-sale locations synchronized with other copies. Pythian’s DBAs experts can help you determine which data synchronization option is best for your organization.
Microsoft SQL Server Service Broker
SQL Server Service Broker provides native support for messaging and queuing applications in the SQL Server database engine. This makes it easier for developers to create sophisticated applications that use the database engine components to communicate between disparate databases. Application developers who use Service Broker can distribute data workloads across several databases without programming complex communication and messaging internals. This reduces development and test work because Service Broker handles the communication paths in the context of a conversation. It also improves performance as applications are able to send process intensive tasks to queues in back-end databases. Service Broker ensures that all tasks are managed in the context of transactions to assure reliability and technical consistency.
Pythian’s experts can assist you with the design, configuration, setup, and implementation of Service Broker. Our DBAs have extensive experience troubleshooting and maintaining Service Broker scenarios and we follow best practices in regards to the key concepts: queues, dialogs, conversation groups, and activation.
Oracle Database Availability and Business Continuity
Many technologies provide high availability and disaster recovery for Oracle databases. Pythian actively supports systems of almost every conceivable configuration in small businesses and fortune 500 companies alike. We can help you evaluate the trade-offs of each approach and find the best solution for your unique business. We can also help you with backup designs; streams, GoldenGate, and integration with storage replication; RAC; standby database (including Data Guard); failover clusters with your choice of operating system, and many other technologies. If you don’t know what technology and architecture is best for you, we can collaborate with you from an independent third-party expert perspective to find the best strategy, and we offer industry-leading operational support to help you keep it running.
Oracle Enterprise Manager Grid Control and Cloud Control
Oracle Enterprise Manager Grid Control (10g/11g) and Cloud Control (12c) provide an extensive portfolio of management solutions to help manage your Oracle IT environments. Pythian routinely helps businesses with strategy, architecture, implementation, and operations of OEM. We’re fluent with standard deployments and we can assist with any unique or uncommon business requirement. Our experts will help you plan, install, and configure highly available and scalable Cloud Control systems, customized to your operational requirements. We have experience with a variety of operating systems, database versions, high-availability configurations, modules, and customizations.
We can work with your in-house database experts to help them get up to speed with all Cloud Control best practices, and plan, install, and configure the system together. We can also use Cloud Control to monitor and manage your entire database system for a complete hands-off approach. If you already have Cloud Control installed, we can make sure it’s configured according to best practices and it matches your high-availability requirements.
Oracle GoldenGate provides real-time access to real-time information. You can dramatically improve the availability, reliability, and performance of your mission-critical systems through Oracle GoldenGate’s log-based change data capture for data warehouses and online transaction processing (OLTP) databases. Oracle GoldenGate offers tight integration with numerous other Oracle technologies, including Oracle Database, Oracle Fusion Middleware, and several Oracle applications.
From Oracle Advanced Replication to Oracle Streams and Oracle GoldenGate, Pythian is deeply familiar with all of Oracle’s replication technologies. We also leverage our significant expertise in Oracle Exadata, as Oracle GoldenGate is certified to capture and deliver data to Oracle Exadata Storage Server to enable real-time data warehousing or data consolidation services. Pythian can assist with the planning, deployment, and management of Oracle GoldenGate, from initial investigation and proof of concept to application migration and ongoing operational support.
Oracle Real Application Clusters (RAC) is a database option that provides high-performance, multi-server scale out capabilities with increased fault tolerance. It continues to lead the industry in relational database scalability and performance.
RAC can sometimes reduce availability if not deployed properly. Pythian can help protect your investment by configuring your new systems according to industry best practices, performing health and configuration checks on existing systems, mentoring your staff, and providing any desired level of operational support to your organization.
Our industry-renowned RAC experts can help you find the best strategic fit for Oracle database clusters in your business and our experienced technical teams can fully support your staff throughout its entire lifecycle—from 24x7x365 operations to emergency escalation only.
As per the norm Sabiha Choudhry is always on top of the situation and always takes the time to explain why something has gone wrong further educating myself. She's efficient, courteous and a pleasure to work with. Thank You, Sabiha.
- Stefano Marcantonio, Canadian Medical Association