Closed

MySQL / MariaDB Expert

We have a large database estate with many database clusters and are looking for a MySQL / MariaDB specialist for ongoing long term support engagement.

You will need in-depth knowledge of:

- MySQL and MariaDB

- Replication options (synchronous and asynchronous)

- Performance optimization techniques

- Query optimization and rewriting

- Linux, especially file systems and storage stack tuning

In your proposal, please answer the following questions:

1) Briefly describe and explain configuration of one of the synchronous (not asynchronous) replication methods available in MySQL or MariaDB?

2) At peak times, you are notice that the MySQL server's response times are very poor. You look at the output of SHOW FULL PROCESSLIST; and you notice there are a lot of queries in "opening tables" state. What configuration option would you look at changing first?

3) You have a query that is indexed as well as it can be, but requires a very large, expensive sort operation due to having a GROUP BY clause that spans fields in multiple tables. Describe a technique you would use to enable you to make that query fully indexable and avoid the sorting operation?

4) You are required to carry out performance analysis and optimisation on a busy server. Explain the steps you would follow to identify the most problematic queries and sub-optimal server configuration.

5) You are tasked with configuring a new MariaDB server for a project. Only InnoDB storage engine will be used. List the settings you would configure each layer of the storage stack with, including file system (of your preference) and RAID (or equivalent), and how those would match up with any relevant MariaDB level configuration.

Skills: Linux, MySQL, Apache, System Admin, Database Administration

See more: find mysql security expert, need linux apache mysql security expert, php mysql script expert, mariadb vs mysql, percona, mariadb mysql, mariadb documentation, mysql consultants, mariadb tutorial, percona mysql tuning, percona monitoring mysql, expert advisor multiple trades, asterisk mysql select query dialplan multiple row, html ajax php mysql css expert, php mysql ajax expert, php mysql optimization expert seo, mysql php send email multiple users, looking excel expert create multiple macros, mysql trigger expert, php mysql girl expert

About the Employer:
( 0 reviews ) Camberley, United Kingdom

Project ID: #23923913

22 freelancers are bidding on average £38/hour for this job

devexpertsteam

Hello, We see that you are searching for a local service provider, however, if by any chance you won't find someone local - here is a letter from our team. ;) We are IT-Engineers and Business Analysts, creating c More

£36 GBP / hour
(72 Reviews)
7.9
sptechnocrats

A Warm Hello! I am readily Available to start working on your project! My name is Rish, [login to view URL] Stack Developer with 7+ years of experience of Website Development and I think I am the guys you are looking for we will More

£36 GBP / hour
(89 Reviews)
7.7
kuldeepvk

Hi, I have experience in cluster set up for both webserver as well as database. Please discuss so that i can answer all your queries. Thank you

£36 GBP / hour
(356 Reviews)
7.0
julianbagilet

Hola, Hemos leído los requerimientos de tu proyecto, quería contarte que estamos dispuestos a trabajar contigo, somos expertos en Apache, Database Administration, Linux, MySQL, System Admin Somos un equipo desarrollad More

£36 GBP / hour
(44 Reviews)
7.0
mrfixersl

Well this is an interesting project. I have been using Galera cluster for this AUS firm for the last couple of years. Answer1 --- To answer your first question. I use MariaDB 10.4.X and Galera4. The nodes are alway More

£50 GBP / hour
(162 Reviews)
6.5
talhamq

I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 20 More

£36 GBP / hour
(263 Reviews)
6.4
infihost

Hi, I will configure server as per the requirement. I do have more than 11 years of expertise in web hosting, server setup, optimisation, MySQl configuration, etc Please discuss to start. Thank you.

£36 GBP / hour
(171 Reviews)
6.0
Solaristech

Hi, I specialize in website design and development and am excited for this opportunity to work with you in accomplishing your goals.. I am Good at Apache, Database Administration, Linux, MySQL, System Admin.. Please Se More

£36 GBP / hour
(50 Reviews)
5.1
schoudhary1553

Hello, I can help you with your project - MySQL / MariaDB Expert I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several More

£36 GBP / hour
(25 Reviews)
5.4
herradi

Hello I am an expert in building and managing systems and networks (Linux and Windows), you can count on me in building and managing your projects distinctively and professionally. I have more than 7 years experience i More

£36 GBP / hour
(20 Reviews)
4.4
android2014213

Dear Hiring Manager, I am Redhat Certified Engineer. I have 8 years of experience as a Linux System Administrator. I posses good knowledge of mail server like zimbra, sendmail, web server like Apache, shell scripting, More

£36 GBP / hour
(20 Reviews)
4.6
TurboWebWP

If it's a Wordpress website, I can help with the speed optimization part. You're losing 11% traffic and 7% conversions for every extra second of load time. I am an expert in this specific field of speed optimization an More

£36 GBP / hour
(4 Reviews)
3.8
bitscollisionpk

Hello I'm expert in MySQL / MariaDB and I have knowledge of MySQL and MariaDB - Replication options (synchronous and asynchronous) - Performance optimization techniques - Query optimization and rewriting - Linux, espe More

£36 GBP / hour
(2 Reviews)
3.6
praveen2121

Hello, I read through the job details extremely carefully and I am sure that I can do the project very well. I can achieve the results with my team of developers, designers, QA and Project Manager who will be respons More

£36 GBP / hour
(1 Review)
2.4
kirilnberezebko

1) If I have Query A,B,C ( B relies on A, C relies on B) So I do the straight forward thing and run them in the order A, B and C. Replication puts them into a log in that same order. So when the slave executes them, i More

£50 GBP / hour
(1 Review)
2.0
lubomirkalinin43

Hi! I reviewed your project description and I feel a stirring of curiosity about your project. I am full experienced database administrators with rich experiences in mysql/mariadb. I am a new freelancer but I've devel More

£36 GBP / hour
(1 Review)
0.6
vw1342868vw

Hi Greetings We are 100% capable to accomplish your task. in few hours we will provide you free sample We divided our work in two steps First Step Free Demo Second Step Free Consultation. open a chat to take a resul More

£36 GBP / hour
(0 Reviews)
0.0
yestheory

Dear Client Hope all is well with you. I would like to offer my services for this job. Thanks and Regards. Relevant Skills and Experience Tuning any size of data and make them responsive.

£40 GBP / hour
(0 Reviews)
0.0
vg10

I have 10 year experience in SQL DB

£38 GBP / hour
(0 Reviews)
0.0
yetiaslinda

Saya memiliki sertifikasi dalam bidang administrasi

£40 GBP / hour
(0 Reviews)
0.0