Will i be able to MySql database with nodejs if i only install Msql server?

|
shivaniaggarwal 2021-08-02 08:32:29
Sales (salesperson_id, name, region_id, city, sales, sex)
Region (region_id, r_name)
 Identify primary key and foreign key in above tables.
 Find all salesperson names and city whose name ends with ‘A’. Arrange it according
to their city.
 Find the salesperson name and region_id that gets the maximum sales.
 Find the region name and cities where average sales per salesperson are greater than
550
 Find the total no. of salespersons in north region, in which the salesperson operates.
shivaniaggarwal 2021-08-02 08:32:37
Pls sove it guyz
shivaniaggarwal 2021-08-02 08:32:38
Pls
ColonelMustang 2021-08-02 13:47:04
Is there a way I can “connect” DBs from two different datacenters with each other so that they are consistent?

Like Datacenter d1 and d2 both accepting write requests to their databases but the end result still being consistent across datacenters

Deb_575 2021-08-02 14:12:25
ColonelMustang 2021-08-02 13:47:04
Is there a way I can “connect” DBs from two different datacenters with each other so that they are consistent?

Like Datacenter d1 and d2 both accepting write requests to their databases but the end result still being consistent across datacenters

Innodb group replication.

ColonelMustang 2021-08-02 14:59:15
Deb_575 2021-08-02 14:12:25
Innodb group replication.

Works across data centers?

MasterZiv 2021-08-02 15:14:55
ColonelMustang 2021-08-02 14:59:15
Works across data centers?

Works across network. Doesn’t matter if it is a datacenter

ColonelMustang 2021-08-02 15:15:51
Okay
ColonelMustang 2021-08-02 15:15:54
Thanks!
petrovivanvlad 2021-08-02 15:36:58
currently trying to figure out how to make mariadb work on 5 disks with raid0+1 machine in order to get rid of bottleneck in selecting perfomance. which direction should i dig into?
svart 2021-08-02 16:25:39
petrovivanvlad 2021-08-02 15:36:58
currently trying to figure out how to make mariadb work on 5 disks with raid0+1 machine in order to get rid of bottleneck in selecting perfomance. which direction should i dig into?

i’d suggest to start with analyzing slow query log.

petrovivanvlad 2021-08-02 16:30:05
i found out that some queries just hangs and wont even start. for example, DELETE. idk why…

btw, im using mariadb 5.5.68. should i upgrade to newer versions of it?

svart 2021-08-02 16:30:15
ColonelMustang 2021-08-02 13:47:04
Is there a way I can “connect” DBs from two different datacenters with each other so that they are consistent?

Like Datacenter d1 and d2 both accepting write requests to their databases but the end result still being consistent across datacenters

if you do not mind I’d like to remind you that galera and group replication initially was designed primarily for WAN. in galera you can introduce segments and it might be that you have something similar in GR which can settle majority in a single DC. it basically mean that you won’t be able to use two servers: one per DC. you will have to use more

svart 2021-08-02 16:34:07
petrovivanvlad 2021-08-02 16:30:05
i found out that some queries just hangs and wont even start. for example, DELETE. idk why…

btw, im using mariadb 5.5.68. should i upgrade to newer versions of it?

“delete” is not a “select”. you are asking about different things. if you have problems with deletes specifically you have to split your work in two parts: 1) find out if a “select” query used to get the same record is fast enough; 2) if “select” is good then consider tuning deletion. that might be tricky and depends on many factors but usually it does not cause much issues unless you delete a significant part of a table. in such cases you should consider partitioning or delete data by small batches

you got the answer on “upgrade” question in another slack channel

petrovivanvlad 2021-08-02 16:38:45
i don’t have slack. i only use telegram and whatsapp
svart 2021-08-02 16:46:48
petrovivanvlad 2021-08-02 16:38:45
i don’t have slack. i only use telegram and whatsapp

sorry. i meant telegram

Deb_575 2021-08-02 16:48:57
petrovivanvlad 2021-08-02 16:30:05
i found out that some queries just hangs and wont even start. for example, DELETE. idk why…

btw, im using mariadb 5.5.68. should i upgrade to newer versions of it?

Yeah upgrade latest is 10.6
5.5 is away too old.

Wenzell 2021-08-02 18:40:49
Will i be able to MySql database with nodejs if i only install Msql server?
Wenzell 2021-08-02 19:22:41
MasterZiv 2021-07-30 08:54:05
Report this to MySQL support

I solved the problem. MySql installer is very lazy it does not the Templates folder. You have to manually create this folder for the installer to use it to store the my-template.ini files. Oracle needs to correct this

MasterZiv 2021-08-02 23:20:37
petrovivanvlad 2021-08-02 15:36:58
currently trying to figure out how to make mariadb work on 5 disks with raid0+1 machine in order to get rid of bottleneck in selecting perfomance. which direction should i dig into?

I’m afraid this all is not about RAID s, but about building good query plans…

MasterZiv 2021-08-02 23:23:46
Wenzell 2021-08-02 19:22:41
I solved the problem. MySql installer is very lazy it does not the Templates folder. You have to manually create this folder for the installer to use it to store the my-template.ini files. Oracle needs to correct this

It does not do what?

Wenzell 2021-08-02 23:24:22
MasterZiv 2021-08-02 23:23:46
It does not do what?

Does not create

MasterZiv 2021-08-02 23:36:49
Wenzell 2021-08-02 19:22:41
I solved the problem. MySql installer is very lazy it does not the Templates folder. You have to manually create this folder for the installer to use it to store the my-template.ini files. Oracle needs to correct this

I doubt.
This softwarte is tested well

ColonelMustang 2021-08-04 08:27:45
MasterZiv 2021-08-02 15:14:55
Works across network. Doesn’t matter if it is a datacenter

How will this work if there’s a network failure between data centers? Considering both the data centers have the same number of nodes

ColonelMustang 2021-08-04 08:28:19
even if they don’t have the same number of nodes, and network connection between the centres fail
MasterZiv 2021-08-04 17:35:55
ColonelMustang 2021-08-04 08:28:19
even if they don’t have the same number of nodes, and network connection between the centres fail

Its the common case when any network between nodes fails.

ColonelMustang 2021-08-04 18:40:49
MasterZiv 2021-08-04 17:35:55
Its the common case when any network between nodes fails.

yes, how does Group Replication handle that? I could not get any explanation regarding this from the documentation

MasterZiv 2021-08-05 10:38:55
ColonelMustang 2021-08-04 18:40:49
yes, how does Group Replication handle that? I could not get any explanation regarding this from the documentation

IDK

svart 2021-08-05 12:23:54
ColonelMustang 2021-08-04 18:40:49
yes, how does Group Replication handle that? I could not get any explanation regarding this from the documentation

the topic is quite wide because GR can be run in 2 modes: with single primary node and with multiple primary nodes. GR has implemented their own consensus protocol based on Paxos. the basic idea is to send communication packets between nodes (as always). if node A does not receive message from B for a certain period of time it decided that it is suspicious and raise to the other members to agree on if node B is offline or not. if decision will be taken then node will be evicted from the cluster until it will try communicate next time. if need any specific details of implementation you can find more info at https://mysqlhighavailability.com and at percona.com and of course you can dig through the source code

Replicate from GTID disabled source to GTID enabled replica directly – MySQL High AvailabilityMySQL High Availability
MySQL 8.0.23 introduces a new feature that makes replication possible from a source server that has been configured without Global Transaction Identifiers (GTIDs) to a replica server configured with GTIDs. This can be achieved by configuring replication channels to use the parameter ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS with the CHANGE REPLICATION SOURCE command. Enabling this option will allow the replica to assign a
ColonelMustang 2021-08-06 13:53:43
svart 2021-08-05 12:23:54
the topic is quite wide because GR can be run in 2 modes: with single primary node and with multiple primary nodes. GR has implemented their own consensus protocol based on Paxos. the basic idea is to send communication packets between nodes (as always). if node A does not receive message from B for a certain period of time it decided that it is suspicious and raise to the other members to agree on if node B is offline or not. if decision will be taken then node will be evicted from the cluster until it will try communicate next time. if need any specific details of implementation you can find more info at https://mysqlhighavailability.com and at percona.com and of course you can dig through the source code

Thanks for replying. This was helpful

2021-08-07 10:29:01
there any one speak sinhala
svart 2021-08-07 18:25:48
2021-08-07 10:29:01
there any one speak sinhala

According to Wikipedia 17mln people speak sinhala

Deb_575 2021-08-07 18:45:26
2021-08-07 10:29:01
there any one speak sinhala

Why btw?

madno 2021-08-07 19:16:17
What are gap locks?
svart 2021-08-07 21:00:41
madno 2021-08-07 19:16:17
What are gap locks?

It might sounds surprisingly, but gap locks used to lock a gap between two index values

|