Questions tagged [mysql]
MySQL is an open-source database owned by Oracle.
8,148
questions
0
votes
0answers
12 views
How to know if mysql server is using sha_256 or caching_sha_256?
Seems like I am using an older version on Mysql Server which uses sha_256 plugin for Authentication (which is now deprecated) .Because of this, I am unable to connect to my server with third party ...
0
votes
0answers
16 views
MySql Slave Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.00116, end_log_pos 8631
I have Active-Passive-Master-Master replication setup in Mysql with version 5.7.
I found the below error in MySql2 (passive Master server) but the status show it's in sync with Master server (mysql1).
...
-2
votes
1answer
33 views
How to open port 3306 for a particular ip and make my MySQL database accessible from remote server?
I am trying to make our site Database (MySQL) accessible from a remote server. But our server is not responding to requests on port 3306
Our server is using CentOS/RHEL and CloudLinux cPanel systems. ...
0
votes
0answers
16 views
500 Gateway with EC2 m5.2xlarge
I have an EC2 m5.2xlarge
with wordpress and the following server configuration:
https://pasteboard.co/JwP5Ecg.png
How is possible to receive a 500 Gateway Error for importing a csv with 50 users (45 ...
1
vote
1answer
59 views
Ubuntu 20.04 update destroyed Java/Mysql app performance
I'm working on a Java / MySQL app and test runs of batch processing were taking 3-4seconds on Ubuntu 18.04.
I made the upgrade to Ubuntu 20.04 last night, and kept the same mysql conf file, and now ...
0
votes
0answers
22 views
MySQL Proxy with routing system
I am looking around for a solution to very specific problem.
I have few years old big system. This system uses the Sphinx system to cache some data from MySQL databases. I have run the Sphinx cluster ...
-1
votes
0answers
16 views
Recommended specs for MySQL and Node [closed]
I have a relatively small MySQL (1 MB of data) database and a Node.js (in this case, I'm using Next.js) app running using Docker Compose. It will be used by no more than 3 people at the time.
Which ...
0
votes
1answer
71 views
Mixing Galera and MariaDB/MySQL replication
reading about it online, it appears we can use both Galera replication and native MariaDB/MySQL replication together. Can anyone confirm that this is correct?
I'm thinking of a scenario where Data ...
1
vote
1answer
49 views
MySQL instances are pointing to the database server DNS causing slow connection
We have very slow connection when accessing MySQL instances but fast when using IP address. When checked, we found out that the instances are all registered to the server hostname. So when you do an ...
0
votes
1answer
19 views
Master-Slave replication with additional selective replication
Using MySQL 5.6 Enterprise is it possible to have a normal master/slave replication between a master and slave with full replication then a second slave server to only have certain tables?
0
votes
0answers
18 views
Upgrade zabbix 4 to 5
I have a situation and I want to get your opinion about my strategy to change to Zabbix version 5,
in the past few weeks, I have a database storage problem and manage it by separating my Zabbix server ...
-7
votes
0answers
45 views
Academic case: Apache+MySQL+PHP+Ubuntu, Website pentrated. How to analyse logs?
I'm a beginner in the pentest. I'm doing an academic case study of a cracked website. The software environment of the website and database server are Apache 2.4.18, MySQL, Ubuntu, PHP. There are 3 ...
-3
votes
0answers
18 views
How do I do these three basic queries and function calls in raw PHP + MySQL(i)/MySQL-PDO?
I am experienced in PHP with PostgreSQL. For complicated reasons, I now have no choice but to only have PHP + MySQL database support with my webhost. I last used MySQL in the early 2000s and no longer ...
-1
votes
1answer
41 views
What is the best mysql configuration for mysql instance with a lot of databases and lot of tables inside?
I have a mysql database instance with more than 3000 database inside. Each database contains more than 200 tables. I have more than 100 gb of data in all these database at present. I am using windows ...
0
votes
1answer
27 views
Is there “another” way of getting log information on SFTP activity?
I'm administrating a debian server since last week. It used to have another administrator.
I presume it's been hacked: files might have been read via SFTP to obtain information about a site that's ...
