MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-4
votes
0answers
13 views

LEMP Setup on CentOS at DigitalOcean [on hold]

I'm following this tutorial. I got some issues start from step four: Configure Nginx to Process PHP Pages. After I typed this $ sudo vi /etc/nginx/conf.d/default.conf. I can't find server { listen ...
-1
votes
0answers
12 views

myisamchk results in segmentation fault

My database table is marked as "in use" in phpMyAdmin. I tried to run repair on it. I get this issue and followed the instructions here: ...
0
votes
0answers
8 views

hardware sizing of web and database server [duplicate]

I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, ...
0
votes
0answers
15 views

How to backup MySQL (MariaDB) database on dedicated servers to AWS (S3 Object Storage?)

We have a 180GB dedicated production server, which we currently backup daily using Percona xtrabackup to a backup server in our rack. We're looking at moving our backups (not the database itself) to ...
0
votes
1answer
18 views

How to enable slow query log in MySQL Galera?

I want to enable slow query logging in MySQL Galera. In order to do so, I have enabled it through my.cnf: log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 1 ...
0
votes
2answers
33 views

Trying to access port 3306 (only using it locally)

I am trying to open port 3306 on my archlinux distro. I've tried multiple different iptables settings, but I can't seem to get it to work. (Locally) Here's my current iptables setting: Chain INPUT ...
0
votes
1answer
18 views

Optimizing mysql and apache ovh vps [duplicate]

My website is 100% mysql php so it gets slowdown and sometimes server shutdown. I'm using VPS Classic: The best cheap VPS - $2.99/month - OVH (VPS Classic 4 - 4 vCores and 8GB RAM). I want some ...
2
votes
1answer
58 views

Website sometimes takes long time to load

I am running a LAMP system with Ubuntu 14.04. I have 4 cores and 8GB Ram on my server The problem is that when I connect to my website after idle period( 2-3 hours or more) the it takes lot of time ...
0
votes
1answer
21 views

multi-tenancy saas isolated database configuration [on hold]

I'm currently researching the world of Multi-tenancy SaaS environments which run on the isolated database configuration. I'm looking to further understand the provisioning of new accounts (creation ...
0
votes
1answer
40 views

MySQL Optimization for write-heavy DB, single connection [on hold]

I have a cloud machine with 1 core CPU, 1GB RAM and 24GB SSD. It is running CentOS 6.5, mysql 5.1.73 with default my.cnf. I have a PHP job that runs and fetches data from some other websites, ...
0
votes
1answer
15 views

How to migrate MySQL Master/Master replication to MySQL Galera Cluster?

Currently our setup consists of two MySQL 5.6 servers on seperate Ubuntu 14.04 bare mettal machines. I am looking into migrating the system to a MySQL Galera Cluster on 3 nodes. Can I "patch" the ...
2
votes
1answer
29 views

MySQL user can't connect from remote host

I have two MySQL users with the exact same permissions, one can connect from a remote host, the other can't. How could this be? Here is my configuration: SELECT * FROM user WHERE user IN ...
0
votes
1answer
19 views

Set up keepalived for MySQL Master-Master replication [on hold]

I managed 2 mysqld processes that listen for connections on different ports- 3306 and 3307 on localhost. I set up MySQL Master-Master replication. And now I want to set up keepalived for MySQL ...
1
vote
1answer
23 views

Can one use a MySQL backend for user authentication in a strongswan VPN server?

We have installed and configured a strongswan VPN server with username / password authentication. Is it possible to store the users' credentials in a MySQL backend and configure strongswan to use the ...
0
votes
1answer
21 views

Removing a mySQL database without password? [duplicate]

So about 6 months ago I set up a wheezy server and at the same time I installed MySQL even though I didn't need it. I've now updated to Jessie and need the database but can not remember the password ...
4
votes
3answers
85 views

Hardware RAID1 configuration - Possibly failed sectors on one physical disk. Does the OS automatically read from the other disk?

I'm not a professional sysadmin but since I couldn't find answers to my specific case after researching for a while I was hoping I could get some help here. Our server uses P222 - a HP Smart ...
0
votes
1answer
41 views

Cant read dir of /etc/my.cnf. (Errcode: 2)

I am running MariaDB (libmysql - 5.5.41-MariaDB) and today I noticed that I couldn't go to mysql via command line to create a dump file. It would throw an error: mysql: Can't read dir of ...
1
vote
1answer
47 views

Linux mysql server will not start, or restart

Intro Im running MariaDB and Apache on my linux machine and today I ran into some problems. I connect to the server via SSH and here are some of the issues Im facing. I have absolutely no idea what ...
-2
votes
1answer
41 views

How does one add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? [closed]

How do you add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? To configure percona-nrpe plugins for mysql you will have to do 3 things viz : 1. define commands in command.cfg 2. ...
-1
votes
0answers
9 views

MySQL Installer Asks for Password But Does Not Seem to Set It [closed]

I'm using the MySQL Installer on Windows 8.1. I go through the installation steps for MySQL Server, including setting my password. However, when I go back to reconfigure my server through the ...
0
votes
0answers
22 views

RDS connection blocked despite security group “Allow all traffic, all ports, all IPs”

I can only connect by ssh-ing into my ec2, and then using mysql from the cli. I can not connect: ssh-ing into my ec2, and connecting from PHP mysql command line on my local machine. I cannot ...
1
vote
1answer
38 views

SQL Query overloading server

I have one php file which is getting called very often for a session check of an external application. I don't know how many calls there are every second, but I think it may be like 20-100 calls every ...
0
votes
1answer
22 views

Unusually high RDS MySQL memory

could use your help in understanding this. I'm running an RDS MySQL instance (db.m3.large on SSD) with 100GB of storage. I'm a little freaked out that my memory is 50% there: I must be doing ...
0
votes
0answers
15 views

configure apache to use sql server authentication using password and salt

I got a web application which I want to protect using apache authentication. I found out that it uses sha1+salt to store passwords. Since auth_mysql_module is deprecated I try to use authn_dbd_module. ...
0
votes
1answer
22 views

Lost connection to MySQL server at ‘reading initial communication packet’

I am using FreeBSD 9.2 and mysql 5.5 and i am using SOMETIMES this error - * Lost connection to MySQL server at 'reading initial communication packet', system error: 0* when i am executing sql ...
1
vote
2answers
88 views

csv import mysql null

I have to import some csv-formatted data into a mysql (mariadb) database. There is no csv header and the lines look like this: 00323acd-7909-41a4-a849-073ca3391dcf,2014-05,\N ...
-2
votes
0answers
19 views

NDB MySQL Table is full after running billion record

Can anyone tell me what wrong with my mysql cluster? I have a problem while running billion record showing table is full. This is my config.ini on the management node: [ndb_mgmd] ...
0
votes
0answers
13 views

unnecessary MySQL port forwording for WAN connection

I have an application that have MySQL as back-end database server,but while I was scanning open ports using nmap, I recognized that the MySQL port had been forwarded to be accessed over a WAN ...
0
votes
1answer
49 views

how to add kernel command before mysql startup in linux

I want to add these commands to the Linux kernel before mysql startup (at boot time): echo never> /sys/kernel/mm/transparent_hugepage/enabled echo never> ...
1
vote
1answer
41 views

Filtered master-master replication-is it possible?

I got task to configure I think some sort of monster. My boss want to have two mysql servers. Let's say serverA and serverB have databases db1,db2,db3,db4. He wanted that serverA will be master for ...
0
votes
2answers
36 views

Recommended 3x SSD Raid for mysql database [duplicate]

I've been configuring dedicated MySQL server (linux) with 3x 300 GB SSD in SoftRaid. I'm trying to decide which Raid to use to get best performance. I'm expecting this database to be a read-heavy (90% ...
0
votes
0answers
44 views

How do I quickly tell the structural differences between two databases? [migrated]

I am upgrading a web application to a newer version and need to migrate the data manually. The newer version uses slightly different database structure. It has added a few tables, but all of the old ...
0
votes
0answers
21 views

amazon server using RedHat EL 7 on port 3306 so that i can access mysql database remotely

I want to remotely access mysqld on port 3306 but when hen i telnet from public ip address i get a connection time out error. Whats happening here. But within the server telnet is working just fine ...
0
votes
1answer
37 views

MySQL with HAProxy on same server - How to connect from VIP

I am running 2 dedicated servers on which each has HAProxy keepalived running, MySQL in master/master and Apache. Load Balancing for Apache already works, but I can not get MySQL LB running. HAProxy ...
0
votes
1answer
14 views

Mysql Import - You have a error in your Syntax - Workarround

i use a exporter for some mysql data. At first it will create the table and after that insert the data into it. Example Code DROP TABLE IF EXISTS `dbc_Item-data`; CREATE TABLE `dbc_Item-data` ( ...
0
votes
1answer
23 views

built-in php cannot connect to homebrew mysql through localhost on osx mavericks [duplicate]

trying to install wordpress on osx mavericks (with built-in apache+php and homebrew mysql). mysql -u root # connects php -r 'var_dump(mysql_connect("localhost", "root", ""));' # doesn't connect ...
1
vote
0answers
23 views

How to make MySQL Server > 5.5.45 on OS X Yosemite accessible through tcp? [duplicate]

Right now I do a netstat -n | grep 3306 and nothing come. Beside I try to connect using: $ mysql -h127.0.0.1 -u root -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on ...
0
votes
1answer
25 views

Spreading a table's partitions across drives

With nearly a billion rows, we have to split up individual partitions across SSDs with about 4 partitions of them in each SSD. The table's current schema: CREATE TABLE IF NOT EXISTS `a` ( `id` ...
-1
votes
0answers
17 views

Bad chown command crashed mysql [duplicate]

I cd'd to my website subfolder /var/www/example.com and tried to change ownership of it's files by running the following command on my Ubuntu 14.04.2 LTS Server sudo chown -R $USER:$USER /* ...
-1
votes
2answers
20 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

I'm dumb, I did the stupidest thing I could. On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, ...
0
votes
1answer
20 views

apache / mysql unable to connect jails with PF firewall

I have setup two jail environments on FreeBSD11 root@ns312773:/etc # jls JID IP Address Hostname Path 1 10.6.6.6 www ...
0
votes
0answers
38 views

Google Container engine - mysql / postgresql image failure to connect from remote machine

I'm quite new to the docker images, containers and all the logic behind linking the running containers together, so please be patient if this question sounds too stupid. I'm trying to setup a working ...
0
votes
1answer
45 views

How to monitor mysql percentage disk utilization? [closed]

I am new to mysql world and not sure if there is a way to calculate mysql TableSpace/DiskSpace utilization in percentage. I am aware mysql does not provide upper limit or free space like Oracle DB, ...
0
votes
2answers
27 views

Denying access for specific host to specific database on mysql

We have a production MySQL server with the following grants: mysql> show grants for the_db; ...
-2
votes
1answer
39 views

MySQL sometimes shutdown itself at the midnight. Here is the log

My MySQL service sometimes shutdown itself at around 2AM of the day. I cannot find which part of this log file explain the cause. I host it on DigitalOcean. I am not sure is it because of their ...
0
votes
1answer
15 views

Why is the MYSQL variable innodb_file_per_table changed to OFF automatically in a OPENSHIFT online gear?

My application is on openshift online gear with mySQL 5.5. Recently I found that my mySQL database become very big quickly (few days increase 1G) without many operations. This made me try to do ...
8
votes
2answers
562 views

How to redirect users to different servers based on their location?

I have a website which is developed by using ASP.NET and MY DB is MySQL. Currently it hosted in USA Servers. But When I try to access it near India dynamic contents are loading too slowly. It is ...
0
votes
2answers
103 views

MySQL Ram Usage & Improve it with mysqltuner

how can i improve my server ram usage: Server Ram = 1GB after install the mysqltuner , I have this result : [root@server ~]# perl mysqltuner.pl >> MySQLTuner 1.5.0 - Major Hayden ...
1
vote
1answer
50 views

RDS to EC2 mysql replication

I would like to create a RDS mysql and to replicate it to an EC2 server so the DB will be local and thus the query time will be faster (the EC2 is a web server). According to the second paragraph here ...
0
votes
0answers
19 views

Amazon RDS Connection Denied via additional user

I just created a new database and user grant all privileges on that user. I don't know what's happening I can't connect by using that user always "Access Denied". But I change to RDS master user it's ...