MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
353 views

MariaDB crashing with “Assertion failure in thread xxx in file rem0rec.cc line 580”

I have three MariaDB servers set up in a Galera cluster. I use one server at a time as a "primary" master (i.e., Galera is just for failover, the app doesn't actively use multiple masters). About ...
-1
votes
1answer
30 views

Need help importing data to new SQL server from MySQL folder

My hard drive crashed, and can no longer write, but it can still read. Because of this, I was unable to export my SQL database to an .sql file for later importing. I can still access the drive, and ...
0
votes
1answer
37 views

mysql command in command line return unknown variable

When I try to use: mysql -u [user] -p command (or any other "mysql") at my Debian server command line I get this error: mysql: unknown variable 'log=/var/log/mysql.log' mysql-client is ...
0
votes
1answer
59 views

Clustring haproxy + Apache + MySQL

Im new to clustering, So I started my LAB using linux centos, My schema is : 2 Load balancers, 2 Web servers (apache), 2 MySQL DBs (separated). I configured the 2 LBs and 2 Webs, the load balancing ...
-3
votes
1answer
45 views

MySQL backups of information_schema? [closed]

When performing routine MySQL backups (using mysqldump), should I be including information_schema? Isn't it just meta information? I've seen multiple suggestions to ignore the mysql and ...
0
votes
1answer
45 views

Current setup maxing CPU. Need help designing AWS architecture and MySQL Clustering via AWS RDS instances

My company runs a mid-sized eCommerce (30,000-50,000 unique views monthly) shopping cart using X-Cart as a back-end. We are in the processing of redesigning and upgrading our back-end software. We are ...
0
votes
0answers
18 views

MySQL ODBC DSN ignoring IP address of server - Windows 7

I'm trying to create an ODBC connection to a MySQL server on my network. I can create the DSN but when I click test I get an error (HY000) Access denied for user user@localhost despite the fact that I ...
0
votes
1answer
29 views

MySQL Cluster ndb_restore fails without error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
0answers
56 views

Connect to a Server from my AWS EC2 instance

I have a app running on AWS EC2 which connects to a database in another server. The database connection Uri is as following, jdbc:XXX:172.18.2.107:3306/database This is what I got form my ...
1
vote
2answers
54 views

Where are MySQL users and passwords stored?

When I delete 'mysql'.'user' table I'm still able to log in as any user I've created before. How is this possible?
1
vote
1answer
45 views

mysql / mariadb - remove ipv6 user

Can I remove the 'user'@'::1' <- ipv6 user from mariadb? I have ipv6 disabled on my CentOs install. Or is it not related to ipv6?
1
vote
0answers
44 views

Cannot install mysql server - Error in PREIN scriptlet in rpm package mysql55-mysql-server-5.5.32-3.el5.x86_64

I am trying to install mysql server 5.5 (or any 5.x versions) on Redhat 5.5 and am having some trouble. I can install the other mysql components but when I try to install mysql-server (or ...
-5
votes
1answer
47 views

Automysqlbackup how long does it keep the backups [closed]

I wonder that if you setup automysqlbackup with default config, how long does it keep the old backups? total 12 drwxr-xr-x 4 root root 4096 2010-01-27 17:20 daily drwxr-xr-x 2 root root 4096 ...
1
vote
2answers
57 views

Need to improve apache and mysql configuration. Current config is crashing server due to RAM maxing out?

Ok, we run a growing auto parts shopping cart. Our server runs slow and is always crashing so we asked our web host to assist us. They sent us these report but I need some advice in how to process it. ...
6
votes
2answers
75 views

Postfix deny relay for some virtual users

I'm using Postfix as MTA and relay. Users that wish to send e-mail from a remote system authenticates and Postfix hands that to Dovecot, and this works well. But how can I limit which users can use ...
0
votes
4answers
270 views

telnet cannot connect to port without firewall

If I try to connect to MySQL with telnet myhost.com 3306 I get a network not reachable error, even when I flush all iptables rules. I can reach other ports like ssh (with the same iptables rules ...
0
votes
0answers
35 views

Elastic search custom mysql server

I want to use ElasticSearch nodes with Amazon RDS servers. How I can do this? The idea is to have the ElasticSearch feature only with a remote DB.
0
votes
3answers
90 views

Offline mysql dump

I'm hosting a 60GB InnoDB file-per-table MySQL database with a VPS provider. I want to generate a dump of the file. Running mysqldump makes the website connected to this database extremely slow, ...
1
vote
2answers
64 views

AWS RDS mysqldump hanging

I am attempting to migrate data between RDS MySQL instances. I cannot use snapshots because, with this migration, I want to encrypt the underlying disk and upgrade versions (5.1.73a to 5.5.41). The ...
-1
votes
2answers
68 views

How to Dump all databases from MySql server with mysqldump without passwords

Is it possible to dump all databases without supplying the username and password for each databe ? The server has 10 databases with different usernames and passwords. I will be logged in as root ...
-1
votes
1answer
111 views

Migrate OTRS database from PostgreSQL to MySQL

OTRS supports PostgreSQL and MySQL databases. I'm using PostgreSQL 9.1 for my OTRS 3.2 but I want to migrate to MySQL 5.5. Is this possible? How?
-1
votes
1answer
68 views

Pros and cons of installing php 5.6 and mysql 5.6 on debian 7 wheezy

I was setting up a VPS server for my client and we had talked that I would install the last stable versions of the programs. Now, in Debian 7 wheezy by default php 5.4 and mysql 5.5 are available. I ...
1
vote
0answers
122 views

ERROR 2003 (HY000): Can't connect to MySQL on server 'myhost.com' (101)

When trying to connect to my mysql server remotely with: ~$ mysql -u user -p -h myhost.com The result is (after asking for password): ERROR 2003 (HY000): Can't connect to MySQL server on ...
2
votes
0answers
86 views

Benchmarking for DISK I/O Writes Per Second - ElasticSearch and MySQL

During working on our project we needed to decide should we use "ElasticSearch" or "MySQL" to record the audit/trail logs of the system. Searching speed is not an issue here, we needed to see the disk ...
0
votes
0answers
40 views

Percona cluster signal 11

We have a percona cluster that is randomly getting signal 11's on different cluster nodes. I've exhausted everthing I know. Here's the .err file with the signal 11. We're running Server version: ...
0
votes
0answers
23 views

Path to mysqldump on Azure VM?

I've set up a VM running MySQL Server (Community Edition) on Azure. My CMS (Perch) has a backup module, which uses mysqldump to back up the database. However, the default options don't seem to be ...
1
vote
1answer
53 views

Server with multiple replicate=do-db entries

I have a server that someone has setup which are acting as a master-master on both servers. Since they have been configured as both master on the same database, changes in one end has caused all sorts ...
0
votes
1answer
23 views

Provisioning MySQL remote users

Seeking advise on optimal way to provision remote MySQL user permissions, when the source of connections is a large network block. Since the MySQL server may have DNS lookups disabled for performance ...
-1
votes
2answers
55 views

Who is responsible for performing the query EC2 or RDS?

Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ). As I understand RDS is (directly after setup) optimized for ...
0
votes
1answer
45 views

ColdFusion Server slow connection to dedicated database server?

We had our database and web server on the same box. For performance reasons, we are now off loading the database to a dedicated server. When updating the CFDSNs to the new server, the verification ...
3
votes
1answer
59 views

searching for the correct way to compile postfix

I am experiencing issues while compiling latest version of postfix from source code. At the moment I'm trying to compile version 3 because Debian 7 and latest Ubuntu 14,10 (version 2,9 and 2,11 for ...
1
vote
1answer
32 views

Best method to ensure Mysql master slave replication is consistent?

I am running a master slave replication system on AWS EC2 systems over ssh. However I came across a couple of best practice articles indicating that even this might allow inconsistencies to creep into ...
0
votes
2answers
80 views

mysqldump connects as different user from cron and from command line

I had a bug in a backup script running as a cron job which I found and corrected, but I'm still puzzled by the fact that this bug did not show up when the script was started from the command line. The ...
0
votes
1answer
141 views

Postfix fails to install in MySQL 5.7

I am trying to install postfix in my server with Centos7 MySQL 5.7 Unfortunately it seems to be they are incompatible. Why? Here the error message. Is there a way around this ? [root@doc ~]# ...
1
vote
0answers
98 views

Amazon RDS Instance slowly losing free diskspace

A while back the server running my instance had 20GB of EBS storage. It then started getting disk storage errors, so I increased it to 40GB. Then again, storage missing errors so I increased again to ...
5
votes
1answer
220 views

Nagios alert based on scheduled MySQL queries results

I have installed Nagios 4.0 on my Ubuntu 14.0 and i want a plugin to alert me based on daily scheduled MySql queries .. if the result of ( select count(*) from tableName > 10 ) raise a critical ...
0
votes
0answers
72 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
1
vote
1answer
513 views

Nginx + HHVM + MariaDB + WordPress install -> Error establishing a database connection

I'm setting up a VPS for a WordPress blog. I'm using Ubuntu 14.04 LTS 64 bits and then I've installed Nginx 1.7.8, HHVM 3.6.0, MariaDB (don't remember the version). Finally I've downloaded WordPress ...
0
votes
1answer
158 views

connect to db instance in private VPC subnet with MySQL Workbench

How do I connect to an AWS (or other) instance in a private subnet in a VPC using MySQL Workbench ? My arrangement is a typical aws Scenario 2 : I can: - SSH into my NAT instance located in my VPC ...
-4
votes
2answers
57 views

How to avoid mysql query hang if the disk is full

The disk is full and my query hangs on the mysql query. From the mysql manual: When a disk-full condition occurs, MySQL does the following: It checks once every minute to see whether there ...
-1
votes
1answer
25 views

Synchronize Staging Server and Live Server [closed]

We have staging and live server at our office. Where Live code and DB changes are far more advanced than staging one.This application developed under php and DB is mysql. Earlier we used to work in ...
0
votes
1answer
121 views

How to monitor MariaDB Galera cluster status from command line

I know to check the Galera cluster status, the command that should be used after login to the mysql client is: SHOW STATUS LIKE 'wsrep%'; but, how to get the output directly from the command line? ...
1
vote
1answer
27 views

Leave only the Server and Client files in a mysql installed manually on windows

I am a php developer and I'm setting up a portable development environment on windows 7. I downloaded the version of mysql "NonInstall Zip Archive" and is working properly. However, I see that ...
-4
votes
1answer
43 views

mysql hot add memory

Is it possible for currently running jobs in MySQL to utilize memory that's been hot added? It looks like when memory is hot added to the VM the currently running jobs are not utilizing the additional ...
1
vote
1answer
60 views

Postfix + mysql: virtual_users combined with a catch-all in virtual_aliases

I have a Postfix (and Dovecot) server running, using MySQL to define the domain names, users and aliases. This is all running fine, but now I want to add a catch-all to a domain where I already have ...
0
votes
1answer
46 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
0
votes
2answers
161 views

Syntax error when setting up master-master replication in MySQL

So I've set up my initial master-slave replication pair on two different MySQL servers. That part is working great. So all I have to do is set up the first master as a slave and set up the first slave ...
1
vote
1answer
60 views

MySQL - Unable to enable binary logging

I'm trying to enable binary logging so that I can set up master-slave replication between two servers. I'm working with an existing server with lots of data and I'm trying to dump the data with the ...
0
votes
0answers
33 views

Mysql reports “unknown variable pass” after upgrading from 5.5.41 -> 5.7.5 on Debian

We have the following problem after upgrading MySQL 5.5.41 (pre-installed on our Debian Wheezy LAMP server from Hetzner) to 5.7.5 version (downloaded from mysql.com). After updgrading from the ...
1
vote
0answers
70 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...