In other words, I would like to know Sharding is possible in MySQL?

|
piterden 2021-06-05 23:16:24
And then check for popularity the same products which user already had bought sometime
piterden 2021-06-05 23:17:59
Or you want to search friends by interests?
bilbss 2021-06-05 23:18:03
i record only one times its doe not matter
bilbss 2021-06-05 23:19:27
think like spotify, mine listened playlist has A – B – C so that my next song recommend will be D, also other user had listened B – C – A for that user recommend will be D
piterden 2021-06-06 01:03:10
Wtf this query is not ok
piterden 2021-06-06 01:29:29
SELECT * FROM orders
WHERE orders.product_id<8
FROM orders;
Never use *. Define fields implicitly
piterden 2021-06-06 01:34:39
Anyway I can’t understand what you want. There is a fact depending on my experience: if something is not clear for me right away, then for about 80% of cases it is wrong thing. But it can be your case placed in 20% which are left and you just can’t describe it clear.
bilbss 2021-06-06 01:35:33
piterden 2021-06-06 01:29:29
SELECT * FROM orders
WHERE orders.product_id<8
FROM orders;
Never use *. Define fields implicitly

okay man i have solved my problem thank you

piterden 2021-06-06 01:36:03
bilbss 2021-06-06 01:35:33
okay man i have solved my problem thank you

Oh, sorry, I really wanted to help

piterden 2021-06-06 01:36:51
It is fine that you got your solution
piterden 2021-06-06 01:38:02
You can post your result query to optimize if you want
bilbss 2021-06-06 01:39:24
piterden 2021-06-06 01:38:02
You can post your result query to optimize if you want

SELECT COUNT(*) as count,order_id FROM orders WHERE product_id=1 or product_id=2 or product_id=3 or product_id=4 OR product_id=5 ) GROUP BY order_id ORDER BY count DESC

piterden 2021-06-06 01:40:36
WHERE product_id IN (1,2,3,4,5) I think will be better
piterden 2021-06-06 01:41:33
Other things are normal
bilbss 2021-06-06 01:42:54
piterden 2021-06-06 01:40:36
WHERE product_id IN (1,2,3,4,5) I think will be better

i will consider your suggest

bilbss 2021-06-06 01:43:15
thank you ๐Ÿ‘
piterden 2021-06-06 01:43:26
NP)
bilbss 2021-06-06 02:03:25
SELECT COUNT(*) as count,order_id FROM orders WHERE product_id IN (1,2,3,4,5) ORDER BY cunt desc;

do i make random sorting same count for order_id’s? because of it will gives always same results. ex. the orders’s count is 5, that always show me same placement result. do i mix their (for which has same count) placement?

piterden 2021-06-06 02:08:18
bilbss 2021-06-06 02:03:25
SELECT COUNT(*) as count,order_id FROM orders WHERE product_id IN (1,2,3,4,5) ORDER BY cunt desc;

do i make random sorting same count for order_id’s? because of it will gives always same results. ex. the orders’s count is 5, that always show me same placement result. do i mix their (for which has same count) placement?

Sorry, what do you mean? Do you need random sort or what?

piterden 2021-06-06 02:08:36
Try to use google translator
bilbss 2021-06-06 02:20:48
can i make random sorting for which has same count of order_id’s? because of it will gives always same results. ex. the orders’s count is 5, that always show me same placement result. can i mix their (for which has same count) placement?
piterden 2021-06-06 02:28:29
bilbss 2021-06-06 02:20:48
can i make random sorting for which has same count of order_id’s? because of it will gives always same results. ex. the orders’s count is 5, that always show me same placement result. can i mix their (for which has same count) placement?

Try to use ORDER BY count DESC, RAND()

bilbss 2021-06-06 02:33:47
piterden 2021-06-06 02:28:29
Try to use ORDER BY count DESC, RAND()

Spasibo ๐Ÿ™

piterden 2021-06-06 02:34:07
ะŸะพะถะฐะปัƒะนัั‚ะฐ )
bilbss 2021-06-06 02:56:35
have a nice night
piterden 2021-06-06 02:56:57
bilbss 2021-06-06 02:56:35
have a nice night

Yeah, and you too

piterden 2021-06-06 02:59:01
If you would use google translate from the begin we could find a common language much earlier ))
piterden 2021-06-06 02:59:21
Next time please do it right away
D 2021-06-06 07:31:07
Hi All- Distributed database design is possible in MySQL? I assume in rdbms designing distributed system will have challenges in data consistency . Please advise
MasterZiv 2021-06-06 08:31:18
D 2021-06-06 07:31:07
Hi All- Distributed database design is possible in MySQL? I assume in rdbms designing distributed system will have challenges in data consistency . Please advise

Ask concrete questions please, this is not a philosophy channel

D 2021-06-06 08:34:11
MasterZiv 2021-06-06 08:31:18
Ask concrete questions please, this is not a philosophy channel

To be specific -how to design MySQL database in distributed environment

MasterZiv 2021-06-06 08:36:57
D 2021-06-06 08:34:11
To be specific -how to design MySQL database in distributed environment

MySQL can do little in this area, only you can have simple replication and that is all.

D 2021-06-06 08:38:57
MasterZiv 2021-06-06 08:36:57
MySQL can do little in this area, only you can have simple replication and that is all.

Can you be specific on what is little ?

D 2021-06-06 08:47:36
D 2021-06-06 08:34:11
To be specific -how to design MySQL database in distributed environment

In other words , I would like to know Sharding is possible in MySQL?

MasterZiv 2021-06-06 08:51:36
D 2021-06-06 08:47:36
In other words , I would like to know Sharding is possible in MySQL?

Sharding is possible with any RDBMS.
It is technic, not technology

|