Short Term Backing: Analysis of Database

Analysis Approach: Analysis and Implementation will be conducted in six phases as shown below

• Phase – 1: Port opening to the monitoring servers.
• Phase – 2: Receiving the access credentials from client.
• Phase – 3: Enable polling for the client servers.
• Phase – 4: Recommendation.
• Phase – 5: Benchmark.
• Phase – 6: Implementation.

Phase – 1: Port opening to the monitoring servers Port 22 and 3306 needs to be opened for our monitoring servers which run in static IP.

Phase – 2: Getting the access credentials from client This requires SSH and MySQL access SSH – Should be a normal user, which should have access to check the RAM, Load, IOstat, VMstat, top etc. MySQL - Read access which will include privilege to check the replication settings/errors, process running in MySQL and flushing the status.

Phase – 3: Enable polling for the client servers Once we get the access credentials and port opening to the monitoring server, we shall enable polling to the client servers to be audited. The monitoring tool will collect the stats from the client servers for every 5 minutes. The acquired data will be analyzed by our DBA for the current issues in the database and the same will recorded.

Phase – 4: Our DBA will check for OS parameters, MySQL parameters and the performance issues on the servers and provide the audit recommendations accordingly. The audit findings & recommendations will look like as listed below.

Phase – 5: In this phase we would record the capacity or the number connections the machine could handle with the existing setup.

Phase – 6: In this phase, based on the audit findings, our DBA Team will perform a few changes in OS/DB and follow a certain iterations of tuning to obtain optimal value for the parameters. Once we are done with implementation, again we shall do the benchmarking for performance in the improved environment.

Long Term Backing: Annual Maintenance

Monitoring

We will be monitoring MySQL database servers.

In case of any issue that occurs in the database servers, our technical person will be available 24*7 and fix those issues. Our monitoring structure will be of two levels:

• Proactive monitoring
• Issue based monitoring

Proactive monitoring: Our team will be monitoring the servers or shall use the monitoring scripts to monitor the MySQL database servers and fix the issues proactively. We take control of the issues that could be proactively alerted. Based on the proactive alerts we get, one of our consultants shall act to get the issue resolved. This will prevent the issue from occurring and hence reduce the downtime. Proactive monitoring includes connection increase, traffic patterns like insert, select, update and delete ratios, no of sorting operations,database size increase and memory utilization pattern change. Changing the variables and configurations based on the analysis of the server performance. This will be done with the help of our polling statistics. Issue based monitoring: If some issue happens in any of the MySQL database servers, then consultant shall get an alert e-mail, based on which the consultant reacts to fix the issue.

Issue based monitoring: If some issue happens in any of the MySQL database servers, service provider shall receive an alert e-mail, based on which a consultant reacts to fix the issue.

Tuning

Tuning of the database servers shall be done in two layers.

• Database level tuning
• Query level tuning

Database level tuning: Our team shall monitor the servers and performance of the same. We will tune the database parameters if there is some scope for improvement.

Query level tuning: Our monitoring script shall keep track of all the queries that take more time to complete the execution. We will collect all queries which are causing issues or taking more time to execute. We will analyze the query to find how the same can be best tuned. Once tuned, the same shall be passed on to Client’s developers after discussing with them. Archiving of Database: As a regular maintenance activity, we will find out all fast growing tables in all the servers and discuss with Client’s developers for the archiving policy. If the Client’s developers are coming up with the tables to be archived, then we will take appropriate steps for archiving, which can be an automated or a manual archival policy for that table.

Maintenance of Database

• All the Maintenance scripts which are running in DB servers will be reviewed and changes will be done, if needed.
• We will do upgradation of servers as per the Client’s needs.
• We might implement new features based on the Client’s needs.
• Architectural changes will be done to suit the growing needs of any application, if needed.
• We will design Fail over Architecture for the requested servers.

Backup of Database

A proper backup solution will be put in place for the requested servers. It will be either of the below ones:

• Consistent backup on a weekly basis.
• Incremental backup daily.
• Shipping the backup to remote place in case of local server failures. The infrastructure for taking the backup will be provided by the Client.

Security Audit

We shall audit the database to improve the security of the system. We will check if the database has not been compromised by any means in terms of Security. We will Audit, if only the needed privileges are given to users and needed hosts have access to the database servers. Only the required access and privileges shall be given to prevent any data loss issues from occurring.

Migration of Database

CEI data migration team helps you to get the most out of your data assets by database migration of any database software and across-vendor database migration that includes Oracle/SQL server/DB2 database from respective older to newer release i.e. Oracle 10g to Oracle 11g migration, Oracle to DB2 migration, DB2 to Oracle migration, SQL server to Oracle migration, Oracle to SQL server migration, database migration from Windows to any Unix (Proprietary or Open source) and vice versa which makes the data environment secure and up-to-date for your organization.

As part of Migration Process we also provide services for-

• Audit of Source Data.
• Full Data-Quality Services.
• Data Enhancement.

Summary

We provide the best in support for the MySQL needs of our Customers and Partners. We can help you manage and optimize your database environments for all MySQL versions (3.x, 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 5.7). We have exposure in managing MySQL databases driving Platforms with large database volumes. Tune and benchmark MySQL for better concurrency and performance.