mysqldba.co.uk

MySQL DBA

Richard Wallman - a MySQL DBA (database administrator). An experienced MySQL database administrator based in Birmingham, UK. Certified to the top levels with the MySQL database server versions 4.0 and 5.0, I have spent several years building and maintaining busy sites with 24x7 database availability and high levels of performance. I am also the administrator of the Linux servers on which I work, allowing me to extend the database optimisation to the OS and hardware level. This results in some systems...

http://mysqldba.co.uk/

OVERVIEW OF mysqldba.co.uk

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

5

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR MYSQLDBA.CO.UK

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

October

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 10 reviews

5 star

3

4 star

5

3 star

1

2 star

0

1 star

1

Hey there! Start your review of mysqldba.co.uk

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT MYSQLDBA.CO.UK

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

5

SSL

EXTERNAL LINKS

45

SITE IP

85.119.82.158

LOAD TIME

0.594 sec

SCORE

6.2

PAGE TITLE

MySQL DBA | mysqldba.co.uk Reviews

<META> DESCRIPTION

Richard Wallman - a MySQL DBA (database administrator). An experienced MySQL database administrator based in Birmingham, UK. Certified to the top levels with the MySQL database server versions 4.0 and 5.0, I have spent several years building and maintaining busy sites with 24x7 database availability and high levels of performance. I am also the administrator of the Linux servers on which I work, allowing me to extend the database optimisation to the OS and hardware level. This results in some systems...

<META> KEYWORDS

1 experience

2 past clients

3 contact me

4 blog tweets

5 articles

6 oracle

7 and mysql

8 valid html5

9 coupons

10 reviews

CONTENT

Page content here

KEYWORDS ON PAGE

experience,past clients,contact me,blog tweets,articles,oracle,and mysql,valid html5

SERVER

nginx/1.10.3

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

MySQL DBA | mysqldba.co.uk Reviews

https://mysqldba.co.uk

Richard Wallman - a MySQL DBA (database administrator). An experienced MySQL database administrator based in Birmingham, UK. Certified to the top levels with the MySQL database server versions 4.0 and 5.0, I have spent several years building and maintaining busy sites with 24x7 database availability and high levels of performance. I am also the administrator of the Linux servers on which I work, allowing me to extend the database optimisation to the OS and hardware level. This results in some systems...

INTERNAL PAGES

mysqldba.co.uk

1

MySQL DBA

http://www.mysqldba.co.uk/clients

Richard Wallman - a MySQL DBA (database administrator). A leading Internet retailer of mobile phones and accessories in the UK and Europe. I spent 5 years working for the company is the role of IT Infrastructure Manager, where I was responsible for the maintenance and development of their office and Internet hardware. This company saw massive growth during my time there, appearing in both the Sunday Times Tech Track 100 and Deloitte Technology Fast50 lists of fastest growing companies.

2

MySQL DBA

http://www.mysqldba.co.uk/experience

Richard Wallman - a MySQL DBA (database administrator). I have over 10 years of hands-on database administration experience, using the MySQL database server from versions 3.23 to 5.5. This has involved data migrations from other RDBMSs and upgrades between MySQL database server versions. I have successfully achieved the following certifications:. Design and content 2011 Richard Wallman. No part of this site may be reproduced without prior written agreement.

3

MySQL DBA

http://www.mysqldba.co.uk/faq

Richard Wallman - a MySQL DBA (database administrator). Are you willing to work under an NDA? Do you charge by the hour or by project? How can I let you securely access my MySQL servers? What's your SSH public key? Are you willing to work under an NDA? Yes, I have no problems working under an NDA. I recognise that I may access to sensitive information, and that people may feel happier having the additional "protection" of a signed NDA. Do you charge by the hour or by project? What's your SSH public key?

4

MySQL DBA

http://www.mysqldba.co.uk/articles

Richard Wallman - a MySQL DBA (database administrator). MySQL DBA for non-DBAs - Why do I need replication? Written: 2016-01-19 @ 10:00:00. Unless you are working on a small, internal application for an organisation, eventually you're going to have to consider how to scale your database service to handle more traffic. If you consult the Internet for advice, the two most frequent answers yo. MySQL DBA for non-DBAs - What is replication? Written: 2016-01-12 @ 10:00:00. Written: 2016-01-06 @ 14:00:00. I gav...

5

MySQL DBA

http://www.mysqldba.co.uk/blog

Richard Wallman - a MySQL DBA (database administrator). Just read the MySQL/HAProxy tutorial on @digitalocean - it's so awful it literally took my breath away for a second. Top result in Google :(. Part 2 of my #mysql #replication for #webdev series: "Why do I need replication? I've been asked to write a series about #mysql replication for #webdev s. Part 1: "What is it? I've been asked to write a series about #mysql replication for #webdev s. Part 1: "What is it? When actually, you've finished it. When ...

UPGRADE TO PREMIUM TO VIEW 0 MORE

TOTAL PAGES IN THIS WEBSITE

5

LINKS TO THIS WEBSITE

richard.wallman.org.uk

Richard's ramblings | nginx

http://richard.wallman.org.uk/tag/nginx

Yes, more vanity. Another month, another Catalyst launch. Okay, this one should have happened a couple of weeks ago, but last-minute snags and a lot of other work delayed things slightly. (more…). Busy, busy, busy. Just a quick update for now – I’ve managed to book myself up quite fully. (more…). One week on – Catalyst still going strong. HOWTO: Deploy a Catalyst application using FastCGI and nginx. Catalyst, nginx and FastCGI – my first bloody nose. Was an interesting affair. (more…). Another busy week ...

richard.wallman.org.uk

Richard's ramblings | Portfolio

http://richard.wallman.org.uk/portfolio

Yes, more vanity. In particular, about me as a MySQL database administrator. Technical articles and downloads coming soon. The Freecycle Network is a global re-gifting movement aimed at reducing the amount of stuff going into landfill. Check out the site for more details. I’ve been responsible for the redesign of the site and the building of a new, custom built system for Freecycle groups to run on. Designed and implemented a spam and virus scanning email system. A site I set up mainly for my parents, to...

richard.wallman.org.uk

Richard's ramblings | My NES

http://richard.wallman.org.uk/my-nes

Yes, more vanity. This takes me back to my youth. There’s more information about what the NES is, visit the Wikipedia. Bits I’d like:. 4 x standard NES controllers. Nintendo Zapper light gun (orange). Games I’d like:. Super Mario Bros/Duck Hunt. Super Mario Bros II. Super Mario Bros III. 8230;well, any that I haven’t got, actually! Wikipedia has a list of NES games. 8211; treat it as a shopping list. Leave a Reply Cancel reply. You must be logged in. To post a comment. Busy, busy, busy.

richard.wallman.org.uk

Richard's ramblings | fastcgi

http://richard.wallman.org.uk/tag/fastcgi

Yes, more vanity. Another busy week in the code mines…. I’ve actually been getting my hands dirty with code again this week – both my existing Catalyst based apps are working fine, so just to keep things interesting I’ve got another two apps as work-in-progress and refactoring the existing ones for translations. (more…). Another month, another Catalyst launch. HOWTO: Monitor a FastCGI server using monit. Busy, busy, busy. One week on – Catalyst still going strong. Last Friday, I took my first Catalyst ap...

richard.wallman.org.uk

Richard's ramblings | HOWTO: Use jQuery/DataTables with Perl/Catalyst/DBIC

http://richard.wallman.org.uk/2011/12/howto-use-jquerydatatables-with-perlcatalystdbic

Yes, more vanity. Laquo; Another busy week in the code mines…. HOWTO: Use jQuery/DataTables with Perl/Catalyst/DBIC. I offered to write an entry for the Catalyst Advent Calendar. Based on a private wiki article I use, and wanted to break the 600 day blogging dry spell! Have made it easier to develop cross-platform, interactive interfaces, but tables of data have still lagged behind a bit. There is a jQuery plugin that adds interactivity to tables of data in HTML – datatables.net. Table id='datatable' sty...

richard.wallman.org.uk

Richard's ramblings | HOWTO: Monitor a FastCGI server using monit

http://richard.wallman.org.uk/2010/03/monitor-a-fastcgi-server-using-monit

Yes, more vanity. Laquo; Busy, busy, busy. Another month, another Catalyst launch. HOWTO: Monitor a FastCGI server using monit. To keep an eye on the system and other running processes, so here’s how I’ve got it checking the FastCGI servers as well. (I could write a Perl script using the FCGI: Client. Module to do checking, but then I’d have to write a monitor to make sure the monitor was still running. Possible – you just have to do your own binary send/expect string, like so:. Empty FastCGI request if ...

richard.wallman.org.uk

Richard's ramblings | monit

http://richard.wallman.org.uk/tag/monit

Yes, more vanity. Another busy week in the code mines…. I’ve actually been getting my hands dirty with code again this week – both my existing Catalyst based apps are working fine, so just to keep things interesting I’ve got another two apps as work-in-progress and refactoring the existing ones for translations. (more…). HOWTO: Monitor a FastCGI server using monit. Module to do checking, but then I’d have to write a monitor to make sure the monitor was still running. Another month, another Catalyst launch.

richard.wallman.org.uk

Richard's ramblings | PerlMongers

http://richard.wallman.org.uk/tag/perlmongers

Yes, more vanity. Another busy week in the code mines…. I’ve actually been getting my hands dirty with code again this week – both my existing Catalyst based apps are working fine, so just to keep things interesting I’ve got another two apps as work-in-progress and refactoring the existing ones for translations. (more…). HOWTO: Use jQuery/DataTables with Perl/Catalyst/DBIC. Another busy week in the code mines…. Another month, another Catalyst launch. HOWTO: Monitor a FastCGI server using monit.

UPGRADE TO PREMIUM TO VIEW 37 MORE

TOTAL LINKS TO THIS WEBSITE

45

SOCIAL ENGAGEMENT

pages/MySQL-DBA/157725190458

mysql_dba_uk

OTHER SITES

mysqldatenbank.com

Mysqldatenbank.com steht zum Verkauf! Domains für Domain-Pofis und Investoren sofort kaufen

Mysqldatenbank.com steht zum Verkauf. Sie können diese Domain jetzt kaufen. Nutzen Sie diese einzigartige Gelegenheit. Und starten Sie mit dieser Domain online durch! Diese Domain jetzt über Domainname.de kaufen:. Diese Domain können Sie auch direkt bei sedo. Kontaktieren Sie uns für eine unverbindliche Anfrage:. Und viele weitere Domains.

mysqldb.bigresource.com

Foreign Key Constraint Error While Deleting From Table?

Foreign Key Constraint Error While Deleting From Table? May 28, 2012. I have two tables:. Requests - Request id , Request Message; / contains Requests. Responses - Response id , Request id , Response Message; / Contains Responses for the request. Request id is foreign key for this table. Now while i am running the query delete from requests where Request id = REQ001;. if there is no corresponding response in responses table then query is working fine, other its giving foreign key constraint error. How To...

mysqldb.wordpress.com

Select Star | People for the ethical treatment of databases

People for the ethical treatment of databases. Yet another DDL dump script. August 23, 2010. Inspired by some recent posts. About scripts for parsing mysqldump files, I thought I’d put my own little dump program out there for those looking for alternatives to mysqldump. It’s written in perl and only actually uses the mysqldump utility to dump the data portion of its file dumps. The rest is done via mysql’s internal. User@svr123]$ mysql -D dbname /path/to/files/dbname/schemas/*.sql. Data files are zipped).

mysqldba.blogspot.com

mySQL DBA, Architecture, Dev, Scale, HA, Code

MySQL DBA, Architecture, Dev, Scale, HA, Code. Saturday, January 27, 2018. Spotify Top 200 in mySQL. I do a lot of data analysis lately, and I try to find answers to questions through data for my companies pressing questions. Let's look at the past year of 2017 and answer questions for people who like music. Artist is the artist name. Track is the artist's track name. List date is which chart date the artist show up on the top200. Streams is the number of plays following spotify specific rules. Drake kil...

mysqldba.co.uk

MySQL DBA

Richard Wallman - a MySQL DBA (database administrator). An experienced MySQL database administrator based in Birmingham, UK. Certified to the top levels with the MySQL database server versions 4.0 and 5.0, I have spent several years building and maintaining busy sites with 24x7 database availability and high levels of performance. I am also the administrator of the Linux servers on which I work, allowing me to extend the database optimisation to the OS and hardware level. This results in some systems...

mysqldba.net

Creating Your Koi Backyard. August 09, 2015 11:38 PM. Petros TN window air conditioning units. Having been in the plant Perrysburg NY window air conditioner. Nursery Penrod KY window ac repair. Industry a small Pen Argyl PA window ac unit. Over five years, I satisfied numerous individuals who wanted a Penn Valley CA window air conditioner. Nice lawn Petersburg TN window air conditioner repair. Pensacola FL window ac units. Pendleton SC window air conditioner repair. Perry FL window air conditioning units.

mysqldba.prasannjha.com

Prasann Kumar Jha

mysqldba.pro

Mysqldba.pro

mysqldbadmin.blogspot.com

mysql administration

Friday, November 18, 2011. Drop all tables in one command. Drop all tables in one shot:. Mysql - user=xxxx - password=xxxx -BNe "show tables" database name tr ' n' ',' sed -e 's/,$/ ' awk '{print "SET FOREIGN KEY CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN KEY CHECKS = 1;"}' mysql - user=xxxx - password=xxxx database name. Saturday, September 11, 2010. Change PuTTYs Default Scrollback Values. 1 Go to Run (Win R), type regedit. 2 In the registry editor, press Ctrl F. Tuesday, August 31, 2010. Relay...

mysqldbahelp.com